Hi:I am working on routine that takes in a datatable, and add extended properties to each column, by reading an XMLDocument object. The routine is currently doing a dt = source.copy, and then has a for each statement, in which extended properties are added by reading each XML node. I would like to a...

Hi,I'm new to ADO.NET and I have a question about working with Datasets. I'm writing a program with Visual Studio 2003 and SQL Server 2000. For this program I need to visualize and administrate (CRUD-operations) the information about USERS in a Windows Form. In the underlying database , t...

Hello i try to create and add a Table to a DB. Untill the 3rd point everything workes fine, but then the catDest.Tables.Append(newTable);-call returns the error "Type is invalid". All columns of the table have the right type (alas, the adding of the colums to the table works fine), but the type o...

error message: >>> If this dialog has OLE controls:>>> AfxEnableControlContainer has not been called yet.>>> You should call it in your app's InitInstance function.Warning: m_pMainWnd is NULL in CWinApp::Run - quitting application.So I add "AfxEnableControlContainer...

Hello i try to insert data into a table located in a DB on a MS-SQLServer. Unfortunally every time i try a INSERT INTO i get a DB_SEC_E_AUTH_FAILED error. My Connection string: Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=db2;Data Source=HBR;Use Procedure...

I have a problem when updateing a dataSet after some data has been added with an ExecuteNonQuery command form another form...I've added a simplified version of my project. It's made in VS .NET 8 and i've used OleDb to connect to an ACCESS database.The project contains 2 Forms:Form1 th...

Hello all,select * from addprofilei want to display the this table information in datagrid.This table having 11450 records.But i am getting the some error ofter executing this pageERRORServer Application Unavailable The web application you are attempting to access on this web server is currently una...

I develop an application using Visual Studio .NET 2002, Managed C++. My computer, on which runs my problematic application, has 256 MB of RAM.I have a problem with a big memory consumption when I perform loading of data into a DataSet using OleDbDataAdapter.Fill() method. When my application is star...

Hi guys,I'm creating my own ADO class (to make it simple). There's something I want to ask about returning Recordset in Select command...Here's my class :--------#import "C:\Program Files\Common Files\System\ADO\msado15.dll" rename_namespace("ADOCG") rename("EOF", "EndOfFile")using na...

I'm retrieving data from a mdb table and inserting it into a sqlserver table. The tables source and destination tables are identical. The mdb table has a PK that is set to autonum in the mdb and identity=yes in sql server.The tables in the sql server are all empty. I want to simple insert all t...

How can we store and retrive Excel Files in ntext or some other BLOB Column of SQL SERVER Database.<br/>provid some built in class or customaise class or any kind of clues will be appriated pls.Thanks.

wrong question

I need some data from an excel sheet. So readonly is enough. Access to the document happens every now and then in my application. So I keep the conncetion open. So far that runs fine. But if another instance of the application is started, I get an error saying that the file is opened in exclusive mo...

Platform : Windows2000, XP,Microsoft Visual C++ .NET (Version 7.1), MS Access (Office 2003), ADOHi,Through my application I need to create a complete database using a sourcedatabase and copy the data from it.I am achieving this by1) Opening ADO connection to both the source and destination database...

Hi, while iam connecting msacess to asp.net through oledb i am not getting blank page as output.Infact the same code is working well for vb.net but the problem is with asp.net.My code is likePrivate Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click...

Hello,I don't know if I'm now in the right forum. I receive the message in the subject during a call the System.IO.FileNotFoundException in CrystalDecisions.CrystalReport.Engine.ReportDocument.SetDataSource(DataSet..)On my pc the program is working fine, but on a other PC also installed c...

I save datetime into database, the code like:dim thetime as datetime = datetime.now()ds.tables(0).rows(0)("time") = thetime' the code to save dbdim newtime as datetime = ds.tables(0).rows(0)("time") if newtime.CompareTo(thetime) = 0 then' do somethingend ifI thought both datetime would be...

1) We have Oracle 10g r2 in Windows 2000 server.2) We have MS-Visual Studio .NET on windows 2000 serrver & working from application to this Oracle server to which Oracle client is configured.3) We get following errors:An unhandled exception of type 'System.AccessViolationException' occured...

Hi there guys, I'm having major problems trying to distinguish which ASP.Net 2.0 objects to use for data access, whilst avoiding n-tier wizard generated, web-control powered tidal waves of codeFor example, u remember the old ADO 2.x ...C.Open "connection string"RS.ActiveConnection = CRS.Open "S...

Platform : Windows2000,XP, MSVisualStudio6.0, ADO, MSAccess (20003)Hi,In my application I need to create a database with tables on the fly andthen copy data to it from the source database using ADO.For this I createthe destination database, create the table structure in the destinationbased on the s...

1. i have some doubt how to create an event in console based applications which have only modules2.what is the basic usage of having multiple modules?3. what is the need of console based application many of the users prefer to use gui environment like windows based applications then what is the fun...

hi guyshow should I load a database into a Dataset object.when loading from a DataAdapter i should use an SQL command. what if when i want to load all databases and reltions and ... in a Dataset?i want to make a program to load all databases (even without knowing the name of the tables)thx guysEdit/...

Hi,<br/>I want to export a DataGrid into an Excel file. How can I do that? Please, give me a sample code, any helpful link, etc.<br/>Thanks in advance.

I have a windows service routine that reads an XML file and populates a database with new records using a typed dataset. Everything works great while I debug the application although, when I start the service the service doesn't write out new records to the database.I've tried starting the...

Can someone please help with the following problem.I am trying to locate a row in the datatable to delete but am not sure how to go about this. I have decided to use a for loop to iterate through the datatable until a match is found with the entered ID number. However, when the matching ID number...

OleDbConnection* ole = new OleDbConnection( S"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\AEM\\Database\\ProTunerDatabase.mdb" );OleDbDataAdapter* dadapter = new OleDbDataAdapter(); DataSet* dset = new DataSet(); ole->Open();dadapter->SelectCommand = new OleDbCommand(S"select * from t...

Dear members I am trying to insert the date in SQL Server database but the thing inserted is 1900/1/1 12.00 etc.How can i insert the read date in the database.the code is given below.Dim RlDate As DateTime Try RlDate = CType(cmbRLYear.SelectedItem.Text & "/" & cmbRLDay....

Hi there ..when I write this code :adapter1.Fill( dataset1 );the table is loaded Entirly at once.and if the table is huge it takes a lot of time !are there any settings to the Ado.Net objects so that the Loading isnot done entirly at once ?thanks....

I know this must be an easy question to answer but i cant seem to find out how to do it. I am an experienced programmer in delphi but just started to learn .NET. What i am trying to do is: 1 - create a DataTable (Ok, done it) 2 - dynamic bind its columns with some textboxes in the form (Ok, done it)...

Hello everyone, I'm using NET 2.0 developing in C# connecting to a Mysql database with ADO.net (MySQL Connector/Net -- Mysql.data.MySqlClient). I want to use the new TransactionScope methods to control my transactions, but I'm not having much luck. Can anyone tell me why the following code...

hi, im wannt to know what the different bettween sql data reader and sql data adapter

When i run Mdac_typ.exe under Winxp Sp2,it display an error message,say that installtion is not support under the operate system,why?<br/>i open "Program Files\common files\system\ado" directory,find that all the files are very old(created between 1998 to 1999),the version of MSADO?.DLL is 2.1

Hallo guys,I try out to use system.transactions, in which I use the msdn code .but I constantly get error 40: server does not allow remote connection.but I enabled the remote connection. I dont know whats the problem happeningcan anyone help me in running this small sample code?I hereby attach my pr...

I have an xml file with nested nodes - i want to populate a dataset with those rows from the .xml file which have roleid=124use of .xsl or .xslt is not allowed.<?xml version="1.0" encoding="utf-8"?> <reports> <report> <group>Administration</group> <reportname>...

Within the VS editor I used the Server Explorer to create a SQL Server 2000 connection. I then incorporated the connection into the web form by dragging a table. This created a SqlConnection control and a SqlAdapter control within the form. I then clicked on Data menu and selected Generate Dataset....

Select customfieldoptionid from `swcustomfieldoptions` where ((customfieldoptionid in ('5' '518' '33' )) and (customfieldoptionid in (Select customfieldoptionid from `swcustomfieldoptions` where customfieldid in (SELECT customfieldid from `swcustomfields` where title li...

Hi there..<br/>How can I Resort a Table in a Dataset, Ex.. After Adding a New Row ?<br/>Thanks.

Hi,<br/>How can i SELECT all 30 columns except one from a table using SELECT. one way is to write all the 29 columns in SELECT query. is there any other simple way for that.

Hi There..<br/>how to use (Top n) to Select a Max Count of DataRow(s) from a<br/>DataTable in a DataSet ?<br/>Thanks.

Hi...<br/>Any body pls clarify for me the differences between opting for ODBC or ADO or OLE DB!! How one is different from the other??<br/>Thank you.

is there a way to insert values (many rows) from dataset to the dataBase?<br/>thnaks in advanced.

anybody knows how to install a sql server in my remote server.<br/>---<br/> http://www.seopromotionlinks.com/warehouse_management.asp

------------------------Hi I am populating a datagrid using a datatable. The following is a snapshot of my codeDim datatable as new datatable() datatable.select ("select * from tenant where 1=1")At this very point of execution I get the following error. Syntax error: Missing operand after 'hmy&...

Hi Everyone,<br/>I need to know how to get a list of all the databases on a sql server using ado.net.<br/>thanks

Hi there..<br/>if I have a BindingManagerBase object called (bdgMgr), <br/>and a DataRow object called (row) from the bound table<br/>How to set bdgMgr.Position to that row ? especially without iterations.<br/>thanks.

Hello all:Nice to know every,my English is very poor,so I don't speak words completely what I would like say,althrough I can tell many answers,I hope everyone to help me to impove the English,so as to interconnect everyone better.My address is yhw19850401@yahoo.com.cn Hope your letter...

I am trying to figure out how to move a table from MS Access to SQL Server.<br/>Can someone step me through using Visual Studio.

is there any ways to connect microsoft access with ado but the format of the access is in .mde not the normal .mdb file..how do i change this source code so that i can connect to .mde file...if(!m_pADOconnection->CreateDispatch(_T("ADODB.Connection") , e)) throw e; C...

I successfully connected and inserted data from my webservice to MS SQL DB .But my database connection is hard coded .Can i do something with the Configuration file or something to make it dynamic ? Any Suggestions,Thanks !

Hi All,I have a stored procedure to update my DB. The stored proc works fine.I'm using the following code to attempt to update my db. The connection object has connected and so I have a valid connection. At the end when I perform the adapter update, I dont receive any error message, but it does...