Untitled

DateTimePicker value not regarded when updating datagridview to SQL Server
SqlDataAdapter dataAdapter = new SqlDataAdapter("Select * From EDI;", conn.ConnectionString);
SqlCommandBuilder cb = new SqlCommandBuilder(dataAdapter);
dataAdapter.UpdateCommand = cb.GetUpdateCommand();
dataAdapter.Update(dataSet, "EDI");

private void dateTimePicker1_ValueChanged(object sender, EventArgs e)
{
        dataGridView1.CurrentCell.Value = dateTimePicker1.Value.ToShortDateString();
        dateTimePicker1.Visible = false;
}