Sunday, 19 February 2012

Insertion of data using ADO.net( disconnected architecture)

protected void  btnsubmit_Click(object sender, EventArgs e)
{
c.cmd.CommandText = "select * from registration ";
c.adp.Fill(c.ds,"vt");
c.dr = c.ds.Tables["vt"].NewRow();
c.dr["name"] = txtname.Text;
c.dr["age"] = txtage.Text;
c.dr["contact_no"] = txtcontno.Text;
c.dr["address"] = txtaddr.Text;
c.dr["email_id"] = txtemail.Text;
dr["userid"] = txtuid.Text;
c.dr["pwd"] = txtpwd.Text;
c.dr["hintq"] = DropDownList1.SelectedItem.Text;
c.dr["ans"] = txtans.Text;
c.dr["imgname"] = FileUpload1.FileName;
c.dr["imgpath"] = "~//image/" + FileUpload1.FileName;
FileUpload1.SaveAs(Server.MapPath("~//image/" + FileUpload1.FileName));
c.ds.Tables["vt"].Rows.Add(c.dr);
SqlCommandBuilder scb = new SqlCommandBuilder(c.adp);
c.adp.Update(c.ds.Tables["vt"]);

Page.RegisterStartupScript("onclick", "<script>alert(Your Data Save successfully!!')</script>")
}

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home