Click here to Skip to main content
15,909,953 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: Try Catch Not working porperly... Pin
Abhijit Jana16-Apr-09 23:02
professionalAbhijit Jana16-Apr-09 23:02 
GeneralRe: Try Catch Not working porperly... Pin
Dev S16-Apr-09 23:12
Dev S16-Apr-09 23:12 
GeneralRe: Try Catch Not working porperly... Pin
Abhijit Jana16-Apr-09 23:45
professionalAbhijit Jana16-Apr-09 23:45 
GeneralRe: Try Catch Not working porperly... Pin
Dev S16-Apr-09 23:52
Dev S16-Apr-09 23:52 
GeneralRe: Try Catch Not working porperly... Pin
Abhijit Jana17-Apr-09 0:14
professionalAbhijit Jana17-Apr-09 0:14 
GeneralRe: Try Catch Not working porperly... Pin
Christian Graus17-Apr-09 12:54
protectorChristian Graus17-Apr-09 12:54 
AnswerRe: Try Catch Not working porperly... Pin
Arindam Tewary17-Apr-09 2:12
professionalArindam Tewary17-Apr-09 2:12 
GeneralRe: Try Catch Not working porperly... Pin
Dev S17-Apr-09 3:32
Dev S17-Apr-09 3:32 
Hi,
Here is my code.








<code>
public partial class SCSFMS_Pages_VisitLog : System.Web.UI.Page
{
Common cmn = new Common();
protected void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
SessionExpiresCheckOnButton();
try
{

hiUid.Text = Session["Usr_Id"].ToString();
hidUtype.Text = Session["UserType"].ToString();
string curdt = System.DateTime.Now.AddHours(13).ToString("dd/MM/yyyy");
string entrydt = cmn.DDMMYYtoMMDDYY(curdt);
txtDate.Text = curdt;
txtVisitDtto.Text = curdt;
if (hidUtype.Text == "A")
{
cmn.fillDDL(ddlUser, "select u.Usr_Id,u.UName from users u, userdetail ud where u.status ='Active' and ud.designationid in (2,4,12) and ud.id=u.usr_id order by UName", "Usr_Id", "UName");
}
string desigid = cmn.nDesgID(hiUid.Text).ToString();
if (hidUtype.Text == "U")
{
if (desigid == "6")
{
cmn.fillDDL(ddlUser, "select u.Usr_Id,u.UName from users u, userdetail ud where u.status ='Active' and ud.id=u.usr_id and (ud.id ="+hiUid.Text+" or ud.admintoreport="+hiUid.Text+") order by UName", "Usr_Id", "UName");
}
else
{
cmn.fillDDL(ddlUser, "select u.Usr_Id,u.UName from users u, userdetail ud where u.status ='Active' and ud.id=u.usr_id and (ud.id =" + hiUid.Text + ") order by UName", "Usr_Id", "UName");
ddlUser.SelectedIndex= 1;
ddlUser.UpdateAfterCallBack = true;
}

}
}

catch (Exception ex)
{
return;
}

}
}
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
try
{
fillgrid();
}
catch (Exception ex)
{
return;
}
}
public void fillgrid()
{

try
{
string usrsearch = "";
string sqlprt = "";
string desigid = cmn.nDesgID(hiUid.Text).ToString();
if (ddlUser.SelectedValue != "0")
{
usrsearch = ddlUser.SelectedValue.ToString();
sqlprt = "and ud.usr_id = "+usrsearch+" ";
}

lblResult.Visible = false;
lblResult.UpdateAfterCallBack = true;


string myentrydt = cmn.DDMMYYtoMMDDYY(txtDate.Text.ToString());
string mydtto = cmn.DDMMYYtoMMDDYY(txtVisitDtto.Text.ToString());
string sql = "";

if (hidUtype.Text == "A")
{
sql = " select ud.uname,amt= case when sum(od.prod_amt) is null then '0' else sum(od.prod_amt)end ,totalcall=count(*),visitdate=convert(varchar(12), ov.visit_date ,6) from tblSCSFMS_OrderVisit_Master ov " +
" left join users ud on ud.usr_id = ov.usr_id " +
" left join tblSCSFMS_Order_Details od on od.visit_id =ov.visit_id " +
" where CAST(FLOOR(CAST(ov.visit_date AS float)) AS datetime) >= '" + myentrydt + "' and CAST(FLOOR(CAST(ov.visit_date AS float)) AS datetime) <= '" + mydtto + "' " +
" " +(sqlprt)+ " group by ud.uname , ov.visit_date, ov.usr_id ";
}
else
{
if (desigid == "6" && ddlUser.SelectedValue != "0")
{
sql = " select ud.uname,amt= case when sum(od.prod_amt) is null then '0' else sum(od.prod_amt)end ,totalcall=count(*),visitdate=convert(varchar(12), ov.visit_date ,6) from tblSCSFMS_OrderVisit_Master ov " +
" left join users ud on ud.usr_id = ov.usr_id " +
" left join tblSCSFMS_Order_Details od on od.visit_id =ov.visit_id " +
" where CAST(FLOOR(CAST(ov.visit_date AS float)) AS datetime) >= '" + myentrydt + "' and CAST(FLOOR(CAST(ov.visit_date AS float)) AS datetime) <= '" + mydtto + "' " +
" " + (sqlprt) + " group by ud.uname , ov.visit_date, ov.usr_id ";

}
else
{
sql = " select ud.uname,amt= case when sum(od.prod_amt) is null then '0' else sum(od.prod_amt)end ,totalcall=count(*),visitdate=convert(varchar(12), ov.visit_date ,6) from tblSCSFMS_OrderVisit_Master ov " +
" left join users ud on ud.usr_id = ov.usr_id " +
" left join userdetail udtl on udtl.id = ov.usr_id " +
" left join tblSCSFMS_Order_Details od on od.visit_id =ov.visit_id " +
" where CAST(FLOOR(CAST(ov.visit_date AS float)) AS datetime) >= '" + myentrydt + "' and CAST(FLOOR(CAST(ov.visit_date AS float)) AS datetime) <= '" + mydtto + "' and (ud.usr_id = " + hiUid.Text.Trim() + " or udtl.admintoreport = " + hiUid.Text.Trim() + ")" +
" group by ud.uname , ov.visit_date, ov.usr_id";
}
}
cmn.fillGridView_By_USP(gdS_AddUser, sql);

if (!gdS_AddUser.Rows.Count.Equals(0))
{

// lblResult.Text = "Search Result";
lblResult.Visible = false;
lblResult.UpdateAfterCallBack = true;

}
else
{
lblResult.Text = "No Data found for the above search criteria.";
lblResult.Visible = true;
lblResult.UpdateAfterCallBack = true;

}
}
catch (Exception ex)
{
return;
}


}
protected void gdS_AddUser_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
gdS_AddUser.PageIndex = e.NewPageIndex;
fillgrid();
}
private void SessionExpiresCheckOnButton()
{
try
{
if (Session["Usr_Id"].ToString() == "" || Session["Usr_Id"].ToString() == null)
{
Session["ExpireMsg"] = "true";
Response.Redirect("../../index.aspx?urlvalue1=SCSFMS");

return;
}
}
catch (Exception)
{
Session["ExpireMsg"] = "true";
Response.Redirect("../../index.aspx?urlvalue1=SCSFMS");
return;
}
}



The error it is giving is "Input String is not in Correct Format." to some of my clients. But i havn't received this error yet even on thorough testing of the page.
AnswerRe: Try Catch Not working porperly... Pin
Yusuf17-Apr-09 6:06
Yusuf17-Apr-09 6:06 
QuestionProblems with Web Service Pin
Raymundo Valdez16-Apr-09 20:26
Raymundo Valdez16-Apr-09 20:26 
Questionsql server connection using ADO.net Pin
cemalakshmi16-Apr-09 19:54
cemalakshmi16-Apr-09 19:54 
AnswerRe: sql server connection using ADO.net Pin
Abhijit Jana16-Apr-09 20:08
professionalAbhijit Jana16-Apr-09 20:08 
QuestionList of countries in Asp.Net 3.5 Pin
Maxy5516-Apr-09 19:48
Maxy5516-Apr-09 19:48 
AnswerRe: List of countries in Asp.Net 3.5 Pin
Christian Graus16-Apr-09 19:52
protectorChristian Graus16-Apr-09 19:52 
AnswerRe: List of countries in Asp.Net 3.5 Pin
shashank70116-Apr-09 22:15
shashank70116-Apr-09 22:15 
AnswerRe: List of countries in Asp.Net 3.5 Pin
Yusuf17-Apr-09 3:34
Yusuf17-Apr-09 3:34 
Questiondownload visual studio 2005 Pin
bhavna432116-Apr-09 19:30
bhavna432116-Apr-09 19:30 
AnswerRe: download visual studio 2005 Pin
Abhijit Jana16-Apr-09 19:33
professionalAbhijit Jana16-Apr-09 19:33 
AnswerRe: download visual studio 2005 Pin
Christian Graus16-Apr-09 19:45
protectorChristian Graus16-Apr-09 19:45 
AnswerRe: download visual studio 2005 Pin
shashank70116-Apr-09 22:18
shashank70116-Apr-09 22:18 
QuestionVisual Foxpro Database/Table in ASP.NET Pin
Girish48116-Apr-09 17:09
Girish48116-Apr-09 17:09 
AnswerRe: Visual Foxpro Database/Table in ASP.NET Pin
Christian Graus16-Apr-09 17:17
protectorChristian Graus16-Apr-09 17:17 
GeneralRe: Visual Foxpro Database/Table in ASP.NET Pin
Girish48116-Apr-09 17:27
Girish48116-Apr-09 17:27 
QuestionAJAX Update Panel... Pin
Illegal Operation16-Apr-09 15:58
Illegal Operation16-Apr-09 15:58 
AnswerRe: AJAX Update Panel... Pin
mr_muskurahat16-Apr-09 21:50
mr_muskurahat16-Apr-09 21:50 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.