Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Get Query string from Dataset/Datatable
Johnny E. Jensen - 27 Oct 2007 9:47 PM - 2 messages
Hello When i fetch data from database i do the following: DataSet ds = new DataSet(); OledbConnection con = new OledbConnection(ConnectionString); using ( OledbCommand cmd = con.CreateCommand()) {     cmd.CommandText = "SELECT * FROM [tblCustomers] WHERE [CustomerName] LIKE 'A%';";     using ( OledbDataAdapter da = new OleDbDataAdapter(cmd)) ...
Score ANN: High performance of remoting ADO.NET objects cross desktop and smart devices
msgroup - 27 Oct 2007 2:16 PM - 1 message
Hi, All: UDAParts has updated .NET versions of SocketProAdapter at [link] for supporting binary remoting .NET ADO.NET objects, DataSet, DataTable and DataReader. Key features and improvements over MS technologies are: 1. Bi-directional remoting DataSet, DataTable and DataReader across desktop ...
Score DAtaset comparision ??
calderara - 27 Oct 2007 9:41 AM - 5 messages
Dear all, What is the best  way to compare 2 dataset ? What I mean by that is not comparing that its teh same object but allso that rows data values in both . In other words I need an effeective way which tells me if records between 2 ...
Score there seems to be some overhead between SQL Server 2005 and a CLR function written in C#. Why is thi
DR - 27 Oct 2007 4:24 AM - 2 messages
there seems to be some overhead between SQL Server 2005 and a CLR function written in C#. Why is this? I have a simple wraper around System.Diagnostics.Stopwatch.GetTimestamp() : public partial class UserDefinedFunctions {     [Microsoft.SqlServer.Server.SqlFunction] ...
Score Problem in copying SQLite file in C# code
mahdaeng - 26 Oct 2007 11:09 PM - 1 message
I have a little Windows application written in C# with a SQLite back- end. I'm using the System.Data.SQLite provider. One of the features the application provides is a database back-up, which just basically copies the S3DB file to a specified location. See ...
Score databinding
vaporpop@gmail.com - 26 Oct 2007 9:39 PM - 2 messages
I have a checkbox (along with textboxes) that I am trying to use as a databound control to an integer field on a database.  I am using Format and Parse with the checkbox to write -1 to the database if the ...
Score Confusing Error related to MappingSource?
Benjamin - 26 Oct 2007 8:05 PM - 1 message
I'm trying to force LINQ to SQL to do some inheritance modeled around the "Table per Concrete Class" methodology as opposed to the normal "Table per Class Hierarchy" model it officially supports.  To do this, I omitted all the ...
Score How do I (cleanly) dispose of a row in DataGridView DataError even
B. Chernick - 26 Oct 2007 6:13 PM - 4 messages
(Reposted from Winforms forum.  Not sure where this belongs.) I'm writing a Winforms project in VB/Dot Net 2.0 and I'm having some trouble handling the DataError event.  The grid is bound to a filtered binding source.  Add is enabled.    Part of ...
Score Inconsistent dat paremeter in query
HMike - 26 Oct 2007 6:14 AM - 8 messages
I am using the same code to query different databases, one SQL 2005 and the other SQL 2000. The query contains a date paremeter @Date... Me.SqlSelectCommand1.Parameters.AddRange(New System.Data.SqlClient.SqlParameter() {New System.Data.SqlClient.SqlParameter("@Date", System.Data.SqlDbType.DateTime, ...
Score web service for accessing db?
Andy - 26 Oct 2007 12:17 AM - 11 messages
hi, is web service good solution for accesing (havily) database (remote or not)? that looks slow, any other methods for secure connection?  SOme of coworkers wants to use web service because they don't want expose connection string. thanks fro advise ...
Score Null Dates in Dataset
Robert E. Flaherty - 25 Oct 2007 5:19 PM - 6 messages
Using C# 2.0 & SQL Server 2000, have a stored procedure that return 0, 1, or more rows.  At least one of the columns is a date and it may null.  I have created an XSD of the output from the stored proc.  The entry for the ...
Score Jobsite for SALE
netxure@gmail.com - 25 Oct 2007 4:45 PM - 1 message
JOBSITE FOR SALE For Details Contact: Netx***@gmail.com FEATURE LIST Job Seeker Features ·    This Job site contains Advanced features of Dice and Monster ·    Search jobs by location, date range, categories, Job type and ...
Score what are the memory caps for threads running as a CLR stored procedure executed by sql server 2005?
DR - 25 Oct 2007 3:37 AM - 2 messages
what are the memory caps for threads running as a CLR stored procedure executed by sql server 2005? is it limited by OS only or also by sql servers memory limits? e.g. lets say my clr stored procedure is executed by sql ...
Score Unable to start TSQL Debugging. Could not attach to SQL Server Process on 'srvname'. The RPC server
DR - 25 Oct 2007 2:37 AM - 2 messages
Unable to start TSQL Debugging. Could not attach to SQL Server Process on 'srvname'. The RPC server is unavailable. I get this error when I try to run a SQL Server Project with a CLR stored Procedure in it. The target DB is SQL Server 2005 and im using VS 2005. I ...
Score datatable vs custom List<MyClass>
paul - 25 Oct 2007 12:16 AM - 3 messages
Let's say I want a read-only copy of a simple query that joins 2 tables. When I compare a DataTable (adapter.fill) and a custom List + DataReader, I see that the custom sol'n is about 6x faster and takes 5x less memory.  For my ...
Score very strange behavior of the method GetChanges(...) from the DataSet class
evald80 - 24 Oct 2007 8:15 PM - 1 message
Hello ! i'm using a typed DataSet called myDs. This dataset has 2 Tables, Table1 and Table2. i have created a DataSet like this: myDs dsOld = new myDs(); //here i populate the 2 tables ....... //and then call the method to get the added rows ...
Score Access vs vb.net/ado.net
John - 24 Oct 2007 6:43 PM - 17 messages
Hi What are the advantages of writing an app in vb.net/ado.net as opposed to MS Access? I need this to sell the idea to the management. Many Thanks Regards ...
Score Why is SQLFreeStmt within the transaction using parameterized inse
EricR - 24 Oct 2007 2:33 PM - 1 message
I am using ODBC.NET to perform mulitple parameterized inserts into a database. The performance has been terrible. Upon research into the ODBC trace log, it appears the a SQLFreeStmt is being executed by ODBC upon every ExecuteNonQuery that I am issuing. This is causing a huge amount of overhead, ...
Score how to insert record in a dataSet into another database table
Toyin - 24 Oct 2007 2:25 PM - 9 messages
hi, pls can someone help me out. its very urgent i get the solution today. i have a webservice that i use to retrieve new record from a database, also there is a client application (window form) that calls this service which ...
Score how to insert record in a dataset into another database
Toyin - 24 Oct 2007 2:07 PM - 1 message
hi, how do i insert a record inside a dataset into another database table on a different server. i use a web service to retrieve the record and store in it into a dataset.i have a client application (a window form) that calls this ...
Score Copy database schema from Access to SQL Server
schneider - 23 Oct 2007 2:36 PM - 8 messages
Hi all, I'm trying to write an application that takes an Access database as template to customize a new or existing SQL Server database. When something in the template database is changed, I want to apply these changes to the SQL database. For example if new columns are added to a ...
Score Memory keeps creaping up...why?
Jerry - 23 Oct 2007 1:53 PM - 5 messages
I have a simple subroutine (see below) which reads a table and populates the items of a combobox.  As the subroutine is executed, I'm watching the taskmanager and the memory in use increases; however, once I get to the Error_Exit: logic and start to close and dispose my memory variables, the memory is not released and does not decrease in the task manager.  Why is that?  Eventually, my program is giving me "Insufficient memory" errors. ...
Score Sybase AsaClient and DbProviderFactories
JC - 23 Oct 2007 2:20 AM - 1 message
Hello all, My team is trying to use the iAnywhere.Sybase.Asaclient (middle part might be spelled incorrect) in our C# project with a DbProviderFactory class to generate new code. However when we try to create a new factory with DbProviderFactory ...
Score Decimal data type wont work!
Cirene - 23 Oct 2007 1:21 AM - 3 messages
I have a SQL Express db with a table field defined as data type decimal(18,0). When I type in .785 in the table field it rounds it to 1. Any ideas why???? ...
Score Question about finding records using Stored Procedures
news.microsoft.com - 22 Oct 2007 9:56 PM - 2 messages
I have a table called Customer.  I have a locator screen which is composed of a grid and a couple of search boxes.  The user is going to choose which customer records to display in the grid.  The choices are LastName or ...
Score Question about SUM query
Cirene - 22 Oct 2007 4:55 PM - 3 messages
I have a "transaction" table with 2 columns, TransTypeId and TransAmt. Example: TransTypeId        TransAmt A                        100 ...
Score i have a problem . please help me
hamid hashemi - 22 Oct 2007 10:47 AM - 3 messages
Hello, I am writing ASP.NET application using SQL Server 2005 Express Edition. my connection string is : "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\DB.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"; I used connection strings syntax from [link] ...
Score How sluggish is a big xml file in combination with datasets?
PSiegmann - 21 Oct 2007 2:59 PM - 3 messages
Hello, I am currently working on a project which will run in an environment, where the size of the database is very limited. That's why I thought about relying in some parts entirely on xml files (and datasets) as an ...
Next »