insert data into database

Rashmi dev

12y1.6kVisual Basic .NET

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

5 Replies

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

Biswa Pujarini Mohapatra12y ago
Accepted answer
check this thread

http://www.codeproject.com/Articles/45421/Gracefully-Inserting-a-Row-into-an-ASP-NET-GridVie
0
Sanjay Kumar12y ago
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/
0
Biswa Pujarini Mohapatra12y ago
do you mean by inline insert command of gridview, because the example i sent using that you can do database insert through gridview data
0
Rashmi dev12y ago
no I want to insert in gridview insert
0

Biswa Pujarini Mohapatra12y ago

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(); }