i want to display record exist and added successfuly

See more:

ASP.NET

protected void Insert(object sender, EventArgs e)
{
string ConnectionString = WebConfigurationManager.ConnectionStrings["testConnectionString"].ConnectionString;
SqlConnection sqlconnection = null;


TextBox cust_id = (TextBox)GridView1.FooterRow.FindControl("txtCustId");

TextBox name = (TextBox)GridView1.FooterRow.FindControl("txtName");

TextBox state = (TextBox)GridView1.FooterRow.FindControl("txtState");

TextBox s_amount = (TextBox)GridView1.FooterRow.FindControl("txtAmnt");

TextBox sales_id = (TextBox)GridView1.FooterRow.FindControl("txtSid");

try
{

using (sqlconnection = new SqlConnection(ConnectionString))
{
sqlconnection.Open();
SqlCommand cmd = new SqlCommand("GetSubmitDetails", sqlconnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@cust_id", SqlDbType.Int).Value = cust_id.Text;
cmd.Parameters.Add("@name", SqlDbType.VarChar).Value = name.Text;
cmd.Parameters.Add("@state", SqlDbType.VarChar).Value = state.Text;
cmd.Parameters.Add("@s_amount", SqlDbType.VarChar).Value = s_amount.Text;
cmd.Parameters.Add("@sales_id", SqlDbType.Int).Value = sales_id.Text;

cmd.ExecuteNonQuery();
SqlDataReader sqlReader =cmd.ExecuteReader();

if (sqlReader.HasRows)
{
while (sqlReader.Read())
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Alert", "alert('Record exist');", true);
}
sqlReader.Close();
}

}
}

catch (Exception ex)
{
Console.WriteLine("Error reading from {0}", ex);
}
finally
{
sqlconnection.Close();
}



GridView1.EditIndex = -1;


ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "Alert", "alert('Record Saved Sucessfully');", true);
GridView1.DataBind();
GetData();


}