SqlConnection con= new SqlConnection(@"Data Source=.\SQLEXPRESS;Initial Catalog=datas;Integrated Security=True");
SqlDataAdapter da=new SqlDataAdapter("select * from tbl_info",con);
DataSet ds=new DataSet();
da.Fill(ds,"tbl_info");
DataRow dr;
SqlCommandBuilder cmd=new SqlCommandBuilder(da);
dr=ds.Tables["tbl_info"].NewRow();
da.Insert.Fill(ds,"tbl_info");
dr["mname"]=txtname.Text;
dr["initial"]=txtinitial.Text;
dr["email"]=txtemail.Text;
dr["color"]=txtcolor.Text;
dr["address"]=txtaddress.Text;
dr["mphone"]=txtphn.Text;
dr["city"]=txtcity.Text;
ds.Tables["tbl_info"].Rows.Add(dr);
da.Update(ds,"tbl_info");
No comments:
Post a Comment