Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score partial merge?
eran - 12 May 2007 7:19 PM - 1 message
Hi, I'm using DataTable.Merge() to merge values from a source DT into a destination DT which are in seperate Datasets. The source DT has columns A,B,C and the destination DT has columns A,B,D. column A is primary key for both of them. So, basically, my target is to ...
Score Changing Database Name and Owner (but not Table Name)in a TypedDat
michael - 12 May 2007 1:43 PM - 1 message
I have a TypedDataSet whose source tables live on a SQL Server. The DataTables in the TypedDataSet have lots of customized TableAdapters to execute special SELECTS. Took a lot of work. I have to change the Database name and Owner (schema actually on SQL 2005) ...
Score OleDb and x64
Mark Rae - 11 May 2007 10:50 PM - 1 message
Hi, Since there *appears* to be no 64-bit support for any data source other than SQL Server (and I wouldn't use OleDb to interface with SQL Server anyway as there's a native .NET data provider for that), what is the "accepted wisdom" ...
Score CFront 3.01
Miguel Arenas - 11 May 2007 9:30 PM - 1 message
Do somebody know how to connect to CFront 3.01 from a Windows Mobile, Using Visual Basic .net 2003 ? or a tool data acces to Cfront? ...
Score Query in memory dataset c# 2
deciacco - 11 May 2007 7:46 PM - 5 messages
Is there a way to query an in-memory dataset with sql or can you only work with the individual table through DataTable.Select()? How can you go about getting the identity of a new record if you use an ...
Score How to populate an empty table in DB?
Lubomir - 11 May 2007 5:14 PM - 2 messages
Hi, I am wondering how I could populate the ampty table in the database from the DataSet or DataTable. So far I am using SqlBulkCopy. Is there any other way, or is it I should be using? I could make Insert row by row, but it is slow, I guess. ...
Score SQLCLR
Lubomir - 11 May 2007 3:27 PM - 1 message
Hi, I have a stored procedure, for example like the following: Public static void MyProc() { using ( SqlConnection conn = new SqlConnection(“Context connection = true”)) {        String  mySql = “…..”     SqlCommand cmd = new SqlCommand (mySql, conn); ...
Score SQLDataReader.GetOrdinal() fails rarely with IndexOutOfRange
emanuele.falchero - 11 May 2007 7:52 AM - 1 message
Hi everybody, In last month I'm experiencing a very strange problem and I think it's linked to ado.net. My team and I developed a lot of WebApplications and our environment is on .NET 2.0 and Sql Server 2000. (All Service packs have been ...
Score Help, Connection to Access Database
Randy - 11 May 2007 1:15 AM - 2 messages
Hi,all     I met one problem of connecting Access database in asp.net web program.     I use ODBC link to Access, the connection string like "PWD=12345;DSN=QADLinkMDB;DriverId=25;MaxBufferSize=2048;FIL=MS ...
Score TableAdapter not updating table if the table is empty when loaded?
Brooke - 10 May 2007 10:08 PM - 2 messages
I am having problems with the table adapter not updating (inserting a new record) the sql server table if I open the form with out any records already in the sql server table. If I add on record in sql server management studio, the the table adapter ...
Score Ole DB Jet 4.0 Provider corrupts recipient Excel database predicta
Jim Walsh - 10 May 2007 8:45 PM - 4 messages
VS2005 C# 2.0 I'm using ADO.NET and the Jet 4.0 OLE DB provider to append a row to an Excel spreadsheet. I have a data table of type System.Data.DataTable, and a table adapter of ...
Score How do I make lots of changes to a database table using a dataset
HONOREDANCESTOR - 10 May 2007 3:13 PM - 3 messages
Hi, I'd like to take a table in a database and modify some rows and delete some others.  So I created a dataset, and tried to make modifications to one of its tables, and then I tried to send it back to the ...
Score Merge Replication SQL 2000 and SQL Server Compact
JB - 10 May 2007 12:40 PM - 2 messages
I have a desktop application using SQL Server Compact Edition and I want to use merge replication with an SQL Server 2000 database (SP4). I have installed all the necessary things (sqlcesa30.dll is available via IIS and displays the message: "Microsoft SQL Server Compact ...
Score SELECTing only the first n records from a database
Nathan Sokalski - 10 May 2007 1:00 AM - 6 messages
I want to select only the first n records from a database using VB.NET. I have declared a DataTable and OleDB.OleDbDataAdapter as follows: Dim linkstable As New DataTable Dim linksadapter As New OleDb.OleDbDataAdapter("SELECT * FROM worldnews ORDER BY updated", ...
Score Concurrency control in updating Access records?
pedestrian - 9 May 2007 10:06 PM - 4 messages
I'm using OleDbDataAdapter to update records to the Access database. Refer to the "Introduction to Data Concurrency in ADO.NET" topic in MSDN: "The Saving-All-Values Approach" section ms-help://MS.MSDNQTR.v80.en/MS.MSDN.v80/MS.VisualStudio.v80. ...
Score data-access approach
Ofer - 9 May 2007 1:27 PM - 1 message
Hi, Your opinion is welcome on choosing a DAL strategy for our .Net web project. We want a single unified DAL approach, but which one? Our new modules (40% of the code) use the DAL created by the XSD designer ...
Score SQL Server Stored Procedure Try Catch and ADO.Net exception handli
Phil Sharp - 9 May 2007 9:29 AM - 5 messages
Hi We have recently moved onto SQL 2005  and our DBA wants us to use Try Catch within our stored procedures. If I have an SP such as: CREATE PROCEDURE NoTry AS BEGIN INSERT INTO MyTable(Id, Description) VALUES (3, 'Toodles'); ...
Score ReadXML Dataset - Original Rows, RowState = Added (not Unchanged)
kkam99504 - 9 May 2007 3:29 AM - 2 messages
I realize the original quesiton was dealt with but this appeared to be the most appropriate thread to post my question under.  Here is my senario:   1)  Connect to DB   2)  Fill DataSet with tables, set Relationships, Constraints ...
Score How to get Column Description from SQL Server
Aamir Mahmood - 8 May 2007 10:04 PM - 2 messages
Hi, Can I get the column's description in my code, for each columns in the table. 'Column description' is set at the table design time. Thanks. - Aamir ...
Score Calling code behind without losing values
Doug - 8 May 2007 4:30 PM - 2 messages
Hi, I'm trying to set up a refresh of some of the data on a page and am using this: <meta http-equiv="refresh" content="120"> This works great with one exception.  I only want to refresh one grid ...
Score Supporting Transactions A La System.Transactions in a custom system
aldousd666 - 8 May 2007 3:29 PM - 3 messages
First of all I apologize that this is a dupe of a post tot he Framework.* mailing list, but this seemed like a more appropriate place for it. I'd like to write an ADO.NET provider for a non-relational data ...
Score TransactionScope - Unable to get error message (6106)
BigLuzer - 8 May 2007 2:46 PM - 2 messages
hi using the new TransactionScope class in .NET 2.0, we occasionally get an "Unable to get error message (6106) message" returned from .net, after (it seems) 60 seconds. we are connecting to Oracle 9.2.0.5 database, with the same version ...
Score DefaultValue not set in columns of Data.DataTable VS2005
Charles Waudby - 8 May 2007 2:24 PM - 1 message
I use a stored procedure to retrieve data from a SQL Server 2000 dB using Data.SqlClient.SqlDataAdapter to fill a DataTable. In SQL several columns of the table have default values but the DefaultValue of each DataColumn is always System.dbNull (which causes a problem with the InsertCommand). ...
Score populating a varchar2 field with .net
Damian - 8 May 2007 10:39 AM - 2 messages
I am trying to populate a varchar2(1) field in an oracle database by createing a varcharparam in .net - but the field is never getting updated. The values I am sending in through the parameter are either "Y" or "N" ...
Score Cannot read file from Client
Johnny - 7 May 2007 9:20 PM - 2 messages
Hi all: I have an ASP.NET form that reads an Excel file and populates a datagrid. If I load the form in IE on the server, and select a local file, the code works fine. However if I load the form in IE from a client ...
Score What's the purpose of "0=1" clause in the Update Command?
pedestrian - 7 May 2007 11:36 AM - 3 messages
I use SqlCommandBuilder to auto-generate update commands (INSERT, UPDATE, DELETE) before calling data adapter's Update method. I view the Sql statement using SQL Server Profiler tool. The following is the update statement: exec sp_executesql N'UPDATE [tblEmployee] SET [FirstName] = @p1 ...
Score 'INSERT INTO' in Access
EmilH - 7 May 2007 8:14 AM - 13 messages
Hi. I wrote the code to insert a new record into an Access database. I get no errors. However a new record is not inserted. Any ideas? Please help. Thanks.Emil. ...
Score I am trying to use Multiple Column Dropdownlist for Access
Scott Starker - 6 May 2007 7:05 PM - 1 message
This is a newbie question. I am using "Multiple Column Dropdownlist for the ASP.NET DataGrid" by Jayarajan S Kulaindevelu ([link]) with an Access database but without the DataGrid. I have been using ...
Score failed to open a rowset !!!!
Butmah - 6 May 2007 2:10 PM - 3 messages
dear ... I'm using crystal reports 8.5 with vb.net ... and my problem is that when a larg number of parameters passed to the report, using this code :    Private Sub ReportsViewer2_Load(ByVal sender As System.Object, ByVal e As ...
Score vbnet Checkbox true or false
Scotty - 6 May 2007 10:41 AM - 2 messages
Hi How to databanding checkbox in windowsform code below does not work Me.txtFax.DataBindings.Add("text", bsAdressen, "Fax")   'Works fine Me.txtEmail.DataBindings.Add("text", bsAdressen, "Email") 'Works fine Me.chkKlant.DataBindings.Add("Checked", bsAdressen, "Klant") 'does not work ...
Next »