Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Can't run aspnet_regsql.exe on remote machine
Amit - 9 Dec 2006 5:32 PM - 5 messages
I cannot run aspnet_regsql.exe on a remote machine.  The remote machine is running  MSSQL 2000 and is behind my local network.  Its basically a sandbox machine. I specify my remote machine's name (Nightcrawler), SQL Server user name and ...
Score i have .net installation problem
gonu - 9 Dec 2006 1:34 PM - 1 message
i have .net installation problem i start the actual install with disk-1 and everything goes fine until a DLL named vdt70vcs.dll is being used/installed A message box pops up asking me to insert "Visual Studio ..NET Professional 2003 - English Disk 1". when i copy all dics to hard ...
Score Finding DataRelation Orphans
KP - 8 Dec 2006 8:22 PM - 7 messages
If I create a Data Relation, is there a way to find the orphans in the child table? I'm creating a relation as follows: oDS.Relations.add("GetRows", dtParent.CustomerID, dtChild.CustomerID, FALSE) I know I have some orphaned rows (by design), and I like to list them out.  ...
Score Error: The transport failed to connect to the server
Nathan Sokalski - 8 Dec 2006 6:06 PM - 5 messages
I am attempting to send an email using ASP.NET 1.1's Mail.SmtpMail.Send() method. My code contains all of the following: Dim mailmsg As New Mail.MailMessage Mail.SmtpMail.SmtpServer = System.Configuration.ConfigurationSettings.AppSettings("smtpserver") mailmsg.BodyFormat = Mail.MailFormat.Text ...
Score I have two questions about the TableAdapter Configuration Wizard
Big Daddy - 8 Dec 2006 4:10 PM - 6 messages
1. I have a table in the database (SQL Server) that I created an adapter for using Visual Studio 2005.  It has select/insert/delete/update methods created, but not using stored procedures, because I check the option that says: ...
Score wendimoore@shaw.ca
Adrian Moore - 8 Dec 2006 1:02 PM - 1 message
Check this out.  The picture doesn't do it justice.  They have them at Costco for $2800 CAD. [link] ...
Score SqlDataReader performance
Jan - 8 Dec 2006 11:36 AM - 17 messages
I've got a rater complex sql query that returns 30+ collums from 4 joined tables. The query performes acceptable in the Query analyzer. dr = cmd.ExecuteReader(); //I retriev my data within a wile loop containing 3 primary sections wile(dr.Rea()) ...
Score Same question, passing params from querydef to querydef.
Edwin Knoppert - 8 Dec 2006 8:40 AM - 1 message
Sorry, lost an earlier topic. I really need this situation solved, it's an access MDB. I want to use a param in a stored querydef like WHERE ID = ? How can i set the ?'s value(s) from another stored querydef?? ...
Score Moving (or Archive ) records to another database (access / Sql Server). best practice ?
nms - 8 Dec 2006 7:21 AM - 3 messages
hello, i'd like to know the best practice for a utility i want to include in my recent project. the requirements is like this, There is a database (access or SQL Server 2005) we use as back-end. now ...
Score DataTable FillSchema Error
Henry Jones - 8 Dec 2006 1:52 AM - 1 message
I put this in the dotnet.languages.vb newsgroup but nobody answered so here goes: VB.NET VS 2005 When I try to fill the Dataset, I issue the following commands: Dim objDA As New SqlDataAdapter(query, objConn) objDA.SelectCommand.CommandTimeout = 0 ...
Score Data Source Code Generation is wrong.
Vernon Peppers - 7 Dec 2006 11:07 PM - 1 message
Every time that I add a data source, or modify it in any way, using the UI, VS seems to automatically enter the code for it.  Every time, it gives me an error.  For example, I have a data set called timeDataSet.  This code shows ...
Score DataTable Type getting lost by Serialization
Harry Keck - 7 Dec 2006 8:10 PM - 5 messages
I have been storing a typed dataset with typed datatables using InProc session successfully.  I recently started trying to use StateServer session, which serializes objects instead of just storing them in memory.  Now, when I retrieve a dataset from the session, the types of all of the ...
Score Cannot write 100MB image data via ADO
Pizzi - 7 Dec 2006 5:14 PM - 3 messages
Hallo I need to write a 100MB image in my Image field via ADO.NET on SQL Server. I get the error "A severe error occurred on the current command". With 80MB it works fine. Does anyone know about a solution ? ...
Score Changing an ordinary column to an identiry column
John Stivenson - 7 Dec 2006 4:27 PM - 5 messages
The primary key of a table was an ordinary int column, but I wanted to change it to an identity column (which would automatically generate its values). I deleted the old column and created new one with same name, this time setting ...
Score SqlDbTypes
KShvats - 7 Dec 2006 12:38 PM - 4 messages
Hey there I have problems creating SqlParameters - 1) Could not find a table with C# counterparts to all SqlDbTypes(e.g. do i use float or double for SqlDbType.Float); 2) How do i find the size of column on the SQL ...
Score TableAdapter Merge issue
usernameexists@googlemail.com - 7 Dec 2006 10:01 AM - 3 messages
I've a DataSet with lots of DataTableAdapters which all work fine, but i'm getting a very strange behavior when merging two unchanged DataSets: pseudo code: MyDataSet ds1 = new MyDataSet(); new MyTableAdapter().Fill(ds1.MyTable); MyDataSet ds2 = new MyDataSet(); ...
Score Default values on new row
Gudni G. Sigurdsson - 7 Dec 2006 7:44 AM - 3 messages
Hi. I have a WinForms app and a SQL Server database.  When the user adds a new row to a table (say table Orders with columns OrderNo and CustNo ), I want to programmatically supply values for CustNo (current user) and OrderNo (number ...
Score Retrieving Sybase Long Binary field value
Peter - 7 Dec 2006 2:14 AM - 1 message
Hi I'm converting a project that was written in VS2003 with .NET Framework 1.1 to VS2005 and .NET Framework 2.0.  The project is built upon a Sybase Adaptive Server Anywhere 8.0.1 database which is accessed via ...
Score Connection pooling questions
crbd98@yahoo.com - 6 Dec 2006 11:19 PM - 18 messages
Hello All, Some time ago, I implemented a data access layer that included a simple connectin pool. At the time, I did it all by  myself: I created N connections, each connection associated with a worker thread that would ...
Score DotNet 2.0 SQLCommandBuilder.DeriveParameters can't find store procedure
greg - 6 Dec 2006 5:35 PM - 2 messages
I have a windows utility that generates .Net procedure call wrappers. Have used for DotNet 1.0 and DotNet 1.1 This code fails at the DeriveParameters call, saying can't find storeprocedure cmd = New SqlCommand(SpName, DirectCast(Connect(), SqlConnection)) ...
Score DataColumn.DateTimeMode property - How to use it?
Tomasz Jastrzebski - 6 Dec 2006 5:27 PM - 3 messages
Hello, Not so long ago I accidentally noticed this new DataColumn.DateTimeMode property. I thought myself: what a cool concept! Perhaps data bound controls can use this setting to automatically perform conversion to/from UTC time when binding/unbinding. However, so far I found no control using this property that way. ...
Score DbCommandBuilder updating read-only columns
Philippe Bertrand - 6 Dec 2006 4:04 PM - 1 message
For example, in our provider we have the rule that primary key columns can not be updated so we mark them as read only in the schema table. So with a table with two primary key columns id, id2 and ConflictOption = ...
Score DbCommandBuilder issues
Philippe Bertrand - 6 Dec 2006 3:01 PM - 3 messages
1. DbCommandBuilder should detect when a column appears twice in the select list and issue an error. For example:    SELECT id, c_bit, c_bit FROM adocmdbld gives    "UPDATE adocmdbld SET c_bit = ?, c_bit = ? WHERE ((id = ?) AND ((? = 1 AND c_bit IS NULL) OR (c_bit = ?)) AND ((? = 1 AND c_bit IS NULL) OR (c_bit ...
Score There must be a better way than this (oledb connections and connection strings)
Matt - 6 Dec 2006 11:28 AM - 9 messages
Hi all, I'm currently writing a windows-forms based application in C# using visual studio express.  It interfaces with an Access Database backend and at the moment, I have a seperate connection for every function (such as a button click) that I use.  This means that at the moment, my ...
Score First child DataRow crashes, subsequent OK
patrourke - 6 Dec 2006 6:22 AM - 1 message
I've only been using .NET for a few months but have read Noyes' Data Binding with Windows Forms 2.0 and a few ADO.NET references as well. I've tried multiple ways of resolving a problem with Master-Details ...
Score Reconnect after Oracle maintenance
n.prabhakar - 6 Dec 2006 5:43 AM - 2 messages
Hi, I am facing a similar problem as described in a much older post <a href="[link]"/>. We are using .NET 1.1 with the MS Oracle ADO.NET driver. After reading the above post, we had disabled Pooling on our application. After that ...
Score Difference between Typed dataset and untyped dataset
tulasikumar - 6 Dec 2006 4:13 AM - 7 messages
hi all, any one tell me what is the difference between typed dataset and untyped dataset? Which situation used typed data set as well which situation used un typed data set? which is the best one in real world scenario as per performance level? ...
Score GetChildRows and add them to new table
mike11d11 - 6 Dec 2006 2:09 AM - 1 message
I'm try to create one table out of two tables based on an inner join. Since I can't run an SQL statement against tables in my dataset I was thinking I could getchildrows and place them in a seperate table and ...
Score c# - How do I use Format on items in combobox
Orr - 5 Dec 2006 8:59 PM - 4 messages
Hi I have a combobox with data source from dataset. I recieve the data in Decimal and I want to present it in Hex. example:     myCmb.DataBindings.Clear();     myCmb.DataSource = myDataset.myDataable;                 myCmb.DisplayMember = "myColumnName"; ...
Score Do I have to call DataSet.AcceptChanges() and commit
Dan V. - 5 Dec 2006 8:13 PM - 2 messages
Do I have to call AcceptChanges() every time I append my data row in the procedure below: FillDataRow  OR  can I just call commit everytime?  thanks. Simplified code below: // ------------------------------------------------ myTrans = vDataAdapter.InsertCommand.Connection.BeginTransaction(IsolationLevel.ReadCo mmitted); ...
Score Warning! Serious design flaw dataset / table adapter designer
Jim Rand - 5 Dec 2006 6:05 PM - 9 messages
VS 2005 provides for dragging tables from a server connection to the dataset designer creating both data tables and related table adapters.  For the most part, the relationships between tables are automatically discovered and rendered on the designer surface. ...
Score Searching on form
Neil Steventon - 5 Dec 2006 3:59 PM - 3 messages
Hi All, I want to be able to trap for the key press "CTRL+F" in any of my textboxes, this will then bring up a form to search the datasource of the open form. Please can someone help, how I would go about this, I cant trap the key ...
Score Using SqlClient.SqlBulkCopy to insert CSV into database table
Rod - 5 Dec 2006 2:42 PM - 8 messages
OK, I'm completely stumped on this one. I'm using SqlClient.SqlBulkCopy to try and bulk copy a csv file into a database.  I am getting the following error after calling the ..WriteToServer method. "The given value of type String from the data source cannot be ...
Score storing and retrieve image
nil - 5 Dec 2006 10:47 AM - 3 messages
hi...can anyone tell me how can i store/retrieve image in the blob column named imgmember of oracle  by vb.net...i am developing one web application in which i need to store the image in the oracle and for ...
Score How to retrieve a attribute from XML?
F=E9rnas_-_Brasil - 5 Dec 2006 10:12 AM - 3 messages
Hey guys, imagine the following XML: <configuracoes>     <tabela nomeXML="aaa" nomeBD="bbb">         <ligacao>             <campoOrigem>ccc</campoOrigem> ...
Score dbexception, sqlexception and sqlstate
bfbfbfbfb - 5 Dec 2006 9:27 AM - 1 message
hi all, there is a way to get the ansi standard code sqlstate from class dbexception ? if I downcast the exception, after the GetType(), to odbcexception I can find it in the errors collection but if my dbexception is of type ...
Score How to determinate the data type
ad - 5 Dec 2006 7:08 AM - 6 messages
How can I determinate the data type of a physical table in SQLServer 2005? ...
Score Changing Data Source Location
Vernon Peppers - 4 Dec 2006 10:58 PM - 7 messages
I am new to .Net and working on my first program.  I have created a Data Source using the Data Source Configuration Wizard, and an Access database.  However, when I distribute this app, I will not have control over where the ...
Score Missing a digit
Gordon - 4 Dec 2006 9:50 PM - 13 messages
Hi When I store a real value to a string variable using the OleDbDataReader like so :     myValStrg = rdr.getValue(2).ToString()   how do I preserve the trailing zero ?    Any other trailing number is preserved. ...
Score How do I delete the result of a Select statement from the original datatable?
Bmack500 - 4 Dec 2006 7:40 PM - 5 messages
Hello, and thanks in advance. I've got a bit of code below, which just iterates through a string array (WSVIP), uses a select statement to fetch an array of datacolums; I would then like to iterate through each found row and delete it from ...
Score DB2 connection
Vicente_García - 4 Dec 2006 7:08 PM - 5 messages
Hi all, I would like to connect my ASP .NET 2.0 site to a DB2 database but I don't know how I could do that and I don't find a correct provider :( For instance if I want to connect my site with Access I do the folling in my code file: ...
Score dataset to table
VEN - 4 Dec 2006 6:29 PM - 2 messages
hello i have two databases , one on firebird, second on mssql and one table is in one and second database and have the same structure. now i read data from firebird table and insert it to dataset. how to insert data from this dataset to second table ? ...
Score DB2 connection with Enterprise Library 2.0 DAAB
ajmastrean - 4 Dec 2006 4:51 PM - 3 messages
Folks, I know the DAAB in EL 2.0 does not have the DB2 connection by default. I did some extensive searching and have not found anything clear cut on whether the EL 1.1 DAAB DB2 connection code can be inserted into the EL ...
Score SQL CLR Function error?
Smokey Grindle - 4 Dec 2006 3:49 PM - 3 messages
What does this mean? Msg 6522, Level 16, State 1, Procedure ValidateCoveragesHaveSameReferenceAndValues, Line 0 A .NET Framework error occurred during execution of user defined routine or aggregate 'ValidateCoveragesHaveSameReferenceAndValues': System.InvalidOperationException: Data access is not allowed in this context. Either the context is a function or method not marked with ...
Score ADO.NET versus T-SQL versus XML
Mike Dunk - 4 Dec 2006 2:56 PM - 4 messages
If dealing in an environment with all SQL database environment, should I use ADO.NET or T-SQL? If in a multidatabase environment, should ADO.NET be used in preference to XML? ...
Score I'm going slightly mad - OleDbCommandBuilder
mik - 4 Dec 2006 12:26 PM - 2 messages
I'm trasferring data (syncronization) from a MDB to another MDB using the OleDbCommandBuilder facilities. sql = "select * from agenti"; ds = new DataSet("Agenti"); db.FillDataSet(sql, ref ds, ref transactionSql); foreach (DataRow row in ds.Tables["Agenti"].Rows) {     sql = "select * from Agenti where ID=" + row["ID"]; ...
Score DataSet.ReadXML and mixed content
mps - 3 Dec 2006 10:56 PM - 3 messages
I can't make DataSet.ReadXML get the contained text of elements with mixed content (It handles everything else fine). Does anyone know how to do this? Pretty much any example of successfully using ReadXML to read mixed content into a DataSet would suffice. ...
Score Best return type for an exception from a library or data layer
Earl - 3 Dec 2006 7:25 PM - 25 messages
I have all of my data operations in a separate library, so I'm looking for what might be termed "best practices" on a return type from those classes. For example, let's say I send an update from the UI layer to a method in a ...
Score can't fetch value in excel table if first 25 rows are empty
André - 3 Dec 2006 3:30 PM - 3 messages
Hi, I don't now whether this is a problem with excel, with oledb provider or asp.net, so i send it to those groups. I created a table in excel with, to simplify, two fields and 30 records. Now i fetch the values from that table with classic commands like: ...
Next »