• Member Avatar for cgeier
    cgeier

    Replied To a Post in Form AutoSize not working

    Did you try refreshing the form after the buttons are generated? this.Refresh();
  • Member Avatar for cgeier
    cgeier

    Stopped Watching "Input String was not in a correct Format"

    Pls do help me, I got an error **Input String was not in a correct format**. Here is the code where error appears, This is in my Record form. After …
  • Member Avatar for cgeier
    cgeier

    Began Watching VB.Net SQL Database Log In

    Hiya guys, I am wondering whether anyone can help me, I have been stuck on this for weeks. I have got a similar thing working but I just cannot get …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in VB.Net SQL Database Log In

    In line 19, use "String.Compare" instead of "<>". This seems unnecessary however, because you already passed all of the information in your SQL query and if it returns any rows, …
  • Member Avatar for cgeier
    cgeier

    Began Watching Creating an SQL statement in a VB.NET form button

    I'm using: Windows 7 Word 2010 Visual Studio 2013 Express for Desktop An Access database with one table As this project is for proof of concept I'm keeping things very …
  • Member Avatar for cgeier
    cgeier

    Began Watching XmlDocument output to listbox

    Hello im making this xml reader that outputs links to listbox, the xml code is like this. <item> <title>file1</title> <category>myfiles</category> <link>http://google.com</link> </item> <item> <title>file2</title> <category>myfiles</category> <link>http://yahoo.com</link> </item> My code looks …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in XmlDocument output to listbox

    [DataGridViewLinkColumnClass](http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridviewlinkcolumn.aspx) See this post on how to [add DataGridViewLinkColumn dynamically](http://stackoverflow.com/questions/3472632/how-can-i-add-a-link-to-datagridviewlinkcolumnvb-net) [Link column in DataGridView](http://forums.codeguru.com/showthread.php?408744-Link-column-in-DataGridView)
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Need of VB.net code

    [Click Here](https://www.google.com/#q=how+to+learn+to+program)
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in How can I show the data that is related with the name in the listbox using

    The code for Client.vb is above, in my very first post.
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Log In Form with On-Screen Keyboard using VB.Net

    TextBox1.Focus will not work, since whenever one presses a virtual key (button) focus will now be on the button, not on the previously selected TextBox.
  • Member Avatar for cgeier
    cgeier

    Began Watching Log In Form with On-Screen Keyboard using VB.Net

    ![ff8496abfb91bf20a23a64db591fa997](/attachments/small/4/ff8496abfb91bf20a23a64db591fa997.jpg "align-left") Hello there! Newbie here! It is my first time to post something here! Can somebody help me please with my problem on my codes. I have already build/created …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Log In Form with On-Screen Keyboard using VB.Net

    You haven't given any information about your code. I am going to make the following assumptions: * Each virtual key is a Button * TextBox named: TextBox1 * TextBox named: …
  • Member Avatar for cgeier
    cgeier

    Began Watching How to get ID of SelectedValue in a combobox

    So I have this: private void GetSuppliersList() { ds = oDAL.GetSuppliersList(); cmbSupplier.DataSource = ds.Tables["SuppliersHeader"]; cmbSupplier.DisplayMember = "SupplierName"; cmbSupplier.ValueMember = "SupplierID"; } And I need to display SupplierAddress from my SQL …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in How to get ID of SelectedValue in a combobox

    [This post](http://www.daniweb.com/software-development/csharp/threads/473541/combobox-value-member-issue) might help you.
  • Member Avatar for cgeier
    cgeier

    Began Watching debugging a database application

    i have worked on standalone projects on vb but dont know how to debug server & client side database application whose front end is vb.net & back end is ms …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in debugging a database application

    Access is just a file, and uses a file lock. It is single-user. What issues are you having? Copy the file to your local computer, and see if you encounter …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in XmlDocument output to listbox

    Use a DataGridView
  • Member Avatar for cgeier
    cgeier

    Began Watching "Input String was not in a correct Format"

    Pls do help me, I got an error **Input String was not in a correct format**. Here is the code where error appears, This is in my Record form. After …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in "Input String was not in a correct Format"

    That error occurs if you have non-numeric data in the variable that you are trying to convert. Check to see what "BlockNo1" contains.
  • Member Avatar for cgeier
    cgeier

    Began Watching Database

    i connect my access to vb2010 using adodb. but i cant display the datas in my listview. can someone help me to solve my problem. i would really appreaciate any …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Database

    Ensure ListView.View = View.Details 'set to details view ListView1.View = View.Details Did you already create the columns? If not, add this to your code: 'Add columns to listview ListView1.Columns.Add("SKU") ListView1.Columns.Add("Quantity") …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in How can I check whether the quiz answer was correct?

    One more note, my code above assumes that you have 3 radio buttons on your form and the radio buttons work as a group (are on a "Panel" or "Groupbox"). …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in How can I check whether the quiz answer was correct?

    If you want to use with a "Next" button then add the following: Private selectedRadioButton As RadioButton Declarations after adding: Private kv As Dictionary(Of String, String) 'Define kv as a …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in How can I check whether the quiz answer was correct?

    After you change lines 21-23 and 57-58 From: RadioButtonDef1.Text = definitionsRandom(0) RadioButtonDef2.Text = definitionsRandom(1) RadioButtonDef3.Text = definitionsRandom(2) To: radDef1.Text = definitionsRandom(0) radDef2.Text = definitionsRandom(1) radDef3.Text = definitionsRandom(2) **Note:** I renamed …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in How can I check whether the quiz answer was correct?

    In your latest code you seem to be referencing radio buttons: radDef1 AND RadioButtonDef1. radDef2 AND RadioButtonDef2. radDef3 AND RadioButtonDef3. Do you have 6 buttons or did you forget to …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Help with calendar in VB10 in Visual Studio 2010

    Since you are learning a new programming language, you may consider learning C# instead. I'm not certain, but I think that it may be more widely used. You could accomplish …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Help with calendar in VB10 in Visual Studio 2010

    I think that you should probably use either a book or some tutorials to work on the basics before you try to work on something more advanced. There are many …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Syntax error (missing operator) in query expression

    Try something like the following: try { string SQLUpdateString = string.Empty; SQLUpdateString = "update Personaldata set BlockNo = @blockNo, "; SQLUpdateString += "LotNo = @lotNo, "; SQLUpdateString += "Numberofoccupants = …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Syntax error (missing operator) in query expression

    What are you trying to accomplish? Why are you replacing a single quote with two single quotes? Check your where clause. What is the data type of BlockNo? You have …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Help with calendar in VB10 in Visual Studio 2010

    Your main (parent) form needs to be aware of any changes made to any of the files. I recommend passing everything to the main (parent) form and letting the main …
  • Member Avatar for cgeier
    cgeier

    Began Watching Syntax error (missing operator) in query expression

    I got an error, "Syntax error (missing operator) in query expression ''Blanco, Familyname='Grace'." in my code, near ExcecuteQuery(); I am performing Update from MSAccess, I can retreive data but when …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Syntax error (missing operator) in query expression

    Check to see if this is causing the error: `SET BlockNo ='" + BlockNo.Replace("'", "''") + "'`. What data does "BlockNo" contain? And how are you wanting it to be …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Accessing serial port name

    Using WMI, try looking in * Win32_PnPEntity * Win32_PnPSignedDriver
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Accessing serial port name

    You may be able to get some info using WMI. [WMI Code Creator](http://www.microsoft.com/en-us/download/details.aspx?id=8572)
  • Member Avatar for cgeier
    cgeier

    Began Watching Accessing serial port name

    I am building a support application (VB.net 2010) for a device that will attach via USB. Most of the end users will not be geeks. In starting the app I …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Accessing serial port name

    What type of device is it? Is it a bluetooth device? Did you try searching the registry for COM9? * regedit * Edit * Find search for: COM9
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Unrecognized database format

    Is Access 2013 installed on the development computer or did you copy the file from a computer that has Access 2013 installed? Did you add a reference to the Access …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in SQL Query + Progressbar

    Requesting the data twice will increase the load on the server. To say that it will make your application half as responsive is an overstatement--the server querying the database is …
  • Member Avatar for cgeier
    cgeier

    Stopped Watching Check if there is an existing record on ms access 2007

    Can someone help me in my source code... my problem is, i need to check if there is an existing record on my current database(ms access 2007) here is my …
  • Member Avatar for cgeier
    cgeier

    Began Watching SQL Query + Progressbar

    If anyone can help me , I wanted to know how to use a progressbar while the sql query is executing. Just a "Beg"inner in VB.net here's my code: dataopen() …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in SQL Query + Progressbar

    You only seem to be retrieving no rows or 1 row, so it seems unnecessary. You could use a status label, instead to keep the user informed what is going …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in SQL Login HELP

    I added another Try-Catch in this version: Private Sub readDB(ByVal username As String, ByVal userpassword As String) Using con As New SqlConnection con.ConnectionString = connString Try con.Open() Using cmd As …
  • Member Avatar for cgeier
    cgeier

    Began Watching Check if there is an existing record on ms access 2007

    Can someone help me in my source code... my problem is, i need to check if there is an existing record on my current database(ms access 2007) here is my …
  • Member Avatar for cgeier
    cgeier

    Began Watching SQL Login HELP

    Having a problem setting up a login form for my project, here's the code: Imports System Imports System.Data.SqlClient Public Class Login Dim con As SqlConnection Dim cmd As SqlCommand Dim …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in SQL Login HELP

    Adding "New" should fix your issue: From: Dim con As SqlConnection Dim cmd As SqlCommand To: Dim con As New SqlConnection Dim cmd As New SqlCommand You should consider using …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in populating a combobox in datagrid

    Probably a database lock issue. Make sure you are closing your connection after using it. Better yet, use a "using" statement. Also, make sure you don't have the file open …
  • Member Avatar for cgeier
    cgeier

    Began Watching Data type mismatch in criteria expression.

    I've got this error: **Additional information: Data type mismatch in criteria expression.** I don't know why.. I want to use split text in a textbox and insert the splitted texts …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Data type mismatch in criteria expression.

    You need to convert "splittedText2[i]" and "splittedText3[i]". What database are you using? Here are some mappings: [SQL Server Data Type Mappings](http://msdn.microsoft.com/en-us/library/cc716729(v=vs.110).aspx) [OLE DB Data Type Mappings](http://msdn.microsoft.com/en-us/library/cc668759(v=vs.110).aspx) [mySQL Data Type Mappings](http://www.devart.com/dotconnect/mysql/docs/DataTypeMapping.html)
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Help with calendar in VB10 in Visual Studio 2010

    Since you have limited experience, it may be easiest to do the following: * Create a folder for the schoolyear (ex: 2013) * Then within the folder, create either one …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Help with calendar in VB10 in Visual Studio 2010

    You can store your data however you like--in a plain text file if you want. A database or XML file would help to keep your data organized. How long does …

The End.