Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. smbrown

    Help With Oracle Select Into Statement

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

    AJAX AutoCompleteExtender from query help

    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...
  3. smbrown

    AJAX AutoCompleteExtender from query help

    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 & "%"...
  4. smbrown

    help using sleep in VB

    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...
  5. smbrown

    open excel on client machine

    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
  6. smbrown

    open excel on client machine

    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...
  7. smbrown

    Collecting values from gridview

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

    add watermark to excel spreadsheet

    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
  9. smbrown

    change color text in header of gridview

    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...
  10. smbrown

    add watermark to excel spreadsheet

    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
  11. smbrown

    change color text in header of gridview

    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...
  12. smbrown

    change color text in header of gridview

    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"...
  13. smbrown

    GridView and vertical gridlines

    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
  14. smbrown

    Gridview not finding values for update.

    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...
  15. smbrown

    Gridview not finding values for update.

    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...

Part and Inventory Search

Back
Top