Comments by jleonorlane (Top 42 by date)

i want to INSERT some data on my website MySQL database. I have already done using the MySQL OBDC Connector and Connector/NET...

Thanks..so where can i get the MySql.Web.dll?and does my connection string change?or just the same?

..thanks thatraja, what i have done now is ,i have try first to connect using the SQLyog SSH Tunnel.
And i had successfully connect to the database of my website.
But my desktop app can't connect to the website database.Do i have to put an SSH feature to my app, for me to connect to my website's database?

thanks..this works but i want from the user input,and then anything that he enter,adds to the datagridview..
here what i've done..but i want it add everytime the user inserts something...
Dim str As String = InputBox("Enter new string")
DataGridView1.Rows(0).Cells("DataGridViewTextBoxColumn1").Value = str

...sorry..i dont have money to pay you now...

..sorry...ok..i'll try ....sorry for disturbances...

...yes a website database...
But how..?i really dont know about on it...

..Thanks..but how about in VB.NET

...where should put this code?in a main form of my app...?

i got an error in the Creat_XML() Functions, says "Token StartElement in state Epilog would result in an invalid XML document."

My Codes in the GetList_First() Function:
.....
Dim writer As New XmlTextWriter("Student List.xml", System.Text.Encoding.UTF8)
writer.WriteStartDocument(True)
writer.Formatting = Formatting.Indented
writer.Indentation = 2

writer.WriteStartElement("Student")
writer.WriteEndElement()

Dim i As Integer = 0
Dim rCnt As Integer = dtgView.Rows.Count
For i = 0 To rCnt - 1

With dtgView

Create_XML(.Item(0, i).Value, _

.....

..but it does not work....

..now here's what i've got...take a look at it...

..no, just a bit of code on the tick event on the timer

can you give me on how to handle on the tick event if the timer

..thanks for this effort...

..thanks also helpful...

..can you please tell me how to done that thing...please..

can you show me some...

yes

..by the way,sorry...i just cant find any answers for my problem...

..thats the problem ....HOW..?

Reason for my vote of 3
..cause i cant see the solution for my problem,even a clue ...
thank u by the way..

..can you give me some links..?

i tried this one :
If Not rowsReader.IsDBNull("Null").ToString Then
If Not rowsReader.GetString("Null").ToString = "YES" Then
query += " NOT NULL"
End If
End If

but still, i got the same error from the top.

I still got an Error "Conversion from String "NULL" to type 'Integer' is not valid."

i cant get the "ex.Message.ToString" in the ErrorLog after the Messagebox in my Try Catch, its becomes null...

Reason for my vote of 1
Not Satisfied

..hey but there's no "ItemDataBound" Event in Datagrid in Visual Studio 2008.I can't see it.

Opps.. sory..
But I've got several errors...
'm using MySQL Server 5.0
.NET Connector 5.2.2
Connector OBDC 5.1

..how about if could there be a progress bar while backing up the database..

...well thank you..., but i figure it out already...

i've got an error "Value of Type DataGridViewRow cannot be converted to Integer"

Reason for my vote of 1 I have checked it & give correct results but my point is to get all what i have arrived result in first 3 IFNULL() clause...

SM: That was a good reason to vote down! What i said was a suggestion and not a resolution. You posted a full big query with a single statement that there is an output error, how would one know which one you are talking of? You did not added that, individually it was working fine. Yet, thanks for the vote!

how about in VB.NET

..how about in Listview