Search results for query: *

Hi, I've got a search results page that takes information from its query string and displays data in labels and a datagrid. It works well, until you move to a new page then go back to it. When you go back there's an error message. The current code (first part) is: Private Sub...

Hi, I've got a page that is used for printing purposes and has been formatted in a specific way. The page, on load, uses a datareader to get data from a back end db and populates the page. I've used labels and panels to account for the fact that the data will be of variable sizes. It all works...

Hi I have a datagrid that is populated with a dataset. There is an extra template column that the datagrid has that I would like to populate programatically, but I'm not sure how to go about doing this. Here's my current code: 'this sub populates the data grid Connection.Open()...

Hi I'm creating a webpage using panels so that the height of each section of the page is dynamic. Each panel needs different text depending on the user/circumstances. Is there a way of setting panel text programmatically? Panels do not appear to have a text property, but you can type text...

Hi I've got a webpage developed in .NET, which I want users to be able to print. I've got the formatting all correct and it looks fine printed with ONE major drawback. When you send a webpage to a printer, by default the page prints with the page name & page number(s) in the header and link...

Hi, I've got a webpage developed in Visual Studio designer. It's a copy of another page, modified slightly. The original page formatting is fine. However the copied page, which consists of multiple panels and hundreds of labels, looks fine until half way down when the formatting goes very...

Hi all, I've got a big and complex webpage with hundreds of labels populated by a datareader, all held in multiple panels. All the data population works fine but, half way down the page, the formatting goes very strange and it doesn't look anything like it does in design mode. Background...

Hi, I've got a button on a webform that redirects users to another page dependant on some variable values. However I don't want to redirect, I want to open the page in a new browser window. How is this possible? Here's my code: Private Sub PrintBtn_Click(ByVal sender As System.Object, ByVal...

Hi, I've got a list box on a web form which, when loaded, uses data from a text field in a database to determine which values should be selected. When the user presses save, the selections from the list box should be resaved to the text field. This works fine if the user manually selects items...

Hi all I've converted a datagrid column to a template column, but I'm not sure how to write the html (I assume it's an IIF statment but not sure) to do the following: If the value is 1 then display Jan, if the value is 2 then display Feb, if the value is 3 then display Mar, etc up to 12 and...

All, I wonder if you can help me, I have the following code that is returning unexpected results and I have no idea why: Dim searchYear As String If InStr(3, wholeYear) = "0" Then searchYear = Right(wholeYear, 1) Else searchYear = Right(wholeYear, 2) End If...

Hi I wonder if anyone can give me some advice. I have a very long webpage (lots of entry fields on it). It has some fields that require autopostback to be set to true (e.g. some radio buttons and drop down lists), however this is causing me a problem. Some of these fields are quite a long way...

Hi all Is there a maximum number of columns for an OLEDB dataadapter to handle? I'm trying to configure a dataadapter to generate select, insert, delete and update commands for an Access table with over 100 columns. I'm going to customise the SQL later because I won't use all 100 columns at the...

I originally posted this: http://www.tek-tips.com/viewthread.cfm?qid=1368058&page=1 and have discovered that my problem is not my SQL, the problem is that I am trying to extract a string from my page's querystring that contains an ampersand, and everything after the ampersand is ignored. I...

Hi, I've got an SQL query string that works fine getting info from a back end Access database from an ASP.Net page. However I've found one of the query fields could contain illegal characters. I've managed to work out how to replace the ' character, but not the & character. What should I do...

I have some code that dumps a datagrid into an excel spreadsheet and saves it to a C drive. Whilst testing locally this worked fine because I was on my own machine and it saved locally. I've just tested on our intranet server and didn't realise that it would save on the intranet C drive - what I...

Hi all, can't work this one out.... I'm updating an Access table from a web form. I've got 2 date fields, one updates, the other creates a data type mismatch criteria error. I've run the SQL directly in Access and it works fine. I must have made a stupid error somewhere but I can't for the life...

Hi all, I am having problems with exporting a datagrid to Word and Excel. Firstly, I need to do the export as the data needs to be reformatted by users and printed (unless someone can give me an easier way of printing a datagrid, as I haven't found one yet). I don't mind whether it goes to...