when i am click on buton then an auto genarate id and value store in sql,
then i am click again in this button then all value are again store for next auto id in sql
Its my code:
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
public partial class Register : System.Web.UI.Page
{
SqlConnection con = new SqlConnection("Data Source=.\\sqlexpress;Initial Catalog=heart;Integrated Security=True");
SqlDataAdapter dap;
DataSet ds = new DataSet();
protected void Page_Load(object sender, EventArgs e)
{
MultiView1.ActiveViewIndex = 0;
opendatabase();
}
void opendatabase()
{
con.Open();
dap = new SqlDataAdapter("select * from tbl_collage,tbl_personal,tbl_company", con);
dap.Fill(ds);
}
...
Go to the complete details ...