insert data into database

Question

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

Biswa Pujarini Mohapatra · 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 (); }