Hi, I have a DataGridView connected to a Database. It is filled like this: Me.KeywordsTableAdapter.Fill(Me.DbDataSet1.keywords) I can see all the data inside DataGridView. Now I can select something and if I press on DELETE (Keyboard) the entries are gone (AllowUserToDeleteRows = true), but they are still in the Database (mdb file) ...
Has anyone found a way to make the ADO.NET Entity Framework work with OLE DB or ODBC data sources? Specifically, I need to work with an Access database that for various reasons can't be upsized to SQL. This MSDN page says: The .NET Framework includes ADO.NET providers for direct access to Microsoft SQL Server (including Entity Frame...
I would be grateful if you can estimate (based on your experience/knowledge) the typical size of the main database of: A SaaS web site A Web2.0 web site Of course this varies by application type, architecture & user-base, but any average estimation would be very helpful. Thanks! ...
Hello, I don't know if this can be done in C#/.NET 2.0 but I want to be able to add a sql call to a method and build the properties based off the call. So, it would be something like this: QueryResult result = QueryDataTable.Query("SELECT ...", "DataConnection"); int someVar = result.SomeTableId; So, above the SomeTableId property wo...
I have a question on best practice for relational databases and hierarchies. My question is, is it more sane to use text or int (id) based hierarchies? I have a hierarchy, but it is not an id based one. The hierarchy is based on text e.g. 'level1', 'level2' as opposed to id1, id2 I use mysql and also solr for managing my data. At the ...
Hi all first .. sorry 4 my english :) i am web developer and using wordpress as framework for any Customized CMS i want build if i want to make a video Cms for example and want to make keys for videos instead of ID'S each video is post has ID , and Customfield ( "vkey" => "1A2B3C" ) each post will have the customfield ( "vkey" ) so...
Possible Duplicate: Storing Images in DB - Yea or Nay? Which approach is better? What are the advantages and disadvantages? Advantages of storing images in database, in my opinion, are: database integrity (it's easier to keep all database entries valid with foreign keys than to keep an eye on filesystem and make required ch...
What meaning does the concept of a primary key have to the database engine of SQL Server? I don't mean the clustered/nonclustered index created on the "ID" column, i mean the constraint object "primary key". Does it matter if it exists or not? Alternatives: alter table add primary key clustered alter table create clustered index Doe...
i've got a mysql table column that acts as a counter (int). each time i update that column i want the field value to get plussed with 1. so if it was 45 i want it to be 46. how could i do that with sql? ...
Let's say I have some table T with some non-null field A. There is a clustered index on A. Consider the following two options: I make A the primary key. I create a UNIQUE constraint for A. Where's the difference? I know what a primary key is, and I know that there is a conceptual difference w.r.t. database theory. But what is the act...
I am trying to query a database (SQLServer) with multiple tables of identical structure and with related names i.e. [TABLE 01 $TRANSACTIONS] [TABLE 02 $TRANSACTIONS] ... [TABLE (n) $TRANSACTIONS] I have a query returning the desired records on one table at a time and can manually select multiple tables with SELECT {QUERY01} FROM [TAB...
i use a trigger to insert a row and want to use the last created id for using in the subsequent query. how could i do this? the code looks like: BEGIN IF (NEW.counter >= 100) THEN INSERT INTO tagCategories (name, counter) VALUES ('unnamed', NEW.counter); // here i want to have access to the above inserted id UPDATE tagCategories2tagPa...
i want to check if a table row exist with a trigger. if it does then it does nothing, but if it doesnt exist it inserts a row. here is my current code i want to modify. BEGIN IF (NEW.counter >= 100) THEN // check if a certain row exists in another table, if not, execute the beneath code INSERT INTO tagCategories (name, counter) VALUES ...
I'm using a legacy database schema with composite keys. I have an entity with two relationships and one of the join columns is shared. For example, Let's say i have a Student entity with two relationships Department and Course. Department uses dept_code column while Course uses dept_code and course_code colum. The domain model is such ...
what is the best architecture to connect to a remote mysqlserver (database) from java swing standalone client app over the internet without using middle server ...
I have a ruby on rails app that uses Heroku. I have the need to run things like import/export tasks on our db that lock up the whole system since they are so heavy on the DB. Is there a way to tell the system to only run these tasks when the database is not being used at that second? ...
I want to input data into a sqlite database so that core data can read from the file but I was wandering if there's a way of populating the sqlite data via xcode or do I have to spend lots of money on an sql manager of some kind like RazorSQL to do it? Thanx... ...
I have one table with USERS and another table with RSS FEED URLS. Both are InnoDB type. Each user may be subscribed to any number of the feeds. I'm trying to figure out the best way to keep record of which feeds users are subscribed to. One way is to have a feed_ids varchar column in users table and separate each. Is there a better wa...
Hi Folk, I'm trying to see if exists something to create a sequence with partition logic. I need a sequence number that depend on other primary key ex: id_person sequence id 1 | 1 1 | 2 2 | 1 3 | 1 1 | 3 so the sequence must depend on the id_person partition. Is there something like this on or...
Hello there I have a database that has 2 tables in it, one is the categoryTable and the is the userMenuTable, the categoryTable currently has two columns in it, categoryId and categoryTitle it currently holds 2 rows of data, the categoryId's = 1 and 2 and the categoryTitles = News and Blog, in the the userMenuTable I keep a record of wh...