Posted on: 10/12/2013 4:06:45 AM | Views : 527

TagId(PK)   BatchId   ClientId
100             1           111
200            2            222
300            3            333
this is my table

string tagid; string batchid; string clientid; public void Data() { string Con = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlConnection con1 = new SqlConnection(Con); SqlDataAdapter da = new SqlDataAdapter("SELECT [TagId],[BatchId],[ClientId] FROM TagTable", con1); DataSet ds = new DataSet();
da.Fill(ds, "TagTable"); foreach ...

Go to the complete details ...