jquery with dialog confirm

Kev Patil

10y1.1k.NET

I have the following sql select code, where im trying to get value and i would like to ask user to continue if value is found or start new.

var getJOB = txtJobNo.Text;
try
{
MGMT_CON.Open();
MGMT_COM = new SqlCommand("SELECT [job],[revno] FROM [MATRR] WHERE [job] = '" + getJOB + "'",
MGMT_CON);
var sqlRRev = MGMT_COM.ExecuteReader();
if (sqlRRev.Read())
{
//ask user if want to continue
//if wants to continue use the value from sql
//else write something else into textbox
//if reads get the revno from sql and convert into int
var revno = Convert.ToInt32(sqlRRev.GetValue(1).ToString());
//write mrr based on revno
ddlRR.Text = "BBB-" + getJOB + "-" + (revno + 1);
}
else
{
ddlRR.Text = "BBB-" + getJOB + "-" + 1001;
}
MGMT_CON.Close();
}
catch (Exception e)
{
ClientScript.RegisterClientScriptBlock(GetType(), "alert", e.Message);
}

I tried looking around for different solution, one was trying jquery but im not familiar with it.

please help.

Thankyou

5 Replies

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

Kev Patil10y ago
@Shubham Kumar that almost worked for me. Only problem im running into is i am trying to get work on the event that i posted up there. Here is an example (but it doesnt work):

var getJOB = txtJobNo.Text;

//java value
ScriptManager.RegisterClientScriptBlock(this, GetType(), "Confirm", "Confirm();", true);
var confirmValue = Request.Form["confirm_value"];
if (confirmValue == "Yes")
{
try
{
MGMT_CON.Open();
MGMT_COM = new SqlCommand("SELECT [job],[revno] FROM [MATRR] WHERE [job] = '" + getJOB + "'",
MGMT_CON);
var sqlRRev = MGMT_COM.ExecuteReader();
if (sqlRRev.Read())
{

//if reads get the revno from sql and convert into int
var revno = Convert.ToInt32(sqlRRev.GetValue(1).ToString());
//write mrr based on revno
ddlRR.Text = "BBB-" + getJOB + "-" + (revno + 1);
}
else
{
ddlRR.Text = "BBB-" + getJOB + "-" + 1001;
}
MGMT_CON.Close();
}
catch (Exception e)
{
ClientScript.RegisterClientScriptBlock(GetType(), "alert", e.Message);
}
else {

}
Anu V10y ago
Just try this

http://jsfiddle.net/Raitono/jcxv8qom/1/
Amit Kumar Singh10y ago
http://jsfiddle.net/taditdash/vvjj8/
Chandu Kumawat10y ago
http://www.aspsnippets.com/Articles/jQuery-UI-Dialog-Modal-Popup-Confirmation-Box-example-in-ASPNet.aspx
Shubham Kumar10y ago
Hi, just try this link it may help you

http://www.aspsnippets.com/Articles/Server-Side-Code-Behind-Yes-No-Confirmation-Message-Box-in-ASPNet.aspx