how to connect web form using c# and asp.net into sql server in visual studio 2010??

Question

Hello.. Actually i dont have any experience how to develop website.. But I need to make a survey form using c# and asp.net in visual studio 2010.. i have create survey.aspx that contains label button submit and textboxt.. then how to get values from textbox to insert into database??.. i have create database already.. please help me..

George Onofrei · Answer

need more info?

Soft Corner · Answer

Hi  1. Add using System.Data.SqlClient; 2. Create Connection -> SqlConnection con = new SqlConnection(Data Source=.\SQLEXPRESS;Initial Catalog=DBName;Integrated Security=True;); 3. open Connection -> con.Open(); 4. Fetch Values from textbox and add into Database string qurey =  Insert into Tablename values(' + txtfirstname .Text + ''  + txtlastname .Text + ' ' + txtaddr .Text + '); SqlCommand cmd = new SqlCommand(qurey con); cmd.ExecuteNonQuery();

Sam Hobbs · Answer

There are many useful articles in this web site that will help you; look for them. There are very many articles in other web sites too. There are many books too.

heartyna · Answer

thank a lot for helping me.. now i can understand how database can connect with my page..tq so much!!