kindofsudden

I have an existing table in an Access DB that I want my user to be able to copy by pressing a button. When the user presses the button, they should be prompted for what is to be the name of the table. The program should then copy the existing …

I have a combobox that is bound to a DB and works great. However, when the user adds a value to the table to which the combobox is bound, the combobox keeps the old value and adds the current items in the table. In this case the table originally held …

Okay, I'm pulling my hair out. I'm getting NO error on the following code: Dim cmd As New OleDb.OleDbCommand("CREATE TABLE [" + empTableName + "] ([ID] DOUBLE, " & _ "[LnameFname] TEXT(255), " & _ "[Location] TEXT(255), " & _ "[SalaryOld] DOUBLE, " & _ "[FtePercentage] DOUBLE, " & _ …

Seems like this should be simple. I am binding comboboxes successfully to my Access DB. It looks like this: Dim da As New OleDbDataAdapter(asql, con) Dim ds As New DataSet da.Fill(ds) cboEmployeeNumber.ValueMember = "ID" cboEmployeeNumber.DataSource = ds.Tables(0) cboEmployeeNumber.SelectedIndex = 0 Works great. Then I try to bind a text box …

I'm trying to visualize how this will be set up... I need my VB.NET application to read year 2013 values (Year, Employee, and Annual Performance Score) from a CSV file and write them to an Access DB. This DB is linked to my VB.NET project using a dataset. No problem, …

I created a table, created a dataview, and sorted the dataview. I then populated the table with three rows of data and all was good. I then changed one of the fields (Hours) in one of the rows which SHOULD HAVE caused it to re-sort, but it did not re-sort. …

This is probably one of those that is so simple I can't see it. I have a string variable called Market. The variable is user chosen and is the exact same name as one of many tables in my dataset. Basically I am having the user choose which table they …

I have a datagridview bound to a datatable and it works great. However, when I try to programmatically change the datasource property to a different existing table, I get a blank datagridview with no cells. Although I have tried many bits of code to remedy the problem, this is the …

Being somewhat new to VB.NET, I built a data solution by using wizards and drag-and-drop on forms. My data is in an Access DB and I opened up those tables with Server Explorer and dragged them into my dataset. I connected the tables to datagridviews. Worked like a charm. Then …

I have read many articles here, but haven't quite found the solution. I have a SQLEXPRESS database that is used by my VB.NET application. I have packaged and deployed the application via an MSI file and everything works great except I cannot figure out how to include my database file …

I put together a vb.net program that does some string parsing and creates a fixed-width file at the end. When I run it on each of my 2 machines it creates a properly formatted file. When my client downloads the msi file, installs it, and runs it, he gets several …

I am new to dealing with SQL Express DB tables. I have a Windows application that gives the user a textbox that is bound to a value in my dataset (ds) which reflects my SQL table (Specs) field. The user can change the numeric value of the textbox and I …

I have a bound datagridview and a dataset with tables. I have two sets of comboboxes bound to the same field "Restaurant" in the tables (mirroring each other). In the "NewEmployeeRestaurant" combobox I change the value and it reflects in the datagridview. I can shoot around clicking all over the …

Okay, I am 50% toward having this figured out, but there are a couple of concepts that are new to me here and it is throwing me for a loop. I am reading an Excel file into VB.NET. There are 4 columns containing dollar figures of varying amounts. Here is …

This is my very first trigger and I'm not sure I have it set up correctly. I have a table called PayTypes. Here is my trigger syntax: [CODE] ALTER trigger payTypes_trigger on PayTypes AFTER INSERT, UPDATE, DELETE s PRINT 'AFTER TRIGGER EXECUTED SUCESSFULLY' [/CODE] I run this with a breakpoint …

First time poster here... My VB.NET program compacts and repairs my DB, but somewhere in the process unsets the database password. No problem, just reset it through VB, right? Ummm... not sure how to go about that task. So I either need to know how to compact it without losing …