DataAdapter的使用 添加数据 ∥连接字符串 string strCon @"Data Source =.Initial Catalog TestDB;Integrated Security =True;"; SqlConnection sqlCon new SqlConnection(strCon); ∥执行连接 sqlCon.Open(); string sltStr =@"insert into JBQK(No,Name,XB,JG,Grade) values(201203,张三，'男，'山东，大二)"； SqlCommand sqlCmd new SqlCommand(sltStr,sqlCon); SqlDataAdapter sda new SqlDataAdapter(); sda.InsertCommand sqlCmd; int iRet sda.InsertCommand.ExecuteNonQuery(); Console.WriteLine(iRet); sqlCon .Close () 12 12 DataAdapter的使用 ▪ 添加数据 string sltStr=@“insert into JBQK(No,Name,XB,JG,Grade) values ('201101','张三','男','山东','大二')"; SqlCommand sqlCmd = new SqlCommand(sltStr, sqlCon); SqlDataAdapter sda = new SqlDataAdapter(); sda.InsertCommand= sqlCmd ; int iRet=sda.InsertCommand.ExecuteNonQuery();