Loading

DataAdapter Code

PankaJ D

I need to insert data using dataAdapter. I have using following code. Isthis code iscorrect or nt??
<<<<<<<<<<<<<<<<<<

private void btnSave_Click(object sender, EventArgs e)
{
SqlConnection cn;

string cnstring = "server=(local)\\SQLEXPRESS;Database=Test;Integrated Security=True";

cn = new SqlConnection(cnstring);

string sql;
sql = "insert into Insert1 values('" + txtname.Text + "'," + txtrno.Text + ",'" + txtadd.Text + "','" + cmdgender + "')";

cn.Open();
SqlDataAdapter da = new SqlDataAdapter(sql, cn);

cn.Close();

}

>>>>>>>>>>>>>>>>

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vasanth16y ago
Through assinging insertcommand for sqldataadapter we will insert , eg ,
SqlDataAdapter da = new SqlDataAdapter();
da.InsertCommand = new SqlCommand ( , cn)
......insert input values in datarow.......
da.update();

No need to use commandbuilder here.
0
Amit Choudhary16y ago
hi friend,

To update or insert using adapter is used with datasets and datatables.
for simple insert statement can be executed using SqlCommand object.
```
SqlCommand cmd=new SqlCommand(cn);
cmd.Text= "insert into Insert1 values('" + txtname.Text + "'," + txtrno.Text + ",'" + txtadd.Text + "','" + cmdgender + "')";
int result=cmd.ExecuteNonQuery();
cn.close();
```
Hope it helps you.
Please mark it as answer and let me know if it helps you.
0