• Member Avatar for cgeier
    cgeier

    Began Watching Using the UPDATE MySQL Command in C#

    I'm a little bit stuck at this moment. As of now, this is the code that I have: private void btnChangeImage_Click(object sender, EventArgs e) { using (OpenFileDialog openFileDialogForImgUser = new …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Using the UPDATE MySQL Command in C#

    [Creating and Using a Database](http://dev.mysql.com/doc/refman/5.1/en/database-use.html) *"...The USE statement is special in another way, too: it must be given on a single line..."* [Connection Strings](http://www.connectionstrings.com/mysql/) *"...The port 3306 is the default …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Key Board Event in VB.net?

    Are you trying to send this to a form you created in VB .NET or to a window in another program? Also, you can edit a post after you sign …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Key Board Event in VB.net?

    [SendKeys.Send Method ](http://msdn.microsoft.com/en-us/library/system.windows.forms.sendkeys.send(v=vs.110).aspx) *"Caution: If your application is intended for international use with a variety of keyboards, the use of Send could yield unpredictable results and should be avoided."*
  • Member Avatar for cgeier
    cgeier

    Began Watching how to write to fil in program folder in VB.net?

    how to write to file in program folder in VB.net? ex Program Files\n\n.ini. how to write to n.ini in program folder.
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in how to write to fil in program folder in VB.net?

    Use one of the following directories to store your data: Dim userProfileDir As String = Environment.GetEnvironmentVariable("USERPROFILE") Dim allUsersProfileDir As String = Environment.GetEnvironmentVariable("ALLUSERSPROFILE") Dim appDataDir As String = Environment.GetEnvironmentVariable("APPDATA") If you …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Download last modified file from FTP server

    I've updated the code. See the notes inside the files (inside FtpDownload.zip) for more details. **Resources:** [using ftp to download a file](http://www.daniweb.com/software-development/vbnet/threads/430102/using-ftp-to-download-a-file) [FtpWebRequest Download File](http://stackoverflow.com/questions/2781654/ftpwebrequest-download-file) [Downloading Files Using FTPWebRequest](http://stackoverflow.com/questions/12519290/downloading-files-using-ftpwebrequest) [FtpWebRequest …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Download last modified file from FTP server

    The following should work: Private _filenamePattern As String = ".*(?<filename>\d{4}-\d{2}-\d{2}-\d{4}.txt.tgz).*" Private _ftpRequest As FtpWebRequest = Nothing Private _downloadDirectory As String = String.Empty Private _ftpUrl As String = String.Empty Private _password …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Download last modified file from FTP server

    I don't understand why you would have to "modify the regex everytime". From the data you provided, the last filename is the newest filename. So you just have to get …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in vb 6 equivalent code in vb 10

    I have a post [here](http://www.daniweb.com/software-development/vbnet/threads/480783/declaration-of-connection-string-using-ado/) that shows using ADODB. It is on page 1. See "Version 4 (using ADODB and OleDbDataAdapter)" It is for DB2 Express, but just change the …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Download last modified file from FTP server

    Try one of the following: Version 1: Dim pattern As String = "[-rwx]{10}\s+\d\s+\d\s+\d\s+\d+\s+(?<monthName>[A-Z][a-z]+)\s+(?<monthNumber>\d+)\s+(?<timeOfDay>\d{2}:\d{2})\s+(?<filename>\d{4}-\d{2}-\d{2}-\d{4}.txt.tgz).*" Version 2: Dim pattern As String = "[-rwx]{10}\s+\d\s+\d\s+\d\s+\d+\s+(?<monthName>[A-Z][a-z]+)\s+(?<monthNumber>\d+)\s+(?<timeOfDay>\d{2}:\d{2})\s+(?<filenameDatePart>\d{4}-\d{2}-\d{2})-(?<filenameTimePart>\d{4}).txt.tgz.*" Version 3: Dim pattern As String = "[-rwx]{10}\s+\d\s+\d\s+\d\s+\d+\s+(?<monthName>[A-Z][a-z]+)\s+(?<monthNumber>\d+)\s+(?<timeOfDay>\d{2}:\d{2})\s+(?<filenameDateYear>\d{4})-(?<filenameDateMonth>\d{2})-(?<filenameDateDay>\d{2})-(?<filenameTimePart>\d{4}).txt.tgz.*" Group …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in SQL database refresh

    If you have foreign keys, the order in which you drop the tables is important. If you are re-creating the tables exactly the same, it isn't necessary to drop the …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Download last modified file from FTP server

    Please post the value of "result" after line #15 is executed.
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in get data from 3 different tables in a database

    Please show your table relationships.
  • Member Avatar for cgeier
    cgeier

    Began Watching Download last modified file from FTP server

    Hello all, I am a vb.net newbie and I am trying to write a code that when executed pulls the latest file on an FTP server (based on creation date). …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Download last modified file from FTP server

    There is some code in [this post](http://www.daniweb.com/software-development/vbnet/threads/480531/regex-alternatives) that uses regex. It demonstrates usage of regex in VB .NET.
  • Member Avatar for cgeier
    cgeier

    Began Watching Data Loss Upon Re-opening Program

    I'm doing a project where I want Data to be saved to a database ALWAYS. :) When Im in debug the data is saved and it is even saved while …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Data Loss Upon Re-opening Program

    What kind of database are you using?
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Outlook contact list

    The code above is not for Exchange. These may be of use: [Programmatically Accessing Outlook Contacts Via Exchange Web Services](http://chrisrisner.com/Programmatically-Accessing-Outlook-Contacts-Via-Exchange-Web-Services) [How do I access my Outlook contacts from my web …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Test question confused

    You will also need to change the protection level of "FirstName", "LastName", and "EmailAddress" (in person). Otherwise the following line will throw a compiler error: mailing.Bcc.Add(person.EmailAddress); [Accessibility Levels (C# Reference)](http://msdn.microsoft.com/en-us/library/ba0a1yw2.aspx) …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Test question confused

    Personalize the message. In emailText replace the word "user" with each person's first name. Use String.Replace
  • Member Avatar for cgeier
    cgeier

    Began Watching How to keep original instance of form and user control

    I am trying to pull data from user control 1 and insert the data into a label on user control 2. I have been doing a lot of research on …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in How to keep original instance of form and user control

    Try the following: **Create your user controls:** * Click "File" * Select "New" * Select "Project" * Click "Visual C#" * Select "Windows" * Select "Windows Forms Control Library" * …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in How to keep original instance of form and user control

    See the following tutorial: [How to pass data between two forms in C#](http://www.daniweb.com/software-development/csharp/tutorials/476685/how-to-pass-data-between-two-forms-in-c)
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in How to keep original instance of form and user control

    What version of VS? What version of .NET? Are both UserControls being used on the same form or different forms? Do you have some screen shots? I'm confused by "I …
  • Member Avatar for cgeier
    cgeier

    Began Watching Looping through 2 datareaders

    hello quys, gota a problem here. i have two datareaders.reade1 reads data from one table and read2 from another.i want to loop through reader1 and reader2 so that records that …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Looping through 2 datareaders

    So you want Table2 to be a copy of Table1? Why don't you delete all the data from Table2 and then use "Select Into". [SQL SELECT INTO Statement](http://www.w3schools.com/sql/sql_select_into.asp) [Inserting Rows …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in reading all store in outlook

    **Resources** (for the above post)**:** [Can I read an Outlook (2003/2007) pst file in C#?](http://stackoverflow.com/questions/577904/can-i-read-an-outlook-2003-2007-pst-file-in-c) (Converted to VB .NET) [Add a new .pst file and set its display name](http://www.outlookcode.com/codedetail.aspx?id=84) [Reading …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Having problems accessing MS Access with C#

    Try surrounding string values with single quotes. Or better yet, use parameters. Search for parameterized queries.
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in reading all store in outlook

    The following was tested on Outlook 2010: If you've already added the .pst files you want, do the following: **Version 1** (.pst manually added)**:** Private Sub getOutlookEmailInfo() Dim output As …
  • Member Avatar for cgeier
    cgeier

    Began Watching Outlook contact list

    Is there a way to get all contacts id's from outlook 2013 or 2007 to datagridview or combobox.collection list. Thanks
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Outlook contact list

    **Add reference to "Microsoft Outlook xx.x Object Library"** (where xx.x = 14.0, 12.0, etc)**:** * Click "Project" * Select "Add Reference" * Click "COM" * Select "Microsoft Outlook 14.0 Object …
  • Member Avatar for cgeier
    cgeier

    Began Watching calling AS400 stored procedure from C# application

    When I calling AS400 stored procedure from C# application I get this error MSG - ERROR [42S02] [IBM][Client Access Express ODBC Driver (32-bit)][DB2/400 SQL]SQL0204 - GVSP07 in TESTGV type *N …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in calling AS400 stored procedure from C# application

    Also what is your connection string (conOdbc)?
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in calling AS400 stored procedure from C# application

    I don't have much experience with DB2, but found the following: [Client Access ODBC: Common External Stored Procedure Errors](http://www-01.ibm.com/support/docview.wss?uid=nas8N1019720) Error: [DB2/400 SQL]SQL0204 - in type \*N not found *This error …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in calling AS400 stored procedure from C# application

    If you want anyone to help, you need to provide your code.
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Trying to make devices broadcast their ip to a website

    Wmi is for computers running Windows. You need to provide more info about your devices and environment.
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Trying to make devices broadcast their ip to a website

    The above assumes that your program is running on each client pc.
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Trying to make devices broadcast their ip to a website

    Use wmi to get the relevant info (mac address, ip address, etc) and send that info wherever you want to send it.
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Problems with Loop in VB

    It's best to post your code, as some people don't want to download unknown files to their computer. Your original code: Module Module1 Sub Main() 'Declarations Dim intC As Integer …
  • Member Avatar for cgeier
    cgeier

    Began Watching Network Hard drive

    Hello, i am presently trying to network my local hard drive c over my home network i enabled sharing, gave full control to everbody however if i try to access …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Network Hard drive

    What os? Is the C drive where the os resides? If so, it's not a good idea to share the os drive to everyone even on your home network. What …
  • Member Avatar for cgeier
    cgeier

    Began Watching Send Mail from System.Net.Mail

    Getting "The specified string is not in the form required for an e-mail address." error while sending from from Vb.net. userid "abc-xyz.net" displayname "abc" If we send mail from gmail …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Send Mail from System.Net.Mail

    A valid e-mail address contains "@" (ex: username@domain). I don't see that in your post.
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in reading all store in outlook

    I don't understand what you are looking for. What do you mean by "but also the pst(s) that is loaded in the outlook"? Maybe you can post a screen shot …
  • Member Avatar for cgeier
    cgeier

    Began Watching vbnet mysql datagrid duplicate data

    Hello everybody.I am amking a programm in vb net and mysql. My question is the following: i have one main form which it loads ,it loads all the database data …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in vbnet mysql datagrid duplicate data

    I noticed that you have the following in your code: `Dim dbdataset As New DataTable`. The name "dbdataset" is a little misleading, because you define it as a DataTable, not …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in vbnet mysql datagrid duplicate data

    Try adding the following: `DataGridView1.DataSource = Nothing` to datagridview_load Public Sub datagridview_load() 'Loads the data into the datagrid table' 'prevents duplicates DataGridView1.DataSource = Nothing mysqlconn = New MySqlConnection mysqlconn.ConnectionString = …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Refreshing data in datagridview

    Please post some code and some more information. Are you adding the data using datagridview? Or on another form?
  • Member Avatar for cgeier
    cgeier

    Began Watching Get and Set Screen Saver Timeout

    After a lot of research I have figured out (sort of) How to get and then set then screen saver time out using VB.Net. What I have doesn't seem to …

The End.