kRod

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 (after typing the text or after clicking a button) but is this possible during input (I mean, while you are …

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. This code below is for import all data from csv to datagridview. If OpenFileDialog1.ShowDialog(Me) = DialogResult.OK Then Try Dim fi …

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 line 6. i cant find the problem. the dataset is transmissoes and the the table is utilizador_avancado. can anyone help, …

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 database items show up, they do. Then I stopped debugging, went back to the table to add more information to …

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 so on??.. if you can give links or tutorials..anything that could help me..i would appreciate it so much. Thank you …

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 melanie" 'TextBox2.Text.ToCharArray Dim lst1 As New List(Of String) Dim lst2 As New List(Of String) For Each c In lstChars1 lst1.Add(c.ToString) …

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 As Button = DirectCast(sender, Button) Dim i As Integer btns(i) = New Button For i = 0 To btns.Length Step …

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 ] How can i do that? Thanks! :(

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 OpenFileDialog to enable the user to browse to the file to copy and also a FolderBrowserDialog which let the user …

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, recently I always receive answers for Data Grid View instead :( ] I just want to re-align the header only, …

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 datagrid every time i click the load button hers my code Private Sub Button15_Click(sender As System.Object, e As System.EventArgs) Handles …

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 for future editing. After I entered the ID(1) I get an "OleDbException was unhandled" " Data type mismatch in criteria …

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 = "Text Files|*.txt|All Files|*.*" .ShowDialog() strFile = .FileName End With If System.IO.File.Exists(strFile) = False Then Exit Sub Dim Reader As …

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 combine these, (or at least a Worksheet from each) and have them tally a certain column, which seems easy enough, …

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 set as needed. It works as expected, but I have to ask if I have remade the wheel. This sub …

hy i got a combo box and datagridview in my form and few other controls (to insert new record into my database),after the insertion is succcesful i want the inserted item to be displayed in my combo box and gridview by then only (i.e without restarting the project) could u …

I have earlier created the databases in the sql management studio. but a friend of mine said it would be possible to dreate the tables directly in visual studio and update to the database. I have tried to do it but I can't seem to make the tableadapters etc. because …

I have data already populated in a datagrid I have three textbox txtCustomername, txtPartcode, txtinvo I want the user to be able to input text into the txtcustomername text box which will result in the datagrid only showing the rows that relate to that customer. Then I want the user …

Below is the code I am using: Dim safe10_comp As Integer Dim ref_date As Date Dim dr As DataRow Dim dt As DataTable = New DataTable() Dim da As OleDb.OleDbDataAdapter = New OleDbDataAdapter() Dim Conn As OleDbConnection = New OleDbConnection(System.Configuration.ConfigurationManager.ConnectionStrings("ConnectionString2").ConnectionString) Dim sql As String = "with a as (select t.employee_number, …

hi guys, I got another issue doin my project. Im using Microsoft access as Database. When i need to UPDATE it work and the msgbox displayed: "thank you", but when i looked into the database nothing happened. Anyone can help me to determine the problem? please Thanks in advance. con.Open() …

Hi again............ I'm having problems in saving the data in my datagrid to my Database Imports System.Data.OleDb Public Class Form2 Dim con As New OleDbConnection("provider=Microsoft.ACE.OLEDB.12.0; Data Source=C:\Users\RMC\Documents\Vehicle.accdb;") Dim cmd As OleDbCommand Dim adpt As OleDbDataAdapter Dim cb As OleDbCommandBuilder Dim sql, lol As String Private Sub Form2_Load(ByVal sender As System.Object, …

i just found this code it was really nice, as im just a beginner i can't solve it. when i execute the code the text inside the combobox is not my database but instead a text "System.Data.DataRowView" im really newbie in vb.net im really curious how will this work. thanks …

Private Sub Load_Faculty() Dim con As New OleDbConnection Dim cmd As New OleDbCommand Dim dr As OleDbDataReader Dim arrImage() As Byte Dim myMS As New IO.MemoryStream Dim sSQL As String = String.Empty Try sSQL = "SELECT b.FacultyID, b.Image, b.Course, a.Course" sSQL = sSQL & " FROM studentsrecords as a left …

in sheet1, i have a table like this activities date completed drawing jan.1,2013 painting jan.6,2013 (note:this table is downloaded from web,everytime the value on the web changes,the value in the excel spreadsheet also changes.) then, i have a form . it is composed with a combo box and a textbox. …

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click myconnection = New OleDbConnection("provider=microsoft.ACE.OLEDB.12.0;data source=C:\Users\DELL\Documents\Visual Studio 2012\Projects\WindowsApplication9\WindowsApplication9\NIBM.accdb") myAdapter = New OleDbDataAdapter("select*from Driverdetails", myconnection) myAdapter.Fill(Ds, "Driverdetails") myconnection.Close() DataGridView1.DataSource = Ds DataGridView1.DataMember = "Driverdetails" End Sub

I am trying to figure out if and how it would be possible to implement something like a conditional statement for the excel spreadsheet my program writes to. The spreadsheet is created on the fly each time the program opens up. I would like to place a statement along the …

So I have this assignment for school and I've got the program working, but some minor issues (maybe major issues with cleanilness of code, but working on it). I'm having to make a Guess My Number program and it seems to work, but when I start a new game it …

Dear All I am using Vb.net to update a database running on SQL Server. I am using the following to increase the value of the NextPlan in the SystemControl table in a SQL database. Command.CommandText = "UPDATE SystemControl SET NextPlan = NextPlan + 1" Command.ExecuteNonQuery() Once the Command is executed …

I can open word, replace words, create word documents, but I can find any way of opening a word document and reporting back that a certain word or prase has been found or not. I see there is a function word.find.found but it never seems to report back anything but …

Hello, i need a code to show data from database into textbox i have this request "select count(*) from table" i work with access database andi want show the result in textbox pleaase help