Click here to Skip to main content
15,886,689 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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();

C#
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)
       {
           //'Put user code to initialize the page here
           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 = Request.QueryString["salesmanno"].ToString().Trim();
           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];


           //CHECK FOR THE EXISTANCE OF USER
            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:" + objdsUser.Tables[0].Rows[0].Item("ErrString").ToString;
                    txtError.Text = "Error:" + dr["ErrString"].ToString();
                    return;
                }

                var _with1 = objdsUser.Tables[0].Rows[0];
                strFLogName = _with1["name"].ToString();//salesman name
                strFLogid = _with1["salesmanid"].ToString().Trim().ToUpper();//loginid
                strFUserCat = _with1["user_catg_c1"].ToString();//user category
                strFSalesManNo = _with1["salesman_no"].ToString().Trim();//salesman no
                strFSpePassword = _with1["spe_password"].ToString().Trim();
                strFRefPassword = _with1["password"].ToString().Trim().ToUpper();//password
            }
       }

   }
Posted
Updated 26-Jun-14 0:05am
v3
Comments
Sprint89 26-Jun-14 3:26am    
You don't seem to have included fn_executequerystring(); in the listing above

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900