Hi All,
I am getting this error while running my application. Any help is appreciated.
Unable to Automatically step into the server. Unable to determine stopping location. Verify symbols are loaded. The function can not be found: fn_executequerystring();
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using URC_CIMS_USER;
using RepTempl;
using System.Configuration;
using System.Data;
using System.Text;
public partial class _Default : System.Web.UI.Page
{
URC_CIMS.WS_SACM ws_temp = new URC_CIMS.WS_SACM();
string strFSalesManNo;
string strFSpePassword;
string strFRefPassword;
string strQsalesman;
string strServerName;
string strFLogid = "";
string strFLogName = "";
string strFUserCat = "";
protected void Page_Load(object sender, EventArgs e)
{
txtError.Style.Add("display", "none");
strServerName = ConfigurationManager.AppSettings["SERVER"];
ws_temp.Url = "http://" + strServerName + "/WS_SACM.asmx";
}
protected void Button1_Click(object sender, EventArgs e)
{
object[] arrLogin = new object[] { };
string lstrRet="";
fn_GetRealWebService();
GetDetails();
strQsalesman = strFSalesManNo.ToString().Trim();
if (!strFSalesManNo.Equals(strQsalesman))
{
string err = "SalesMan No Mismatch";
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + err + "');", true);
return;
}
if (!strFSalesManNo.Equals(txtPwd.Text.Trim().ToUpper()))
{
string err = "Special Password Mismatch";
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + err + "');", true);
return;
}
arrLogin[0] = "D";
arrLogin[1] = strFSalesManNo.ToUpper();
arrLogin[2] = Request.QueryString["CardSrNo"].ToString().Trim();
arrLogin[3] = "L";
arrLogin[4] = "";
arrLogin[5] = "0";
lstrRet = ws_temp.fn_IUD_SESLOG_Asm(arrLogin);
if(!lstrRet.Equals("0"))
{
string err = lstrRet;
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + err + "');", true);
return;
}
else
{
string err ="Login has been Restored";
ClientScript.RegisterStartupScript(this.GetType(), "myalert", "alert('" + err + "');", true);
Response.Redirect("Home.aspx");
}
}
protected void fn_GetRealWebService()
{
string wsUrs = "http://" + strServerName + "/WS_CIMS.asmx";
string executeUrl = "http://" + strServerName + "/WS_GIFT.asmx";
string masterUrl = "http://" + strServerName + "/WS_SACM.asmx";
}
private void GetDetails()
{
DataSet objdsUser = new DataSet("User");
object[] arrUser=new object[5];
arrUser[0] = "select a.name,a.salesman_no,a.user_catg_c1,a.salesmanid,"
+ "b.chk_crd_c1,a.spe_password,a.password from csdsalesman a,csdcounters b "
+ "where upper(a.salesmanid)='"
+ txtId.Text.ToUpper().Trim()
+ "' and a.counter_id=b.counter_id and a.shop_id=b.shop_id";
objdsUser = ws_temp.fn_ExecuteQuery(arrUser);
if (objdsUser != null)
{
if (objdsUser.Tables[0].Columns[0].ColumnName.ToLower().Equals("errstring"))
{
txtError.Visible = true;
DataRow dr = objdsUser.Tables[0].Rows[0];
txtError.Text = "Error:" + dr["ErrString"].ToString();
return;
}
var _with1 = objdsUser.Tables[0].Rows[0];
strFLogName = _with1["name"].ToString();
strFLogid = _with1["salesmanid"].ToString().Trim().ToUpper();
strFUserCat = _with1["user_catg_c1"].ToString();
strFSalesManNo = _with1["salesman_no"].ToString().Trim();
strFSpePassword = _with1["spe_password"].ToString().Trim();
strFRefPassword = _with1["password"].ToString().Trim().ToUpper();
}
}
}