I created a database, an .mdf file.I went into my program a few minutes ago and the database showed that there was 0 records on file.I looked in my project folder and the database and datasets exists but my program does not pull the data.How can I restore the data in my dataset and pull it up in my program again?
View 3 Replies
In VB3, I could open an Access file, select the table, specify the index and read a record in just that many lines. [code] If the customer's phone number was stored in Access as Phone, once the seek command was implemented, it was available as HeaderTb(Phone)In this example, OE was short for Order Entry, and the database contained the header files for all orders.I worked through the oft-cited tutorial to pick up the basics for database control, but it provides a means for the user to look over and work with records.But what if my application was more of a relational database? How do I instruct VB10 to access a record by its key and how do I use the data it comes back with?
View 9 RepliesIs there a way to see if the form needs to be saved? I would like to do something like this:
msg = "Save Changes?" ' Define message.
style = MsgBoxStyle.DefaultButton2 Or _
MsgBoxStyle.Critical Or MsgBoxStyle.YesNo
[Code]....
The CurrentItemChanged starts firing before the form is even fully displayed.
In VB.NET 2005, when you entered a closing bracket in your code, the corresponding bracket on the other side became bold so that if you had lots of brackets you could easily see where the corresponding opening bracket was for a closing bracket (and vice versa).I found this feature great, but it seems to have been removed in 2008. Why? Is there any way to get it back?
View 4 RepliesI have an object, say Order where if an error occurs, it raises the ErrorOccurred event. If I'm running some code in say, the codebehind for a .aspx page with an public Order registered as WithEvents and I want to check to see if an error has occurred before I run more code, how do I do this? I can't simply check theOrder.ErrorOccurred. Do I have to create a local boolean flag that switches over in the event handler (OnErrorOccurred)?
Example:
Public WithEvents theOrder As New Order
Public Sub DoStuff()
theOrder.DoSomething()
If theOrder.ErrorOccurred Then
[code]....
I am trying to import a bunch of excel 2003 files all with A:H columns and they are under the same headings etc. into a table in access 2003 database. This is a module in access im making. Im using a file search to look for every file that begins with Format (which they all do ) to get at all the files in the folder path. is there a more efficient way to do this? somehow select all files in a folder? and import each to the same table in access? The DoCmd.TransferSpreadsheet seeems to take each file path individually so I'm not sure how to get each file name in the folder to import it.
I have this at the moment:
Sub Import()
Dim db As Database
Set db = CurrentDb
[Code].....
I have multiple file upload boxes on a form in my mvc3 application. Request.Files shows 3 files when I put a break point in the below function and look at it.. Problem is other than coding a counter and using a select case I dont see a way to handle saving each file name to the database column it belongs to... Is there away to assign the variable on the fly I guess you could say So that the foreach loop would drop the file in the correct column. Ie handoutFile1, handoutFile2 , handoutFile3, Etc. As it stands the below will overwrite the filename in handoutfile1 every time the loop is gone through. I thought about throwing a counter in the loop and just put a select case on it to assign the db column based on the counter number. Seems like a cheap work around though. [Code]
View 2 RepliesI have a PDA application created with VB 2008. I used SDF files for my database. Within the database i have a table that has the following fields : Lot, Part, Expiration Date, Status. The user completes information on a form ( Lot, Part) and then i have to look up that combination in the table. However, the table has between 75,000 and 100,000 records and takes approx. 6 to 12 seconds to find the correct record, and display the expiration date. This is a huge problem. Is there any way what so ever to make this look up any faster? I need it to be around 1 second or less.
View 4 RepliesI have some exe files that I've uploaded into my database as I don't want them to be publicly accessible. I tried using a link button and a generic handler to serve the file using the following code:
Context.Response.Clear()
Context.Response.ContentType = "application/exe"
Context.Response.AppendHeader("Content-Disposition", "filename=program.exe")
Context.Response.BinaryWrite(binaryfile)
The problem: Google Chrome does not treat the download as any other exe, instead after downloading it reports "program.exe is not commonly downloaded and could be dangerous." with a "discard" button and the option to "keep" the download is hidden under a context menu.
serve exe files stored in the database?
i am to create a database filled with pdf files and its stored into binary. i was able to convert each file into binary but the problem is dat now i cant display it in the viewer..i remember that i used to do it on a pic through:[code]
View 2 RepliesI'm developing one application that consists in input data (byte mode) into database and then retrieve it. Okay, I've already done that. However, how d'hell now I execute the files that I retrieved?[code]...
View 1 Repliesim having trouble retrieving pdf files from a database and displaying them on a web form i am able to upload it from a dialog but cant retrieve from a access database. below is code that i have written to retrieve and display the pdf . it runs but doesnt display the pdf in the windows form nor does it give any errors .
Dim picture As Byte()
Dim count As Integer
Try
[Code]....
I have created a login form that asks the user for the username and password fr authentication.Inspite of storing the username and the password in a database,can we store the same in a xml file and retrieve the data at the authentication time from the xml file?Is there any advantage/disadvantage of using the xml file in this particular case rather than using a database to store the username and the password?
View 10 RepliesI am writting an application that stores data in an Access database. I can't put the files in the Program Files directory since standard users can't write to that folder. I can't use a 'user' folder since multiple users will need to access the same file. In addition to accessing the file, users on occassion will copy new versions of the file into the folder, overwritting the old file.Where should I put this file? I am thinking the ProgramData folder, but when I create that folder during the install, it is also read-only for a standard user.I'm lost as to where I should put a file that can be accessed by multiple users, that is read/write, and I can install the folder into the location. I don't think I have a programmatic way of installing a file into the Public users folder.
View 1 RepliesI am working on a very simple program for someone and because it's been so long since i've programmed, I'm looking for an answer as to the best way to do the following.
My program consists of tracking incident reports and each report needs to have the data entered as well as the "paper form" linked to it that shows the members signature. I have everything completed on the program but how to get my file to link with the incident. I am using Access for my database and have been looking everywhere online on how to attachment documents within Access using the Attachment Datatype. So my question is.....
Should i find a way to import the file to Access, and if so, how do i do this, or should i just send the file path to Access as a text field, and then hyperlink the file when it is displayed on the report? I've never done anything like this and was just looking for some pointers.
I use this code to create dump files of my database.Now what I want, if possible, is to encrypt it so that when it is viewed in notepad or anything similar, average users cannot read it.
Code
Call isDirectoryExist()
Call createDbBackupName()
Dim myProcess As Process = New Process
Dim strUser As String = "superadmin"
[Code]...
I have seen a few .NET apps use .db files. I am not new to Visual Basic, however I have never created a VB app that uses databases. I do know PHP pretty well, and working with databases in PHP I am familiar with.
[Code]...
i'm Uploading files to my pc waht i want is to know how to save tha path of the files to my database and use the path to download the files
View 4 RepliesI barely know VB at all, but I managed to build an application with it, to import some text files into a database. So my problem that is left is that I need to install the application on the server and setup the scheduled task. I have the setup project built, but I can't figure out how to publish it so I can put it onto a CD. I am working in Visual Studio 2005.
View 1 RepliesMy files are being inserted but the byte array is showing as a 0x0000... etc for every file after the first inserted file. The first inserted image is correct. The database is set up as an Image type. The problem exists in the code here\
Dim uploads As HttpFileCollection
uploads = HttpContext.Current.Request.Files
For i As Integer = 0 To (uploads.Count - 1)
[code].....
How it works is the user registers their details on one form which will append those details to the end of the 2 text files that are holding the data.At the moment this hasn't been implemented so we're just doing this manually.Anyway, after that the user can "login" inputting a user name and password into 2 text boxes and the program looks for those details in the text files that they just registered.I want the programme to read this by using "readline" in 2 text files and comparing what they've written in the text box with the corresponding text file and then checking whether those 2 words are on corresponding lines in the different text files, and so ensuring the user has put in the right username and password.
As I have average knowledge of vb.net and reading and writing to text files is new to me, I haven't really been able to debug it properly. But I had one idea to get the program to add an integer value at the beginning of each line and then get the program just to read the first character of each line and check if that was the same. But then I realised It ended up not having anything to do with the text boxes and I didn't know how to compare line by line anyway so It was pretty much pointless, but I'll include it in the code anyway.
I am currently trying to make an overview of certain files in a database. To make it easy to use I decided to use a tabcontrol so the user doesn't haveto click other buttons to go too another overview.My question now is, if i have 2 different datasources ( so 2 connections to a different acces database ) and I want to show detailed information about them, on 2 different tabs, using a bindingnavigator to scroll through the records. How do I do this? It's always just one tab working and the other doesn't.
View 4 RepliesMy problem is that i am using a data base and every time i publish my project it keep giving me the error that the path is not correct, how can i over come this problem? how can I make the data base go with the installation files?
View 1 RepliesInitially while login from form1, the application will check login from the database and after login, it again populate values from database to gridview in another form2, and after that i will add values to the database in another form3. And so when again coming to form2, the gridview does not populating the updated values from database. Actually where to place the database files in an application?
View 5 RepliesI have a question about error handling. I have a Try...Catch Error Handling block and with in the Try section I query a database to get a list of files that need to be opened by AutoCAD (using an AutoCAD script file) and a PDF generated of that DWG file. My problem is that sometimes a user has that particular drawing open that it detects to open up and PDF. I use the following code to determine if it is open or not.
[Code]...
Edit by Moderator: use code tags when posting code. Click on this post's quote button to see how.
We are trying to retrieve PDF files stored in a SQL Database. We want to display them on a web page. We are using VB and ASP Code within Visual Studio 2008. We have found snippets of code, but because we are new it does not make sense to us. We are looking for infomation on how to retrieve the PDF from the database and either display directly to a web page, or write the information to a Temporary PDF file we can delete later.
View 1 Replieshow to connect sql server to forms, and also retrieving files from database to txtbox.
View 1 RepliesI wish to save some data but dont want to use database. I have studies that XML files can be used for that. But I have no idea abut XML.
What is the difference between using XML and database?
I am in front of a great dilemma whether to store files in Database or doing it the standard way. I would choose the second option, but my application will be used by multiple users, so I am doing it by Web Services.
On the one hand, storing in database will be very useful as every user would have access to everything very fast, not caring about file paths, locations and so on.
On the other hand, if this table consists of 1000 files, wouldn't it be a bad idea as there should be some performance loss?
At the present moment, I am using mysql as database, but I am thinking of moving to SQL Server, but I suppose this is not DB Issue.
I have a folder on the Server that has a bunch of files such SBSA_UPLO_20101124, SBSA_UPLO_20101125, SBSA_UPLO_20101126. I would like to copy these files from this Server to a remote host Server that is connected to my IBM Universe database. The application must only copy a file that was uploaded 3 days before the current date.
e.g. if the current date is 27/11/2010, it must copy this file SBSA_UPLO_20101124.
SourcePath : \\ntdfkku1\download
Destination Path: cd /disk1/mmhh/PFILES
I am not sure what the best way to start this is
