i want if mobile number is incorrect it display "mobile is incorrect" or pin is not generated
i want changes in stored procedure.below is Stored procedure
ALTER PROCEDURE [dbo].[usp_Downloadreportgetpin]
@CaseID varchar(50),
@Pin varchar(6),
@MobileNo varchar(12)
AS
BEGIN
Select T1.*,T2.Mobileno from [reportdownloadpin] as T1 inner join comm_SenderType as T2 on T1.CaseId=T2.Fsl_CaseID
where Pin=@Pin and CaseId=@CaseID
end
protected void btnsubmit_Click(object sender, EventArgs e)
{
DataTable dt = new DataTable();
SqlDataAdapter adp = new SqlDataAdapter();
try
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["my connection string"].ConnectionString);
SqlCommand cmd = new SqlCommand("usp_Downloadreportgetpin", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CaseID", txtcaseid.Text.Trim());
cmd.Parameters.AddWithValue("@MobileNo", txtmobileno.Text.Trim());
cmd.Parameters.AddWithValue("@Pin", txtpin.Text.Trim());
adp.SelectCommand = cmd;
adp.Fill(dt);
if (dt.Rows.Count == 0)
{
lblmob.Text = "Case examination is under process-PIN not generated";
}
else
{
lblmob.Text = "sucess";
}
cmd.Dispose();
}
catch (Exception ex)
{
ScriptManager.RegisterStartupScript(this, this.GetType(), "Message", "alert('Oops!! following error occured : " + ex.Message.ToString() + "');", true);
}
finally
{
dt.Clear();
dt.Dispose();
adp.Dispose();
}
}