while accessing a database (*.mdb file) on a multi-client c# program,<br/>do i have to worry about "single write - multi reader" protection<br/>or ADO.NET is taking care of this for me (accessing the file)????

hello :) :) I have a data set i created with some merges, i want to put that dataset into another database that has the same datastruture already, but the table is empty.The following code doesn't give any errors but doesn't put anything into the database, am i missing some code to accomp...

I am trying to load a dataset using the like command, but I have not had success with case sensitivity. My sql statements will always get all matches.Exampleselect * from tablewhere id like '%A%' I cant get it to only get the upper case 'A'. Is there a way to do thisThanks in A...

I have a data table and want to select a value. The database has a string with the value4,4' DDDYes, the value has a single quote in it. How do I use the Select function of DataTable to select this value.It does not look like it's possibletable.Select("Value = '4, 4' DDD'")...

Can Andy or anyone introduce me some good books about ADO, I intend to study ADo after i made an operation to change my gender, this is truthfull, I have nothing to hide even in public like this. I am really sorry if that is an irrelevent...hmm... "confession".<br/>Thanks very much in advance

what is the difference between SQLConnection & OleDbConnection ?

I have a checkbox in the Datagrid header, when i check the checkbox all the rows in my datagrid should be changed to different color. can i achieve this at the client side. After selecting the rows when i click on any button can i retrieve id column of the rows for update or delete action. I will ap...

Hi!I am using MS ACCESS. I retreive data in my SQL statement in my ADO.net. My statement is:Select Group_Name as Group from myTableHowever, I get error saying that Group is a reserved word and cannot be used in the select statment.Is there any way that I can use a reserved word for an alias in my se...

Hello everyone! I have a big problem cos I want to do some things with MSDE and I experience some difficulties...I have some questions, if somebody knows please enlighten me...1. Can I use MSDE in Windows 98, 95, Me? If I can, what are the requirements? Will the MSDE server run properly as in Window...

Hi everybody, I have a problem. A friend and me are doing a contact center program using Datagrids in c#. Well, in the datagrid we have some rows. Each row, when you do a double click shows a new form with the information of the row. Ok, to here it's okey. But if i sort a column doing a click i...

in my Access DB I have some records likeCOP_QCC Minor 5647662_loooo!#@#$$%^&*(+_(*&_long_nameNS1 Self_TestCOP_QCC Minor 5647662_loooo!#@#$$%^&*(+_(*&_long_nameNS1 No_PowerCOP_QCC Minor Device10 NS1 Self_TestI wanna list out all records which are having "5647662_loooo!#@#$$%^&*(+_(*&_long_nameNS1"Whe...

Hi,<br/>How can I enumerate SQL data sources in my domain using C#? I found MS KnowledgeBase article 310107, but I can't get the code to even compile.<br/>Thanks,<br/>Royce

Hi, I am using the GetSchemaTable() method of the C# .NET OleDbDataReader class to read the schema of an Access table. The following columns always have the same wrong values: AllowDBNull = True IsUnique = False IsKey = False IsAutoIncrement = FalseWhy do these schema columns show the opposite valu...

How do you map TimeStamp (SQL Server) to DateTime (.NET) datatype? I ran into the following error:"Could not cast the value in field ts_times4_ to the Type TimestampType. Please check to make sure that the mapping is correct and that your DataProvider supports this Data Type."My table:CREATE TABLE [...

Hi!I have installed Office 2003 and all the PIA are installed in GAC. I checked the GAC, there is a ADODB.dll in C:\WINDOWS\assembly\GAC and version is 7.0.3300.0.However, in my project, when I reference ADO 2.7, it does not pick up the one from GAC instead it referes to a path "D:\InetPub\wwwroot\...

I wonder how navigation is done in the Dataset . for example by using Recordset we could do this by Calling MoveNext() .. and methods like this.<br/>In Dataset class I could not find any thing related to this.<br/>thanks for helps.

Hey guys, how do I:<br/>SELECT AVG(SomeDateTimeColumn) FROM TimeLog WHERE EMPID=12345<br/>Any useful script for lazy me? Thanks in advance.

I'm dealing with an old problem...When i have a datagrid,and use an adapter on it,what is the procedure, to solve this error Concurency Violation:Update command affected...orConcurency Violation: Delete command affected...p.s: (i used) onDataAdapter_RowUpdated() ''' somtin lik...

Does any one know where can i find a list of all ms-access reserved words?<br/>(The words that needs [] in the SQL statements)/<br/>I couldn't find one anywhere.

SUBJECT: Criteria query - Parent's property as select criteria.Hi, I'm trying to issue a SELECT statement via Criteria query, but can't get it working...Basically, I have two classes:Public Class MyChildClass...Public Property MyParent As MyParentClass...End PropertyPublic Property Ch...

Having set up my connection using the database explorer - the drag and drop stuff works fine. But i now need to access that connection to write some code. How is that connection found from say the datasource control. Or is that really a new connection object is generated every time an sql request is...

Hey guys, just downloaded, "NHibernate Query Analyzer", I unpacked it, but now wondering what to do with it. Is there any tutorial for this tool? Or should I resort to SQL Server's SQL Profiler... Thanks.

Hi, I'm not sure if I'm doing my UPDATE's and DELETE's the proper way:Basically, I want to make sure what I updates, or deletes, in fact exists (ie not deleted by another user) before I actually perform the operation:o_session = SetupBISConnection(...)trx = o_session.BeginTransac...

The DistinctCount function in MDX is applied to topmost level of a dimension only, what should I do if I need to applied this to all levels ?

Hi,<br/>i have a table in database sql server<br/>one field from this has a default value,<br/>i create dataadapter and dataset<br/>and create dataentery form(with databinding)<br/>when i make new record<br/>that field dont show default value

I have a .NET application (C#) that uses Access Database as the applications repository.The application loads the data into DataSet and converts it to internal objects. Upon user request the application does the exact opposite: Converts the data into a DataSet and then updates the original .mdb file...

When I set a password to my access db.myCon = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=db.mdb;Password=password");myCon->Open();I get a exception error."The workgroup information file is missing or opened exclusively by another user"..but when I remove it, it open ok. Wh...

Hi to Everybody!<br/>Ive got such problem. I have DataTable and I need to save it in dbf file. I need create .dbf file and then save DtataTables contents there.<br/>Does anyone have any suggestions?

I Use ADOX to create an Access DatabaseInterop::ADOX::CatalogClass* db = new CatalogClass();db->Create(String::Concat(S"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=",dbPath,this->ID,S"\\dbConv.mdb;"));Now I want to close the connection but I don't now how.Help me please!!!...

Hi everyone,I need import a mass o data from excel to SQL, I wrote 2 peace of code that import from Excel and bring it to a dataset, so to send to SQL I did two diferents routine but I'm still not happy with the performance! LookFirstly I Tryied - For Each drow in dt.row call my stored pro...

i want to apply ado to access database. i put following in my stdafx.h#import "c:\Program Files\Common Files\System\ADO\msado15.dll" no_namespace rename("EOF", "adoEOF") but when i compile ,there are some similar errors ,for example ,"error C2011: 'LockTypeEnum' : 'enum' type red...

I've been looking around the net for one of these today, but I see that mysql don't officially support oledb. They do however have a great ODBC driver that works well (with the odbcConnection object).I have tried using microsoft's oledb for odbc driver to enable me to access my data...

this thread explains the difference between access and sql server

I am writing an application using ASP VBScript. However, to utilize the onClick methods of an <img> tag, I have to code the function with javascript (I have tried repeatedly to use client side VBScript as the language for the onClick methods and I get an error saying the function is not defin...

Are there C++ wrapper classes for ADO?I had started working with DAO for my SQL database needs and found (after much searching) that there are a number of C++ classes provided by Mircosoft to make it easier to use. Then, realising that DAO is deprecated (obsolete) I started looking at ADO, but I can...

Hello,I'm new in VB.NET, I'm just wondering if when use the usual way of connecting to database like ADODB.CONNECTION, is this part of ADO.NET? I check the .NET tab in the reference, and I saw ADODB type is .NET so I think if i didn't use the dataadapter, i'm still using the res...

Hi,I have some doughts from the last few days.Please letme know.1) Diffrence between Stored Proceduer and function?2) How to change the datagrid cell color depending upon the data?3) Can I update mutiple rows at a time in a data grid?4) Diffrence between Span and div tag?5) Can I place a text box fo...

Does anyone know how to retrieve and write a BLOB object from an ACCESS database, using ADO? I can do it using DAO though..<br/>ADO is a little bit more involved than I anticipated! lol..<br/>Regards<br/>John

I have the following code to insert a New row in VC++ using ADO (NOT ADO.Net.) DB_STATUS status = SUCCESS; HRESULT hr; CString strForename; CString strSurname; PersonalRecord.GetPersonalDetails(strForename, strSurname); m_strSQLCommand.Format(IDS_STRING_INSERT_NEW_PERSONAL_RECORD, strForename, strS...

Using delete method works from 1 to second last row of a table in dataset. But for last row it is neither showing exception nor deleting it.<br/>Any suggestions or workaround?<br/>I am using vb.net and ado.net 1.1

I have used ADODB for several years and now I have been using VB.NET for a short couple of months. Now I need to learn how to use ADO.NET. Could someone tell me how to use ado.net in relation to adodb? DataSets, DataTables, etc. didnt exist in adodb, only recordsets and command objects. :(Using SQL...

I am having a problem using the DataAdapter.Update methond. I am trying to move data from one database to another using a web service. What I want to do is create a data set on a client, pass the data set to a web service and then insert all rows into a database. I have created a data adapter with i...

Hello all.Hopefully i've just overlooked something...ComboBox's DataSource is set to a DataSet. However, I want to change the index of the comboBox right away which I cannot do. Like so://returns dataset filled with infoDataSet MyDataSet = DataClass.getDataSet(SomeOleDbCommand, "Golf");//T...

Hi,I am executing a query from Vb using ADO / Informix drivers to Informix server.If I am running the same query on informix console I am getting records in a particular oder but If I am executing the same query from VB then the recordset that I am receving is coming in a seperate order than Informi...

HiIs there a quicker and more efficient way of importing data programmatically from a table in database A into a table in database B using a C# windows application?At the moment I open the connection to database A and read the data form the table into a dataReader object. Then I open the connection...

Can you specify user account and password with Reporting Service / URL access?I know you could with Reporting Service Web Service Library:Dim rs As New ReportingService()rs.Credentials = System.Net.CredentialCache.DefaultCredentials'Orrs.Credentials = New System.Net.NetworkCredential(username,...

I just downloaded Enterprise Library Application Blocks from MSDN, the latest version June 2005 ( http://msdn.microsoft.com/practices/GetStarted/default.aspx?pull=/library/en-us/dnpag2/html/entlib.asp). I open the solution for "Data Access Application Block \ Data Design" and tried to compile it:The...

When we use typed datase and untped dataset?<br/>What is the difference between them?<br/>let me know<br/>thank you

Can any one know how to reset identity number of primary key ???Let me explained it to you properly, What i want?I have created one table say employee table.And I have assigned primary key to it.I have inserted some rows into it.say 100 rows.So the last identity number would be 100.What I want to do...

I am using SQLAdapater class -I have Join statement from which the dataset is been filled & i want to get the schema of the table & get information which is columns are primary-key or not, but i am not able to get it. if i use single slect * from table; then fillschema function give me complete info...