Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post May 09, 2011 09:52 AM by Fabienne
Member
11 Points
6 Posts
May 05, 2011 07:07 AM|LINK
Hey there !
I need to create staff. But how do I check for duplicate data and it will display error message when inserting record?
All-Star
128470 Points
18149 Posts
MVP
May 05, 2011 08:40 AM|LINK
Here's one way:
private void CheckIfExist(string field) { SqlConnection conn = new SqlConnection("Your Connection String"); DataTable dt = new DataTable(); try { conn.Open(); String sql = "SELECT * FROM TableName WHERE FieldName= @Field"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@Field",field); SqlDataAdapter ad = new SqlDataAdapter(cmd); ad.Fill(dt); if (dt.Rows.Count > 0) { Label1.Text = "Already Exist"; } else { Label1.Text = "Available"; //CALL the INSERT method here and pass its parameter values InsertInfo("value1","Value2","Value3"); } } finally { conn.Close(); } } private void InsertInfo(string strValue1, string strValue2, string strValue3) { SqlConnection conn = new SqlConnection("YOUR CONNECTION STRING"); string sql = "INSERT INTO TableName (ColumnName1,ColumnName2,ColumnName3) VALUES (@Val1,@Val2,@Val3)"; try { conn.Open(); SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@Val1", strValue1); cmd.Parameters.AddWithValue("@Val2", strValue2); cmd.Parameters.AddWithValue("@Val3", strValue3); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); } finally { conn.Close(); } } protected void Button1_Click(object sender, EventArgs e) { string field = "SomethingToCompare"; CheckIfExist(field); }
May 09, 2011 09:52 AM|LINK
thank u very much yeah :D
Fabienne
Member
11 Points
6 Posts
Dupilcate record
May 05, 2011 07:07 AM|LINK
Hey there !
I need to create staff. But how do I check for duplicate data and it will display error message when inserting record?
vinz
All-Star
128470 Points
18149 Posts
MVP
Re: Dupilcate record
May 05, 2011 08:40 AM|LINK
Here's one way:
private void CheckIfExist(string field) { SqlConnection conn = new SqlConnection("Your Connection String"); DataTable dt = new DataTable(); try { conn.Open(); String sql = "SELECT * FROM TableName WHERE FieldName= @Field"; SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@Field",field); SqlDataAdapter ad = new SqlDataAdapter(cmd); ad.Fill(dt); if (dt.Rows.Count > 0) { Label1.Text = "Already Exist"; } else { Label1.Text = "Available"; //CALL the INSERT method here and pass its parameter values InsertInfo("value1","Value2","Value3"); } } finally { conn.Close(); } } private void InsertInfo(string strValue1, string strValue2, string strValue3) { SqlConnection conn = new SqlConnection("YOUR CONNECTION STRING"); string sql = "INSERT INTO TableName (ColumnName1,ColumnName2,ColumnName3) VALUES (@Val1,@Val2,@Val3)"; try { conn.Open(); SqlCommand cmd = new SqlCommand(sql, conn); cmd.Parameters.AddWithValue("@Val1", strValue1); cmd.Parameters.AddWithValue("@Val2", strValue2); cmd.Parameters.AddWithValue("@Val3", strValue3); cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); } finally { conn.Close(); } } protected void Button1_Click(object sender, EventArgs e) { string field = "SomethingToCompare"; CheckIfExist(field); }MessageBox Controls for WebForms | Blog | Twitter | Linkedin
Fabienne
Member
11 Points
6 Posts
Re: Dupilcate record
May 09, 2011 09:52 AM|LINK
thank u very much yeah :D