How To Insert Distinct Values In Database

Hello,

 I have three columns in my database named FirstName, LastName, StudentID. i want to insert only the distinct values and avoid the values which are already in the database. can anybody please help me with the logic? is there any possibility of checking for the redudant values in the stored procedure?

 below is my code:protected void Page_Load(object sender, EventArgs e)

{Label1.Visible = false;GridView1.Visible = false;

}protected void Button1_Click(object sender, EventArgs e)

{

 

loaddata();TextBox1.Visible = false;

TextBox2.Visible = false;TextBox3.Visible = false;

Button1.Visible = false;Label1.Visible = true;

Label2.Visible = false;Label3.Visible = false;Label4.Visible = false;

loadGrid();GridView1.Visible = true;

 

}private void loaddata()

{string str = ConfigurationManager.ConnectionStrings["adventure"].ConnectionString;

SqlConnection conn = new SqlConnection(str);SqlCommand cmd = new SqlCommand("Sp_Student", conn);

conn.Open();cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.Add("@FirstName", SqlDbType.VarChar).Value = TextBox1.Text;cmd.Parameters.Add("@LastName", SqlDbType.VarChar).Value = TextBox2.Text;cmd.Parameters.Add("@StudentID", SqlDbType.Int).Value = TextBox3.Text;

cmd.ExecuteNonQuery();

conn.Close();

}

 private void loadGrid()

{string strn = ConfigurationManager.ConnectionStrings["adventure"].ConnectionString;

SqlConnection connect = new SqlConnection(strn);string select = "select * from Student";

SqlCommand comm = new SqlCommand(select, connect);SqlDataAdapter da = new SqlDataAdapter(comm);

DataSet ds = new DataSet();da.Fill(ds, "Student");GridView1.DataSource = ds.Tables["Student"];

GridView1.DataBind();

 

 

}

Thanks

Sandeep