Creating primary key constraints on a table using VB.NET

[sivakumar mariappan]

Hi, I have developed a code to create a ms-access table through VB.NET as mentioned below. ADOXtable = New ADOX.Table ADOXtable.Name = "ACN_CHARX_INSTANCE" ADOXtable.Columns.Append("LOGICAL_DB_NAME", ADOX.DataTypeEnum.adVarWChar, 32) ADOXtable.Columns.Append("DIM_NAME", ADOX.DataTypeEnum.adVarWChar, 32) ADOXtable.Columns.Append("CHARX_NAME", ADOX.DataTypeEnum.adVarWChar, 128) ADOXtable.Columns.Append("CHARX_TABLE", ADOX.DataTypeEnum.adVarWChar, 128) ADOXtable.Columns.Append("CHARX_VALUE_COL", ADOX.DataTypeEnum.adVarWChar, 128) ADOXtable.Columns.Append("VALUES_UNIQUE", ADOX.DataTypeEnum.adInteger) ADOXtable.Columns.Append("CHARX_ORDER_COL", ADOX.DataTypeEnum.adVarWChar, 128) ADOXtable.Columns.Append("CHARX_ORDER", ADOX.DataTypeEnum.adInteger) ADOXtable.Columns.Append("CHARX_NUMERIC_COL", ADOX.DataTypeEnum.adVarWChar, 128) ADOXtable.Columns.Append("BITMAP_COL", ADOX.DataTypeEnum.adVarWChar, 128) cat.Tables.Append(ADOXtable) Now i want to set primary key constraints for this table through coding. Please share your ideas... Thanks, Sivakumar.M.

[Lost User]

Please ignore.. http://www.codeproject.com/Forums/1725/General-Database.aspx?fid=1725&select=3086066#xx3086066xx[^]

Regards Aman Bhullar www.arlivesupport.com[^]