Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
~2K People Reached
Interests
Games Programming
Favorite Forums
Favorite Tags
Member Avatar for 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 ??

Member Avatar for swayzion
0
103
Member Avatar for bestex

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?

Member Avatar for Pgmer
0
63
Member Avatar for bestex

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 …

Member Avatar for CodeWord
0
58
Member Avatar for bestex

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 & "','" & …

Member Avatar for Tommymac501
0
110
Member Avatar for bestex

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?

Member Avatar for kvprajapati
0
98
Member Avatar for bestex

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

0
46
Member Avatar for bestex

[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??

Member Avatar for codeorder
0
138
Member Avatar for bestex

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 …

Member Avatar for bestex
0
140
Member Avatar for bestex

[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 …

Member Avatar for bestex
0
476
Member Avatar for bestex

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 …

Member Avatar for bestex
0
113
Member Avatar for bestex

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 …

Member Avatar for bestex
0
206