السلام عليكم ورحمته الله وبركاته
يوجد لدى مشكله فى الحفظ حيث يظهر رساله الاتية :
SqlDateTime overflow. Must be between 1/1/1753 12:00:00 AM and 12/31/9999 11:59:59 PM.
حيث ان كود الاضافه هو الاتى
For x As Integer = 0 To DataGridView1.Rows.Count - 1
If DataGridView1.Rows.Item(x).IsNewRow Then
Dim emp_id As Integer = TextBox1.Text
Dim name As String = DataGridView1.Rows.Item(x).Cells(0).Value
Dim date1 As DateTime = DataGridView1.Rows.Item(x).Cells(3).Value
Dim no As Integer = DataGridView1.Rows.Item(x).Cells(5).Value
Dim date2 As DateTime = DataGridView1.Rows.Item(x).Cells(6).Value
Dim kind As String = DataGridView1.Rows.Item(x).Cells(7).Value
Dim notes As String = DataGridView1.Rows.Item(x).Cells(9).Value
Dim cmd2 As New SqlClient.SqlCommand("SELECT COUNT(*) FROM stop_emp WHERE id=@id", cn)
Dim id As Integer = DataGridView1.Rows.Item(x).Cells(0).Value
cmd2.Parameters.AddWithValue("@id", id)
Dim count As Integer = cmd2.ExecuteScalar()
If count > 0 Then
Continue For
End If
cmd.Parameters.Clear()
cmd.CommandType = CommandType.StoredProcedure
cmd.CommandText = "insertstop_emp"
cmd.Parameters.Add("@emp_id", SqlDbType.Int).Value = TextBox1.Text
cmd.Parameters.Add("@name", SqlDbType.VarChar).Value = name
cmd.Parameters.Add("@date", SqlDbType.DateTime).Value = date1
cmd.Parameters.Add("@no", SqlDbType.Int).Value = no
cmd.Parameters.Add("@date1", SqlDbType.DateTime).Value = date2
cmd.Parameters.Add("@kind", SqlDbType.VarChar).Value = kind
cmd.Parameters.Add("@notes", SqlDbType.VarChar).Value = notes
cmd.ExecuteNonQuery()
End If
Next
MessageBox.Show("تم الحفظ ")كما اننى اكتب التاريخ بصورة صحيحه وهى 1/1/2000 مثلا
وشكرا




