I am trying to rename a textbox within a template column at runtime. I need to do this at runtime because the number of columns will change, upwards of 1000 columns. Since there is no VB code to dynamically create a template column with a textbox control, I created a hidden datagrid with the template column, and then at runtime I am copying the column to my visible datagrid and using it for each column. This then throws a HTTPException because it can't distinguish between the different columns' textboxes. Short of creating all 1000 columns in the hidden datagrid and copying over the corresponding column, is there any way to change the name of the textbox for each column as the column is being created. I know that the ItemCreated event is only raised when the datagrid rows are populated, so I cannot use this to change the name. Any suggestions would be greatly appreciated ColdWaterBlue - Rock On!

I actually just figured it out myself. The two front slashes are not needed, but you need to add a user to the SQL Server (in my case, add the 'Guest' user) and give it administrative rights over the database. The User ID and Password are no longer needed, since the Integrated Security uses a trusted connection. Thanks anyway. ------------------------ ColdWaterBlue - Rock On

I am trying to access SQL Server 2000 across a personal network. I am using the following connection string: "Data Source=\\GUITARCHORD\LABTRACK;Initial Catalog=LabTrack Server;Integrated Security=SSPI;User ID=someone,Password=pass" The name of the computer is GUITARCHORD, the name of the SQL Server instance is LABTRACK, and the name of the database I am trying to connect to is LABTRACK SERVER. The user id and password are the Windows Login for the computer that SQL Server is running on. SQL Server is running but I can only access it if I am working on the same computer. I am using VB.NET to try to access this server. I am getting the following error message: "SQL Server does not exist or access denied." I have tried every thing I could think of for a connection string, including using TCP/IP settings. Any suggestions would be extremely helpful. ------------------------ ColdWaterBlue - Rock On

I am in the process of updating a VB 5 application to .NET (not just converting, actually re-coding everything). In the previous version, it was possible to Embed an object to a form and view it's contents. I know that .NET removed the OLE functionality and I was wondering if anybody had any suggestions for a way to mimic the functionality. One of the ideas I have is to use Internet Explorer within the form to display the contents, whether its a picture or text document. I have never worked with this before and do not know if it will actually work for OLE functionality, and if it will I do not know how to get it started. If anybody has any suggestions or can point me to a website, I would appreciate it. ColdWaterBlue - Rock On

I am trying to execute a crosstab query in SQL Server 2000, but alot of the columns display null values for every row. This is an example of what I am getting: Test | Prompt | 0412-0001 | 0412-0002 | 0412-0003 ------------------------------------------------------- BTEX | Benzene | NULL | NULL | ND ph VALUE | ph VALUE | NULL | NULL | 7 And what I want displayed is the following: Test | Prompt | 0412-0003 ------------------------------- BTEX | Benzene | ND ph VALUE | ph VALUE | 7 (I think the formatting is screwing up with the columns, but | indicates a column separator) I am using the stored procedure found here: http://www.sqlteam.com/item.asp?itemID=2955[^] I do not know much about SQL programming and I was wondering if there is a way to modify this stored procedure to eliminate all columns that contain no data. Nick

I've heard that I can use SQL to run dynamically changing mathematical equations. I've got the equation stored in a string (i.e. "((100-75)/100)*100") with the values randomly changing. the formula will not stay constant either, but it is the example I am using. How do I get this to produce a result that I can store in another string? Thanks. Nick

For simplicity's sake, I did not include most of the code. The "sampleTable" variable is actually a global variable that houses the table name, but I included the Dim statement to show that it was a variable.

I am trying to update a table in SQL Server 2000 that will be able to have varying column names (based on the user's specifications). I can read the data fine, but I can't add anything to the table. There are spaces in the column name (i.e. "Received By") and when reading I put brackets [] around it and it works. When I am trying to write to the table, I can update the dataset fine, but not the table in SQL Server. I believe it is a problem with my parameter declaration. When I try to save the data, I get the following error: Line 1: Incorrect syntax near 'varchar'. My code is as follows (not everything because it is quite lengthy): Dim custom01 As String 'Contains the name of the column/field Dim sampleTable As String 'Contains the name of the table within SQL Server sampleUpdate = New SqlClient.SqlCommand("UPDATE " & sampleTable & " SET " & custom01 & " = @" & custom01, dataConnect) With sampleUpdate With .Parameters .Add("@" & custom01, SqlDbType.Varchar, 50, custom01) End With End With As I said, I can update the dataset fine, but when I try to up the dataset back into SQL Server, it crashes. Any thoughts would be greatly appreciated.

I am trying to make one cell in a DataGrid bold based on it's value (i.e. If a customer's number of orders is greater than ten, bold the orders field for that customer). I read somewhere that the key to doing this is through the DataGridColumnStyles but I can't seem to find anything there for this. Does anybody know how this gets done? You think you know everything I'll show you what everyone else can see It's too late to change anything What's here is all that we need to be!

I'm trying to mimic the RowHeaderClick event whenever a row is click in a DataGrid. Does anybody know how to do it? Basically I just want to highlight the entire row. Also, is there a way to change either the font color or background color of different rows in a DataGrid?