Using Grid view how to check Vendor name already exists

narasiman rao

13y4.4kC#

i am doing application using grid view.in that i am inserting the record as VendorFName, VendorLName,VendorCity,VendorState,VendorCountry,VendorDescription etc.

in that i am using VendorID as Primary Key.

suppose when i insert one record VendorFName, VendorLName,VendorCity,VendorState,VendorCountry,VendorDescription it is saved in the database.

suppose again i am repeating the same VendorFName and click the new ADDROW Button i want to show the message VendorFName already exists.

for that how to write the code using csharp.

i send my code as follows;from my code how to write the code VendorFName already exists.

protected void ResultGridView_RowCommand(object sender, GridViewCommandEventArgs e)

{

if (e.CommandName.Equals("AddNew"))

{

TextBox txtFName = (TextBox)ResultGridView.FooterRow.FindControl("txtFName1");

TextBox txtLName = (TextBox)ResultGridView.FooterRow.FindControl("txtLName1");

TextBox txtCity = (TextBox)ResultGridView.FooterRow.FindControl("txtCity1");

TextBox txtState = (TextBox)ResultGridView.FooterRow.FindControl("txtState1");

TextBox txtCountry = (TextBox)ResultGridView.FooterRow.FindControl("txtCountry1");

TextBox txtDescription = (TextBox)ResultGridView.FooterRow.FindControl("txtDescription1");

SqlConnection conn = new SqlConnection("Server=(local);initial catalog=master;Trusted_Connection=True");

cmd.Connection = conn;

cmd.CommandText = "INSERT INTO Vendors(VendorFName, VendorLName,VendorCity,VendorState,VendorCountry,VendorDescription) Values('" + txtFName.Text + "', '" + txtLName.Text + "', '" + txtCity.Text + "', '" + txtState.Text + "', '" + txtCountry.Text + "' , '" + txtDescription.Text + "')";

conn.Open();

cmd.ExecuteNonQuery();

FillVendorGrid();

conn.Close();

}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Satyapriya Nayak13y ago
If the above post helps you mark it as answer
Vishnujeet Kumar13y ago
try this:

if (e.CommandName.Equals("AddNew"))
{

TextBox txtFName = (TextBox)ResultGridView.FooterRow.FindControl("txtFName1");
TextBox txtLName = (TextBox)ResultGridView.FooterRow.FindControl("txtLName1");
TextBox txtCity = (TextBox)ResultGridView.FooterRow.FindControl("txtCity1");
TextBox txtState = (TextBox)ResultGridView.FooterRow.FindControl("txtState1");
TextBox txtCountry = (TextBox)ResultGridView.FooterRow.FindControl("txtCountry1");
TextBox txtDescription = (TextBox)ResultGridView.FooterRow.FindControl("txtDescription1");
SqlConnection con = new SqlConnection("Server=(local);initial catalog=master;Trusted_Connection=True");

string Sqlquery = "SELECT UserID FROM LoginTable where username='" + txtFName.Text + "'";
SqlCommand com = new SqlCommand("Sqlquery", con);
SqlDataReader reader = new SqlDataReader();
con.Open();
reader = com.ExecuteReader;

if (!reader.Read)
{
cmd.Connection = conn;
cmd.CommandText = "INSERT INTO Vendors(VendorFName, VendorLName,VendorCity,VendorState,VendorCountry,VendorDescription) Values('" + txtFName.Text + "', '" + txtLName.Text + "', '" + txtCity.Text + "', '" + txtState.Text + "', '" + txtCountry.Text + "' , '" + txtDescription.Text + "')";
conn.Open();
cmd.ExecuteNonQuery();
FillVendorGrid();
}
else
{
lblMessage.Text = " VendorFName already exists";
}
reader.Close();
con.Close();

conn.Close();
}