Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score How to increase the width of Crystal report.
sai - 15 Jul 2006 7:07 AM - 1 message
Hi all,               how to increase the width of crystal report of an application. while displaying the columns. thanks in advance, sai.t ...
Score Parameters and CrystalReports.
Kevin Burton - 14 Jul 2006 10:03 PM - 2 messages
I am new to CrystalReports and I just want to use the print functionality. I am currently passing a data set and that works just fine:             Dim rpt As New QuoteDetail ...
Score Command Timeout on Queries
MarkO - 14 Jul 2006 8:23 PM - 2 messages
I'm reading mixed opinions on the effect of a command timeout, and wanted to asked for clarification.  From what I understood (and from what my testing seems to indicate), CommandTimeout affect non-queries executes only.  Therefore if ADO was calling an SP, and the Command object was set to 1 ...
Score Efficient Filling Multiple DataTables
JT - 14 Jul 2006 7:30 PM - 3 messages
Hi all, I am transitioning from ADO.NET 1.1 to 2.0.  One of my 1.1 practices when filling a dataset with several related datatables was to explicitly open the connection, call fill for each dataAdapter involved, ...
Score Polling a database - Performance question
rlrcstr - 14 Jul 2006 6:15 PM - 4 messages
I created a couple of custom performance monitor counters.  Basically I have a service that runs and updates the counter on an interval as often as once per second. So the question is, for performance on the SQL Server and the app itself, so ...
Score Can anyone See where I'm going wrong?
MikeY - 14 Jul 2006 4:56 PM - 6 messages
Hi Everyone, Can anyone see where I'm going wrong? Win [C#] OleDbConnection thisConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\HOST 017.MDB"); thisConnection.Open(); OleDbDataAdapter thisAdapter = new OleDbDataAdapter("SELECT * from TableTemplate", thisConnection); OleDbCommandBuilder thisBuilder = new OleDbCommandBuilder(thisAdapter); ...
Score 2100 sqlparameter
Björn - 14 Jul 2006 2:34 PM - 1 message
Hallo Ich möchte einen bulk insert mittels eines SqlCommands und dazugehörigen SqlParametern machen. Dazu habe ich innerhalb einer for schleife einen Stringbuilder mit insert statements gefüllt. Ebenfalls habe ich innerhalb der forschleife die Sqlparameter erzeugt. ...
Score Ado.Net and Access
Ferdinand Zaubzer - 14 Jul 2006 2:32 PM - 2 messages
Is there any easy way of creating a new Access file and adding a table to this new Access file from within a c# application? Thanks Ferdinand ...
Score DataReader, Update the same reading row ?
Aruna Tennakoon - 14 Jul 2006 9:40 AM - 2 messages
Hi everyone, I have a small problem, I am reading the data using the datareader. and I want to update the same row later using a different connection and a transaction. When I update the same row which is currently loaded to the ...
Score Remote IDbConnections, opening/closing and errors
Chukkalove - 14 Jul 2006 9:27 AM - 4 messages
Hi Im newish with databases so I'd thought I'd ask a general question. Im using a remote MySQL database accessed across the internet with dotnet provider components. The code I've written creates a new connection for each transaction on the ...
Score Dataset to excel
Reggie - 14 Jul 2006 6:57 AM - 2 messages
Hi and TIA!  I have a recordset retrieved into a datgrid in my web app, from an SQL database that I want to save as an excel formatted file.  I would like the user to click a button, get a prompt to save/name the file.  Is ...
Score Dataset to excel
Reggie - 14 Jul 2006 6:56 AM - 4 messages
Hi and TIA!  I have a recordset retrieved into a datgrid in my web app, from an SQL database that I want to save as an excel formatted file.  I would like the user to click a button, get a prompt to save/name the file.  Is ...
Score Help Updating Northwind Syntax Win[C#] OLEDB
MikeY - 14 Jul 2006 6:48 AM - 1 message
Hi Everyone, Even though this is a OLE question, hopefully someone can help me. I'm having problems with my syntax on the updating part for the Northwind.MDB. All other code seems fine. It has to do with the Order Details on the ...
Score Re: Determining field type CHAR vs VARCHAR
Shawn Wildermuth - 13 Jul 2006 11:00 PM - 1 message
As an alternative to being specific to SQL Server, you might want to look at DbDataReader.GetSchemaTable().  It provides a mechanism to get the schema of a SqlDataReader (which might be a good way of getting this data). No way that I know of to get this from a ...
Score Re: SQL Server Authentication versus Windows Authentication
Shawn Wildermuth - 13 Jul 2006 9:26 PM - 3 messages
Its more complicated than that unfortunately.  Using SQL Server authentication has some security implications so it is generally better (IMHO) to use Windows Authentication to SQL Server, though by using a Integrated Security you are using the current principal running the ...
Score SQL Server Authentication versus Windows Authentication
supvine - 13 Jul 2006 9:13 PM - 1 message
Hello, I am hearing conflicting point of views regarding ASP.Net development - some folks say that when connecting to a SQL Server via ASP.Net it is better to connect using Integrated Windows Authentication (trusted connection) while others say that it is better to connect using SQL ...
Score Determining field type CHAR vs VARCHAR
Jared - 13 Jul 2006 8:12 PM - 4 messages
Is there a way to programmatically determine if a SQL Server field is of type CHAR vs. VARCHAR? I'm able to use the DataColumn.DataType property to determine that a field is a string, and to retrieve its max length.  As far as I can ...
Score How to execute SP with type of Table..
venkat.oar - 13 Jul 2006 7:42 PM - 3 messages
Guru's, I have oracle sp with the below types defined, and my sp uses these types for outparameter, i am using DAAB. Need to know how to execute this kind of SP. highly appreciate if you can get me solution for this.. ...
Score Any way to avoid using SP_EXECUTESQL in ADO.NET?
Brad P - 13 Jul 2006 7:21 PM - 5 messages
Hi, Our development team has encountered some performance problems when using ADO.NET (using the SqlCommand and SqlDataAdapter objects) to perform queries on large data tables. We've drilled into the issue considerably, and the problem seems to be related to how ADO.NET uses ...
Score DataAdapter not updating underlying SQL Database! Help!
Bmack500 - 13 Jul 2006 1:59 PM - 1 message
Thanks in advance! I'm using Visual studio.net 2005 I can't get the underlying table (incoming) to update. I modify the datarows, checking the database before and after running (the code gets several hits while iterating the records), and it doesn't update it. ...
Score Help - DataAdapter.Update is not updating Access database
Roy - 13 Jul 2006 1:49 PM - 2 messages
Hi all, I'm trying to update a table in an Access database with the records in a table from another Access database that both tables have exact schema. Table one has about 10,000 records and table two usually has 10-20 records. ...
Score Adding column description to Access table, HOW?
Søren M. Olesen - 13 Jul 2006 10:06 AM - 2 messages
Hi I'm trying to add a column and it's description to an Access table using the following code: objTable.Columns.Append("RefId", adInteger) objTable.Columns("RefId").Properties("Description").Value = "Reference Id" however I get the following exception: "Item cannot be found in the collection corresponding to the requested name ...
Score generating crystal report from multiple tables
sai - 13 Jul 2006 1:03 AM - 2 messages
hi all,          i am working on a MS.access project, in this i need to generate a report from multiple tables. I have  used  stored queries for operation on database tables how to do generate Crystal report from multiple tables?. ...
Score Async Database methods with a Oracle or Postgres
Chris Mullins - 13 Jul 2006 12:56 AM - 1 message
The ADO.NET 2.0 SqlDataProvider provides a nice set of async methods to perform database access. Unfortunatly this is the only database provider that I can find that supports these. Is anyone aware of an Oracle implementation that provides Begin/End versions ...
Score How to Send XML to client
ad - 12 Jul 2006 9:43 PM - 4 messages
I am using VS2005 to develop Asp.Net program. I use the codes below to create a XML stream: How can I set the Stream to client? //----------------------------------------------------------------------------- MemoryStream sm= new MemoryStream(); dsHealth.WriteXml(sm); ...
Score Foreign key constraints from DB at runtime
Shelah - 12 Jul 2006 8:44 PM - 2 messages
I'm trying to figure out how to discover foreign key constraints at runtime by asking the database. All the code samples I see in .NET have you manually create the foreign key constraints.  I'm trying to detect them from the database's schema. ...
Score Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
daokfella - 12 Jul 2006 7:03 PM - 1 message
I'm trying to connect to an R:Base database on my machine. I created a system DSN using the R:Base provider which connects fine. In my project, I can browse the database by adding this connection in the ...
Score Connection timeout - Sleeping Processes - Connection Pools? Why oh Why
mark.ellul - 12 Jul 2006 5:24 PM - 5 messages
Hi Everyone, I have a problem with a system in production. Basically we are getting timeouts on getting a connection from the connection pool... I will give the background now... We have a Web Server and a Database Server with the below ...
Score Proper resource deallocation through Dispose()
Michael Russell - 12 Jul 2006 4:07 PM - 4 messages
Hi All, Trying to get a grip on the proper deallocation of unmanaged resources.   I asked some general questions in another group, here's my ADO question:  If I call Dispose on a DbDataAdapter, for example, am I ...
Score Prevent DataRow Deletion
AxelHecker - 12 Jul 2006 12:19 PM - 4 messages
Hi! Scenario: A User deletes a row in a DataTable; a MessageBox comes up and asks if he/she really wants to delete the row; in case the answer is "no", the row deletion should be cancelled. There are straightforward solutions for this scenario when an intelligent ...
Score Copy all records from access MDB to others via ADONET
Edwin Knoppert - 12 Jul 2006 12:04 PM - 24 messages
I'm generating an MDB or XLS or CSV from an access database (MDB) I want to copy all records in the query over to the newly created database and (empty) table. I seen: [link] which only shows a ...
Score Migration
Nau - 12 Jul 2006 11:10 AM - 2 messages
Dear All, What is the relevant way of migration of ASP to ASP.net ...
Score run multiple SQL statement in OleDbCommand
wesbird - 12 Jul 2006 2:19 AM - 2 messages
Hello:   I am using 2 datagrid in a master-detail, now if I want delete a record in master, I should delete all child record of this master record before I delete the master.   I don't know how to run mutiple SQL statement in my custom OleDbCommand? ...
Score Unspecified error OLEDB
Mike - 11 Jul 2006 10:22 PM - 1 message
Hello, I developed an export to Excel that runs in an ASP.NET 1.1 page (code-behind). Sometimes, when calling the Open() method of the OLEDB connection to Excel, an "Unspecified Error" occurs. I have the impression that it has to do with some security on IIS, but cannot figure out exactly ...
Score No dataview item property
Earl - 11 Jul 2006 8:47 PM - 3 messages
This was initially posted on the C# forum and was meant to be cross-posted here. Noting first that I'm coming from VS2003 and VB.Net to C# and VS2005 ... Using an untyped dataset, I create a dataview. When I try to use the Item ...
Score DataRelation left outer join different database types
Peter - 11 Jul 2006 8:45 PM - 5 messages
Hello, I'm trying to create an application that reads data from two tables, where the one table is stored in a MySQL database (Table 1) and the other is stored in SQL Server (Table 2). I need all the data from table 1 that doesn't exist in table 2, in ...
Score weird connection error
ECathell - 11 Jul 2006 7:20 PM - 1 message
Name have been changed to protect the innocent. This is the only class that is causing me this issue and I can't figure out why. Everything before this one loads fine, and the ones after this load fine. I have checked the underlying tables and the user has proper permissions. I do not get the error, but I have more permissions than he does. The other person using the application does not get this error either, but he has elevated privileges too...I have done everything I can think of and it is still occurring ... ...
Score First Connection To DB2
OldButStillLearning - 11 Jul 2006 6:10 PM - 6 messages
Hello, I have used mainly Oracle and VS, but now I am taking a crack at DB2. I am using DB2 Mainframe.   If I go to the DB2 software which is installed on my machine amd bring up "information center", it brings back the following ...
Score how to query a .Net(2.0) dataTable?
Rich - 11 Jul 2006 4:18 PM - 2 messages
Hello, I pull sql server data into a .Net (2.0) dataTable (vb2005 app) using criteria like CompanyName = '3com%'  which will return every variation of '3com' in the source data like  '3com inc', '3com Group'....   The rows all contain a ...
Score Selecting Dates for database connection
MasterChief - 11 Jul 2006 3:01 PM - 3 messages
I have a calendar control that I am using to have a person select a date. Then I connect to a database and I want to display anything that is equal to that date or where the date selected is atleast between the ...
Score Enterprise Library - DataAccessApplicaitonBlock - Oracle
Gil - 11 Jul 2006 7:58 AM - 10 messages
I am using the Enterprise library DAAB in my applicaiton connecting to an Oracle instance, and all works fine on my development box, I can connect to the datbase and perform the functions I require. On my customers machine the connection fails, in the windows event log I get ...
Score Possible to tweake dataset (de)serialization .NET 2.0-->1.1?
henk gijsbert - 11 Jul 2006 7:01 AM - 1 message
I'm getting an error when I try send a dataset from a .NET2.0 proces to a .NET1.1 proces: Type is not resolved for System.Data.Serializationformat, System.Data, .... It appears Microsoft does not support backward compatiblity on datasets ...
Score IsDBNull check -- translation from VB.Net to C#
Earl - 11 Jul 2006 6:50 AM - 5 messages
In VB.Net, I often check for a null in a dataview column before assigning a value from that column to a variable:    If Not IsDBNull(dvContacts.Item(0).Item("LastName")) Then     strLastName = CStr(dvContacts.Item(0).Item("LastName")) ...
Score Typed DataSets in VS 2005
PR - 11 Jul 2006 3:01 AM - 3 messages
...
Score How to get the connectionstirng form a TableAdapter
ad - 11 Jul 2006 1:26 AM - 6 messages
We have to assign a connection string to a TableAdpater when we desgin a TableAdapter in desgin time. How can I get the connection string  in run time? ...
Score How can we insert a DataTable into database?
ad - 11 Jul 2006 1:19 AM - 4 messages
I have a typed DataSet with a DataTable in it. The structure of the DataTable is from a table in a database. Now I have make the DataTble with about 10 new row. How can I insert the DataTable into database at once? ...
Score Event: ADO.NET Provider Writer Tech Preview, July 31 - August 2, 2006
David Sceppa [MSFT] - 11 Jul 2006 12:38 AM - 1 message
Attention ADO.NET provider writers!  Microsoft is inviting third party ADO.NET provider writers to take part in our ADO.NET Provider Writer Tech Preview taking place at Microsoft Campus, Redmond, July 31 – August 2, 2006. Please see details below and respond to me on this as per the mini form. ...
Score Oracle 10g Express, 9i Client & Wireless Enet
Brian Pruitt - 10 Jul 2006 11:34 PM - 1 message
Hello, Just recently installed 10g Express and the latest release of ODP.net and found an issue or more of a nuisance. Everything works fine except for the connection time to the DB. Using: XP Professional Visual Studio 2003 Oracle 10g Express ...
Score How to Determine if a Record is Locked
Scott - 10 Jul 2006 10:48 PM - 1 message
All, I have set a transaction lock on an Sql Server 2005 database as below:     transaction = connection.BeginTransaction(IsolationLevel.RepeatableRead); I keep the connection and transaction open while processing data (done deliberately). When I launch another application I can read the record that is locked but ...
Score Filling from inside a transaction?
Mike King - 10 Jul 2006 7:06 PM - 4 messages
How can one fill a DataSet or DataTable from inside a transaction?  I'm receiving an exception when the following Fill method is executed. DataTable dt = new DataTable(); OracleDataAdapter da = new OracleDataAdapter("SELECT * FROM dual", conn); da.Fill(dt); ...
Score connection pooling
John A Grandy - 10 Jul 2006 5:47 PM - 3 messages
My understanding of ADO.NET connection pooling as it relates to Sql Server is that once a connection is created and opened, behind the scenes ADO.NET adds this connection to a pool of connections with identical connection strings.  If a connection is closed in code this does not necessarily mean ...
Score cannot debug on the webserver
Philippe - 10 Jul 2006 3:39 PM - 3 messages
Seems to me that a lot of people have had this problem. I went through [link] but none of the solutions worked. I'm still not able to debug my asp.net app. ...
Score Access to the ADO.net Managed Provider 'SqlClientFactory' was denied in the data source with ID 'sds
William Buchanan - 10 Jul 2006 8:09 AM - 1 message
Anyone know what is causing this? I've just deployed a fairly basic site onto a Win 2003 server (ASP.NET 2.0, MS Sql Server 2005). Thanks! ...
Score ExecuteXmlReader
Kevin Burton - 10 Jul 2006 4:23 AM - 4 messages
I have a table that has some data that is being read is a column with XML data. It is typed 'text' and the server is running 2000 so I don't have an option to type the column as XML. I would however like to  use ...
Score SqlCommand and multiple SQL statements
Arne_Vajhøj - 9 Jul 2006 11:11 PM - 3 messages
Is the capability of System.Data.SqlClient.SqlCommand to execute more than one SQL statement (two SQL statements in CommandText separated by semicolon and just one Execute call) a supported feature that we can expect to continue to work in the future ? ...
Score Problem with Login control and web.config
hrawada - 9 Jul 2006 3:53 PM - 3 messages
Hello everyone, I am desperate to solve this problem. I have built my website using Visual Web Developer. The website works perfectly fine when I test it on my computer. However it doesn't work when I upload to my website ...
Score Querying a join (Which method is better?)
Bruce One - 9 Jul 2006 12:30 PM - 2 messages
Hey folks, I have a quiz in my mind... When u have a query that u have 3 ou 4 tables involved (tables), I figure there r 2 solutions: 1) You write a SELECT for capturing fields in just one table, and then, ...
Score Query Help - Distinct Row with Date Portion of a DateTime
Alex Maghen - 9 Jul 2006 6:39 AM - 3 messages
I have a table with a DateTime column and both the date and time portions of the field are used in the entries. But I want to write a query that'll do the following: Get a list of each distinct DATE from all of the rows of the DateTime ...
Score Vishual Studio.NET 2005 and Vishual Studio.NET 2003
harrypotter - 9 Jul 2006 4:05 AM - 3 messages
I tried this code" Imports System.Windows.Forms " on VB 2005. My project type was class library. When I compile I had an error massage by saying that this type of code doesn't exists. But when I use the VB ...
Next »