// Handling of Button btnAdd Click Event , To Add State in Database protected void btnAdd_Click(object sender, EventArgs e) { // Declare Local Variables FlagInsert,FlagState and countryid int FlagInsert; int FlagState; int countryid = Convert.ToInt32(drpCountry.SelectedValue); FlagState = objState.Get_By_StateName(txtStateName.Text.ToString().Trim()); // Check whether state already exist , if FlagState is zero then State not exist in Database if (FlagState == 0) { objState.Countryid = countryid; objState.Statename = txtStateName.Text.ToString().Trim(); // Insert data into Database by calling function objState.Insert() FlagInsert = objState.Insert(); // If FlagInsert is 1 then ,operation perform Successfully if (FlagInsert == 1) { BindGrid(); lblerrmsg.Text = Resources.MessageResource.erradd.ToString(); } // Some Error Occured while inserting data into database else { lblerrmsg.Text = Resources.MessageResource.errOccured.ToString(); } } else { // Display Message State Already Exist lblerrmsg.Text = Resources.MessageResource.errStateExist.ToString(); } }