please anyone give me the code for how to save data

shoaib shaikh

13y1.8k.NET

give me the code for how to save data into database my back end is mysql and also how to write the code of auto increment id???

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

shoaib shaikh13y ago
try { string MyConString = "SERVER=localhost;DATABASE=sale;UID=root;PASSWORD=alimola;"; MySqlConnection connection = new MySqlConnection(MyConString); string cmdText = "INSERT INTO customer(C_Name ,E-mail ,Password ,Address)VALUES ('C_Name.Text','E-mail.Text','Password.Text','Address.Text')"; MySqlCommand cmd = new MySqlCommand(cmdText, connection); connection.Open(); int result = cmd.ExecuteNonQuery(); connection.Close(); //lblError.Text = "Data Saved"; } catch (Exception ) { Console.Write("not entered"); //lblError.Text = ex.Message; } i have this code also,but it is not working properly...when i click save button it is displaying me the message that data save successfully...but when i check my database...it is empty..so please tell me what is the reason of it???
0
Ravi Shekhar13y ago
check below link...

http://www.w3schools.com/sql/sql_autoincrement.asp

and

http://learneveryday.net/asp-net/mysql/insert-in-to-mysql-with-asp-net-part-1/

Mark it as answer if it helped you.
0
Sanjeeb Lenka13y ago
check this link

http://www.c-sharpcorner.com/uploadfile/iamibohal/how-to-connect-mysql-server-with-Asp-Net-2005-2008-C-Sharp/

http://dev.mysql.com/doc/refman/5.0/en/example-auto-increment.html
0
Sunny Sharma13y ago
Hi Shoaib,

To use MySql Database in C#, download and install MySql .NET connector from here:
http://dev.mysql.com/downloads/connector/net/

After you finish installation,add reference to MySql.Data.dll and add namespace as:
Using MySql.Data.MySqlClient;

Syntax for ConnectionString is as follows:
"Server=localhost;uid=username;password=pwd;database=test;pooling=false;"

Below is a sample code snippet which will enable you to connect and perform operations on MySql Database:

//Create and initialize the connection and command
MySqlConnection conn = new MySqlConnection(connectionString);
MySqlCommand cmd = new MySqlCommand("select * from table", conn);
try
{
conn.Open();
}
catch(Exception ex)
{
// Database connection error;
}

if (conn.State == ConnectionState.Open) //ConnectionState Enum is contained in System.Data namespace
{
//Perform operations here
```
MySqlCommand cmd = new MySqlCommand("INSERT INTO myTable values (...);", mycon); 
```
try
{
cmd.ExecuteNonQuery();
}
catch(Exception ex)
{
//Handle exception here
}
}

if (conn.State == ConnectionState.Open)
{
try
{
conn.Close();
}
catch { }
}

--------------------------------------------------------------------

Happy Coding :)

Mark it as answer if it helps.
Cheers!
0