Search results for query: *

This can become tricky. Will your form change meaning that the number of inputs etc will increase or decrease, or will you have a static number of inputs and just need to change the label text?

There is an example here that may help: https://docs.microsoft.com/en-us/sql/t-sql/functions/openjson-transact-sql?view=sql-server-2017 Instead of trying to do everything in on SQL statement, why not break it up? First get the data with the query you have ( select into a temp table ). Instead...

Could be a timing issue. Would need to see the HTML mark up from the master and content page as well as the code behind of the content page

The problem is you are using a data reader and I am not sure why, it is not saving you anything, but just causing issues: https://stackoverflow.com/questions/16381490/binding-sqldatareader-to-gridview-c-sharp https://www.codeproject.com/Questions/679137/fill-gridview-from-datareader Save...

You can create a user defined function and return what you need. We do something similar however, we do not use FOR XML. We simply pass in a delimited string and the delimiter and pass back a table of values. Then in the SQL we join to the returned table

Check to make sure all projects / dlls /assemblies are referencing the same version of the .NET framework https://stackoverflow.com/questions/16322678/new-pc-causing-namespace-of-type-specified-in-the-imports-doesnt-contain-any-p...

An IF statement will always evaluate each condition. A switch will fall through once the condition is met. True, depending on the conditions, they could be equal in performance, but the switch will win out in most cases.

Technically, a Switch / Case statement is faster because in an IF Statment, each IF / ElseIF is evaluated. In a Switch/Case, once the condition is met, the Switch/Case is exited. Personally, I find Switch/Case to look cleaner and more readable as well. If it is just a small check as in xwb's...

With a Using statement you don't need to specifically close the connection. That is the major point of using a Using statment.

This should not happen in newer versions of the framework since the have enhanced garbage collection. Since I don't know what version or your exact code, I suspect connections are being left open. The best thing to do is to get into the habit of using "Using" statements when opening...

I am not sure why you would need quotes around the value. Maybe you could explain further. But to answer your questions you could do this: If you can't read it '"' = single quote, double quote, single quote

I know nothing of that library, but I would have to say no. Windows forms run on the client machine, ASP.NET and all web based languages do not, they run on a server. Unless they have a client service or script that can run on the client machine, you would be out of luck.

You are correct. There would be an authentication key you would have to pass in the header when calling one of the endpoints. I would suspect you first need to register with this company and they an authentication key would be given to you and also more information like the URL and how to...

No end users need SSMS, only you. I don't know how your process works but if people are giving you spreadsheets on a regular basis, I would have them upload to a server somewhere that you control. You can write your SSIS package to run at any interval you want to check for files and then...

You will have to debug further into ImportExcelSheet(). Check that your file path is correct. Make sure after you read the stream that you have data in your pck object. Honestly this seems like a lot of work to import excel data. Personally, I would import the data into a SQL table using...

Remember Google is your best friend as a programmer. Using a quick search I found this: https://support.microsoft.com/en-us/help/317597/how-to-populate-a-treeview-control-with-xml-data-in-visual-c-2005-or-i AND...

What have you tried, if anything, so far? what does your markup and code-behind look like?

Where are you getting the error, what line? YOu need to step through each line to find where the problem starts

I have no idea how to do this in the markup as I never user the datasource controls. I am very against them for just this reason. Whenever you need to do something a bit differently or more complicated, they just become a PITA. You should just simply set the value of the parameter in the code...

You will have to debug through your code that is getting the querystring value: Public ReadOnly Property CardNo(Page As HttpContext) As String Get Dim iData As String If Not String.IsNullOrWhiteSpace(Page.Request.QueryString("cardno")) Then iData = Page.Request.QueryString("cardno") Else...