CasperG

Help!!! I cannot get my combo box to populate using a select statement from mysql database. Please see below for coding [code] CN = New ADODB.Connection 'Connecion to database CN.Open("driver={mysql odbc 5.1 driver};server=localhost;database=v_control;user=root;password=;option=3") RS = New ADODB.Recordset RS.Open(SQLdata, CN, ADODB.CursorTypeEnum.adOpenUnspecified, ADODB.LockTypeEnum.adLockPessimistic) If DBconnect() = True Then SQLSearch("select * from engineer …

Where do you want the data to appear? you have selected the data, but you havnt said what you want to do with it?

Can anyone tell me what is wrong with this code, i am trying to add information into a gridview from a sql datbase, thanks SQLSearch("SELECT * FROM engineerissues WHERE EngineerNumber = " & cmbRepTyp.Text) RS.AddNew() Dim dgvRow As New DataGridViewRow Dim dgvCell As DataGridViewCell dgvCell = New DataGridViewTextBoxCell() dgvCell.Value = …

Hi Sharon, not 100% sure if this is what you are after, but give it a go. create yourself a form add dateTimePicker control add command button add this code to the command button_on click event [code] MsgBox("Your birth date was " & DateTimePicker1.Text) MsgBox("Day of the year: " & …

Hi, hope you can help, i am quite new to this. I need to know who to write data from several text boxes on a form to a sql database. I have created the sql database on a localhost using myphp admin, i have created the connection in a module …