Comments by Christopher Fernandes (Top 105 by date)

I would like to disclose that this WPF App is a .Net Framework App (v4.8), not a .NET Core App

It throws NullReference exception

This is the perfect solution.

By preview I mean display the contents of the file

I forgot mention this the content in the text file is html.

I meant in my code, not in your code. The issue is now resolved.

There was an error on the login form which did not allow the form to show and just quit.

the frmLogin login first authenticates the credentials entered. Then if all is well it will create a session on the app server. After that the API code checks if the authentication session token exists for the current user.

There is no timer on the frmLogin form.

I cannot show you the code to check if the user has signed as it is a custom method used in multiple apps.

I want to know why the code below the objfrmLogin.ShowDialog(); executes before showing the form.

I am making changes to a legacy ASP.Net WebForms app for the firm.

You were correct the month variable had the wrong value. Also now I have used jQuery append() method to create rows & columns of the dynamic calendar.

You were correct the month variable had the wrong value. Also now I have used jQuery append() method to create rows & columns of the dynamic calendar.

I have added the designer code that is I have done nothing in the cs file of the form as yet

What code do you need? I guess the designer code?

That image is just an icon of the parent form. Can you tell me why the menu strip is expanding.

It is fixed. I dont know how. Thanks so much

I am doing everything as you have shown and yet it opens and closes quickly

I have set the parent as IsMDIContainer true and yet it does the same thing

SELECT
ED.RefEmpID AS [EmpID]
,ED.EmpFirstName
,ED.EmpMiddleName
,ED.EmpLastName
,EMG.RefEMGID AS [ManagerID]
,ELC.RefELCID AS [ELCID]
,ELC.CashedDate
,ELC.CashedCount
,ELC.RefCalendarPeriodID AS [APID]
,ELC.PeriodStartDate
,ELC.PeriodEndDate
,LTY.RefLeaveTypeID AS [LTYID]
,LTY.LeaveTypeName
FROM EmployeeLeaveCashed ELC
LEFT JOIN CalendarPeriod CP ON ELC.RefCalendarPeriod = CP.RefCalendarPeriod
LEFT JOIN LeaveType LTY ON ELC.RefLeaveTypeID = LTY.RefLeaveTypeID
LEFT JOIN Employee ED ON ELC.RefEmpID = ED.RefEmpID
LEFT JOIN EmployeeManager EMG ON ED.RefEmpID = EMG.RefEmpID

it was working until a few days ago even with ipaddress suddenly started this issue yesterday.

i have followed this article https://www.mikesdotnetting.com/article/216/windows-authentication-with-asp-net-web-pages

I think the issue is that the server on which the app is hosted cannot access the Active Directory server. Hence cannot validate user credentials.

<authentication mode="Windows">

http://ipaddress:portnumber/subfolder/home.aspx

It is a temp string variable to check what value is fetched from the database.

The code is not working because the datarow type in the datatable is decimal. It work for text values only see the question and the commented part.

the above code does not work

I am trying this code now

string value = dataTable.Rows[0]["Value5"].ToString();
if (ddlSL5.Items.FindByValue(value) != null) { ddlSL5.Items.FindByValue(value).Selected = true; }

Even this is not working. Is this because the list items are hard coded and not databound to the dropdownlist.

All listitems in all dropdownlist are added at design time. There is no data binding & index change event that I am using in this form. Only trying to select values in all dropdownlist with what is fetched from the database table at page load & update button click event.

I scanned each line of code still the cookies set on login and expire on Master page when i check them in the Page_Init method

Which Windows server version would be best to host ASP.NET Webforms & ASP.NET MVC Apps Also Sql Server Enterprise Edition?

ok

I am not passing the login credentials in the query string but the auth key in an encrypted format.

I have added the table data please tell me how to get rid of duplicate table rows

Okay I'll rewrite the question

the other tables are just master tables

Yes thats what I am planning to do now since it is so much affecting the perfomance

How about if I strip out the prefix IE and split the numbers & then compare the number by creating a custom function

I know BigInt is 2^63. But by my estimates, The app will be generating 250,000 ID every day.
As you can see there are 3 parts to the ID value a)ID b) bigint middle number c) bigint outer number
So whenever outer number reaches the upper limit of bigint I want it to increment the middle number by one and set outer number to one again.

So it is used to indicate that the event was created in a specific timezone before converting to UTC

what is there inside the repeater?

Thanks a lot sir

The item will re-appear because you must be not updating the db

Thanks F-ES Sitecore

Dear Richard sir,
I have implemented the first & second option and both the apps are in seperate folder path. Both the apps now work fine. But i am curious to learn about the 3rd option. How to do that?

Thanks again buddy been scrapping my head at since 5 days. :)

this worked thanks man

That's what the regex pattern is getting treated as a string hence not matching to value.

I did not escape the characters the escape character are coming auto. it is this escape characters that are creating problems for me here in this regex.

I implemeted your code this is what the re look like when the code executes /\/^[a-z0-9\_\-\.]+[\@]{1}[a-z0-9]+[\.]{1}[a-z]{2,}\//i
it does not work i mean even if i enter a valid email.

that otherfunction() is doing something else. The dialog closes when the user clicks on close button of the dialog or one of the buttons on it.

No! what i want is until the dialog is not closed the next line of javascript code in the same code block should not execute.

even that throws an error

it breaks at \s in the regex value. it cant escape the \s

I experimented with 200 items. It does not show at all

The issue is that between overlay show and hide the function that gets called has a execution time of 0.015 milliseconds.
So the show and hide overlay toggle happens very fast.

Asp.net Web Forms & C#

How do i then prompt the user to save or open the file?

Thanks Nathan

Also if you dont mind just tell me why is the file not downloading.

How to do either of that?

Now the PDF generated does not get downloaded

Thanks, I had missed the param changes

{"Message":"Invalid object passed in, \u0027:\u0027 or \u0027}\u0027 expected. (1409): {\"filename : Test,HtmlContent : \u003cdiv style=\\\"color:#ffffff; text-align:center; background-color:#4F9EC9; width:100%;\\\"\u003eTest\u003c/div\u003e\u003cbr/\u003e\u003cbr/\u003e\u003cdiv\u003e\u003cp\u003eChristopher\u003c/p\u003e\\n\\n\u003cp\u003e\u0026nbsp;\u003c/p\u003e\\n\\n\u003cp\u003eChristopher\u003c/p\u003e\\n\\n\u003cp\u003e\u003cimg alt=\\\"\\\" src=\\\"../cklibrary/images/mud-sling.png\\\" style=\\\"height:261px; width:650px\\\"\u003e\u003c/p\u003e\\n\\n\u003cp\u003eTest\u003c/p\u003e\\n\\n\u003cp\u003e\u0026nbsp;\u003c/p\u003e\\n\\n\u003cp\u003echristopher\u003c/p\u003e\\n\\n\u003ctable border=\\\"1\\\" cellpadding=\\\"1\\\" cellspacing=\\\"1\\\" style=\\\"width:200px\\\"\u003e\\n\\t\u003ctbody\u003e\\n\\t\\t\u003ctr\u003e\\n\\t\\t\\t\u003ctd\u003eFirst Name\u003c/td\u003e\\n\\t\\t\\t\u003ctd\u003eLast Name\u003c/td\u003e\\n\\t\\t\u003c/tr\u003e\\n\\t\\t\u003ctr\u003e\\n\\t\\t\\t\u003ctd\u003eChristopher\u003c/td\u003e\\n\\t\\t\\t\u003ctd\u003eFernandes\u003c/td\u003e\\n\\t\\t\u003c/tr\u003e\\n\\t\\t\u003ctr\u003e\\n\\t\\t\\t\u003ctd\u003eCalvin\u003c/td\u003e\\n\\t\\t\\t\u003ctd\u003eFernandes\u003c/td\u003e\\n\\t\\t\u003c/tr\u003e\\n\\t\u003c/tbody\u003e\\n\u003c/table\u003e\\n\\n\u003cp\u003e\u0026nbsp;\u003c/p\u003e\\n\u003c/div\u003e\u003cbr/\u003e\u003cbr/\u003e\u003cdiv\u003e\\n \u003cdiv class=\\\"articledownload bg-color\\\"\u003e\\n \u003ca id=\\\"articlelink\\\" class=\\\"articledownloadlink\\\" target=\\\"_blank\\\" download=\\\"\\\"\u003edownload\u003c/a\u003e\\n \u003c/div\u003e\\n \u003ch3\u003e\u003cu\u003eArticle Details : \u003c/u\u003e\u003c/h3\u003e\\n \u003ch3\u003eAuthors\u003c/h3\u003e\\n \u003cdiv id=\\\"articleAuthor\\\" style=\\\"min-height: 10px;\\\"\u003eChristopher Fernandes, Claire Cylkowski\u003c/div\u003e\\n \u003ch3\u003eCategory\u003c/h3\u003e\\n \u003cdiv id=\\\"articleCategory\\\" style=\\\"min-height: 10px;\\\"\u003edefault-category\u003c/div\u003e\\n \u003ch3\u003eTag\u003c/h3\u003e\\n \u003cdiv id=\\\"articleTag\\\" style=\\\"min-height: 10px;\\\"\u003edefault-tag\u003c/div\u003e\\n \u003c/div\u003e\u003cbr/\u003e\"}","StackTrace":" at System.Web.Script.Serialization.JavaScriptObjectDeserializer.DeserializeDictionary(Int32 depth)\r\n at System.Web.Script.Serialization.JavaScriptObjectDeserializer.DeserializeInternal(Int32 depth)\r\n at System.Web.Script.Serialization.JavaScriptObjectDeserializer.BasicDeserialize(String input, Int32 depthLimit, JavaScriptSerializer serializer)\r\n at System.Web.Script.Serialization.JavaScriptSerializer.Deserialize(JavaScriptSerializer serializer, String input, Type type, Int32 depthLimit)\r\n at System.Web.Script.Serialization.JavaScriptSerializer.Deserialize[T](String input)\r\n at System.Web.Script.Services.RestHandler.GetRawParamsFromPostRequest(HttpContext context, JavaScriptSerializer serializer)\r\n at System.Web.Script.Services.RestHandler.GetRawParams(WebServiceMethodData methodData, HttpContext context)\r\n at System.Web.Script.Services.RestHandler.ExecuteWebServiceCall(HttpContext context, WebServiceMethodData methodData)","ExceptionType":"System.ArgumentException"}

I tried it doesn't work

The first ajax call is to get the filepath and the second ajax call is to check if the file actually exists on the server and only then make it available to the user for download.
I dont want the users to see 404 error page

Yes, exactly. i cannot update the path string for the subfolders under the root folder which gets moved to a new location.

I am able to move the folders and sub folders to the new folder and maintain the correct folder structure in the new location. As i said i want to update the relative path in the database table which i guess i have to do by using recursion.

I did understand what you said.
But I thought that would require me copy the same code on multiple pages as i have disable different html elements on each page depending on a certain cookie value.

Looks great will try. Thanks a lot.

I am new to jQuery so please be a little patient with me.

jQuery is Awesome:)

Are you talking about jQuery or suggesting some other library which can be used as an alternative

the code works fine when I set async:false. but thats what i dont want as about 90+ thousand users currently hit the webapp.

Hey it worked as per your instructions. But had to call window.parent.ParentFunction(boolval,stringval) from the iframe.

Same error even on moving the ParentFunction outside dom.ready() and inside dom.ready()

does parent.ParentFunction(); work or is there another way?

will this work for js functions with parameters?

I added CKFinder to CkEditor and it works fine

They are added to IIS as websites.
Users upload/delete documents & pictures of all types in each of these apps.

Thanks for the suggestion.

Yes

How to solve this error?

The source was not found, but some or all event logs could not be searched. To create the source, you need permission to read all event logs to make sure that the new source name is unique. Inaccessible logs: Security.

Thanks this was the issue I had no data where in the table at first entry and after entry the SP works fine

Thanks a ton!!!! using the profiler worked like magic. Solved my Issue.

I tried doing that but no luck. The method GetDataDSWithParameters in the DataStore.cs class file is used by many other page and works fine there but just not for this call.

I have provided the code now. Please check it.

I am an curious learner trying to attain certain skills in the .Net Framework
It would be really good if anyone would at least throw a hint on how to get started with this.

when i target interop.excel v15.0 in development pc where office 2013 is installed the export work great but in the production environment the export fails and get error saying com exception occurred

Now it gives an error of Exclusive lock not acquired.

Hey thanks it is working now.

Does not work for me. Need for Windows system,

I need it for a Desktop based application and i want to export it to Excel 2013

It is a query for which i do not have an answer so it is a question. Please provide an answer if you have one. Need it urgently.

But I need this in Asp.net Web Forms.