• Member Avatar for cgeier
    cgeier

    Replied To a Post in Syntax error in INSERT statement

    What are the data types for each of the columns in the database?
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Select Query fails to retrieve from multiple tables in Access

    Why are you using all these parentheses? FROM (((((Comp_Code INNER JOIN... Also, why are you naming columns the same name as the table that contains it? You're more likely to …
  • Member Avatar for cgeier
    cgeier

    Created How to pass data between two forms in C#

    I will be showing how to pass data between two forms in C#. I will be using two forms, two classes which we will define, a delegate, an event, and …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in .dbo database connection string

    On the computer that is running SQLExpress, ensure that the services are running: * SQL Server * SQL Server Browser [Database Connectivity](http://msdn.microsoft.com/en-us/sqlserver/ff688946)
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in .dbo database connection string

    How are you connecting the computers? Through a router/switch? Or are you attempting to connect them using a cable between the LAN cards?
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in VB.NET 2010 Developed apps not working on win7

    [Teach Your Apps To Play Nicely With Windows Vista User Account Control](http://msdn.microsoft.com/en-us/magazine/cc163486.aspx)
  • Member Avatar for cgeier
    cgeier

    Began Watching VB.NET 2010 Developed apps not working on win7

    Hello all, I have a weird problem. I have created an application in VB.NET 2010 on my PC which runs Windows XP Home Edition SP3. Upon testing my application, I …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in VB.NET 2010 Developed apps not working on win7

    What version of XP (32-bit or 64-bit)? What version of Vista (32-bit or 64-bit)? What version of Win 7 (32-bit or 64-bit)? Did you check that the necessary version of …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Running Multiple project from one solution

    These links may be of help: [Walkthrough: Adding an existing Visual Studio solution to another solution](http://blogs.msdn.com/b/habibh/archive/2009/06/24/walkthrough-adding-an-existing-visual-studio-solution-to-another-solution.aspx) [How to: Create Multi-Project Solutions](http://msdn.microsoft.com/en-us/library/h970wzkb.aspx) [How to: Modify Project Properties and Configuration Settings](http://msdn.microsoft.com/en-us/library/z15yzzew.aspx) [How …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Running Multiple project from one solution

    What do you mean by "different modules....in different project solutions"? Are you talking about a vb module (ex: Module1.vb, Module2.vb, etc)? Or are you talking about some forms that exist …
  • Member Avatar for cgeier
    cgeier

    Began Watching Trouble again with arrays any help needed would be great

    So I'm basically trying to recreate the simulation of two dice being rolled, and I need to count the frequency in a two dimensional rectangular array, then display the array. …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Trouble again with arrays any help needed would be great

    Here is a small program I wrote to help understand what nested for loops do: static void Main(string[] args) { string inputStr = String.Empty; int outerForLoopCount = 0; int firstNestedForLoopCount …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Refreshing data when using a datareader

    [TimeZoneInfo](http://msdn.microsoft.com/en-us/library/system.timezoneinfo(v=vs.110).aspx) looks like it is only supported in .NET versions >= 3.5 Here are some other resources: [.NET Framework Versions and Dependencies](http://msdn.microsoft.com/en-us/library/bb822049(v=vs.110).aspx) [Multi-Targeting Support](http://weblogs.asp.net/scottgu/archive/2007/06/20/vs-2008-multi-targeting-support.aspx) [Global Time](http://blogs.msdn.com/b/lightswitch/archive/2013/09/25/what-time-is-it-global-time.aspx) [VS Express 2010](http://www.visualstudio.com/en-us/downloads#d-2010-express) [VS …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Refreshing data when using a datareader

    I've updated 'getData' to use an SqlDataAdapter and added code that significantly reduces the number of times the labels are re-drawn (appearance of flashing on the form). This is an …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Refreshing data when using a datareader

    'SqlDataReader' version is basically the same one that I posted previously. Other minor modifications are documented in the code. 'SQLDataAdapter' version has the changes made by xj implemented (uses SqlDataAdapter …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Refreshing data when using a datareader

    *In the For Loop where the labels are removed, it refers to lblName (for each lblName in...) but when i add that it complains that lblName is not declared.* Fix: …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Refreshing data when using a datareader

    I think that it is easier to understand if I post some sample data. **Team Sample Data:** ![2197aa5b5582691ca4d8da6f22b8e31b](/attachments/fetch/L2ltYWdlcy9hdHRhY2htZW50cy8xLzIxOTdhYTViNTU4MjY5MWNhNGQ4ZGE2ZjIyYjhlMzFiLkpQRw%3D%3D/190 "align-middle") **TeamMember Sample Data:** ![b0110e224e6a9cc33f38774b0ee59fd5](/attachments/fetch/L2ltYWdlcy9hdHRhY2htZW50cy8xL2IwMTEwZTIyNGU2YTljYzMzZjM4Nzc0YjBlZTU5ZmQ1LkpQRw%3D%3D/300 "align-middle") **Schedule Sample Data:** ![d351ec5ed99bc31834b2b04ad2cd21c9](/attachments/fetch/L2ltYWdlcy9hdHRhY2htZW50cy8xL2QzNTFlYzVlZDk5YmMzMTgzNGIyYjA0YWQyY2QyMWM5LkpQRw%3D%3D/300 "align-middle") A …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Refreshing data when using a datareader

    You may notice some flashing when an update is occuring because the labels are removed and added again. A work-around, would be to check to see if any of the …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Refreshing data when using a datareader

    The code should work with your local project database too--I tested it both ways. In "SQLExpressDB.vb" (connectStr), comment out the "connectStr" that is currently used and uncomment one of the …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Refreshing data when using a datareader

    Here is a project I created. It is based on the code you posted above. It requires that you have SQLExpress installed. Download [SQL Management Studio](http://www.microsoft.com/en-us/download/details.aspx?id=29062). It will make it …
  • Member Avatar for cgeier
    cgeier

    Began Watching HOW TO ADD DATETIMEPICKER CONTROL IN THE COLUMN OF DATAGRID

    HOW TO ADD DATETIMEPICKER CONTROL IN THE COLUMN OF DATAGRID.........TO PICK THE DATE AT RUN TIME
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in HOW TO ADD DATETIMEPICKER CONTROL IN THE COLUMN OF DATAGRID

    The following post may help: [How to: Host Controls in Windows Forms DataGridView Cells](http://msdn.microsoft.com/en-us/library/7tas5c80.aspx?cs-save-lang=1&cs-lang=vb#code-snippet-1)
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in fetch data from 2 table of access database

    Duplicate post: http://www.daniweb.com/software-development/vbnet/threads/476214/saving-selected-data-from-textbox-to-db See your other post for a better database design. When you have a properly designed database, you can use "join" statements to retrieve the data you want.
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Saving selected data from textbox to db

    Duplicate post: http://www.daniweb.com/software-development/vbnet/threads/476114/fetch-data-from-2-table-of-access-database
  • Member Avatar for cgeier
    cgeier

    Began Watching Saving selected data from textbox to db

    Hi I have a form in vb.net that contains textbox as ID, Name, Age, Sex, Hb, BG. in database access i have 2 tables as Table1 and Table2. The Table1 …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Saving selected data from textbox to db

    We don't write your code for you. If you want to hire someone to write your code for you, there are other sites for that.
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Saving selected data from textbox to db

    I don't know your data, but you should probably use 3 tables: **Table 1:** * ID: primary key * Name * Age * Sex If one ID in Table 1 …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Refreshing data when using a datareader

    Here is the table creation code. It is in "SQLExpress.vb" which is in "Files.zip". I will put it here in case the file becomes unavailable. **Connection String (same as above):** …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Refreshing data when using a datareader

    Here's some of the code I used. The database structure is slightly different from what you currently have. I use the following table names: * Team * TeamMember * Schedule …
  • Member Avatar for cgeier
    cgeier

    Began Watching Refreshing data when using a datareader

    Hi, I am new to VB.NET and am working on what is pretty much my first app. The app is based on a sql data source (created within Visual Studio) …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Refreshing data when using a datareader

    If you should decide to place your labels onto a panel, you will need to reference each label by it's parent. To do so, you need to first find it's …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Refreshing data when using a datareader

    I believe that your issue is that you are creating a label for each person, but never attempt to remove them before updating the data. So if a person's shift …
  • Member Avatar for cgeier
    cgeier

    Began Watching Open .Txt File in DGV with OpenFileDialog

    Hey everyone, Heres my problem. I have 2 forms. Form 1 contains a menu strip and data grid view Form 2 Contains a Button and a bunch of other controls …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Open .Txt File in DGV with OpenFileDialog

    I haven't tried this, but [this post](http://carllbrown.blogspot.co.uk/2007/09/populate-dataset-from-csv-delimited_18.html) shows how you can read a csv file into a dataset. Once you have a dataset you should be able to set DataGridView.Datasource …
  • Member Avatar for cgeier
    cgeier

    Began Watching Hailstone Sequence

    Hey, so I have an assignment for java using the hailstone sequence. My teacher wants us to print out the length of the longest sequence and the number for that. …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Hailstone Sequence

    How many sequences are you supposed to prompt for? You probably need a while loop. You could probably use two Vectors or ArrayLists. One holds the longest list of numbers …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in How to get the most recently selected item in a listbox?

    Tough crowd. The Console.WriteLine statements were for debugging. I left them in so that one could verify the results. They should be removed when finished debugging. Here is an updated …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Trouble Procedurally Changing Textbox Settings

    I think that Reverend Jim has identified the problem--controls being on a panel. Try something like the following: Let's create a sub to rename our controls: Private Sub renameControl(ByRef myCtrl …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in How to get the most recently selected item in a listbox?

    I re-worked the above code to create a version that allows you to specify if you want the last "Selected" item, the last "De-selected" item, or last item that was …
  • Member Avatar for cgeier
    cgeier

    Began Watching How to get the most recently selected item in a listbox?

    I have a multiselection listbox. I want to see the last selected item (which the user just selected). I can't find any way to do this googling.. Thanks in advance.
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in How to get the most recently selected item in a listbox?

    Here's a solution. Version 2 code has been tested. Create a new class called "ItemInfo". Replace with the following code: **ItemInfo:** public class ItemInfo { public string Name { get; …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Trouble Procedurally Changing Textbox Settings

    To help with debugging, you can print out all of the control names on your form using the following sub: Private Sub printControls(ByVal ctrlParent As Control) Dim ctrl As Control …
  • Member Avatar for cgeier
    cgeier

    Began Watching Swing panels inside classes.

    I cannot for the life of me get my GUI to comeup with my deckPanel displayed along with my JButton that I intented to add an Action Listener to. THanks …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Swing panels inside classes.

    Two errors. **Error #1:** **OrderCalc** In line 10, you declare "decks". private deckPanel decks; In line 47, you attempt to use "decks": add(decks, BorderLayout.NORTH); However, you haven't created a new …
  • Member Avatar for cgeier
    cgeier

    Began Watching Java application program to help determine students' grade

    I am having a problem completing my program. I am sure it is a simple mistake. My results look something like this How many students do you have? 2 How …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Java application program to help determine students' grade

    Hint: Use the following for loops: If want to print out the average score and letter grade for each student before prompting for the scores from the next student, you …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Java application program to help determine students' grade

    Please review the following documentation: [For-each loop](http://docs.oracle.com/javase/1.5.0/docs/guide/language/foreach.html) *"...When you see the colon (:) read it as “in.” "* Applied to one of your loops: `for(int bigTemp: studentsArray){ ` The loop …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Looping error

    What seems to be the issue? [Sentintel value](http://en.wikipedia.org/wiki/Sentinel_value)
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Trouble Procedurally Changing Textbox Settings

    Please post the code that you are now using. A screen shot would also be helpful. I've implemented some checking to see if the control exists (a possible issue that …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in can i use BindingNavigator to go through database tables

    If you change your database as in my previous post, all of the data from all the tables you currently have will be in one table (Weather). You could even …

The End.