466 byte By
rireland at 2007-11-23 8:55:49
Hi - I can successfully reference ADOX from my ADO.Net application to create an Access database, and create tables and indexes within that database. I cannot, however, figure out how to use ADOX (or ADO for that matter) to create queries within that database. Can anybody out there give me a m...
what is ADO ?<br/>and what is so special about ADO ?
I have a SPROC that returns like fields that are stored in two seperate tables within the same database. i.e. employee and dependent name, DOB, Social Security etc. <br/>How do I get ASP.NET to recognize more than one returned dataset
hi AllWe have Adapters in .Net which we can use to fill a dataset from a Database .But is there a way by which we can fill a table in DataBase from Dataset?What Actually I am trying to do is that I have got a dataset filled with a table dsTblEmp . Now I have a table dbo.TblNewEmp Into which I want t...
3497 byte By
GT23 at 2007-11-23 9:27:31
I am trying to update the northwind access database firstly listing the records:<%option explicit%><html><head><title>List Database Table</title></head><body><%dim conn,rs,xset conn=Server.CreateObject("ADODB.Connection")conn.provider="Microsoft.Jet.OLEDB...
1054 byte By
qgma58 at 2007-11-23 9:27:55
deleting a row using Dataset seems not working. The following is the code I am using to try to delete a row from a table, but it is not working. No exceptions are throwed. Any idea?Your help is appreciated.const string TBL_NAME = "EmployeeTitles"; SqlConnection sqlconn = new SqlConnection("server=...
1056 byte By
kyaqub at 2007-11-23 9:33:27
Greetings: Well I am using Oracle with ADO.Net in my VB.Net Application & I am making a Client/Server application. The problem that I am facing is that my DB Server has the Unicode Character set & it has Japanese character stores in it as data. My client PC has the Win 2000 Prof. Eng...
Hi,<br/> I read xml file into dataset, but I want to separate the datarelation and bind them into different datagrid, just like master-detail. Does anyone can tell me how to do it?<br/>Thanks,<br/>Vicky
403 byte By
AndyMonk at 2007-11-23 9:41:01
I'm creating an app that generates SQL statements, but I there is the possibility of the need for a table to be joined to itself:SELECT T01.Name, T02.Name FROM [TAB1] AS T01, [TAB2] AS T02 WHERE etc...Why can't I do this? Actually my initial stumbling block is that it seems I'm not...
502 byte By
Bum_Holo at 2007-11-23 9:41:32
Afternoon all,I am new to VB.NET and I need to add, edit and delete records from an access database. In VB6 I used the connection and recordset objects but now that I'm using VB.NET I'm not sure what to use now that there is an oledbconnection, oledbadapter, oledbreader objects etc...Can a...
Hello everybody,I tryed to set some Provider-Specific Connection Parameters for a ADO Connection to "Microsoft.Jet.OLEDB.4.0".Some of the Properties worked but a whole bunch of settings described in the Help-Files isn't accessible.If I try to set them via:Connection.Properties("Jet OLEDB:User C...
Please welcome andy_tacker as the new moderator of this forum!<br/>Brad!
422 byte By
khawari at 2007-11-23 9:49:11
ASP.net ADO.net C#i have a dataset that has a table in it called activities, which is already filled with data.I want to run "select * from activities where (date='today')" and have the result saved in another temporary table.Please provide sample code is C# I will greatly appriciate your...
471 byte By
bdejong at 2007-11-23 9:55:10
I have two identical database files. One os for current data for the past month and the other is for historical data. Each week I want to move data from one database to the historical database.The data base files are identical. Data is spread across several tables and are all linked to the main t...
370 byte By
sam25 at 2007-11-23 9:55:42
Hi,How do i update my existing blob data in my database...For e.g my table has following column :-varchar classname, int idnum, image data.i have my new blob in my Byte[] newdata;how do i update.update mytable set classname = 'newclass', data = ?( newdata)where idnum = searchnum.Thanks,Sam...
I am try to fill the CategoryID and Catergory Name to a dataSet and get the following error message:An unhandled exception of type 'System.InvalidOperationException' occurred in system.data.dllAdditional information: The ConnectionString property has not been initialized.at the line: da.Fi...
195 byte By
yyf at 2007-11-23 10:01:16
when do u need to use BeginEdit & EndEdit? I try to use it in a update situation, but I found that there's no difference if I use it or not. Can anyone tell me?<br/>Thanks in advanced!
58 byte By
yyf at 2007-11-23 10:01:24
Can I use DbTransaction when using DataSet to update data?
I am very green, so hopefully this will be an easy solution.I have two datasets, datatables, and datarows. If I find a matching records in the clean dataset and the temp dataset, I want to increment the field HitCount (ItemArray[4]) in my clean dataset. I am using select to find matching records....
681 byte By
bdejong at 2007-11-23 10:02:48
I have a problem with the following ,I read a cunk of data from one database. I then want to transfer this chunk of data to another database. The read into the dataset goes well and the data is there, but when I try to update it to the other database it does not write any of the records.I believe...
293 byte By
qfang at 2007-11-23 10:05:37
I am using Access XP as my database. In my table, the primary key is autonumber. After I send a insert statement to add a new row into the table, I try to find out the autonumber it generates as primary key. I want to use a select statement. Does anyone know how to write the select statement?
534 byte By
yyf at 2007-11-23 10:10:07
Hi all,I am working on a tool to execute sql files(something like Query Analyzer) using ADO.Net & C#. I try to add a function which can cancel any executing queries. To achieve this, I think I need to use multi-thread. I want to create a thread to execute the sql, meanwhile, if user click the cancel...
846 byte By
yyf at 2007-11-23 10:15:01
HiI am not entirely sure if this is a bug or whether it's a limitation with ADO.Net.1) run a query that requires long time to run on a background thread. eg: select * from users2) Try cancelling the query by doing oledbcommand.cancel() and then abort the thread.I use SQL Server 2000.Here is wha...
450 byte By
yyf at 2007-11-23 10:15:17
I am building 2 classes using C#. Their relationship is 1 ~ n. And each one has the corresponding table in database. for example :CompanyClass & EmployeeClass, table name in Database is Company & EmployeeI think I should use collection to build CompanyClass, but I am not sure how to do it. There...
new thread ( http://www.dev-archive.com/forum/showthread.php?s=&threadid=259561) <br/>Thread has been moved
1059 byte By
DNaama at 2007-11-23 10:23:23
Hello, I want to insert a new record into a table tbl01 which contains a primary key field 'pkField' which is populated automatically by the database (IDENTITY), and another int field - called field2. I add a new row to the DataTable of the DataSet, and call the Update method of the DataAd...
649 byte By
beatrice at 2007-11-23 10:23:34
Hi,Does anyone know how to set the current selection in the DataCombo control?In the Combobox I think there's a SetCurSel method, but this method is not available for the DataCombo control.Please help, I've been trying to figure it out the hole day.I'm using ADO and the binding code i...
I wonder if ADO can attach a DBF on the run, like Acces can attach a DBF.
439 byte By
vgrigor3 at 2007-11-23 10:26:48
I create every day ACCESS file ,by copynig from initial, rename and that write,Every day.but initial file takes size of 210 kilobytes,by the year 60 Megabytes. It is much.How to make smaller initial acces file ?By excluding system tables?(How to do it?)Compressing?By excluding unneed fuctionality?I...
1676 byte By
yyf at 2007-11-23 10:27:37
HELP!!!I am trying to insert a row into an Access table using ADO.Net & C#. But it always give me an exception of "<b>Syntax Error</b>". But I don't understand, I am using the OleDbCommandBuilder to build the sql, why it has syntax error?Please help me, I am almost crazy!!!!Here is...
Hi AllI'm very new to ADO.NET, I want to know how do I connect to a Access 2000 DB that has a password? I have the following codeDim objConnection As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\TEST\test.mdb")Dim objOwnerDA As New OleDb.OleDbDataAdapter("Select *...
1692 byte By
DNaama at 2007-11-23 10:52:19
Hello, my question is regarding relationships between DataTables in a DataSet:I have a DataSet which consists of 3 DataTables: The first DataTable is tblParent, the second is tblChild and the third is tblGrandChild. tblParent has primary key pk1, tblChild is related to tblParent through a field whic...
812 byte By
mrdj1002 at 2007-11-23 10:59:08
Hi guysIts my first time developing db application working on a LAN. Ive been using DAO before for past projects but now I need to develop an application which works on the LAN so I moved to ADO.NET but I dont know how to access the dbs on the server form my application BTW I would better not use S...
786 byte By
mrdj1002 at 2007-11-23 10:59:10
Hi guysIts my first time developing db application working on a LAN. Ive been using DAO before for past projects but now I need to develop an application which works on the LAN so I moved to ADO.NET but I dont know how to access the dbs on the server form my application BTW I would better not use S...
Newbie here ASP.NET in C# (mainly C#)I need to lut users enter link/html/javascript code in a form (editbox), store it in the DB, and show it in a list (show the link text as a clickable item and link to it on a click).I made a test, and in a form I entered the user name and link as (hope this will...
1841 byte By
kyaqub at 2007-11-23 11:01:18
Greetings: Well I am having problem in doing updations through the Dataset. I am using Oracle 9i with ODP.Net provider. Also I am settting the UpdateCommand property of the DataAdapter object manually and not using the CommandBuilder. So when i execute the update method of the Data a...
700 byte By
rajmv at 2007-11-23 11:05:07
hi allI am learning ADO.NET and doing some small applications.right now i am doing a small application in which i am using Dataset.i am able to fill a dataset and displaying the records in a listviewand also i am able to insert some records into the dataset.now the problem is i am not able to update...
561 byte By
mrdj1002 at 2007-11-23 11:07:46
Hi I want to insert some rows form dbSource.table1 into dbTarget.table1, in ADO.Net how should I do this?In DAO I used to do it with such code: dbTarget.Execute "Insert Into table2 Select * From table1 IN '" _+ dbSource.Name + "' Where someField = Something"BTW the 2 dbs are located on ano...
i need to connect to a database(independent of whatever databse it is)<br/>from my C++ program..<br/>it should be done with ADO..<br/>how do i do it?<br/>what are the ADO functions to do this job?
WHEN I USE ADO ,i found first-chance exception ,0xC0000005: Access Violation,what's wrong with it.when i use such command:1:m_pConnection.CreateInstance(_uuidof(Connection));2:m_pRecordset->open(...);m_pRecordset->EndofFile;3:m_pConnection->Execute("select count(*) from table",);m_pRec...
when I use multiple thread to operation database in Client,if the Client is disconnected with the Database server,such as the network's disconnection,so the Client's threads must wait for the exception disappear,how do I realize this function.if I use the reconnect the database in the catc...
_ConnectionPtr m_pConnection; what does the above statement mean..?i have to use the above mentioned in my program to get the data from my database..can some one plzzz explain me on what it actually means...and i've attached the code also with this query!does the attached code really help me in...
327 byte By
iqueen at 2007-11-23 11:37:05
How to retrieve System support "Oledb Provider Name" list. Such as microsoft oledb provider for ms-sql servermicrosoft oledb provider for oraclemicrosoft oledb provider for odbcmicrosoft oledb provider for ......microsoft Jet .......Use what function to list this. thanks....
the following is the ocde to accessa ms database using ADO..the code connects it to the databse..but how to display the output..kindly help me in this regard..#include<stdio.h>#include<stdlib.h>#include<iostream.h>#include "STDAFX.H"//#include "AFX.H"#import "c:\program files\commo...
1117 byte By
DNaama at 2007-11-23 11:38:18
Hello, I have a [Serializable] class, called ds1derived, that derives from DataSet DataSet1, and another [Serializable] class, called ds2derived, that derives from DataSet DataSet2.I want to hold an instance of ds2derived in ds1derived, as a property, and be able to set this property in the client:d...
625 byte By
edwwsw at 2007-11-23 11:41:15
I was woundering if there is an easy way to set column sizes (on a per column basis) for a datagrid that is bound to a dataset? I'm aware of the preferredColumnWidth attribute but that is applied global and does not allow a per column value.I've found references to using the TableStyles[]...
375 byte By
edwwsw at 2007-11-23 11:44:11
I have a new one now. I have a DataGrid and given a selected row, I want to find out which Row in the Dataset that corresponds to. The primary key is not displayed in the datagrid (that would be too easy). Keep in mind that the DataGrid allows sorting on header value so the mapping of display row...
Hi all,<br/>I used SqlConnection to connect to SQL Server database. My server have had some databases. Now I want to list all name of them, but I didn't find any method of SqlConnection can make it. How I can list all database names ? Please help me.<br/>Thank you.
535 byte By
TIS_Guru at 2007-11-23 11:48:13
I'm using Visual C++6 and I want to add a new record in a recordset.I must use the C_Recordset::AddNew(const VARIANT& FieldList, const VARIANT& Values) methodI don't know how to create the arrays to pass to the AddNew method. I saw that I should use SafeArrays but I can't find clear e...
1739 byte By
Sunsam at 2007-11-23 11:49:33
HI All,I am not able to delete a record from the dataset.I get an error when I use deletecommand."DeleteCommand is not supported against a SelectCommand that does not return any key column information."Below is the code for deleting the coomand Private Sub Button1_Click(ByVal sender As System.Objec...