insert data into database

Question

hi, I need code how to insert data into database, please help me

Biswa Pujarini Mohapatra · Accepted Answer

check this thread
http://www.codeproject.com/Articles/45421/Gracefully-Inserting-a-Row-into-an-ASP-NET-GridVie

Sanjay Kumar · Answer

Hi
http://www.c-sharpcorner.com/UploadFile/0c1bb2/inserting-form-data-into-database-and-display-it-in-gridview/
http://www.c-sharpcorner.com/UploadFile/0c1bb2/inserting-from-data-into-database-using-stored-procedure-in/
http://www.c-sharpcorner.com/UploadFile/47548d/simple-insert-select-update-and-delete-in-Asp-Net-using-mysq/

Biswa Pujarini Mohapatra · Answer

do you mean by inline insert command of gridview, because the example i sent using that you can do database insert through gridview data

Rashmi dev · Answer

no I want to insert in gridview insert

Biswa Pujarini Mohapatra · Answer

you can use ADO.NET to insert
e.g.
using ( SqlConnection connection = new SqlConnection ( connectionString )) { SqlCommand cmd = new SqlCommand ( "INSERT INTO Data (Name, PhoneNo, Address) VALUES (@Name, @PhoneNo, @Address)" ); cmd . CommandType = CommandType . Text ; cmd . Connection = connection ; cmd . Parameters . AddWithValue ( "@Name" , txtName . Text ); cmd . Parameters . AddWithValue ( "@PhoneNo" , txtPhone . Text ); cmd . Parameters . AddWithValue ( "@Address" , txtAddress . Text ); connection . Open (); cmd . ExecuteNonQuery (); }