Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How to Insert a TextBox value in to Sql database using C#
coding?

Answers were Sorted based on User's Feedback



How to Insert a TextBox value in to Sql database using C# coding?..

Answer / anand

SqlConnection con = new SqlConnection();

con.ConnectionString = "data source=anand\\sqlexpress.
initial catalog=Database1;integrated security=sspi;";

SqlCommand myCommand = new SqlCommand();

myCommand.CommandText = "Insert into
usr(firstname,lastname,dob,phno,email,Address,state,bgroup)
Values('" + firstname.Text + "','" + lastname.Text + "'," +
dob.Text + "," + phno.Text + ",'" + email.Text + "','" +
Address.Text + "','" + state.Text + "','" + bgroup.Text + "')";

myCommand.Connection = con;

con.Open();

myCommand.ExecuteNonQuery();

con.Close();

Is This Answer Correct ?    5 Yes 4 No

How to Insert a TextBox value in to Sql database using C# coding?..

Answer / balakumar

string strconn = @"Data Source=localhost;
Initial Catalog=Bala;
Trusted_Connection=yes;";
SqlConnection conn = new SqlConnection(strconn);
conn.Open();
string insertcommand = "insert into Employee
values('" + TextBox1.Text + "','" + TextBox2.Text + "','" +
TextBox3.Text + "')";
SqlCommand cmd = new SqlCommand(insertcommand, conn);
cmd.ExecuteNonQuery();
conn.Close();

Is This Answer Correct ?    3 Yes 2 No

How to Insert a TextBox value in to Sql database using C# coding?..

Answer / surendra

How to Insert two TextBoxs values in to one column sql database using C# coding

Is This Answer Correct ?    0 Yes 0 No

How to Insert a TextBox value in to Sql database using C# coding?..

Answer / thualsi

insertBox("(Text1.Text)")+("(Text1.Text)");

Is This Answer Correct ?    0 Yes 0 No

How to Insert a TextBox value in to Sql database using C# coding?..

Answer / mmm

almost all the posted answers above are correct(85%).

Is This Answer Correct ?    3 Yes 4 No

How to Insert a TextBox value in to Sql database using C# coding?..

Answer / ghanshyam verma

c# question in type

Is This Answer Correct ?    0 Yes 4 No

How to Insert a TextBox value in to Sql database using C# coding?..

Answer / jeevananth

try
{
SqlConnecion cn=new SqlConnection("Data
source=.;database=Studentdetail;uid=sa;pwd=sa");
SqlCommand cmd=new SqlCommand();
cn.Open();
string qry;
qry="insert into Table values('"+ TextBox1.Text +"','"+
TextBox2.Text +"')";
cmd=new(qry,cn);
cmd.cmd.ExecuteNonQuery();


cn.Close();
}
catch(Exception ex)
{
Responce.Write(ex.Message.ToString());
}

Is This Answer Correct ?    0 Yes 6 No

Post New Answer

More ASP.NET Interview Questions

Why is global asax is used?

0 Answers  


What is a page life cycle? What are the events in a page life cycle?

0 Answers  


Explain about ASP.NET?

0 Answers  


Is it possible to write code in many languages in one asp.net project?

0 Answers  


what is the requirement that .Net web services can access the java application?

6 Answers   iSoft,


What is owin authentication?

0 Answers  


How .Net has implemented security for web applications?

1 Answers  


What is new asp.net core?

0 Answers  


Given an ASP.NET Web Form called WebFrom1, what class does the WebForm1 class inherit from by default? a) System.Web.Form b) System.Web.GUI.Page c) System.Web.UI.Page d) System.Web.UI.Form

3 Answers   Syntax Softtech,


what are the server controls used in sitepath navigation?

1 Answers  


Explain automatic memory management in .net.

0 Answers  


Explain what are the advantages of asp.net mvc framework? : asp.net mvc

0 Answers  


Categories