I have a database that I just converted the back end to SQL Server using SSMA. I left the front end in MS Access. I only converted the tables and not the queries. It already had some data in it and that moved over just fine. All was going well until just recently. On opening the database and loading the main form Event Interest it s...
This is code for select user password where id = 1 ; I want to match this value to a text box. If the value is a match then second window form will be open. But it is not working ... OleDbConnection con = new OleDbConnection(database2.conn); con.Open(); OleDbCommand OCom = new OleDbCommand("select user_pasword from tblpasword where id...
I need to get access to some data that is stored in an old DOS format. Specifically using Ashton-Tate's RapidFile format. Does anyone know if there are ADO drivers or any other more "modern" data access technology that will enable me to read the data? ...
I have to insert value from one table to another table which both having two fields first field name is ID and and second field name is Flag. While inserting if the ID value already exists in any of the destination table rows it will insert the new row in source table as same ID and Flag as NEW if the ID value is not matching in any of...
Hey Folks - This is not a technical question, but thought I'd throw it out anyway. I am in need of a rough size of the End-User Database Application market. Specifically, I'm talking about products like Microsoft Access and Filemaker Pro. Does anyone know where I could find such information (preferably without paying $5000 for a ma...
Hi everyone, I have a desktop application that needs to read data from a database, both installed on client computer. That data in database must be encrypted, to deny client access, and protect data. I need to know what kind of database to use that can supports encryption, because the amount of data in some tables will be very huge, I...
Let's say I have the following table with three columns: id | start_block | end_block ----------------------------- 01 | 00000000001 | 00000000005 02 | 00000000006 | 00000000011 03 | 00000000012 | 00000000018 04 | 00000000025 | 00000000031 05 | 00000000032 | 00000000043 Each row was a "Start Block" and an "End Block". If the data was...
Hi There, What is the best way to create databases on C# application, I mean by a click of a button, it will create a database with a different name but the same model? Currently, I script TSQL onto a C# application, so when I click a button, a new database will be created with the name I defined, it works well, however, it is extremel...
Rails has a nice set of filters (before_validation, before_create, after_save, etc) as well as support for observers, but I'm faced with a situation in which relying on a filter or observer is far too computationally expensive. I need an alternative. The problem: I'm logging web server hits to a large number of pages. What I need is a...
I always get stuck on foreign keys so I have a question about where the foreign key should reside in a bug tracking system in which a bug has a single status at any given time while only a small number of statuses exist (Open, Under Investigation, Resolved, Pending Approval). So each status has many bugs associated with it. My assumption...
I have used SQLite.NET many times. It always worked fine but I have a friend that is really pestering me that I should use instead SQL Server Compact so I stayed fully in Microsoft environment. Now, I never worked with Compact, and he tells me it works fine for him, but seeing that .MDF extension gives me the creeps. No kidding. Last th...
I've got a project where I'm attempting to use SQLite via System.Data.SQLite. In my attempts to keep the database under version-control, I went ahead and created a Database Project in my VS2008. Sounds fine, right? I created my first table create script and tried to run it using right-click->Run on the script and I get this error messa...
One of the main reasons I use Hibernate is that it provides the flexibility to switch to another database without having to rewrite any code. But until now I did not figure out a good way to define additional views on the tables to which my hibernate entities are matched; I am still using simple SQL scripts for that. Is there a more el...
Hi everyone, I am wondering if it's possible to add data to a DataTable through a DataGridView and save the data in the DataTable by serializing it--and all of this without having to create an underlying database. One DataTable is sufficient for the amount of data I am trying to store and a database is definitely overkill. Thanks! ...
I'm being given a data source weekly that I'm going to parse and put into a database. The data will not change much from week to week, but I should be updating the database on a regular basis. Besides this weekly update, the data is static. For now rebuilding the entire database isn't a problem, but eventually this database will be li...
If I have two tables - Logins and Users, as follows: Logins LoginIdNo UserIdNo HashedPassword Users UserIdNo LoginIdNo Username Each login "has a user" and each user "has a login" but which "belongs to" which? Is it simply a judgment call or is there a clearcut formula for determining where the foreign key should reside? ...
I have a small application in which i have 9 different forms, and every form have a least 40+ fields where the user must enter some data. I have written each form in a single php file and made a master PHP file where i only add the form in the middle of the page. My question is: I don't want to write 9 different function for each form...
Assumed infinite storage where size/volume/physics (metrics,gigabytes/terrabytes) won't matter only the number of elements and their labels, statistically pattern should emerge already at 30 subsets, but can you agree that less than 1000 subsets is too little to test, and at least 10000 distinct subsets / "elements", "entries" / entities...
Our client need to encrypt the MOSS content database so the content db should not be able to view by DBA or unauthorized people without the right encryption key. Seem the Transparent Data Encryption (TDE) in SQL Server 2008 cannot protect the sensitive information from DBA cause TDE is designed to protect data 'at rest'. Does anyone her...
I need to log all post and get requests on web site in the database. There will be two tables: requests with time stamp, user id and requested URI request parameters with name, value and request id I will use it only for analytical reports once per month. No regular usage of this data. I have about one million requests a day and th...