Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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 / chandra shaker

insert into emp(empname) values('"+textbox1.value+"')


If you use html cocntrol textbox1.Value
or
If you use Aso cocntrol textbox1.Text

Is This Answer Correct ?    192 Yes 83 No

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

Answer / v.vijayakumar

Syntax:
INSERT INTO table name(column name,column name,column
name)values(values,values,values);
Example:
INSERT INTO
employee(Name,emp_id,designation)values('"+textbox1.text+"',"+textbox2.text+",'"+textbox3.text+"');


..................if u use Html control we must use
textbox1.value ..if u use asp.net controls we have to use
textbox1.text........

Is This Answer Correct ?    160 Yes 56 No

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

Answer / sona

insert into emp(empname) values('"+textbox1.Text+"');

Is This Answer Correct ?    159 Yes 62 No

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

Answer / premkumar.m

in asp.net webform,

first assign namespace like using system.data.sqlclient;

insert coding

sqlcommand cmd = new sqlcommand("insert into address values
('"+ textbox1.text +"', "+ textbox2.text +")",
connectionstring);

note:

Is This Answer Correct ?    145 Yes 56 No

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

Answer / digital

SqlCommand CmdSql = new SqlCommand("INSERT INTO
Customers(FirstName,Surname,Address,City,Postcode,PhoneNumber)
Values
(@FirstName,@Surname,@Address,@City,@Postcode,@PhoneNumber)", conn);
conn.Open();
CmdSql.Parameters.AddWithValue("@FirstName", FirstName);
CmdSql.Parameters.AddWithValue("@Surname", Surname);
CmdSql.Parameters.AddWithValue("@Address", Address);
CmdSql.Parameters.AddWithValue("@City", City);
CmdSql.Parameters.AddWithValue("@Postcode", Postcode);
CmdSql.Parameters.AddWithValue("@PhoneNumber",
PhoneNumber);
CmdSql.ExecuteNonQuery();
conn.Close();

//all @values are names of the variables the text value is
stored as (you could also enter txtFirstName.Text etc.)
//conn = connection name (which should be declared before
the page_load

Is This Answer Correct ?    113 Yes 35 No

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

Answer / jegan

SqlConnection con = new SqlConnection();
con.ConnectionString = "connection string(path)";
try
{
con.Open();
SqlCommand cmd = new SqlCommand("insert into emp_detail values(' " + tb1.Text + " ',' " + tb2.Text + " ',' " + tb3.Text + " ')", con);
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception ex)
{
throw new Exception(ex.ToString());
}

Is This Answer Correct ?    65 Yes 26 No

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

Answer / ramachandraprabu

SqlConnection conn = new SqlConnection(strCon);
SqlCommand CmdSql = new SqlCommand("INSERT INTO Customers
(Firstname,Lastname,Address)Values('" + textbox1.Text
+ "', '"+textbox2.Test+"', '"+textbox3.Text+"')", conn);
CmdSql.ExecuteNonQuery();


\\If u use Html control we must use
textbox1.value
\\If u use asp.net controls we have to use
textbox1.text

Is This Answer Correct ?    51 Yes 23 No

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

Answer / pksutha

sqlcommand cmd = new sqlcommand("insert into address values
(@textbox1.text,@textbox2.text)",connectionstring);

Is This Answer Correct ?    63 Yes 37 No

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

Answer / suthasyed

sqlcommand cmd = new sqlcommand("insert into address values
('"+ textbox1.text +"', "+ textbox2.text +")",
connectionstring);

Is This Answer Correct ?    66 Yes 41 No

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

Answer / pranitha

first assign namespace like using system.data.sqlclient;

SqlCommand cmd = new SqlCommand("insert into emp
(EmpName,EmployeeCode,Designation,Location)values('" +
TextBox1.Text + "','" + TextBox2.Text + "','" +
TextBox3.Text + "','" + TextBox4.Text + "')");

Is This Answer Correct ?    51 Yes 33 No

Post New Answer



More ASP.NET Interview Questions

What type of code (server or client) is found in a Code- Behind class?

2 Answers  


What data type does the RangeValidator control support?

3 Answers   Visual Soft,


In which event of the page life cycle, is the viewstate available?

0 Answers  


How would you get ASP.NET running in Apache web servers - why would you even do this?

1 Answers   Siebel Systems,


If there are two web.config files in a application which config files will get priority?

5 Answers  






In a Repeater control how one can provide an alternating color scheme ?

0 Answers   Siebel,


When was asp.net released?

0 Answers  


Should sn.exe be used before gacutil.exe ?

2 Answers   Accenture, BirlaSoft,


Explain the use of dataadapter.

0 Answers  


what is meant by sitemapnode ?

0 Answers   Netsweeper,


What's a bubbled event?

3 Answers   Siebel,


Is asp.net mvc front end or backend? : Asp.Net MVC

0 Answers  






Categories