|
Hello,
For a project of mine, I need a database. I installed SQL server 7, and created the database in it.
Now I need to acces the database in my application. I quickly decided that it would be best if I used a class to represent the database in my application. My knowledge about programming a database ends here...
My program is written in C++ (and a part of it uses MFC). The application is a NT Service and needs to be connected to the database.
I would like to know wich classes I should use to create my own database interface (class that handles the connection and such with the actual database). I would like a general approach so that it is easy to build support for other databases as well.
Thanks in advande.
Multiply it by infinity and take it beyond eternity and you'll still have no idea about what I'm talking about.
|
|
|
|
|
|
Thanks alot, this is just what I need.
Multiply it by infinity and take it beyond eternity and you'll still have no idea about what I'm talking about.
|
|
|
|
|
Hi, i usually create a script file in SQL query analyzer to create database, create table... in SQL server. But now I have design my database in SQL server using wizard (interface). I would like to know, how could I convert my structure of my database in to a script file that could be use in SQL query analyser? if it is possible it is very easy for me to distribute my database via a diskette.
A thousand mile of journey, begin with the first step.
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
In the Enterprise Manager navigate to your database. Then right click the database entry in the tree on the left and select All Tasks-->Generate SQL Script...
Follow the wizard to ensure that all the elements you want to script are output.
Do you want to know more?
Not getting the response you want from a question asked in an online forum: How to Ask Questions the Smart Way!
|
|
|
|
|
Thank you very much, I will try it latter.
A thousand mile of journey, begin with the first step.
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
hai i am working a project where i have to get a excel format on my VC++ dialog based application from the database by a click of a button. please help in this
|
|
|
|
|
hi,
Please be little more specific.
**************************
S r e e j i t h N a i r
**************************
|
|
|
|
|
hai nair, let me explain ,that what i want to do . I have a dialog based application which has to get data from the database in an excel format by a click event . which is similar to the datagrid Active X control where we can ADD , DELETE and UPDATE the record .
My project is related to a call center where they have a shift roster , in this the key is the shift time , So I have to get data from the database in a excel format , for a particular shift time the number agents working and there area of stay , the shift roster that is the [ Date working and leaves details]
|
|
|
|
|
Hi,
I have a database which is being developed as the application which uses it is and so is being changed very regularley. How can I copy the database into another location on the server to back it up?
Dave Banks
|
|
|
|
|
What database?
I imagine you would need to shut the database down temporarily if you want to copy it elsewhere.
store your internet favourites online - www.my-faves.co.uk
|
|
|
|
|
Having made an app with a type-safe dataset. In this set there are two datatables 'Contract' and 'Contract1' which are identical. When I insert a record from the second DataTable with my stored procedure into the database, it results two result-sets 'Table' and 'Table1'. This is correct, but the only not working thing is that I don't get one column ie ContractNummer. This is made read-only in the DataTable. It is filled in the database with a after-insert-trigger and returned from the insert-procedure. Why cannot I get this value? When it comes from the first DataTable 'Contract', it strangeally works fine. Al the names and the amount of names are correct. Can you tell give me a clue? Thanks very much. Here is my code for the TableMapping-section:
DataTableMapping dtm1, dtm2;
dtm1 = oDa.TableMappings.Add("Table", "Contract");
dtm2 = oDa.TableMappings.Add("Table1", "Contract1");
dtm1.ColumnMappings.Add("ContractID", "ContractID");
dtm1.ColumnMappings.Add("Contractnummer", "Contractnummer");
dtm1.ColumnMappings.Add("Titel", "Titel");
dtm1.ColumnMappings.Add("BeginDatum", "BeginDatum");
dtm1.ColumnMappings.Add("EindDatum", "EindDatum");
dtm1.ColumnMappings.Add("BUID", "BUID");
dtm1.ColumnMappings.Add("TyperingID", "TyperingID");
dtm1.ColumnMappings.Add("KlantID", "KlantID");
dtm1.ColumnMappings.Add("Omschrijving", "Omschrijving");
dtm1.ColumnMappings.Add("MantelID", "MantelID");
dtm1.ColumnMappings.Add("PDF", "PDF");
dtm2.ColumnMappings.Add("ContractID", "ContractID");
dtm2.ColumnMappings.Add("Contractnummer", "Contractnummer");
dtm2.ColumnMappings.Add("Titel", "Titel");
dtm2.ColumnMappings.Add("BeginDatum", "BeginDatum");
dtm2.ColumnMappings.Add("EindDatum", "EindDatum");
dtm2.ColumnMappings.Add("BUID", "BUID");
dtm2.ColumnMappings.Add("TyperingID", "TyperingID");
dtm2.ColumnMappings.Add("KlantID", "KlantID");
dtm2.ColumnMappings.Add("Omschrijving", "Omschrijving");
dtm2.ColumnMappings.Add("MantelID", "MantelID");
dtm2.ColumnMappings.Add("PDF", "PDF");
try
{
oDa.Update(oDs);
oTrn.Commit();
}
Dries
|
|
|
|
|
Hi
Is it possible to have information about the delete status (marked as deleted or not) of a dBase record using ADO?
Friedhelm
|
|
|
|
|
I define a default value for my filed in SQL server.
but when i drag and drop thats table on my form, and then generate DataSet from its DataAdapter, its DataSet have not Default Value.
I can define a default value for it in xml schema, but i want do it automatically .
please help . thanks.
|
|
|
|
|
I'm pretty sure you can define default values using table styles.
|
|
|
|
|
i want to define default value in sql server table , without redefining it in dataset.
|
|
|
|
|
I want to change a RowState property of a DataRow from a DataTable manually.
in example , i want to change from "Unchanged" state to "Added" state.
thanks.
|
|
|
|
|
How can I print reports from the .Net Reporting Services?
Can I have a "Print" button there to click on the web form to print out the reports?
|
|
|
|
|
hi,
Please check the reporting articles which is there in codeproject.com. I seen lot of reporting related here in codeproject.com.
**************************
S r e e j i t h N a i r
**************************
|
|
|
|
|
Yes I have checked those articles but then none mentioned bout printing those reports from .Net Reporting Services.
|
|
|
|
|
VistaDB 2.0 (RC3) data engine for .NET is now available for download.
VistaDB is the #1 alternative to Jet/Access, MSDE, Xbase and sometimes
SQL Server, for building small to midsize .NET database applications.
Includes embeddable 1MB engine, managed ADO.NET Provider and VCL components.
Special $129 intro offer expires Sept. 24th (Save $200).
Download Eval: http://www.vistadb.net/evalrequest.asp [^]
(1st post went in the wrong board -- please no extra flames)
Anthony Carrabino
www.vistadb.net
|
|
|
|
|
vistasoftware wrote:
(1st post went in the wrong board -- please no extra flames)
Yeah, some of those lounge regulars are pretty trigger happy with the flamethrower. I have to say you did a good job of correcting it though. Deserves recognition in my book!
Matt Newman
...armed with what? spitballs!? - Zell Miller
|
|
|
|
|
Thanks Matt. That was like having a pit in my stomach
seeing that one lady post those nasty msgs. I don't
blame her because so many people have abused the system
so now we're all hyper-sensitive with advertisements.
The funny thing is we all need each other -- developers
need tools, tool vendors need customers and online forums
need vendors to pay for advertisement.
Sometimes feathers get ruffled
It's ok. It won't happen again.
Anthony Carrabino
www.vistadb.net
|
|
|
|
|
vistasoftware wrote:
That was like having a pit in my stomach
seeing that one lady post those nasty msgs
If you stay a while you'll get used to lauren's... ummm.. "style". Just don't mention Sony laptops.
Do you want to know more?
Not getting the response you want from a question asked in an online forum: How to Ask Questions the Smart Way!
|
|
|
|
|