i have a table with auto id (here id is "Case_Ref"), when i am click on submit button then all data are stored in sql and then when i am update these data and click on submit button then a new auto id generate and these all updated data stored in new ID.
i want to remove Duplication of data on two or more ID
aspx Code:
public partial class Admin_Add_New_Party : System.Web.UI.Page
{
clsConnection c1 = new clsConnection();
static int ind = 0;
protected void Page_Load(object sender, EventArgs e)
{
lbl_Date_Enter.Text = DateTime.Now.ToString("dd/MM/yyyy hh:mm tt");
if (!IsPostBack)
{
FillDetails();
}
}
private void FillDetails()
{
SqlDataReader rd;
string sql;
if (Session["Case_Ref"] != null)
{
sql = "SELECT * FROM tbl_FPD WHERE Case_Ref='" + Session[&q ...
Go to the complete details ...