how to connect database

You could:
1) Try being a little politer.
2) Try google first: http://www.google.co.uk/search?sourceid=chrome&ie=UTF-8&q=database+connection+using+dataset+for+inserting+into+table[^] The top link looks kinda relevant...

Hi,
Hope you are new to this site, Before posting questions better google it your self. Any ways here is the link you may follow.

http://en.kioskea.net/forum/affich-61898-how-to-make-database-connectivity-in-asp-net[^]


Regards

Shiv

Please look at this page again:
http://www.codeproject.com/Questions/ask.aspx[^]

Look at the bottom of the page: "A few simple rules when posting your question". Please be so kind to read and utilize them.

—SA

Creating the Database
Now let's create the database, and the table that we are going to query from our application later on.
From the command line, we start by creating the database:
Collapse
create database ConnectCsharpToMysql;
Then we select the database to use before creating the table:
Collapse
use ConnectCsharpToMysql;
And we create the table that we will query from our application:

using MySql.Data.MySqlClient;
//add MySQL library

private void button1_Click_1(object sender, EventArgs e)
{
string mycon = "SERVER=localhost;DATABASE=manager;UID=root;password=123456";
MySqlConnection connection = new MySqlConnection(mycon);
MySqlCommand command = connection.CreateCommand();
MySqlDataReader Reader;
command.CommandText = "select * from logging where Name='" + textBox1.Text + "' AND Password='" + textBox2.Text + "'";
connection.Open();
Reader = command.ExecuteReader();
while (Reader.Read())
{
if (this.textBox1.Text.Equals(Reader.GetString(0)) && this.textBox2.Text.Equals(Reader.GetString(1)))
{
skl mykk = new skl();
mykk.Show();

}
}


}