• Member Avatar for cgeier
    cgeier

    Replied To a Post in Try | Catch question

    Where is your code running? On your computer? Are you trying to update a database on your computer and on the web server?
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in PhD project I need someone to program it for me

    What is the project? What is the PhD in?
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Reload data in Data Grid View

    You can also try something like the following: dgTranslog = New DataGridView() Dim tbColDatePerformed As DataGridViewTextBoxColumn = New DataGridViewTextBoxColumn() tbColDatePerformed.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill tbColDatePerformed.DataPropertyName = Nothing tbColDatePerformed.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter tbColDatePerformed.HeaderText = …
  • Member Avatar for cgeier
    cgeier

    Began Watching Reload data in Data Grid View

    Hi! I am using Data Grid View to display the data from my database. This code works properly. It displays the data. This code is inserted in the Form_Load of …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Reload data in Data Grid View

    Try this: Public Function filterDataSet(ByVal ds As DataSet) As DataView Dim dv As DataView = New DataView() dv = ds.Tables(0).DefaultView dv.RowFilter = "startDate > #1/30/2008# and endDate < #1/30/2010#" Return …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Reload data in Data Grid View

    Search for DataView and DataView.RowFilter
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in C# MultiFilter for DataGridView when TextChanged event is fired

    Above, in "updateFilterDict", change from: whereClause = "WHERE " + kvp.Value; To: whereClause = kvp.Value;
  • Member Avatar for cgeier
    cgeier

    Began Watching C# MultiFilter for DataGridView when TextChanged event is fired

    Hi, I have a DataGridView with a table loaded onto it. I have nine textboxes which will serve as a search feature for the DataGridView. What I want is that …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in C# MultiFilter for DataGridView when TextChanged event is fired

    The following is an easy way to accomplish it. Add the following: Dictionary<string, string> filterDict = new Dictionary<string, string>(); private string whereClause = string.Empty; Then call the following everytime "TextChanged" …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Help with renaming controls in C#

    Change the name using the properties for the control. Right-click the control, and select "Properties". Look for "(Name)". Change the name there.
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Load data in Data Grid View upon form_load

    Use the code from your other post that uses the DataTable. Set the DataTable as the datasource for the DataGridView. A DataSet can hold multiple data tables.
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in iDB2Commands in Visual Studio 2010

    If you aren't updating any data, you can use "ExecuteScalar" or "ExecuteReader". ExecuteScalar returns a single value. It can be used when you only need to get a single column …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Testing/Understanding Code

    How many lines of code? Did you overstate your abilities during your interview? You may find it beneficial to shadow one (or more) of the users of the product--to get …
  • Member Avatar for cgeier
    cgeier

    Began Watching Include An Excel Macro in VB.net Code

    I have created a workbook template that will be used to collect some data from users. I want to restrict user input to numbers between 0 and 20 in each …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Include An Excel Macro in VB.net Code

    [Create, Execute and delete Macro in excel using C#](http://codingsense.wordpress.com/2009/05/11/create-execute-and-delete-macro-in-excel-using-c/) There is also a VB .NET version in the post. **To add Microsoft.Vbe.Interop reference:** * Project * Add Reference * .NET …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Basic if statement question

    In the second example it will skip the rest of the else if statements when it has found a satisfying condition. In your first example every if statement will be …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Controls not updating in specific area in code.

    First of all, your code doesn't compile. You're missing the following: Dim clients As New Hashtable In Server, try the following: Sub Recieved(ByVal Message As String, ByVal Client As ConnectedClient) …
  • Member Avatar for cgeier
    cgeier

    Began Watching Hide excel columns from column K to the right using vb.net

    I have created a workbook using VB.net and I need to Hide all columns to the right of Column K in all worksheets. To hide column K alone I can …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Hide excel columns from column K to the right using vb.net

    The following has been tested in Excel 2010: **Add a reference to Microsoft Excel xx.x Object Library** * Project * Add Reference * COM * Microsoft Excel 14.0 Object Library …
  • Member Avatar for cgeier
    cgeier

    Began Watching Controls not updating in specific area in code.

    Hello, I'm using a modified version of a multiple client TCP server ([View here](http://www.drawbycode.com/blog/?p=218), and trying to have the server add an item to the listbox when a client connects. …
  • Member Avatar for cgeier
    cgeier

    Began Watching get some info from youtube

    is there a way to get info from a youtube video link such as i want to get the title, description, video duration, thumbnail link, and videoid ie.: v=**gJ_3BN0m7S8** just …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in iDB2Commands in Visual Studio 2010

    I made a couple of changes to "ClsDB2", so I'm re-attaching it. Also attached below is the verion in VB .NET. Both are untested. VB .NET version: ModuleDB2.zip C# version: …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in iDB2Commands in Visual Studio 2010

    Below I've attached a C# version of the code so you can see how to do it in C#. The code is untested though, because I don't have a database …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in iDB2Commands in Visual Studio 2010

    Also, when you are searching for information, do a general search rather than searching for info on DB2. You will get more results. Example: DB2: iDB2DataAdapter Try searching for: * …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in iDB2Commands in Visual Studio 2010

    You may find more help if you switch to C#. C# seems to be more popular and more examples seem to be available. See my post [here](http://www.daniweb.com/software-development/csharp/threads/479847/tableadapter-and-unicode) on how to …
  • Member Avatar for cgeier
    cgeier

    Began Watching inserting and reading a Japanese/Chinese script from DB

    Hi, Need an help in reading a column value where there are addresses which holds data in any language, for now, when i try to read the column value i …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in inserting and reading a Japanese/Chinese script from DB

    See the following post: [TableAdapter and Unicode?](http://www.daniweb.com/software-development/csharp/threads/479847/tableadapter-and-unicode)
  • Member Avatar for cgeier
    cgeier

    Began Watching HtmlElement.SetAttribute not working for Password Field

    I have a problem with WebBrowser Control when I try to set attribute for password element. It simply doesn't work. The password field is always empty(setting attribute for txtUName element …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in HtmlElement.SetAttribute not working for Password Field

    First of all, you want to make sure that the DocumentCompleted event is only firing once. [Determine a web page is done loading in WebBrowser (CSWebBrowserLoadComplete)](http://code.msdn.microsoft.com/windowsapps/CSWebBrowserLoadComplete-ae1391fc) *"...In the case of …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in How to find a word in C#

    Yes. You need to have an "electronic" version of a dictionary that contains valid words. This electronic version can be a text file. Additionally, new words are added to dictionaries …
  • Member Avatar for cgeier
    cgeier

    Began Watching iDB2Commands in Visual Studio 2010

    Hi! These are the basic things I know about iDB2Commands to be used in Visual Studio 2010. Could you please help me how could I extract data from DB2? I …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in iDB2Commands in Visual Studio 2010

    See the [other post](http://www.daniweb.com/software-development/vbnet/threads/482957/update-not-working-using-idb2) on how to use parameters. I am not able to test it on DB2, but I believe that the driver follows the same syntax rules as …
  • Member Avatar for cgeier
    cgeier

    Began Watching Update not working using iDB2

    Hi! I have no problem when trying to execute and `insert` or a `delete` SQL Command. However, this `update` command does not seems to work well and I am having …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Update not working using iDB2

    Try the following: Dim param1 As New iDB2Parameter param1.ParameterName = "@username" param1.iDB2DbType = iDB2DbType.iDB2VarChar param1.Value = txtUsername.Text cmdUpdate.Parameters.Add(param1) Dim param2 As New iDB2Parameter param2.ParameterName = "@loginDate" param2.iDB2DbType = iDB2DbType.iDB2Date param2.Value …
  • Member Avatar for cgeier
    cgeier

    Began Watching Changing column from Text to ComboBox in DataGridView using VB

    I had a windows form connected to a SQL database. In the form the data grid view contains 12 columns, all of which are text columns. I want to change …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Changing column from Text to ComboBox in DataGridView using VB

    How did you create the columns? In VS or using code?
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in inserting and reading a Japanese/Chinese script from DB

    What is the data type of the column?
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in How to find a word in C#

    Question 1: How do you know "dog" is a word? Question 2: If you didn't know if "dog" was a word or not, how would you find out?
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Sum values of array

    Use a variable to sum the totals as you add them to listview2. Then after the for loop add a series of '-' (dashes) in each column of a new …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in get some info from youtube

    For duration, you see the following: <meta itemprop="duration" content="PT2M13S"> It appears that “PT” marks the start of the time part of the value. "M" is for minute(s). "S" is for …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in get some info from youtube

    You could use WebClient or HttpWebRequest to get the URL source. Then look for the desired info. **Add the following Imports statements:** * Imports System.IO * Imports System.Net **Version 1** …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Sum values of array

    Here is another version that uses List--just to show another way to do it. **Version 4** (using List)**:** We will use our custom class "CarInfo". **CarInfo.vb** Public Class CarInfo Public …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Sum values of array

    If your teacher asked you to use an array, it is probably better to not use a Dictionary. [Dictionary<TKey, TValue> Class](http://msdn.microsoft.com/en-us/library/xfhwa508(v=vs.110).aspx) Represents a collection of keys and values. It exists …
  • Member Avatar for cgeier
    cgeier

    Began Watching Sum values of array

    Hi guys, I'm having some problems with sum of array values and I hope you can help me out. I have a form from which there are multiple values added …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Sum values of array

    Here are 3 different versions. * Version 1 uses the dictionary above, mentioned by Reverend Jim. * Version 2 uses two arrays. * Version 3 uses an array of a …
  • Member Avatar for cgeier
    cgeier

    Began Watching Send multiple embedded images from outlook using c#

    Following is the code which sends single embedded image very fine from Outlook using c# public void sendEMailThroughOUTLOOK() { try { Outlook.Application oApp = new Outlook.Application(); Outlook.MailItem oMsg = (Outlook.MailItem)oApp.CreateItem(Outlook.OlItemType.olMailItem); …
  • Member Avatar for cgeier
    cgeier

    Replied To a Post in Send multiple embedded images from outlook using c#

    I haven't tested this, but it looks like it might be what you are trying to do: [Programmatically forwarding email message with inline images](http://www.codeproject.com/Articles/21342/Programmatically-forwarding-email-message-with-inl)
  • Member Avatar for cgeier
    cgeier

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

    In my previous post, in the connection string, "Port" should only be in there once.
  • Member Avatar for cgeier
    cgeier

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

    See the post from deceptikon for: [System.Environment.SpecialFolder Enumeration](http://msdn.microsoft.com/en-us/library/system.environment.specialfolder(v=vs.110).aspx) **UserProfile:** *"...The user's profile folder. Applications should not create files or folders at this level; they should put their data under the …
  • Member Avatar for cgeier
    cgeier

    Gave Reputation to arunkumars in Using the UPDATE MySQL Command in C#

    "UPDATE tblUsers SET UserImage = @file" What does @file hold there ? probably it should hold the path i suppose, so the patch is usually like "C:\Desktop......", the best way …

The End.