How to import mysql-database using csharp

[earni23]

Hi!
How do I import mysql-database using csharp?

[Mike_O]

Hey earni23,

I'm not sure what you mean by "import", but if you want to connect to a MySQL database via .NET, you have to install a MySQL connector. Here's the link: http://www.mysql.com/products/connector/

Mike

[HostingASPNet]

Hello,

You could also check here - http://dev.mysql.com/doc/refman/5.0/en/connector-net-tutorials-asp-roles.html

Regards

[Eddiewilson]

Hi Everyone,

Thanks for give a great link but i want to know about database connection code step wise..

Thanks,
Eddie wilson

[Mike_O]

Hi Eddie,

What you're asking is vague because there are many ways you can connect to your MySQL DB and for many different purposes. What kind of sql operation(s) are you performing (insert/select/delete/etc...)? Will your call be a query or a stored procedure? What do you want to do with the data? Do you want to loop through each record explicitly or do you want to bind the data to something, or dump it into somewhere in one shot? See what I mean?

For this reason, and also to avoid reiterating this topic all over again, just Google it. I GUARANTEE that you will find plenty of examples of what you're looking for.

Mike

[Eddiewilson]

Hi Mike,

I want to know about code for MySql data base-DB connection with c-sharp.

Thanks in advance
Eddie wilson

[Mike_O]

Hi Eddie,

I hate do do this to you, but what you're asking now is absolutely no different than what you asked the previous time. Like I mentioned before, it is unclear. It's kind of like if you need to fix your car and you go to the shop and tell them - here, go fix my car (i'm sure there are better analogies).

Could you please elaborate more by answering at least these two questions: What do you need to do on the database side?

If you are grabbing data from the database, what do you need to do with the data in your C#.NET program.

Mike

[dadz]

i have tried above things but no luck can some body provide the step by step instructions
thanks

[cyberdesignz]

OleDbConnection conn = new OleDbConnection(
"Provider=MySqlProv;" +
"Data Source=localhost;" +
"User id=UserName;" +
"Password=Secret;"
);

I hope this code will help you to make connection with database.