大家好,
实际上,主题说明问题。详情为何;
我有一个Windows窗体DataGridView从一个SQL表中的数据。我插入DataGridViewCheckBoxColumn的复选框。我需要检查一个或多个复选框(行)更新选定行。有一个列,其中包括的DateTime。我尝试过这么多的代码,但都失败了,我猜是因为DateTime列
我会很高兴,如果你可以给一些例子,如代码。
提前感谢,
For each row as DataGridViewRow in Datagridview1.Rows
'Assuming first column has the checkboxes
If row.Cells(0).Value = True Then
'Carry out update and make sure your DateTime is properly formatted
cmdUpdate = "UPDATE TABLE ... SET ... WHERE ..."
End If
Next
private void button1_Click(object sender, EventArgs e)
{
//sql balant谋 depo giri
SqlConnection sconn = new SqlConnection();
sconn.ConnectionString = "Data Source=R2D2\\SQLEXPRESS;Integrated Security=SSPI;Initial Catalog=depom";
sconn.Open();
//
// here is where selection starts
//
List<DataRow> lst = new List<DataRow>();
for (int i = 0; i < malzemeDataGridView.Rows.Count; i++)
{
if (Convert.ToBoolean(malzemeDataGridView.Rows[i].Cells["sec"].Value) == true)
{
SqlCommand ins = new SqlCommand();
ins.Connection = sconn;
ins.CommandText = "update malzeme set depo='Merkez', degistirmeT=@degT, konum=@knm where malzemeID=@malz";
ins.Parameters.AddWithValue("@malz", malzemeDataGridView.Rows[i].Cells["dataGridViewTextBoxColumn1"].Value.ToString());
ins.Parameters.AddWithValue("@degT", DateTime.Now.ToString());
ins.Parameters.AddWithValue("@knm", textBox1.Text = "");
//ons balant谋s谋 balang谋莽
SqlCommand ons = new SqlCommand();
ons.Connection = sconn;
ons.CommandText = "insert into tarihegore (malzemeID, konum, depo, sinif, marka, model, aciklama, spectrumNO, seriNO, notlar, islemtarihi) values (@malzemeID, @konum, @depo, @sinif, @marka, @model, @aciklama, @spectrumNO, @seriNO, @notlar, @islemtarihi)";
ons.Parameters.AddWithValue("@malzemeID", malzemeIDTextBox.Text.Trim());
ons.Parameters.AddWithValue("@konum", konumTextBox.Text.Trim());
ons.Parameters.AddWithValue("@depo", depoTextBox.Text.Trim());
ons.Parameters.AddWithValue("@sinif", sinifTextBox.Text.Trim());
ons.Parameters.AddWithValue("@marka", markaTextBox.Text.Trim());
ons.Parameters.AddWithValue("@model", modelTextBox.Text.Trim());
ons.Parameters.AddWithValue("@aciklama", aciklamaTextBox.Text.Trim());
ons.Parameters.AddWithValue("@spectrumNO", spectrumNOTextBox.Text.Trim());
ons.Parameters.AddWithValue("@seriNO", seriNOTextBox.Text.Trim());
ons.Parameters.AddWithValue("@notlar", depoTextBox.Text.Trim() + " " + konumTextBox.Text.Trim() + " dan Merkeze geldi.");
ons.Parameters.AddWithValue("@islemtarihi", DateTime.Now.ToString());
//ons balant谋s谋 sonu
//sconn.Open();
MessageBox.Show(markaTextBox.Text.Trim() + " " + modelTextBox.Text.Trim() + " depoya girdi", "Depoya Giri");
ins.ExecuteNonQuery();
ons.ExecuteNonQuery();
try
{
this.malzemeTableAdapter.T眉m眉n眉_G枚ster(this.dataSet1.malzeme);
}
catch (System.Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
sconn.Close();
}
}
}
的