dataadapter中insert、delete、update的使用方法

SqlDataAdapter有关InsertCommand,UpdateCommand,DeleteCommand 实例

Posted on许珅阅读(226) 评论()编辑收藏

 

             (SqlConnection conn = = , (, ( [] { ,  [] { ,  [] { , = =  SqlCommand(=  SqlCommand(, conn);
                adapter.InsertCommand.Parameters.Add(].SourceColumn = ].SourceColumn = 
= (dtInsert.Rows.Count > 

 

 

2,UpdateCommand

 

 
             (SqlConnection conn = =  sql = =  (DataRow datarow  ds.Tables[] = ;
= 

 

 

3,DeleteCommand

 

             (SqlConnection conn = =  sql = 
                SqlDataAdapter adapter = =  SqlCommand(
].Rows[ds.Tables[].Rows.Count - 

 

详细页面：http://www.verydemo.com/demo_c152_i8255.html