while inserting record in database its inserting twice in asp.net

Question

while inserting record in sql server database. every time inserting 2 records, i think event firing two times. how to stop inserting records twice in ado.net.

protected void btnSubmit_Click(object sender, EventArgs e)
{
    try
    {
        CompanyName = txtCompany.Text.Trim();
        InsertData();
    }
    catch (Exception)
    {
        throw;
    }
}

private void InsertData()
{
    if (Page.IsPostBack)
    {
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["kernelCS"].ConnectionString);
        SqlCommand cmd = new SqlCommand(@"INSERT INTO [tbl_Leads]([CompanyName])VALUES(@CompanyName)", con);
        cmd.Parameters.AddWithValue("@CompanyName", txtCompany.Text.ToString());
        con.Open();
        cmd.ExecuteNonQuery();
        DataSet ds = new DataSet();
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        da.Fill(ds);
        ...
    }
}

i tried to stop inserting twice .so i used page.ispostback@RahulSingh — krishna mohan
– krishna mohan, Commented Dec 14, 2015 at 6:23

Jay Bhalani · Accepted Answer · 2015-12-14 06:59:44Z

6

You are firing the query twice in your code by cmd.ExecuteNonQuery() and da.Fill(ds) statements.

edited Dec 14, 2015 at 6:59

Jay Bhalani

4,1818 gold badges40 silver badges51 bronze badges

answered Dec 14, 2015 at 6:30

Akshey Bhat

8,6872 gold badges23 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Vaibhav Chaurasiya · Accepted Answer · 2015-12-14 06:36:30Z

0

Try This :

private void InsertData()
{
  SqlConnection con = new  SqlConnection(ConfigurationManager.
  ConnectionStrings["kernelCS"].ConnectionString);
  SqlCommand cmd = new SqlCommand(@"INSERT INTO [tbl_Leads]
  ([CompanyName]) VALUES (@CompanyName)", con);
  cmd.Parameters.AddWithValue("@CompanyName", txtCompany.Text.ToString());

  con.Open();
  cmd.ExecuteNonQuery();
}`

answered Dec 14, 2015 at 6:36

Vaibhav Chaurasiya

1669 bronze badges

Collectives™ on Stack Overflow

while inserting record in database its inserting twice in asp.net

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related