How to Insert a TextBox value in to Sql database using C#
coding?
Answers were Sorted based on User's Feedback
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 | 84 No |
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 |
Answer / sona
insert into emp(empname) values('"+textbox1.Text+"');
Is This Answer Correct ? | 159 Yes | 62 No |
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 |
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 |
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 ? | 66 Yes | 26 No |
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 |
Answer / pksutha
sqlcommand cmd = new sqlcommand("insert into address values
(@textbox1.text,@textbox2.text)",connectionstring);
Is This Answer Correct ? | 63 Yes | 37 No |
Answer / suthasyed
sqlcommand cmd = new sqlcommand("insert into address values
('"+ textbox1.text +"', "+ textbox2.text +")",
connectionstring);
Is This Answer Correct ? | 66 Yes | 41 No |
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 |
In asp.net, how can you validate drop down box?
web user and custom conrols
Explain the reason why the javascript validation not run on the asp.net button but run successfully on the html button?
How can we create a website?
Which is better php or asp.net?
Explain security types in asp.net?
What are the new navigation controls in asp.net 2.0?
State Management (viewstate, session etc)
How can you handle unmanaged code exceptions in asp.net?
Suppose You Want A Certain Asp.net Function Executed On Mouseover For A Certain Button. Where Do You Add An Event Handler?
Explain about solution explorer window?
how can create login from create and written conde in asp.net