Hi, Suppose any reference type is stored in some memory location and its data is continuously expanding for example appending string in loop in StringBuilder. How memory manager manages the scenario when its object doesnt has contiguous memory available at that location. It would be great if any one can explain it in detail. Thanks, Devesh

Hi, I have sql server table containing dates,currency and rates. For non working dates we dont get rates data, so I need a stored proc to fill these gaps. for example: for Saturday and Sunday, rates data is not received, so for Sat and Sun data with rates of previous working days i.e. Friday should be entered. Same is the case with public holidays also. Please provide me with some sample proc. Any help is appreciated!

Hi, I have a windows application in which sinlge instance check is applied and is working well. But when i schedule my application to run on system startup the probelm comes as the exe runs in process but no icon is shown in task bar (on minimize mode application icon is shown in taskbar) or the forms are shown. So when i click on the icon nothing happens as already exe is running in process. I need a solution like when scheduled task runs my application its icon shuold automatically appear in the taskbar.

Amit viewstate or any such thing has no relevance with this. Just put another textbox and try with that as now i cant find anything wrong in it.

Do one thing take the Session value in variable first and then test with break points. I think your if condition is not working correctly.

Hi, Few days ago I posted my problem in the forum and even after long discussion no conclusion was arrived. Now i came to know that problem was beacuse of I.E. 8 and after clikcing on the Compatibilty View button to support earlier versions such problem can be overcome. But i want to know how to make IE8 compatible applications so that such issues cant arise. Abhijit, Yusuf or anyone else any idea about this.

Hi, You have mistakes ...

Nekkantidivya wrote:

Set @Query='Select * from emplayee where empId=1"

You have ended up with double quotes.

Nekkantidivya wrote:

Declare @Query varchar(max)

Replace 'max' with some number like 200 as your string cant go over this. Correct it n then check.

modified on Saturday, April 18, 2009 7:24 AM

What is the problem in this you have SelectedIndexChanged event in radiobutton list which u can use to fire any events depending upon the option selected.

Hi, Explain your problem in detail. As no one can make out what your problem is. Your foreign key issue you should handle from sql query. I guess your solution is the "DataKeyNames" property of gridview.

write conn. string like this : <pre> <add name="sasannaderi_maskan" connectionString="Data Source=.\SQLExpress;Initial Catalog=sasannaderi_maskan" providerName="System.Data.SqlClient" /> may be this work for you. But when u upload it on server a proper data source is required. As "." is ok for local but i dont think for server.

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

On this page i have only two textboxes for input that are used for entering dates. And i have tested it with every type of incorrect input. It is not giving any error.

Hi Abhijit, Even on entering special charatcers , report is working fine. I cant fnd this error on local and only once on server but my clients have reported it many times. I am not undertaking any data conversions. I have text boxes for dates and i have tested it several times they are working fine. Even I cant understand why this error is coming as on local and even on server i cant find this error except only 1 time with all types of input.

The error appears like this --> Server Error in '/' Application. -------------------------------------------------------------------------------- Input string was not in a correct format. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.FormatException: Input string was not in a correct format. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [FormatException: Input string was not in a correct format.] System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) +7469351 System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) +119 System.Web.UI.WebControls.ImageButton.LoadPostData(String postDataKey, NameValueCollection postCollection) +163 System.Web.UI.WebControls.ImageButton.System.Web.UI.IPostBackDataHandler.LoadPostData(String postDataKey, NameValueCollection postCollection) +14 System.Web.UI.Page.ProcessPostData(NameValueCollection postData, Boolean fBeforeLoad) +693 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1743 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:2.0.50727.3082; ASP.NET Version:2.0.50727.3082

I cant understand what you mean by this. If i am handling the exception before any function or data conversion executes then how this error can come.

Hi, In my website i have a report where i have implemented try-catch try { ... ... } catch(Exception) { return; } but even on appling try-catch on every event my report sometimes gives error like "INPUT STRING IS NOT IN CORRECT FORMAT". I have tried my best so that data type mismatch should not occur. This problem is significant with this report only. Help me.

Hi, I have a website in which users save thier reports but the problem is this after filling up all the information when user clicks the submit button lots of validation process takes place. So in slow speed internet connections they often press submit twice and beacuse of that information gets duplicated. I want to stop this duplicate entry. For this i tried to disable submit button when user clicks the button and enable it later on after all the processing is done but this doesnt work. Help me how to do it.

Ya i agree with you this thing has also puzzled me. But i dont find any problem in the logic. I am saving the userid to database which i retrieve from the session so how it is possible that other user's id is fetched while saving whereas the user is seeing all the information related to him on the screen but on saving the data it goes it other person account.

Abhijit here what i think is the same session shared by two users. So how to prevent that? As in my case one user is logged in into his account, there it was ok even on welcome message i can see his username appearing but while saving the data other user's id was passed. I think it is beacuse of sharing of same session by two users and this thing happened for the first time after more than 1000 entries. What u say about this??

After checkin some condition this code comes. I ahve used a stored procedure to save the data and the userid is passed through a variable "usrid" which i assigned the value on top from the session variable.

SqlConnection con = cmn.getcon(); //new SqlConnection(constr);
if (con.State == ConnectionState.Open)
con.Close();
con.Open();
SqlDateTime sqldatenull;
sqldatenull = SqlDateTime.Null;
SqlCommand cmd = new SqlCommand("usp_OrderMaster_Ins", con);
cmd.CommandType = CommandType.StoredProcedure;

            string a = txtVisitHr1.Text.ToString();
            string b = txtVisitMin1.Text.ToString();

            // Define Parameters

            cmd.Parameters.Add("@VisitDate", SqlDbType.DateTime, 8).Value = cmn.MMDDYYtoYYMMDD(txtVisitDate1.Text);

            // --------------Stop After Discussion with Anand and G.Shyam Sundar -------------------------

            // cmd.Parameters.Add("@VisitTime", SqlDbType.DateTime, 8).Value = txtVisitHr1.Text.ToString() + ":" + txtVisitMin1.Text.ToString() + " " + ddlAMPM.SelectedValue.ToString();

            // -----------------------------------------------------------------------------------------

            cmd.Parameters.Add("@VisitType", SqlDbType.Char, 1).Value = ddlVisitType1.SelectedValue.ToString();
            cmd.Parameters.Add("@Usr\_ID", SqlDbType.Int, 4).Value = Convert.ToInt32(**usrid**);
            cmd.Parameters.Add("@FinYr", SqlDbType.Char, 7).Value = cmn.FinYr();

            //change to session userid

            cmd.Parameters.Add("@OutledId", SqlDbType.Int, 4).Value = ddlPartner1.SelectedValue;

            int itmcnt = gdOrderDetails.Items.Count;

            string ordst = "";

            if (itmcnt > 0)
            {
                ordst = "Y";
            }
            else
            {
                ordst = "N";
            }

            cmd.Parameters.Add("@OrderStatus", SqlDbType.Char, 1).Value = ordst;

            if (txtNextVisitDt1.Text.ToString() == "")
            {
                cmd.Parameters.Add("@NextVisitDate", SqlDbType.DateTime, 8).Value = sqldatenull;
            }
            else
            {
                cmd.Parameters.Add("@NextVisitDate", SqlDbType.DateTime, 8).Value = cmn.MMDDYYtoYYMMDD(txtNextVisitDt1.Text.ToS