bestex

Hi guyz, My problem is when i am saving a record in MySQL Database there is an error occured "Incorrect datatime value 3/20/2011 for COLUMN DATE at ROW 1" I used Date as my DataType in MySQL server? Can anyone fix my error ??

Hi why do i have errors in updating a column using where? this is my code [CODE]"Update inventory Set isExpired='1' from inventory where expirationDate= '" & DateTimePicker1.Text & "'"[/CODE] my date format is yyy-MM-dd can anyone help me pls?

Hi im having a problem on displaying my Date ng my listview here is my code [CODE] Private Sub frmTransaction_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Try IsConnected("Select CONCAT(person.lastName, ',',person.firstName,' ',person.middleName) AS FullName, transaction.transactionDate from transaction INNER JOIN person ON person.personId = transaction.personId", False) Call Loader() Catch …

hi, can i ask how do i insert my records from my textbox to specific column name of my table [CODE]IsConnected("Insert into products values(" & _ Me.TextBox1.Text & ",'" & _ Me.TextBox2.Text & "','" & _ Me.TextBox3.Text & "','" & _ Me.TextBox4.Text & "','" & _ Me.TextBox5.Text & "','" & …

hi guyz , i have an error in my path, all i want is to make app.path correct heres is my code [CODE] Dim cryRpt As New ReportDocument cryRpt.Load(Application.StartupPath & "\ProductList.rpt") CrystalReportViewer1.ReportSource = cryRpt CrystalReportViewer1.Refresh()[/CODE] i dont know what the error?

hi guyz, can i ask is it possible if ireport or jasperreport can be used as Reports in vb.net?? need some advice here?

[CODE] IsConnected("Select count(ID) from transaction", False) If myDR.Read = True Then Me.TextBox1.Text = myDR.GetValue(0) + 1 Else Me.TextBox1.Text = 1 End If TextBox1.Focus() End If[/CODE] im going to ask how can i make my autonumber like these "10001" instead of "1" can anyone help me to fix my code??

Hi Guyz, i just wanna know how to fix my problem, or rather fix my code and simply my code base on my MODULE. heres the error " You have an error in your SQL syntax; check the manual that corresponds to your mysql server version for the right syntax …

[CODE]Imports MySql.Data.MySqlClient Public Class Form8 Dim connection As MySqlConnection Dim con As MySqlConnection Dim da As MySqlDataAdapter Dim dt As DataTable Dim strQuery As String Private Sub Form8_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load strQuery = "server=localhost; user id=root; password=phoenix0931; database=accounts;" con = New MySqlConnection(strQuery) con.Open() Me.Text …

Hi all, heres my code [CODE]Dim con As New MySqlConnection("server=localhost; user id=root; password=phoenix0931; database=accounts;") Try con.Open() Dim dat As MySqlDataAdapter = New MySqlDataAdapter("SELECT customers_id,customer_name,customer_add FROM customers ", con) Dim dt As New DataSet dat.Fill(dt, "customers") ComboBox1.DataSource = dt.Tables("customers").DefaultView ComboBox1.DisplayMember = "customer_name" ComboBox1.ValueMember = "customers_id" Catch ex As Exception MessageBox.Show(ex.Message) Finally …

I dont know what code to put Here? to get the exact value of my record on my database here is my code [CODE] Protected Const strConnPubs As String = "server=localhost; user id=root; password=phoenix0931; database=accounts;" Protected strPubsCMD As String = "select customers_id, customer_name from customers" Protected dvName As DataView Protected …