Data Stored Double Time in Sql Server

See more:

ASP.NET

Hi,

when i save the data it will save without any error but with in that save null columns.

For Example:

if i save id no 2 that saved successfully but before id no 1(one) added empty columns. here my code

DAL:

#region InsertData
   public int Insert(NCBAL ObjInsert)
   {
       con = new SqlConnection(constr);
       con.Open();
       cmd = new SqlCommand("InsertNewComp_SP", con);
       cmd.CommandType = CommandType.StoredProcedure;
       try
       {
           cmd.Parameters.AddWithValue("@compliantID",ObjInsert.compid).ToString();
           cmd.Parameters.AddWithValue("@customerid", ObjInsert.cusid).ToString();
           cmd.Parameters.AddWithValue("@customername", ObjInsert.cusname).ToString();
           cmd.Parameters.AddWithValue("@branchid", ObjInsert.ddlbranch).ToString();
           cmd.Parameters.AddWithValue("@servicetype",ObjInsert.servicetype);
           return cmd.ExecuteNonQuery();
       }
       catch
       {
           throw;
       }
       finally
       {
           cmd.Dispose();
           con.Close();
           con.Dispose();
       }
   }
   #endregion

BAL:

#region Insert Data
   public int Insert(NCBAL ObjInsert)
   {
       try
       {
           return ncd.Insert(ObjInsert);
       }
       catch
       {
           throw;
       }
       finally
       {
           ncd = null;
       }
   }
   #endregion

UI:

ncb.compid = txtcompid.Text;
                        ncb.cusid = txtcusid.Text;
                        ncb.cusname = txtcusname.Text;
                        ncb.cusnum = txtcusnumber.Text;
                        ncb.compname = txtcompname.Text;
                        ncb.ddlproduct = DDlProductname.Text;
                        ncb.compliant = txtCompliant.Text;
                        ncb.compdate = Convert.ToDateTime(txtcompdate.Text);
                        ncb.solution = txtsolution.Text;
                        ncb.ddlassign = DDlAssign.Text;
                        ncb.datetocomp = Convert.ToDateTime(txtdatetocom.Text);
                        ncb.ddlpriorty = DDlPriorty.Text;
                        ncb.ddlstatus = DDlStatus.Text;
                        ncb.complianttime = txtcomplianttime.Text;
                        ncb.datetocomp = txtdatecomptime.Text;
                        ncb.ddlbranch = DDLbranch.Text;
                        String str = "";
                        for (int i = 0; i <= CBLservicetype.Items.Count - 1; i++)
                        {
                            if (CBLservicetype.Items[i].Selected)
                            {
                                if (str == "")
                                {
                                    str = CBLservicetype.Items[i].Text;
                                }
                                else
                                {
                                    str += "," + CBLservicetype.Items[i].Text;
                                }
                            }
                        }
                        ncb.servicetype = str;
                         int result = ncb.Insert(ncb);
                    }

How Can i Solve that...