In the software I am developing for my A-level computing coursework I want to add a function to export the database (to backup, use in other computers, etc) and later on a function to import databases (that I had previously exported using this function). At the moment I have a SaveFileDialog, and I have filtered .mdb files only (as this is the type of files supported by my application). But How do I select what is going to be saved? (How do I point to the .mdb file that is located in the program's directory?)
I am pulling information out of my Access Database and reading to a webpage. I need to add a update, delete, and email function to this page. I am trying to do this with the selection of a check box and buttons for each one. But I am unable to get the delete to do anything but redirect back to the orignal page. For the update I want to be able to pull the info in text boxes and just change the info and click update and it gets changed. I also want to be able to pull their email from the database and put it into a text box to be able to email right from the page. Code for show page and delete page below.
I need to execute a stored function in oracle or sql through vb.net. I created a command object. Depending on the database type(oracle or SQL) i am preparing the Command text as Select functionName(?,?,?,?,?,?,?,?) from dual; (For Oracle) Adding the parameter values of the function. Now performing the ExecuteScalar which is not working saying invalid parameter. This works with ODBC connection string. But ODBC doesn't with 64bit. My Requirement: Code should execute a user defined stored procedure by taking the values at runtime.
i want to know how to export sql server 2005 database to access through vb.net coding..no need to select n insert table one by one,just save package...
I have a project am about to start and I want to used vb.net 2008.
I have an access database with some messed up data for example instead of firstname, Lastname field the person who create the database used fullname for the name filed. The good thing about this is the clerk types the names with a space.
I want to create a program that find the first name insert it into a new table.firstname and last name and put it into a table.lname using a loop all at once.
I am writing a chat program and im adding a transfer file function but Ive hit i bit of a snag..The way my program knows its a file coming and not a regular text message is i added a 3-6 bytes prefix depending on what is being sent.
[Code]...
Ive tried the copyto method but since my file byte array is empty it throws an exception. If i wasn't clear with something let me know and i will try to explain better.
In using the IDisposable Interface, the two subroutines are displayed in my code from Microsoft when coded. How do I do the same with an Interface that I write? Is it possible or is this a feature that only Microsoft can do? I am using Visual Studio 2005!
I'm using Visual Basic Express 2008 (VB.NEt). I've created a project which connect to a Microsoft Access Database (OLEDB) & displays the records using textboxes in the windows app.
I need to add a button which exports the database to a fixed length text file. Does anyone know the code I would use to do this?
I'm fairly new to learning visual basic. I'm trying to create a program that dynamically generates a EXE file that performs mouse movements and keystrokes. To dynamically generate EXE files, I am using the CODEDOM API for Visual Basic.
I have an XML file and I have a function to which this XML is passed as string. I have loaded this string in Xmldocument and I need to insert few children nodes under one node. This function returns the modified XML string. I want that whenever this function is called, new child nodes are added, currently, It adds child nodes once.Do I need to overwrite the XML file ? If so, How can I replace the node with new node ( with new child nodes added) so that It has child nodes added before the function is called again ?
My code looks something like this:
Dim doc As New XmlDocument doc.LoadXml(applicationXml) Dim parentNode As XmlNode = doc.GetElementsByTagName("prList").Item(0)
I have a function that converts a .csv file to a datatable. One of the columns I am converting is is a field of names that have a comma in them i.e. "Doe, John" when converting the function treats this as 2 seperate fields because of the comma. I need the datatable to hold this as one field Doe, John in the datatable.
Function CSV2DataTable(ByVal filename As String, ByVal sepChar As String) As DataTable Dim reader As System.IO.StreamReader Dim table As New DataTable Dim colAdded As Boolean = False
i have search for tutorials but none seems to work for me.This is my app code Public Class Form1 Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
[Code]...
As you see, "button2" renames files to backup, and "button3" renames them back to original name.How can i make dir (C:Program FilesRockstar GamesGTA San Andreas) a variable?And maybe when app starts it lets user to select their program path (browse function) then it will but their selected path to variable, and i can use this variable in my code as path?
In the exam paper, student have to check the checkboxes [usercontrol does not work] whether the question is correct or wrong.Now as I have hundreds of questions, I cannot write the same code again and again with the IF conditions, is there anyway to make it a function or something then call it whenever is needed.As well as I wanted the marks to be added when a student submits the paper.
I am looping through all folders on the computer in a background worker. Starting with just the C: drive, the function works perfectly I've been tasked with adding recursiveness to this function to loop through all subfolders within each and every folder.
This is the working code without recursive. Startpath is set = "c:".
Private Sub BackgroundWorker1_DoWork(ByVal sender As Object, ByVal e As System.ComponentModel.DoWorkEventArgs) Handles BackgroundWorker1.DoWork Dim fs As New FileSystemObject Dim fsfolder As Folder Dim subfolder As Folder
[Code]...
EDIT: I was doing some testing and threw in an if check to skip the C:$ folders. Working ok so far and noticed something really strange. It doesn't loop through all the folders in the C: drive. I think it will loop through only the first 2 folders. One is C:Boot so I skip that and the other is C:Dev-cpp. It won't loop through the Program Files, Program Files (x86), or Users.
I'm using Visual Basic Express 2008 (VB.NEt). I've created a project which connects to a Microsoft Access Database (OLEDB) & displays the records using textboxes in the windows app.
I need to add a button which exports the database to a fixed length text file. Does anyone know the code I would use to do this?
I'd like to export a table from Access to a text file (or a spreadsheet) using VB code in Excel 02. I'm using the transfertext command but my code runs through without actually doing anything or throwing up any errors. If I swap the code round and change Export to Import and move the data into the text file manually then the code will happily import the table into Access.
Sub Export() dbfile = "C:XLSMDBTable.mdb" Dim a As Object Set a = CreateObject("access.application")
I have two Access database, say database One.mdb and Two.mdb. I want to use VB2005 to export tblCustomer from One.mdb to Two.mdb, and replace the existing tblCustomer in Two.mdb, during run time. I basically want to simulate the export function that is available in MS Access (which can export one table from one Access database to another) with VB2005 during run time. I can think of a way by querying the table to a dataset and then delete everything on the other database before filling the table in that database with the dataset
I have been able to export data from a query to the xlsx file..howerver those fields which are currency in my sql server 2005 table are currency are showing up in the spreadsheet as text. The column mappings are correct when I look at it in connection manager.
Also Is there also a way to create a new worksheet each time the export is run or does the file have to be already named?
I am looking for the simplest way to push a new row to a database by inserting one record and then retrieving the Primary Key generated by inserting that row.
I know there are several ways this can be done but I can't seem to get any of them to work yet.
I have made a form that has three labels and textboxs and two buttons. The labels arelblPersonID, lblFirstName and lblLastname. The textboxs are txbPersoonID, txbFirstName and txbLastName. The two buttons are btnSave and btnQuit with "End" in htis button. I have also made a database "MyFriends" with a table that has PersonId, FirstName and LastName.
I want to be able to type into my textboxs and have that information saved as a neww row.