Is there a sample C# winform application (a starter kit or something ) which use the Northwind 2007 Acess Database version ?
some concept like http://northwind.codeplex.com/ ?
If I recall correctly, there where at least to desktop programas from sun which were very useful for handling mysql databases...
Now, all I can find is some mysql workbench which is only useful for designing data...
Both programs I'm talking about allowed you to manage servers, create database, create tables, index, perform querys, edit data, etc...
unfortunately I don't even recall there names...
Any idea where I can find them?
thanks a lot
I have a database containing multiple tables (Person, Parents, etc)
Person table has certain attributes particularly ssn, countryofbirth and currentcountry.
Parents table has ssn, and fathersbirthcountry
I'm trying to output the SSNs of all people who have the same countryofbirth as their fathersbirthcountry and also have same currentcountry as fathersbirthcountry.
SELECT Person.ssn
FROM Person, Parents
WHERE fathersbirthcountry = countryofbirth
AND currentcountry = fathersbirthcountry;
the above doesn't seem to be working, could anyone please help me out?
Hello.
I've heard much good about nodejs and writting client-server application with it. But I can't get, for example, when developing IM client-server application, how nodejs server script is supposed to talk to database server to actually store it's data? Or may be I miss something and nodejs server scripts are not supposed to do that? If so, please, push me to correct direction.
Ok,
I wanting to database a small library.
I've only had limmited experience with databeses,
and vnone with queerying a websever.
I'm going to want to retrieve information like title, Publisher, maybe author, desciption
the simplest way i can think of dooing this is looking them up via the isbn.
I'm wondering how I should go about doing this.
I've coma across isbndb.com before, but the api for accessing it seems rather complex.
I am building a .NET application that given a connection string, at run time, needs to be able to retrieve information from the corresponding database schema, such as available columns, datatypes, and whether they are nullable.
What is the best way to accomplish this? Has anyone done anything like this before?
Many thanks, Nigel.
Hi,
I am planning to work in TRIE data structure for which I need a dictionary database or a text or word file containing the entire list of english words. It doesnt matter if the size is huge. Larger the better.
I'm building an article system, and each article will have one more Tags associated with it (similar to the Tags on this site).
The tables are set up something like this:
Article_Table
Article_ID | Title | Author_ID | Content | Date_Posted | IP ...
Tag_Table
Tag_ID | Name ...
Tag_Intersect_Table
Tag_ID | Article_ID
Is it possible query an article and all of its associated tags in one database call? If so, how is this done?
I have loaded my database with one table under "Data Connections" in the "Server Explorer" pane.
What is the standard / best-practices way to handle a simple query in a VB ASPX page?
My left <div> would be a set of form elements to filter rows, and when the button is clicked, the main <div> would show the columns I want for the rows returned.
Note: Answers in C# are okay too, I'll just translate.
I am using AMFPHP w/ a Flex application and am needing to start storing the user sessions in the database instead of the filesystem. I've tried utilizing the session save handler function but no matter what I do it still ends up storing the files on the filesystem. Any ideas?
Can anybody explain (or suggest a site or paper) the exact difference between triggers, assertions and checks, and also describe where I should use them?
EDIT: I mean in database, not in any other system or language.
We want to establish some database metadata naming rules in our new project. For example:
tables are named as nouns in a plural
form (courses, books, lessons)
if present, an adjective goes before
a noun in a table name and is separated
by an underscore (red_books,
new_lessons)
table index column is always named
"id"
foreign key names are derived from a
table name with suffix _id (book_id,
red_book_id)
so on
Does someone know any guide like this?
I am planning to make Q&A system (quite specific, has nothing to do with IT)
I was looking for Stackoverflow database map: http://meta.stackoverflow.com/questions/2677/anatomy-of-a-data-dump/2678#2678
And I am thinking is not it is better practice to make separate table for questions titles. With "firstPostId".
Instead of
|- PostTypeId
| - 1: Question
| - 2: Answer
So I want to know, why stackoverflow did not use separate table for questions title. Is it "Do not optimize yet" or does it have any logic behind it?
I have two firebird databases running on the same server and I want to write to a table on one of the databases from a trigger on the other database when certain actions occur. I have had a search and cannot find out if this is possible.
Can it be done either natively in firebird or via a UDF?
Thanks
Neil
Hi,
I need to create XML file, given a table/view in the Database. The actual requirement would be: The code has to get the table/view name as input parameter, read the schema of the same, create a corresponding XML file with the same structure as that of the table/view, and load the XML with the data of the table/view. Language preferred here is JSP. Kindly let me know how to go about this idea.
Thanks in advance,
Geetha
I have 2 identical databases. abc15 and abc18. But one of the database has one extra table and I need to find that. I thought the following query should return it, but is it not showing the record that I expect.
select * from information_schema.tables as a
left join information_schema.tables as b
on a.TABLE_SCHEMA=b.TABLE_SCHEMA AND a.TABLE_NAME=b.TABLE_NAME
where a.TABLE_SCHEMA = 'abc15' AND b.TABLE_SCHEMA='abc18' and
b.TABLE_NAME IS NULL
i have inherited a database application from someone else and there are a few tables that dont have any primary keys. I want to add a new column into an already existing table and have it autonumber (starting from 1). how would i go about doing this?
is there some standard about how to graphically represent database schemas? Is UML a defacto standard for this?
Also, is there some free tool that can help me convert an sql file (basically bunch of CREATE TABLE queries) into some nice graph (UML or not UML)?
Hi,
I have an HTML page, and I would like to import data from a database. Will it be possible to do it without using a programing language such as Java, .NET, PHP etc?
thanks
Hello . I have the following problem.
I have an object with some DateTime properties , and a Table in database that I store all that objects , in Sql server I want to store the DateTime properties in some columns of DateTime Datatype, but the format of datetime in sql server is different from the DateTime class in c# and I got an sql exception saying "DateTime cannot be parsed". I know how to solve this by making the format yyyy-MM-dd but is this the proper and best solution to do this?
Hi all,
I have really wired problems here. I am using MS 2008 sql server at the moment. After I did a tail-log backup, the target database is automatically restoring and keeping on restoring.
Does anyone know what's the problem?
Thanks,
Ling
how do i backup /restore any kind of databases inside my java application to flate files.Are there any tools framework available to backup database to flat file like CSV, XML,or secure encrypted file,or restore from csv or xml files to databases ,it should be also capable of dumping table vise restore and backup also
Hi all,
I am trying to make a fashion boutique site.
In this site each product (t-shirt,jeans etc) belongs to a collection. Each collection has looks (t-shirt,jean,accessories). A product can belong to one collection and to multiple looks. How should I design the database?