sql - C# How to Retrieve DateSet Value in SqlDataAdapter? -
In the development, I intend to retrieve the indicator key from the SQL Server database and applies to the local SDF database. . However, I failed to retrieve the pointer key from the SQL Server database. So, how do I get the value stored in DataSet?
example: tagname = "productive", indexName = "IX_product"
or does my SqlDataAdapter do not return any value? P / S: I think there are a lot of tutorials working in Forum and Stakeoverflow, unfortunately, I could not work it out.
Private zeros btnGetSchema_Click (Object Seether, RoutedEventArgs e) {SyncDbSchema (); } Private Zero syncDbSchema () {// setIndexSchema (); Dataset dsIndex = getIndexSchema (); MessageBox.Show ("table row count:" + dsIndex.Tables ["tbIndex"]. Rows.count); (Int i = 0; i
The query is doing the perfect job in T-SQL and intends to get the results.
table name index column name index unique tbReport IX_tbReport_SID SalesID 2 0 tbReport IX_tbReport_RID Report ID 2 0
Are you sure you want to use FillSchema?
Why not just?
adapter.phill (dataset);
Of course you can add them to the first movie (but why do you need it?), The next data (just fill)
Comments
Post a Comment