Programming ideas
My thoughts about vb.Net, asp.net, Php, Javascript and more.
my sql timeout expired in vb.net using data adapter
Error :timeout expired the time out period to completion of the operation or the server is not responding
Solution
Public Function read(ByVal str As String) As DataTable
Dim dt As DataTable = New DataTable()
Try
Dim sql As MySqlCommand = New MySqlCommand(str, con)
Dim DataAdapter1 As MySqlDataAdapter = New MySqlDataAdapter()
DataAdapter1.SelectCommand = sql
DataAdapter1.SelectCommand.CommandTimeout = 0
DataAdapter1.Fill(dt)
Catch ex As Exception
MessageBox.Show(ex.Message)
Finally
If con.State = ConnectionState.Open Then
con.Close()
End If
End Try
Return dt
End Function
How to Change default search engine of FireFox address bar
Create MDI Child Forms
Private Sub CourseFeeToolStripMenuItem_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CourseFeeToolStripMenuItem.Click
Dim NewMDIChild As New Frm_course_fee()
'Set the Parent Form of the Child window.
NewMDIChild.MdiParent = Me
'Display the new form.
NewMDIChild.Show()
End Sub
Please note main form ismdicontainer=true
Dim NewMDIChild As New Frm_course_fee()
'Set the Parent Form of the Child window.
NewMDIChild.MdiParent = Me
'Display the new form.
NewMDIChild.Show()
End Sub
Please note main form ismdicontainer=true
HOW TO RESTORE GOOGLE SPREADSHEET INTO OLDER DATE
First take a look in the revisions (File->Revision history...) of the open document. You may be able to revert to the revision that contains your recent work.
Joining Multiple Tables with SQL Inner Join Statements
SELECT * FROM drivers, vehicles, locations
WHERE drivers.location = vehicles.location
AND vehicles.location = locations.location
WHERE drivers.location = vehicles.location
AND vehicles.location = locations.location
Subscribe to:
Posts (Atom)