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 …

Hi Can anyone please check my code ? I'm trying to get today's date from database I tried many ways and I'm stuck now.. at my database access the transdate appears like this [CODE]11/29/2009 2:02:23 AM[/CODE] and this is my query code from VB.NET [CODE]"SELECT TransDate, Deposit, Withdrawal, TotalAmount FROM …

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, I am creating a project for my VB class, using VB 2008 Express, and I would like to be able to have the age of child (whose birthdate is a constant, in otherwords, it won't be changed or entered). I figure that I would need to use the "[B]Today …

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 …