Hi tanung ko lang po kung anu mali sa code ko , code po sya to - TopicsExpress



          

Hi tanung ko lang po kung anu mali sa code ko , code po sya to check faculty schedule. Pag nag input po ako ng bagong schedule hahanapin nya sa database kung may conflict sa faculty schedule bag may conflct po may display po na msgbox pag wala pong conflict insert po sa database ang problema ko po ay ung program ko pag may na check na po syang conflict ay dina sha ulit makaka check ng conflict slmat po lagi n lang po sya insert schedule agad slmat po Sub checkfacsched1() Try Dim aws As String Dim asdf As Integer sqlcmd.Connection = sqlcon sqlcmd.CommandText = select * from schedule where day_id = & ComboBox4.SelectedValue & and fid= & ComboBox2.SelectedValue & and (start_time between & ac & and & endt.SelectedValue & ) and (end_time between & ac & and & endt.SelectedValue & ); dr = sqlcmd.ExecuteReader While dr.Read asdf = dr.Item(0) End While If asdf = Nothing Then fclose() Else aws = MsgBox(FACULTY SCHEDULE CONFLICT, +vbOKOnly + MsgBoxStyle.Information) If aws = vbOKOnly Then Me.Refresh() End If End If dr.Close() Catch ex As Exception End Try End Sub
Posted on: Sun, 28 Sep 2014 12:45:09 +0000

Trending Topics



Recently Viewed Topics




© 2015