No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.
|
I have created a table in mysql database table(tblmysq) with id(autoincrement),name(string),branch(string),sex(string),and dat(datetime).The following error occurs when i try to insert a record:check the manual that corresponds to your mysql server version for the right syntax near line 1. My lines of code are : Try conn = New MySqlConnection(conStr) conn.Open() …
|
|
|
My UPDATE vb.net code below displays this error message:conversion from string "UPDATE tblstaff SET fName='name' " to type 'integer' is not valid.Microsoft.visualBasic conn.Open() If conn.State = ConnectionState.Open Then com = New OleDb.OleDbCommand("SELECT *FROM tblstaff ") com.Connection = conn Dim cb As New OleDb.OleDbCommandBuilder(da) da.Fill(ds, "Eeestaffinfo") Dim sql As String = …
|
|
|
I have created a datagridview on a vb.nt form with drug_id,brand_name,date_made,date_expired as columns and i want to get a vb.net procedure or vb.net code that will insert the data on the datagridview to my Access database when i click insert button on the form.My database contains int_id column which is … 
|
|
|
pls i need a vb.net procedure using sql statement to save data with 5 columns and 10 rows from listview for example,to my access database.Thanks. 
|
|
|
pls someone should help me to format the date_made and date_expired on my form's datetimepickers to "dd/MM/yyyy" date format.See the code below: Dim listofdrugs As New List(Of Drug) For Each ListItem As ListViewItem In lvDrugs.Items 'change list item and subitems to drug Dim newdrug As New Drug With newdrug .drug_id … 
|