DB/Reporting :: Searching For More Effective Data Storage For Quick Access?
May 12, 2008
I am quite green to VB .NET and it start occuring to me that I am doing things probably in a very ineffective way.Anyway here is the problem I have datasets, consisting of integers there is set 1 which is of format ID, ID2 - ID here is unique but different ID can refer to same ID2. Before I start reading in the data I have unknown number of these entries (ID and ID2 can be at least as high as 99999999)
Then I have a second data set of format ID2 here is the same as in the set 1 and it can contain several PID entries (all integers). In this set the ID2 is unique and again for one ID2 there can be unknown amount of these PIDs, same PID can occur more than once.
say you have a database that you want to store 100 different recipes in. Out of that 100 recipes 20 have 5 ingredients, 30 have 7 ingredients, 30 have 4 ingredients and 20 have 6 ingredients. So what's the best practice for storing an unknown number of items in a database?
Currently what I am doing in these situations is storing them in a single field in a database separated by a comma. Then when I have to retrieve them I split them by the comma into an array. This doesn't seem right to me but I haven't noticed an impact on speed or efficiency, so what would be the best practice to handle this situation?
I need a simple method for a user to enter as many rows of data as they wish (probably won't exceed 50 in most cases and that's pushing it) and then store that data for retrieving the next time they want to reuse that list. I will also need to read the rows in for manipulating text in a file with those entries.
Would the best method to be to use the DataSet in VB Express 2008 and then use the DataGridView for allowing the display and entry of the data?
I use the following code in vb.net to search across several Access database fields, which works well, is there a way to find out WHICH field had the search data in?
[code] Public Function Incomming_Number(ByVal strNum As String) As String Dim oConnect As New OleDbConnection Dim sql As OleDbCommand
I'm just getting started with Visual Studio (2005), and my aim is to write a fairly simple application in Visual Basic that will need to store some data to disk.What I really want is to be able to send the application to the end users (xp, vista, win7) and have them just be able to use it without having down download all kinds of extras. For example I'm guessing that if I use an SQL database in my application they will need to download SQl server express or some other sql downloadable?
If so is there a similar downloadable for MS Access?I'm just in the 'seeing how things work' stage at the moment and I don't want to waste time going down the SQL track just to find it won't actually work unless my users all download SQL to their machines (which they won't want to do).
my search function is functional however, it does not behave as what i intended it to be. I have a Text box call Text1 and I have a button called cmdSearch. when i click the cmdSearch, the text in Text will search it in my MS access file here is my code:
Code: Private Sub cmdSearch_Click() RS.Open "SELECT * FROM productTB where Pname like '%" & Text1 & "%'", Con
I know how to search for one specific number from a single line in an access database using a query, but now I have to search through a whole database and display each instance. Ex) I search the number "1" in column "1" of the database and it has "2" instances. So now I have to take the corresponding data in the rows next to it in order to display them in the label.
I know how to put the results for "1" line of a database into the .item field, but im confused on how to search multiple lines of a database and store multiple items. Heres what I have so far...
Private Sub btnShowPay_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnShowPay.Click Dim targetid As String
Im working on a program that will display a price when an item number is entered in the search box. I have the information in a text file for the program to find it but am unable. I have successfully made it so the items show up in a list box and will show the price when clicked on, but cant get the other one to work.
Here is my code for searching from a search box:
Option Explicit On Option Strict On Public Class TryonServices
I am developing a VB application using the Visual Studio 2008 IDE. I was making changes to my code using the Quick Replace function when the dialog window stopped displaying. Selection of Quick Find or Quick Replace from the Edit menu, as well as use of shortcut keys (CTL+F and CTL+H) all have the same affect: the IDE loses focus but no dialog windows display. Is this a known issue with an available fix?
I'm working on a VB.Net Windows form that is supposed to manipulate an Access Database. I can Already read data from the database (placing them in a combobox) using the following:
Code: Private Sub Form2a_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load OpenFileDialog1.FileName = "" OpenFileDialog1.Title = "C# Corner Open File Dialog"
I'm trying to remember how to insert data in to a table. Here is my code
Code:
I get the error
Quote:
Number of query values and destination fields are not the same.
I also get some error about the Insert INTO part not being right somewhere. Am I doing this how you would do it, or how would you do something like this?
Using Access I created a few Data Access Pages. These web pages, once opened, work fine to manipulate data as intended, but they keep generating annoying warning messages.There are two messages that pop up every time the web page is accessed. Before the page opens the first message that pops up states: "This website uses a data provider that may be unsafe. If you trust the website, click OK, otherwise click cancel."After pressing OK on the first, the second message pops up and states:"This website is using your identity to access a data source. If you trust the website, click OK, otherwise click cancel."After pressing OK on both messages the page functionality works just fine.I've tried adding password protection to the database and even signing the project with a digital certificate, but I still get the warning messages. This would be fine except there are multiple end users for the access pages and I am trying to avoid the additional confusion this will create, especially since IT has restricted many of the users from editing the internet options.
See our Posting Guidelines for our policy on archived threads.I am confused as to where to place the following code snippet in my code. I put the function above my load event and the same exception still occurs:
An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll
I'm using XP and access 2003 and visual studio 2005. I created a project and connect this project with database access file. and I created some textboxes and command button on the form. Is possible to modify and add a new record to the database without using the navigation toolbar by insert a code in the command button.
I am new convert from VB6 and needs some help developing a stand alone application in VB 2008 that needs access to stored data values.All applications I have developed so far have been for computers that have either SQL Express or Access installed locally on the computer. This has made development really easy since I could use ADO to access and query the data.
The application I am now developing will be installed on a computer that does not have any of the MS office applications and I do not want to install SQL Express on the computer. But I still would like to use an 'ADO type' functionality to access, query and modify the data stored in the system.I started looking into using XML, but I was unable to find much information on querying and modifying individual elements.
I'm trying to convert an old Quick BASIC program to VB.Net. There doesn't appear to be any direct replacement for the old file statements. Building a database seems like overkill for my simple needs.
How can I do the following in VB.Net?
OPEN "test.dat" FOR RANDOM AS #1 LEN = 20 FIELD #1, 10 AS a$, 10 AS b$ LSET a$ = "One" LSET b$ = "Two" PUT #1, 1 GET #1, 1 PRINT a$, b$ CLOSE #1
the access data are not getting reflected on the DataGridView unless the form is reloaded again. I am acessing the MSAcess data for back end processing (SELECT,DELETE)using odbc connection and displayin on .NET form using DataGridVew
I have a problem with transfering data from MSSQL Server 2005 to Access.
I need to make a VBScript that can take out all data from one table in mssql and update one table in Access. The tables exist in both databases and looks the same, but there can be more data in the table from MSSQL Server so i need to update the table in Access with this data.
E.g. I have a table called: SMP_Alert in both database's. So i want to do something like this (dunno if that is possiable):
Set objConMSSQL = CreateObject("ADODB.Connection") conMSSQL = "Provider=SQLNCLI;Server=127.0.0.1SMP;Database=SMP;Uid=SA; Pwd=smp;" objConMSSQL.Open(conMSSQL)
[Code].....
Or do i need to create a recordset of the table (SMP_Alert) from MSSQL, and loop through it to transfer the data into the table in the Access database?
I have an ASP.NET site in a web server and the images are stored in NAS (some kind of lacie external storage), I tried UNC and other things but no success.how can I access images from external storage in ASP.NET
Update: The images are reachable from the server but when I try to access in ASP.NET throws me error.
I have a client who wants his custom-written CRM to be able to access his sales people's emails so that, effectively, a history of email conversations between customer and salesperson is stored inside the CRM's database.
The CRM is written in VB 2008 and the database is SQL Server 2008. The only email these people use, in the shop and on the road, is GMAIL. Each sales person has their own GMAIL address. Thats how they operate.
If they're on the road and respond to a customer's email inquiry about a product, they would like that email conversation to be stored in a table in the database. I think thats the part I cant wrap my head around. How to get access to the email data (knowing the user id and password) and doing so from VB 2008
Update: A free or close to free solution would be preferred.
I am trying to search a datatable using a compound key. I can create the compound key just fine, but when I go to create an object to pass to the find it give me an error. Below is a sample of my code. dim lblDT...etc...
Here is where I create the compound key, and it seems fine. lblDT.PrimaryKey = New DataColumn() { lblDT.Columns("serialno"), _ lblDT.Columns("type")}
This is where I am trying to create an object to pass to the .find dim objSearch As New Object() {10643, 28} It if would work this is how the find would be. Dim row As DataRow = lblDT.Rows.Find(objSearch)
I'm presently creating an application which uses Access2007 as the database. No problem there. But Since most use Excel for data-entry, i've created two tables in access linked to excel source file. Any change in excel will reflect in Access database and subsequently in my Application . Until now my application only reads the database and displays records in DataGridView. These records, i then export to excel along with other formatting for direct printing as a report as I have no idea how to make report. Now i want to add data-entry capability to my app using password-protection user-access. So i can directly add new record to source file. Also need to know if There's any way of eliminating Access from the picture entirely....
I'm opening this discussion up primarily because I felt that it was inappropriate that Samir Ibrahim and I had hijacked another thread by turning it into a collaborative development thread. This thread will also hopefully serve as a searchable reference for those few who actually make an attempt to search the forum for information before posting a question. For reference the original thread I mentioned is [URL]
This thread is meant to be a repository for our continued collaboration on trying to find a way to update the attachment field using the OLEDB class. Samir believes that he is close to cracking the secret code.:)
Attachment retrieval and updating is a fairly trivial task using the Microsoft Access Database Engine. It is also fairly trival to retrieve the attached files using OLEDb as well. The difficulty comes when trying to add or delete an attachment with OLEDB.
The attachment field is actually a record set where each record consists of six fields. One of these fields is the data field that contains the binary file data. According to the documentation, Access will compress certain file. It appears that compression/decompression is handled behind the scenes so to say and what you are present with is sequence of bytes. The data field consists of sequence of header bytes followed by the actual data. The first four bytes define an offset to the start of the data. One thing that we are trying to determine is the meaning of other bytes in the header.
I have uploaded a sample project at: [URL]
This project is by no means a finished product. It is hard code to retrieve the first record from the included Access database.
I'm a junior VB programmer and looking for some advice on this subject. I'm trying to create a chunk of code that will create dynamic storage for variables for use later by dynamic custom controls.
For example: An INI file might have an entry in it that looks something this: .... [var1] <-- this becomes the Storage name description=My Variable type=System.Int32 <-- this could be any valid VB type last_val=456 <-- Other code would save the last value ....
And I want to access the data using a standard "property set" like so after it's created: var1_reference.value = 55 I've tried using a generic class which works ok as long as I declare the variables at design time from within the design environment. But when I try to create them from the INI file it gets messy.
Here's the simple generic class i've constructed to test this: Public Class GenericVar(Of T) ' ' Generic Symbol Class for data storage ' Private VarName As String Private VarType As Type [Code] .....
Also, as each object is created (and they could be different types) I store a reference in an array to make it easier to keep track of, but I'm having a hard time getting access to the objects and their properties, and certainly cant seem to assign an event handler to it once its in an arraylist because the design time code doesn't know what "Type" it is in the arraylist of objects.
I have and application written that works great on XP. It is VB.Net 2008, using .net 3.5. I install and Access database to the program file directory. In Vista, I get an error that is permissions related as even admins don't have default write permissions to the Program Files directory and access creates a .ldb file when in use. To solve this, I have had the users give themselves permission to the folder.
Is that the best solution? If not, where should data be stored in Vista and in Windows 7? Also, I have an update feature of my software that will download updates to the program files folder. Is this out, too?
Whether using XML database for data storage is safe enough? because I wanted to branch using an XML database and then she sends the data to the center. and then the data is in process at the center and then incorporated into the database server
I'm relatively new to the vb.net framework and object oriented programming. After perusing the threads for a few hours I can't quite find an answer so I'm posting this thread. I'm not necessarily looking for code examples. I just want to know if it's possible and where to look next. Basically I'm trying to build a starter application that will help me learn programming. One of the main things I want to do is to be able to dynamically (at run time) create a set of information (data) that can be manipulated via a set of static (and/or dynamic) functions/calculations. The reason I need it to be dynamic is because even though this program is really just for my own fun and perusal on my own machine (and I want it to be able to run without any outside connections (i.e. databases or servers) the data itself is going to be location (i.e.State of residence or even city) specific. Essentially most of the data will be numerical and can be of the integer type. But I'd like to be able to adjust and create new data sets if desired. From everything I've read and researched I haven't found a way to do this (at least now without an excessive amount of coding that is above my expertise). So I want to know if there is a way to do this that is relatively simple.
