Is it possible to insert value of TextBox into Sql database using C sharp?

[Sarfaraj Khan]

Hi Friends,

Is it possible to insert value of TextBox into Sql database using C sharp ? I am trying to code the c sharp program to insert value of TextBox into Sql database, but I am not yet successful in it.
I want to know your suggestion over this, please don't hesitate to suggest. I am waiting for your reply.

[opaper]

Hi,

Use following statement in your program to insert the textbox value and execute that program.

sqlcommand SQcmd =
new sqlcommand ("INSERT INTO TABdemo values (@textboxName1.text, @textboxName2.text)", Connectionstring);

I hope it will definitely help you.

[MindSpace]

Hello Friend,

Yes it is possible to insert value of TextBox into Sql database using C sharp. I have tried this try of program many times. But code for this program is quit complicated to understand, See below:

SqlCommand CmdSqlStr = new SqlCommand("insert into Customers (FirstNm,SurNm,Addr,,Pstcode,PhoneNum)
Values (@FirstNm,@SurNm,@Addr,@Pstcode,@PhoneNum)", conn);

conn.Open();

CmdSql.Parameters.AddWithValue("@PhoneNum", PhoneNum);
CmdSql.Parameters.AddWithValue("@Pstcode", Pstcode);
CmdSql.Parameters.AddWithValue("@FirstNm", FirstNm);
CmdSql.Parameters.AddWithValue("@SurNm", SurNm);
CmdSql.Parameters.AddWithValue("@Addr", Addre);

CmdSql.ExecuteNonQuery();

conn.close();

[Modifier]

Hi,

I think you need to use the "insert" command of SQL in your C sharp program. First define the connection string for SQL database connection. Then you need to assign the "insert" command to the defined connection string. Following is the syntax and example for the same:

Syntax:
Insert into tableName(columnName, columnName,columName) values (ColumnValues,ColumnValues,ColumnValues)

Example:
Insert into emply (EmpName, empl_id, dsigntion) values ('"+txtbox1.text+"',"+txtbox2.text+",'"+textbox3.text +"');

[Praetor]

Example of inserting textbox value into the sql:

void Buttn1_Click(EventArgs e, object sender )
{

SqlConnection myCon = new SqlConnection();

myCon.ConnectionString = “Put connection string here“;

myCon.Open();

string strqr = “Insert into stud values (” + TextBoxOne.Text +
“,’” + TextBoxTwo.Text + “‘,’” + TextBoxThree.Text + “‘)”;

SqlCommand myCm = new SqlCommand (strqr, myCon);

int numrw = myCm.ExecuteNonQuery();

myCon.Close();

}

[Katty]

I have used below sqlcommand statement in my c sharp program for sql database connection. Copy this sqlcommand statement and replace the the values of "txtbx1" and "txtbx2" with your defined names for text boxes:

sqlcommand cmmd =
new sqlcommand("insert into addressdemo values
('"+ txtbx1.text +"', "+ txtbx2.text +")",
connectionstring);