如何获取表的主键 [英] How to obtain primary key of table

问题描述

我想知道在sql server数据库中定义了主键的列。

以下是我的代码

 SqlConnection con = new SqlConnection（Initial Catalog = Dbname; Data Source = MySqlServer; User = testuser; Password = pass123;）; 
 
 DataSet ds = new DataSet（）; 
 
 SqlCommand cmd = new SqlCommand（select * from TableName，con）; 
 cmd.CommandType = CommandType.Text; 
 
 SqlDataAdapter da = new SqlDataAdapter（cmd）; 
 da.Fill（ds）; 
 
 DataColumn []列; 
 columns = ds.Tables [0] .PrimaryKey; 
 
 //获取数组中的元素数量。 
 Response.Write（Column Count：+ columns.Length）; 
 for（int i = 0; i< columns.Length; i ++）
 {
 Response.Write（columns [i] .ColumnName + columns [i] .DataType）; 
} 

事实上，我已经在

 TableName 

但我的代码返回零计数。

请纠正我，如果我错了并提供替代解决方案

感谢提前。

解决方案

阅读以下内容： http://stackoverflow.com/questions/3930338/sql-server-get-table-primary-key-using-sql-query [ ^ ]

我得到了答案......

 da.MissingSchemaAction = MissingSchemaAction.AddWithKey; 

then

 da.Fill（ds）; 

它有效......

Hi,
I want to know column which has primary key defined in sql server database.
Following is my code

    SqlConnection con = new SqlConnection("Initial Catalog=Dbname; Data Source=MySqlServer; User=testuser; Password=pass123;");

    DataSet ds = new DataSet();

SqlCommand cmd = new SqlCommand("select * from TableName", con);
        cmd.CommandType = CommandType.Text;

        SqlDataAdapter da = new SqlDataAdapter(cmd);
        da.Fill(ds);

        DataColumn[] columns;
        columns = ds.Tables[0].PrimaryKey;

        // Get the number of elements in the array.
         Response.Write("Column Count: " + columns.Length);
        for (int i = 0; i < columns.Length; i++)
        {
            Response.Write(columns[i].ColumnName + columns[i].DataType);
        }

In fact, i have defined one primary key on a column of

TableName

But my code returns zero count.
please correct me, if i am wrong and provide me alternative solution
thank is advance.

解决方案

Read the following : http://stackoverflow.com/questions/3930338/sql-server-get-table-primary-key-using-sql-query[^]

I got the answer......

da.MissingSchemaAction = MissingSchemaAction.AddWithKey;

then

da.Fill(ds);

It worked......

这篇关于如何获取表的主键的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！