Search:

Type: Posts; User: sc0ttr0

Search: Search took 0.02 seconds.

  1. Replies
    5
    Views
    679

    Re: [2005] Datagridview

    Ok. Creating a datatable instead works perfectly.

    Thanks for pointing me in the right direction. I cleaned it up per your suggestions.
  2. Replies
    5
    Views
    679

    Re: [2005] Datagridview

    It's my first go with the datagridview and the dataadapters. I copied and pasted this code directly from the web to get me started and just modified it. I thought people on the internet were always...
  3. Replies
    5
    Views
    679

    Re: [2005] Datagridview

    Sorry. It's a vb05 windows application
  4. Replies
    5
    Views
    679

    [RESOLVED] [2005] Datagridview

    I'm new to datagridviews. This code runs behind a button click. It runs through without errors but doesn't fill the datagridview with any visible data.

    Am I missing something simple or going...
  5. Replies
    5
    Views
    665

    Re: Pass dropdown selection

    you can have them click a button or do it on "selectedindexchange" event


    dim strSelection
    dim strLink

    strselection = me.dropdown1.selectedvalue
    strlink = "~/Page2.aspx?departmentnumber=" &...
  6. Thread: date diff

    by sc0ttr0
    Replies
    3
    Views
    457

    Re: date diff

    now()-1
  7. Replies
    2
    Views
    469

    Re: ASP working with a form

    checkbox1.checked=true





    If you're redirecting just pass a URL value to the other page:
  8. Replies
    6
    Views
    3,511

    Re: [2005] Recordset Problem

    What are the cons to using ado? Just curious because it's how I was taught to do it the "right way".
  9. Replies
    1
    Views
    524

    Re: [2005] Working with webbrowser control.

    Yikes. I know this sounds stupid but it's neccessary for a short term fix to "high-tech Red-Neck" this. I've searched google and cant seem to find what im looking for. Maybe it's just not meant to...
  10. Replies
    1
    Views
    524

    [2005] Working with webbrowser control.

    I saw a post about this but i cannot find it. If somebody could point me in the right direction I'd appreciate it.

    What I'm trying to do is use an aspx page from a webbrowser control in a vb...
  11. Re: [2005] Help with E-Mail sending it doesnt work

    Catch the inner exception of the error it's throwing
  12. Replies
    0
    Views
    13,697

    Excel on the fly

    It may not be the best but it worked like a champ for me. This is a page I've written to select data from an SQL server database and write out an excel file server side with streams and then...
  13. Re: Rearrange the order of the columns in a datatable/dataset

    if you're selecting out the data to display with a statement just instead of doing "select * from" try "select column4,column1,column2,column3 from"

    then it doesn't matter what order the tables...
  14. Replies
    4
    Views
    900

    Re: sql server and vb.net

    Or this. This validates User based on a username being inputted into a textbox on your form. Run this behind some kind of "Login" or "Validate" button.




    dim SQLconn as object
    dim SQLrs as...
  15. Re: [RESOLVED] Hyperlink fields in gridview: [2005]

    in the hyperlink field properties window:

    datanavigateurlfields = InitiativeID
    datanavigateurlformatstring = Benefits.aspx?InitiativeID={0}

    ON the results page give your datagrid the parameter...
  16. Replies
    26
    Views
    1,767

    Re: How Should I Change This

    Why does the data change? Why not simply keep records and generate your report based on date values instead of changing that data?

    I'd really have to understand what the data is and why you do it...
  17. Replies
    12
    Views
    841

    Re: How to migrate from Access to SQL

    run a DTS job on your SQL server to pull in all the data tables. once that's done creat a copy of your original database and ODBC link the tables back into it. They will show up as dbo_<tablename>...
  18. Re: Problem with SQL update statement

    I would say that you have # fields formatted as text. Leave the apostrophies off the number fields.



    "UPDATE dailyTable SET [day]='Tuesday',
    grossSales=1000,vatableSales=117.5,...
  19. Replies
    12
    Views
    921

    Re: SQL Select on DateTime problem

    Try taking the apostrophies off the cdtstr variable if you havent.



    and (act_date = " & CDTStr & ")"


    Another thing to consider is when you format CDT and the month or day is single digit...
  20. Replies
    16
    Views
    948

    Re: Add data to Access DB

    Is it giving a data-type mismatch error?
  21. Replies
    12
    Views
    921

    Re: SQL Select on DateTime problem

    Gotcha

    Could you retrive a unique identifer as well and use that to drill down to a specific record?
  22. Replies
    12
    Views
    921

    Re: SQL Select on DateTime problem

    SQLString = "select * from datevalues"
    SQLString = SQLString & " where symbol = '" & ACSymbol & "'"
    SQLString = SQLString & " and datepart(dy,act_date) = datepart(dy," & now() & ")"
    SQLString =...
  23. Replies
    5
    Views
    1,159

    Re: Sending mail using SMTP server

    Imports System.web.Mail


    Sub MailMsg()

    Dim msg As MailMessage = New MailMessage
    Dim txtinnerex As String

    Try
    SmtpMail.SmtpServer = "xx.xxx.x.x" 'smtp...
  24. Replies
    8
    Views
    913

    Re: [RESOLVED] Streamread.close() problems

    works perfectly inside a timer instead of a filewatch.
  25. Replies
    8
    Views
    913

    Re: Streamread.close() problems

    I'll try a timer event instead......thanks!
  26. Replies
    8
    Views
    913

    Re: Streamread.close() problems

    DOH....I'm such a tard.
  27. Replies
    8
    Views
    913

    Re: Streamread.close() problems

    Sorry

    I set a file monitor up and it calls the routine on file change.
  28. Replies
    8
    Views
    913

    [RESOLVED] Streamread.close() problems

    sorry i posted on the end of a solved post so I thought i would bring it out as a fresh post.

    I'm trying to monitor a log file. this log updates several time per second at times and im trying...
  29. Replies
    6
    Views
    858

    Re: [RESOLVED] clearing a text file

    I'm running into kind of the same thing.

    Same situation. If there are changes I streamread the text file and read the contents into a textbox and trigger different actions based on what is is...
Results 1 to 29 of 29



Click Here to Expand Forum to Full Width