Sign up to connect with kRod and gain access to their complete profile
  • Member Avatar
    kRod

    Began Watching Format a textbox to display currency during input

    Is it possible to make a textbox format inputted text into currency form (with comma separators and two decimal places) during input? I have tried formatting currencies from textbox input …
  • Member Avatar
    kRod

    Replied To a Post in Format a textbox to display currency during input

    give thisread [Click Here](http://www.codeproject.com/Tips/311959/Format-a-textbox-for-currency-input-VB-NET)
  • Member Avatar
    kRod

    Replied To a Post in Import CSV file to Datagridview readonly START and END

    This is the structure of a CSV File yours loads into a datagrid but the info is all lumped together EXTENSION,DESCRIPTION,EXECUTABLE_PATH .001,None,C:\Program Files\7-Zip\7z.exe .323,H.323 Internet Telephony,rundll32.exe .386,Virtual device driver,NO DEFAULT …
  • Member Avatar
    kRod

    Replied To a Post in Import CSV file to Datagridview readonly START and END

    Please post some of your CSV file. We do n ot know what your column names are or what your data looks like.
  • Member Avatar
    kRod

    Replied To a Post in Import CSV file to Datagridview readonly START and END

    As for your wanting rows 98 - 156 use the following. cnt is an integer variable: cnt = objDataset.Tables(0).Rows.Count - 1 For i As Integer = cnt To 0 Step …
  • Member Avatar
    kRod

    Replied To a Post in Import CSV file to Datagridview readonly START and END

    Where line of code caused "No value given for one or more required parameters. i got this error sir" error?
  • Member Avatar
    kRod

    Replied To a Post in Can't delete record from database

    Does your DataAdapter have an Update Command Query Set? Also remove ` BindingSource1.ResetBindings(False)` Does your ACCESS table have a Primary Key?
  • Member Avatar
    kRod

    Replied To a Post in Database issue with updating the Table [Data]

    Ok the Select Case was a demo so you could create your queries by which checkbox was checked. You really need to study up on your ADO.Net. I'm not trying …
  • Member Avatar
    kRod

    Began Watching Import CSV file to Datagridview readonly START and END

    I would like to do is to read CSV file begin to display to datagridview. show all the rows in the CSV but only the columns between START and END. …
  • Member Avatar
    kRod

    Replied To a Post in Import CSV file to Datagridview readonly START and END

    If your CSV File has headers you can Just get the columns you want by the SELECT Query. Dim objCmdSelect As New OleDbCommand("SELECT Col1,Col2,col3... FROM " & fi.Name, objConn)
  • Member Avatar
    kRod

    Replied To a Post in Database issue with updating the Table [Data]

    Your query for the selected person from the ListBox should be like **SELECT Field1, Field2, Field3... FROM [TableName] WHERE Last_First_Name = 'selectedName';**
  • Member Avatar
    kRod

    Replied To a Post in Database issue with updating the Table [Data]

    Use the following to create your queries based on the CheckBoxes Checked State Select Case True Case CheckBox1.Checked And CheckBox2.Checked MsgBox("Both CheckBoxes Are Checked") Case CheckBox1.Checked MsgBox("CheckBox 1 Checked") Case …
  • Member Avatar
    kRod

    Began Watching Can't delete record from database

    Hi, im developing a software in vb 2012 with a access 2010 local db, but for some reason i canĀ“t remove records from the database. the following code breaks on …
  • Member Avatar
    kRod

    Replied To a Post in Can't delete record from database

    I haven't had a chance to test this but I'm pretty sure you can ->Instead of deleting your record from the datatable. ` Me.TransmissoesDataSet.Tables("utilizador_Avancado").Rows(itemFound).Delete()` Remove the item from the BindingSource …
  • Member Avatar
    kRod

    Marked Solved Status for Intersect

    I have a question about the string.intersect method. I am not getting the results I expect. Dim lstChars1() As Char = "hello dolly" 'TextBox1.Text.ToCharArray Dim lstchars2() As Char = "help …
  • Member Avatar
    kRod

    Replied To a Post in Intersect

    Very True Minimalist I just tested my code and it didn't matter they just have to be distinct
  • Member Avatar
    kRod

    Replied To a Post in Intersect

    Yes I understand that it returns the matching elements. I went to the MSDN and read that it only returns Distinct elements that match so that is probably why the …
  • Member Avatar
    kRod

    Replied To a Post in Database issue with updating the Table [Data]

    You will need to decide which fields you'll be needing from your sql server datatable. then you can create the commands, connection, dataadapter, and dataset.Then you can use the field …
  • Member Avatar
    kRod

    Created Intersect

    I have a question about the string.intersect method. I am not getting the results I expect. Dim lstChars1() As Char = "hello dolly" 'TextBox1.Text.ToCharArray Dim lstchars2() As Char = "help …
  • Member Avatar
    kRod

    Began Watching Intersect

    I have a question about the string.intersect method. I am not getting the results I expect. Dim lstChars1() As Char = "hello dolly" 'TextBox1.Text.ToCharArray Dim lstchars2() As Char = "help …
  • Member Avatar
    kRod

    Began Watching Object reference not set to an instance of an object

    Greetings. I'm having a rough time solving this problem. this is my global dec Dim btns As Button() = New Button() {Button1, Button2} and this is my eventhandler Dim btnName …
  • Member Avatar
    kRod

    Replied To a Post in Object reference not set to an instance of an object

    What exactly are you trying to do? You have an array of Button then you give a variable btnName a type Button without using it. Then you take your button …
  • Member Avatar
    kRod

    Replied To a Post in Compare Strings

    I was a little too hasty with my previous post it should have been: Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Dim lstChars1() As Char = TextBox1.Text.ToCharArray …
  • Member Avatar
    kRod

    Replied To a Post in Database issue with updating the Table [Data]

    I would load the listbox with the names and when the user clicks the name you could execute a query against either the database or a DataSet to get your …
  • Member Avatar
    kRod

    Began Watching Compare Strings

    Hello, i have 2 textbox. and i need to compare those 2 strings to get the number of same letters/characters. Example: Hack Cake Total same letters/characters = 3 [ C.K.A …
  • Member Avatar
    kRod

    Replied To a Post in Compare Strings

    ignnniter, see if this helps you get your head around it. I have a button and two textboxes on a form use the default names in the click event put …
  • Member Avatar
    kRod

    Replied To a Post in Database issue with updating the Table [Data]

    First what are the 2 datasources? it looked from your first images of the data it was all in one table: Second what is supposed to happen when you click …
  • Member Avatar
    kRod

    Replied To a Post in Database issue with updating the Table [Data]

    Start4me; Sorry for the delay in replying... I would have either have a textbox for each type of phone or some checkboxes or radiobuttons to determine which phone you'd want …
  • Member Avatar
    kRod

    Began Watching Change Data Grid Column header alignment to center?

    How could I change the column header of the Data Grid to center or right but not left as default? [Pls pay attention, We are talking 'bout Data Grid here, …
  • Member Avatar
    kRod

    Replied To a Post in Change Data Grid Column header alignment to center?

    Probably shouldn't help dredge up this post but it was never actually answered in VB so here goes. Intellisense will give you 10 choices of how you want to Align …

The End.