Search results for query: *

Did the catch display an error? If so what was the error? Thanks, SMBrown

Got it. I just eliminated the parameters.add and pass the value straight to the select statement. Made a few changes to the order I was doing this in. So now the code looks like this: [code] Dim Con As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data...

I am trying to use a query to give the suggestions for the AutoCompleteExtender. The event is fired, and I catch an error "No value given for one or more parameters." I am thinking that the line: da.SelectCommand.Parameters.Add("@prefixText", OleDbType.VarChar, 50).Value = prefixText & "%"...

I want to notify the user that the record was updated in the DB when an update is made, then clear the message from the text box. I tried the following, but the message is never displayed. Seems like I have done this before, but now I can't find the code I used. What am I missing...

Would it be easier to just export the data we need from the excel file to a table in Oracle, and then just query the data? I have never needed to do this before (get or export from excel). Just trying to gather my options. Thanks, SMBrown Thanks, SMBrown

We are building an application that does some calcs based on values from Oracle queries. Half way through the development I was told I need to retrieve a value from an Excel spreadsheet, instead of having the user select the value from a dropdown. Excel is not installed on the server, and never...

This has worked for me: gridText = CType(GridView1.Rows(0).Cell(0).FindControl("CriteriaTextBox"), TextBox).Text SMBrown

That worked perfect. I had never seen a watermark option anywhere, but that doesn't mean that you guys haven't. Thanks for the help. SMBrown

If e.Row.RowType = DataControlRowType.Header Then e.Row.Cells(1).ForeColor = Drawing.Color.CornflowerBlue End If This works if I want to change the font color of the whole column. The column header says: # of Problems I only want to change the "Problems" to red font, and the "# of" to stay...

I have a spreadsheet that has confidential information on it. I was asked to put a "watermark" in the background of the spreadsheet that says "confidential" in red. Is this even possible? Thanks for the help. SMBrown

Sorry. The data from the table is bound to a gridview in the front end of the web page. Do you have an example of the syntax used to do this? I haven't been able to get anything that I have found to work. They all just change the entire header or the footer. I just want to change the color of...

I create a grid using my VB code. I want to change the color of the text in only one of the headers (Problems) in my VB code as well. Dim myTable As New DataTable() Dim dc1 As New DataColumn("Year", Type.GetType("System.Int32")) Dim dc8 As New DataColumn("Problems"...

Had that same problem a bit ago. This worked for me. Try adding the cellspacing and cellpadding to the grid like this: <asp:GridView ID="GridView1" Runat="server" BorderColor="Black" CellPadding="1" CellSpacing="1" BackColor="Black" BorderWidth="1px" SMBrown

I think that the problem I am having is that I need to query the DB based on values chosen by the user, and fill the grid with that data, which is not working if I use the AccessDataSource. SO I agree that I need to get rid of it. I want to do everything in the VB code on the backside. I...

I have a web form that users can select dropdowns on, and fill a grid with the returned values. I need the grid to allow the user to make changes to the grid, and have those changes goto the DB. There is an error on the myID, myUser1... in the VB. It can't find the values for these. Do I need...