-
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 … -
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) -
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 … -
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. -
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 … -
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? -
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? -
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 … -
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. … -
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) -
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';** -
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 … -
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 … -
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 … -
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 … -
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 -
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 … -
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 … -
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 … -
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 … -
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 … -
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 … -
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 … -
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 … -
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 … -
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 … -
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 … -
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 … -
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, … -
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 … -
Began Watching Code word document
HI, I am saving my form to word document. But the result, looks too simple. How do i insert table or insert image or maybe,could change the font style and … -
Replied To a Post in Code word document
The following code shows how to put a table and some other minor things into a word doc. It's part of a database schema app. displaying the table name column … -
Replied To a Post in Directory already exist in the path error
If your problem is solved you should mark it as such. -
Began Watching Database issue with updating the Table [Data]
I'm trying to create a database. After creating the Table [Design], I've went to the Table [Data] to add items to the database, ran the program to check if the … -
Replied To a Post in Database issue with updating the Table [Data]
Can you show some code where your error is happening. From the message it would seem you are trying to execute a query with the connection Closed. -
Began Watching Clearing of Datagrid View
hi everyone my question is how to clear a datagrid view in vb.net 2010 i have tried DatGridView1.Clear() but it only works once and i would like to clear my … -
Replied To a Post in Clearing of Datagrid View
Why not bind the datagridview to a bindingsource. the reset the bindingsource. You will need a datatable or a collection but that should give you what you want. All you … -
Replied To a Post in Directory already exist in the path error
**Quick and dirty demo** Public Class Form1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim filePathAndName As String = SelectFile() If filePathAndName IsNot Nothing Then … -
Began Watching Directory already exist in the path error
Hi Dw I'm trying to copy a chosen file to a directory under 'C:\example' directory folder, I have a textbox to store the address (path) to the selected file, a … -
Replied To a Post in Directory already exist in the path error
You didn't provide the name for the file in the destination My.Computer.FileSystem.CopyFile("C:\Users\coder\Desktop\EXCEL PROJECT\excel\1_2012.xlsx", My.Computer.FileSystem.SpecialDirectories.Desktop & "\TestCopy.xlsx", True) [Click Here](http://msdn.microsoft.com/en-us/library/ms127964(v=vs.110).aspx) -
Began Watching Visual Basic : Data type mismatch in criteria expression.
Hello, I was trying to view all the data from a single from a database after the button "search" is clicked and the output will be inserted into corresponding textboxes … -
Replied To a Post in Visual Basic : Data type mismatch in criteria expression.
Try the following in your code. If it doesn't work take the single quotes from around searchStr it is probably Type integer in the Database Table Dim cmd As New … -
Began Watching reads all lines in text file and be able to edit many lines etc
Public Class Form1 Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click Dim ofd As New OpenFileDialog Dim strFile As String With ofd .Title = "Select a List" .Filter … -
Replied To a Post in reads all lines in text file and be able to edit many lines etc
Why not look for the LastIndexOf("0") [Click Here](http://msdn.microsoft.com/en-us/library/system.string(v=vs.110).aspx) -
Began Watching Combining Worksheets
Seems this wouldnt be too hard, but I'm scratiching my head bald... I have multiple workbooks. They are all housed in the same folder. WBa, WBb, WBc. I need to … -
Replied To a Post in Combining Worksheets
Hello Jimmy_1, Just want to ask a few questions. From each of the worksheets how many Columns are you totaling and Are you Creating a new Worksheet in a new … -
Replied To a Post in Money Only TextBox
Thank You all for your quality responses. I really appreciate the input. I see from the varying code samples this objective can be skinned in a lot of different way. … -
Marked Solved Status for Money Only TextBox
I've been working on a Textbox that only accepts 0-9, Decimal Point, and the Backspace Keys. Also keeps it in the base form 0.00. Max value is 999999.99 can be … -
Created Money Only TextBox
I've been working on a Textbox that only accepts 0-9, Decimal Point, and the Backspace Keys. Also keeps it in the base form 0.00. Max value is 999999.99 can be … -
Began Watching Money Only TextBox
I've been working on a Textbox that only accepts 0-9, Decimal Point, and the Backspace Keys. Also keeps it in the base form 0.00. Max value is 999999.99 can be …
The End.