how to submit values into sql server 2008 using c#

Question

employee name textbox employee designation textbox employee mobile number textbox submit when am submittg these values saved in to sql server 2008 i need c# code and how to web config

Munesh Sharma · Answer

In Web Config File:- On C# page Some namespace using System; using System.Collections.Generic; using System.Data.SqlClient; protected void Page_load(object source EventArgs e) { } string str = configurationmanager.connectionstring[connect].connectionstring(); protected void Submit_event(object source EventArgs e) { sqlconnection con = new sqlconnection(); con.open(); sqlcommand cmd = new sqlcommand( insert into tablename values(@1  @2 @3con) cmd. Parameters.Addwithvalue ( @1textbox1.text) cmd. Parameters.Add withvalue ( @2textbox2.text) cmd. Parameters.Add withvalue ( @3textbox3.text) cmd.executenonquery(); con.close(); }

Jignesh Trivedi · Answer

hi Please refer below link it might help you. http://www.dotnetperls.com/sqlclient http://msdn.microsoft.com/en-us/library/ms233812.aspx http://www.devmanuals.com/tutorials/ms/aspdotnet/insertdataindatabse.html