I am trying to add a datatable to a database. Here's what I've been trying: Dim newDataTable As DataTable = New DataTable("Example") VocabularyDataSet.Tables.Add(newDataTable) SqlDataAdapter1.Fill(VocabularyDataSet.Tables("Example")) I've tried various incarnations of Fill and Update. But the tables will not save on the ...
Hello I am in a very embarrassing situation, I was trying to upgrade to ubuntu 10.04 from ubuntu 9.10 yesterday and while updating I forgot to put my laptop on charger and the battery ran out. Since we know that there is no track back process in linux, all I get now is a blank terminal screen at the start up. Even if I login, I still am ...
Hello Everyone, I have a database with me consisting of certain tables. I have written a query to fetch some fields from a table and stored those fetched values in some variables. Now, I am looking for a way which will allow to assign values fetched from database to the XSL variables. I am trying to generate a HTML page using fetched va...
I wish to save some semantic information about data in a table. How can I save this information in MySQL, such that I can access data and also search for the articles using the semantic data. For example, I have a article about Apple and Microsoft. The semantic data will be like Person : Steve Jobs Person : Steve Ballmer Company : Apple...
At some point, a few days ago, I stumbled across a database frontend for the Stackexchange-2.0 sites. One could get various statistics and write general queries to the database. I've been looking for that site without much success.... Could someone direct me to such a page? Is there a way to compare the different stackexchange-2.0 si...
I'm developing a web site and i would like to use the SQL Server Express as my DB. The Express edition is limited for 4GB per DB. Is it legal to create & use several DB's for the use of a single web site? ...
I'm thinking of starting a facebook style website with bio pages, friend requests etc, roughly what sort of database tables would be advisable? Ie. Users, status? A rough list would help? Thanks ...
I have a homework that I wanna present neatly. ...
I need to selectively (both rows and columns) export around 20 million rows from one table to another. This is what I tried: --Run this in batch: INSERT INTO Table 2 Select A, B from Table1 where A > a and B < b ---Table1 have columns A, B....Z and got around 50 million records. It takes around 12 hours to finish. I don't think syb...
Hi, Currently I am designing a small twitter/facebook kind of system, where in a user should be able to see his friends latest activities. I am using ASP.NET with MySQL database. My Friendships table is as follows: |Friendshipid|friend1|Friend2|confirmed| Friend1 and Friend2 in the above table are userids. User activities table ...
I have a search page that allows the users to filter other users by various categories (age, gender, country, region, ethnicity, etc). The first time the search function is called it gets all the possible values for each category from the database. Just wondering though... Is it better to POST this data back each time the page is re-loa...
Hello folks, There is a project that we need to have a complete list of vehicles made in 2010 and 2011. We need to import that list into our MySQL database for future references. Also, we need to associate each car model's picture(s) with the corresponding entry from the database. Therefore, the list of the cars that we're looking for ha...
Ok, so I'm putting a list of 25 tuples, with each tuple containing 5 items, into an sqlite database. Each time I try the main code to write, I get "apsw.SQLError: SQLError: near "?": syntax error" Here's the code I'm running. Be aware that this is part of a much, much larger server project for a game, so some of the functions will be unk...
It seems like most people use MySQL together with PHP. I've used H2 and Postgres with Java, but I can't really say why, I didn't evaluate any before I started. Does some work best with a specific language? Are there more stable ones that are better at large capacities? ...