Add new record in to sql database

Question

Hi, i want to add new record into a SQL Server 2000 database from the controls of form using ADO.NET.Can someone help me how i can write the code for this ?????

paparao · Answer

Here i am writing the code for add new record.(By using asp.net with C#.net) 1) u should create table name like (student) in database or u can create from front end itself and create some fields like sno and sname ok.......... 2) u should take fields like student number, student name and u take button name like ADD or INSERT ok................ 3)double click ADD or INSERT button and then 4)go to the coding part and type following statement in namespaces using System.Data.SqlClient; 5) Button1_click { try { sqlconnection con= new sqlconnection (userid=..;password=................;server=............;database=............. "); sqlcommand cmd=new sqlcommand(); con.open(); cmd.commandtext="insert into student values ("+textbox1.text+",'"+textbox2.text+"')"; cmd.connection=con; cmd.ExecuteNonQuery(); con.close(); Response.Write("Records Are Insertd"); } catch(SqlException e) { Response.write(E.Message()); } }//Button1

Jan Montano · Answer

There are various ways to do this. I personally, would call a stored procedure to insert a record in my table. Here's a link to get you started: This example constructs an insert query. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1738271&SiteID=1

Add new record in to sql database

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)