raziel_'s Profile User Rating: *****

Reputation: 466 Architect
Group:
Expert w/DIC++
Active Posts:
4,266 (1.82 per day)
Joined:
25-March 09
Profile Views:
78,974
Last Active:
User is offline Aug 28 2015 08:25 AM
Currently:
Offline

Previous Fields

Country:
Who Cares
OS Preference:
Who Cares
Favorite Browser:
Who Cares
Favorite Processor:
Who Cares
Favorite Gaming Platform:
Who Cares
Your Car:
Who Cares
Dream Kudos:
700

Latest Visitors

Icon   raziel_ has not set their status

Posts I've Made

  1. In Topic: Is there an easier/better way?

    Posted 20 May 2015

    Hi,

    Personally i would make all those " WHERE [_Company] like '%" strings in constants for example:
    Private Const DateWhere As String = " WHERE [_Date] like '%@Date%'"
    
    


    then i would use variables for your if like this
    Dim dateVal As String
    Dim companyVal As String
     If Me.radDate.Checked = True Then
                    If Me.cmbDate.Text = "Specific..." Then
                        dateVal = Me.txtSearch.Text
                        sQuery = sQuery & DateWhere
                    Else
                        dateVal = Me.cmbDate.Text 
                        sQuery = sQuery & DateWhere
                    End If
                ElseIf Me.radCompany.Checked = True Then
                    companyVal = Me.txtSearch.Text 
    ...
    
    

    then i would use parametarized queries.

    Using cn As New SqlConnection("Your connection string here"), _
            cmd As New SqlCommand(sQuery, cn)
    
            cmd.Parameters.Add("@Date", SqlDbType.VarChar, 50).Value = dateVal
            
    
    


    Be aware that you must use correct database types for the parameters. You can do a little more cleaning with the if statements.

    Hope that helps :)
  2. In Topic: Vb.net Variable in a Query

    Posted 17 Mar 2015

    Say what now? If you want to dynamically choose the column which to update perhaps you can use the selecteditem or selectedvalue which is good for your design etc. of the combobox and create your query. something like query="update Payroll set " & combobox.selectedvalue & " where id=@id". Also i would recommend you use parameterized queries

    best regards
  3. In Topic: how do u save array data into file.

    Posted 17 Mar 2015

    Hi,

    Well you can always try to loop the array and save it in a file. Have you tried something? Dose your code give you any errors?

    Best regards
  4. In Topic: how to get the selected value of datagridview in textbox in vb.net

    Posted 10 Mar 2015

    Hi there,
    You're probably using VB.NET with that visual studio. Anyway using TextChange Event in the textbox you can update the datagrid. Give it some try and post us back here with the code that you have worked on if you have more troubles and we will be more then happy to take a look at it and help you :)/>

    Best Regards
  5. In Topic: What's your phone?

    Posted 28 Jan 2015

    I had nexus 5 and change it to LG G3. G3 have better battery life better display better camera. And since its not pure android the bugs that 5.1 have do not exist in LG G3. As for now the best deal that i have made is to trade the nexus for this phone. As for the battery on standby without too much talking on it i drain 10% per day. But if i start using youtube and other stuff like that the drain is insane though less then nexus5. there are a lot of cool features that LG put on this phone including split screen that is kinda useful from time to time.

My Information

Member Title:
Like a lollipop
Age:
31 years old
Birthday:
March 11, 1984
Gender:

Contact Information

E-mail:
Private
Website URL:
Website URL  http://

Comments

  • (2 Pages)
  • +
  • 1
  • 2
  1. Photo

    byron126 Icon

    28 Nov 2013 - 12:46
    Hi just wanted to say thanks for existing! ;)
    Having spent hours looking for a way to read and search specific data from a text file to no avail i stumbled accross yore reply to the thread http://www.dreamincode.net/forums/topic/171347-search-text-from-saved-txt-file/
    I really hope you don't mind I use this as part of my A-level computing project :)
  2. Photo

    Rajandy Icon

    27 Mar 2012 - 14:06
    I'm wondering how I could save data that I have created in an MSFlexGrid to either an excel file or CSV or the like to be able to save user input settings in the VB6 environment?
  3. Photo

    andrern2000 Icon

    14 Mar 2012 - 06:12
    My thanks.
  4. Photo

    raziel_ Icon

    10 Jul 2011 - 04:59
    ty man :)
  5. Photo

    noorahmad Icon

    09 Jul 2011 - 21:15
    Congrats for your promotion... ;)
  6. Photo

    raziel_ Icon

    26 May 2011 - 07:12
    I`m expert at being clueless :P
  7. Photo

    ishkabible Icon

    25 May 2011 - 18:19
    you are an expert but it doesn't say in what.
  8. Photo

    cornetto456 Icon

    08 Jan 2011 - 14:14
    Can you check my Tread again thanks ^^
  9. Photo

    cornetto456 Icon

    07 Jan 2011 - 16:37
    Can you check my tread plz thx ^^
  10. Photo

    CharlieMay Icon

    07 Jan 2011 - 11:14
    Thanks, It came as a surprise to be honest.
  11. Photo

    cornetto456 Icon

    04 Jan 2011 - 12:45
    Could you plz check my tread again i need some help :S
  12. Photo

    raziel_ Icon

    20 Dec 2010 - 02:57
    XD ty dude
  13. Photo

    Alex6788 Icon

    18 Dec 2010 - 15:42
    I love your username, avatar, and member title.
  14. Photo

    sk8ter87 Icon

    16 Dec 2010 - 09:11
    bro,can you help me in this thread:
    http://www.dreamincode.net/forums/topic/205663-vb6-mysql/
  15. Photo

    raziel_ Icon

    03 Dec 2010 - 07:24
    woot
  • (2 Pages)
  • +
  • 1
  • 2