Insert values into database from ASP.NET page

Hi,
Need ur DB details as error relates to DB

1. Table structure.
2. Any parent or child tables relates to this table
3. Existing row details.
4. Once delete the existing 2 rows and then try to insert new row what's resut?

HI guys,

Here is my whole code ............

================================
using System;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Windows.Forms;
using System.Xml.Linq;
using System.Data.SqlClient;
using System.Data.Sql;


public partial class _Default : System.Web.UI.Page
{
    cConnect1 objcConnect = new cConnect1();
    int i = 0;
   
    protected void Page_Load(object sender, EventArgs e)
    {
        objcConnect.getdata();
        DisplayData();
    }      
    private void DisplayData()
    {
        txtEmpId.Text = objcConnect.dset.Tables["Emp"].Rows[i]["ID"].ToString();
        txtName.Text = objcConnect.dset.Tables["Emp"].Rows[i]["Name"].ToString();
        txtDesignation.Text = objcConnect.dset.Tables["Emp"].Rows[i]["Designation"].ToString();
        txtTaddress.Text = objcConnect.dset.Tables["Emp"].Rows[i]["TempAddress"].ToString();
        txtPAddress.Text = objcConnect.dset.Tables["Emp"].Rows[i]["PermanentAddress"].ToString();
        txtSalary.Text = objcConnect.dset.Tables["Emp"].Rows[i]["Salary"].ToString();
        txtContact.Text = objcConnect.dset.Tables["Emp"].Rows[i]["Contact"].ToString();
    }
    protected void btnNext_Click(object sender, EventArgs e)
    {
        i++;
        DisplayData();
    }
    protected void btnPrevious_Click(object sender, EventArgs e)
    {
        if (IsPostBack == false)
        i--;
        DisplayData();
    }
    protected void btnClear_Click(object sender, EventArgs e)
    {
        txtEmpId.Text = "";
        txtName.Text = "";
        txtDesignation.Text = "";
        txtPAddress.Text = "";
        txtSalary.Text = "";
        txtTaddress.Text = "";
        txtContact.Text = "";
    }
    protected void btnInsert_Click(object sender, EventArgs e)
    {
        //if (IsPostBack == false)
        InsertRecord(); 
    }
    private void InsertRecord()
    {
        try
        {
            if (Page.IsPostBack)
            {
               
                string InsertString = "Insert into Emp" + "(ID, Name, Designation, TempAddress, PermanentAddress, Salary, Contact)" +
                                       "values('" + txtEmpId.Text + "','" + txtName.Text + "','" + txtDesignation.Text + "','" + txtPAddress.Text + "','" + txtTaddress.Text + "','" + txtSalary.Text + "','" + txtContact.Text + "')";

               if (txtEmpId.Text != "" && txtName.Text != "" && txtDesignation.Text != "" && txtPAddress.Text != "" && txtTaddress.Text != "" && txtSalary.Text != "" && txtContact.Text != "")
                {

                    SqlCommand command = new SqlCommand(InsertString, objcConnect.con);
                    objcConnect.dAdapEmp.InsertCommand = command;
                    objcConnect.dAdapEmp.InsertCommand.ExecuteNonQuery();
                    //command.ExecuteNonQuery();

                    MessageBox.Show("Value Inserted");

                }
            }
        }
        catch (Exception ex)
        {
            MessageBox.Show(ex.ToString());
        }
    }
}
       
  

   

ID is the only primary key...........
in ID :- A101, A102,

Trying to insert :- A103 or E001

Check below things and reply.

1. Which field has markes as PrimaryKey in DB
2. What are the values of ID available in DB
3. What are the values of ID you are trying to insert.

As you may already aware, a filed marked as primary key can not accept dulicate values