I used a Datagridview, I fetch my table data into the Datagridview.
And I add a Select Checkbox column and date column into the same Datagridview.
When I will check checkbox that time that row should be save into the database.
For date column I am using datetime picker control into the datagridview (not separately on the form).
When I debug it all column able to save but not date.
Now I am not able to save my row into the database.
What I have tried:
I have used this code for datetime picker add in datagridview.
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
{
DateTimePicker dtp = new DateTimePicker();
if (e.ColumnIndex == 1)
{
dtp = new DateTimePicker();
dataGridView1.Controls.Add(dtp);
dtp.Format = DateTimePickerFormat.Short;
Rectangle oRectangle = dataGridView1.GetCellDisplayRectangle(e.ColumnIndex, e.RowIndex, true);
dtp.Size = new Size(oRectangle.Width, oRectangle.Height);
dtp.Location = new Point(oRectangle.X, oRectangle.Y);
dtp.Visible = true;
}
}
This code is for Save button to save that checked row into the database.
private void Btnsaveandpass_Click(object sender, EventArgs e)
{
foreach (DataGridViewRow dr in dataGridView1.Rows)
{
bool checkboxselected = Convert.ToBoolean(dr.Cells["Column1"].Value);
if (checkboxselected)
{
string insert = "insert into TBLDailyRecord values( @date ,@brandname, @generatedcode, @perpieceprice, @percentage, @soldprice)";
SqlCommand cmd = new SqlCommand(insert, con);
cmd.Parameters.AddWithValue("@date",dr.Cells[1].Value );
cmd.Parameters.AddWithValue("@brandname", dr.Cells[2].Value);
cmd.Parameters.AddWithValue("@generatedcode", dr.Cells[3].Value);
cmd.Parameters.AddWithValue("@perpieceprice", dr.Cells[4].Value);
cmd.Parameters.AddWithValue("@percentage", dr.Cells[5].Value);
cmd.Parameters.AddWithValue("@soldprice", dr.Cells[6].Value);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
label1.Text = "Selected rows save";
}