Hi. Can you show us how you insert the two rows from TextBoxes to the DataSet. And what is this factor property of the DataSet.

Hi public void SetMyCustomFormat() { // Set the Format type and the CustomFormat string. dateTimePicker1.Format = DateTimePickerFormat.Custom; dateTimePicker1.CustomFormat = "MMMM dd, yyyy - dddd"; } Hope it helps

Can you show us C# code that execute the huge insert. If you use the same stored procedure to insert big number of rows, you can use sqlCommand.Prepare(), where sqlCommand = new SqlCommand("MyStoredProcedure", myConnection)