انا استخدم الكود التالي
وشغال معي في البرنامج
For Each Row As GridViewRow In GridView2.Rows
'If DateDiff("h", Row.Cells(5).Text, Row.Cells(6).Text) < "24" Then
Row.Cells(7).Text = DateDiff("n", Row.Cells(5).Text, Row.Cells(6).Text) & " min"
Next
For Each Row As GridViewRow In GridView2.Rows
If Row.Cells(7).Text = "196 min" Then 'And Row.Cells(9).Text = "false" Then
Row.BackColor = Drawing.Color.Maroon
Row.ForeColor = Drawing.Color.White
Dim con As New OleDbConnection("Provider=MSDAORA.1;Password=eee;User ID=emp;Data Source=expora;Persist Security Info=True")
Dim cmd As New OleDbCommand("UPDATE emp_req SET late ='yes' WHERE sno = " & Row.Cells(0).Text, con)
Dim cmd1 As New OleDbCommand("UPDATE emp_req SET MAIL_SENT ='true' WHERE sno = " & Row.Cells(0).Text, con)
' Dim RecNo = (GridView2.Rows(Row.RowIndex).Cells(0).Text.ToString)
'cmd.Parameters.AddWithValue("SNO", RecNo)
Try
con.Open()
cmd.ExecuteNonQuery()
cmd1.ExecuteNonQuery()
Finally
con.Close()
End Try
end if
nextبس المشكلة لما نقلت المشروع في IIs
هذا الكود لم يعد يعمل لماذا
ارجووووووو المساعدة
