please anyone give me the code for how to save data

Question

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???

shoaib shaikh · Answer

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???

Ravi Shekhar · Answer

check below link... http://www.w3schools.com/sql/sql_autoincrement.asp a nd http://learneveryday.net/asp-net/mysql/insert-in-to-mysql-with-asp-net-part-1/ Mark it as answer if it helped you.

Sanjeeb Lenka · Answer

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

Sunny Sharma · Answer

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!

please anyone give me the code for how to save data

Answers (4)