How to get data from remote mysql in grid ??

[Saurabh]

Hii,

I have a grid and i want the data from my remote mysql. I have tested the connection but i am not aware as how to get the data in the grid.

Like this is my connection-
 string connString = "Server=174.121.35.162;Database=funiks_phonebook;Uid=funiks_phonebook;Pwd=phonebook;Port = 3306;";
            MySqlConnection conn = new MySqlConnection(connString);
            MySqlCommand command = conn.CreateCommand();
            command.CommandText = "select contactname,phno from phonebook";

Now i want to get these values in my grid, please advise, Please stretch it so that i can change the values and update the table as well.

It will be very helpful.

[Stefan]

Hi Saurabh,

Thank you for writing.

Please refer to the following documentation article, which explains in a step by step manner how to bind your grid to a sql table: http://www.telerik.com/help/winforms/gridview-populating-with-data-tutorial-binding-to-datatable-or-dataset.html.

Let me know if you have any additional questions.
 
Regards,
Stefan
the Telerik team

[Saurabh]

Thank you,

i was waiting since long for this help. See i am trying to join to remote or local mysql  or sql server or access, so please help me accordingly

[Saurabh]

Its been around 4 days i am waiting for an answer

i want to remind that i wish to use mysql with grid and the link you have posted is guiding about acess and sqlserver.

Please advise me on right direction.

Thanks.

[Stefan]

Hello Saurabh,

Thank you for writing.

Here is a quote from the "Important information on using the Telerik forums" thread.

The goal of the Telerik Forum is to provide all registered users with a way to find answers to their questions before officially contacting Telerik. In case you need a faster and precise response, please start a new support ticket as it gets higher priority than Forum posts.

A post in the Forums doesn't guarantee you a response from the Telerik support team although 95% of all posts are eventually addressed. Additionally, a post is not assigned a response time as with the support ticketing system. 

I would add that the usual response time for forums is 72 hours (business days only). Your first post was on Oct 21, and you got an answer on Oct 23 - less than 72 hrs. Then your posted again on Oct 23, so you should get an answer in 72 hrs from then.

More information about the support plans is available here: http://www.telerik.com/purchase/support-plans.aspx.

In regards to your question at hand, the article which I provided indeed demonstrates how to use access db, however, if you take a look at p5 in the article, you can see how to change the datasource type. p6 gives you the list with the available options access/sql/oracle/etc. Select the one that you need, click OK, and then when back to p5, add your server address, user and pass and you should be good to go. Additional information about setting up a data source can be found on MSDN: http://msdn.microsoft.com/en-us/library/ms171890.aspx.

I hope that you find this information useful.

All the best,
Stefan
the Telerik team