110,571
社区成员
发帖
与我相关
我的任务
分享
SqlConnection cn = new SqlConnection(Properties.Settings.Default.ConnectionString);
SqlCommand cmd = new SqlCommand("insert into Products(productID, productName) values(@productID, @productName)", cn);
foreach (ListViewItem item in lvwProducts.Items)
{
//MessageBox.Show(item.Text + " " + item.SubItems[1].Text);
cn.Open();
cmd.Parameters.AddWithValue("@productID", item.Text);
cmd.Parameters.AddWithValue("@productName", item.SubItems[1].Text);
cmd.ExecuteNonQuery();
cn.Close();
cmd.Parameters.Clear();
}
// Assumes connection is a valid SqlConnection.
SqlDataAdapter dataAdpater = new SqlDataAdapter(
"SELECT CategoryID, CategoryName FROM Categories", connection);
dataAdpater.UpdateCommand = new SqlCommand(
"UPDATE Categories SET CategoryName = @CategoryName " +
"WHERE CategoryID = @CategoryID" , connection);
dataAdpater.UpdateCommand.Parameters.Add(
"@CategoryName", SqlDbType.NVarChar, 15, "CategoryName");
SqlParameter parameter = dataAdpater.UpdateCommand.Parameters.Add(
"@CategoryID", SqlDbType.Int);
parameter.SourceColumn = "CategoryID";
parameter.SourceVersion = DataRowVersion.Original;
DataSet dataSet = new DataSet();
dataAdpater.Fill(dataSet, "Categories");
DataRow row = dataSet.Tables["Categories"].Rows[0];
row ["CategoryName"] = "New Category";
dataAdpater.Update(dataSet, "Categories");