I want to save datetime picker column of datagridview into the database.

See more:

C#

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 ); // I am getting error here.



			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";
	}