public void CreateSqlDataAdapter() {
string mySelectText = "SELECT * FROM Categories ORDER BY CategoryID";
string mySelectConn = "Data Source=localhost;Integrated Security=SSPI;Initial Catalog=northwind";
SqlDataAdapter myDataAdapter = new SqlDataAdapter(mySelectText,mySelectConn);
myDataAdapter.InsertCommand.CommandText = "INSERT INTO Categories(CategoryName, Description, Picture) Values(@CategoryName,@Description,@Picture)";
myDataAdapter.InsertCommand.Connection = (SqlConnection) myDataAdapter.SelectCommand.Connection;
}
string mySelectText = "SELECT * FROM Categories ORDER BY CategoryID";
string mySelectConn = "Data Source=localhost;Integrated Security=SSPI;Initial Catalog=northwind";
SqlDataAdapter myDataAdapter = new SqlDataAdapter(mySelectText,mySelectConn);
myDataAdapter.InsertCommand.CommandText = "INSERT INTO Categories(CategoryName, Description, Picture) Values(@CategoryName,@Description,@Picture)";
myDataAdapter.InsertCommand.Connection = (SqlConnection) myDataAdapter.SelectCommand.Connection;
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货