Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score BindingSource.EndEdit and Position
Samuel_García - 3 Nov 2007 8:11 PM - 1 message
When I call BindingSource.EndEdit on one of the BindingSources of my application, it correctly finishes the addition of the new row but surprisingly it also resets its Position to zero (and so also changes the object referenced by its Current property to the first item on the DataView ...
Score How to resort records in a dataSet?
Andrew - 3 Nov 2007 6:18 PM - 7 messages
Hello, friends, We have an app in c#.net 2003. There is a dataSet. Its data are populated to a customized list in a loop (NO data binding, now and future). We need to modify it so that it can be sorted based on user's selections. ...
Score simple SQL: select missing rows
Lloyd Dupont - 3 Nov 2007 8:48 AM - 5 messages
I have some simple data like that Product -------- PR_Id (PK), Name -------- 1    Wall Clock 2    Nails Invoice ------- IN_id (PK) ------- 1 2 InvoiceLine ------------ LI_Id (PK), IN_id (FK in Invoice), PR_id (FK in Product) ------------ 1    1    1 ...
Score How to debug sql 2005 on remote machine. I am administrator on both my dev machine and remote sql se
DR - 2 Nov 2007 9:05 PM - 1 message
How to debug sql 2005 on remote machine. I am administrator on both my dev machine and remote sql server machine. I get this error when i try to connect to remote machien with visual studio: unable to connect to microsoft vistual studio remote debugging monitor named ...
Score Need utility for deleting rows
Chris Dunaway - 2 Nov 2007 6:18 PM - 4 messages
In the course of developing my application, it inserts many test rows into the test database.  These are standard Orders with details and other data.  Now, I wish to delete these "dummy" orders, but because of the relationships between the order, details, and other tables, ...
Score "IDBCommand.CommandTimeout" property won't change!
Amir Tohidi - 2 Nov 2007 12:37 PM - 3 messages
Hi I have an ADO.NET 2.0 command object. i am trying to set the CommandTimeout property. Whatever value I try get ignored and the property remains on 0! Any idea? Thanks ...
Score DotNetNuke Development
VB - 2 Nov 2007 9:57 AM - 1 message
[link] DotNetNuke development services for DNN include: ·    Product Design and Analysis ·    Prototyping ·    Incremental Development Approach ·    Full Product Testing Cycle ...
Score IsZombied (This SqlTransaction has complete; it is no longer usable.)
mjwills1 - 2 Nov 2007 5:25 AM - 2 messages
We develop software used by banks and financial planners throughout Australia. On one particular site (out of thousands) we are getting an error: This SqlTransaction has completed; it is no longer usable. Server stack trace:    at System.Data.SqlClient.SqlTransaction.ZombieCheck() ...
Score RE: How does GetSchema get foreign key constraints?
DRB - 1 Nov 2007 8:07 PM - 1 message
Where is this link now? ...
Score Underlying (SQL Server) DataTypes for Columns in a DataSet?
TBQ - 1 Nov 2007 7:41 PM - 1 message
I have an application that allows the user to enter any number of (SQL Server) select statements in a text box, execute the "script" and work with the resulting data.  Due to the multiple queries, I use a SqlDataAdapter.Fill ...
Score sqlcommand
ted185 - 1 Nov 2007 6:57 PM - 2 messages
I am trying to come up with a generic way of generating an insert statement widh command builer then additional parameter to the insert command so I can get the id of new records back.     Once I get the inserrt command from sql ...
Score xcopy deployment to sql server DTS package in restricted environme
Beth - 1 Nov 2007 5:16 PM - 6 messages
Hello. I'm an old VB6 programmer who would like to distribute an .exe with the simplest method possible, and that's not working. I have an application which updates rows on a SQL Server.  If I run the .exe ...
Score Fastest way to move XML document into and back out of CLR function
DR - 1 Nov 2007 1:41 AM - 2 messages
Fastest way to move XML document into and back out of CLR function In SQL Server 2005 and Visual Studio 2005, what is the fastest way to pass an xml data type variable into a C# CLR function and retrieve it back out of ...
Score Generics?
John - 1 Nov 2007 1:24 AM - 13 messages
Hi I am fairly proficient in vb6 and vb.net but I am baffled by generics. What are generics about and can I make use of them in my winform vb.net database applications? Many Thanks Regards ...
Score ADO Net examples
Mike TI - 31 Oct 2007 1:47 PM - 2 messages
October 31, 2007 Hi all Can someone point me out to a site with some good examples of data file manipulation. Thank you Mike TI ...
Score Connections String Questions
Mike TI - 31 Oct 2007 12:53 PM - 4 messages
Oct 31, 2007 Hi all Sorry for repeating my previous posting. I am new to VB Net. Q1. Which provider should be preferred when defining a connection, Data provider for SQL server or Data provider for OLEDB. I intend to use SQL ...
Score vs2008
John - 31 Oct 2007 12:22 PM - 5 messages
Hi What are the advantage of vs2008 over vs2005? Thanks Regards ...
Score Elementary question on connection string
Mike TI - 31 Oct 2007 5:16 AM - 7 messages
Oct 30, 2007 Hi all Using VB.Net 2005 & SQL 2005. I tried to use a database on my local PC and a remote database. Now is there a way I can make the connection string flexible. I tried to ...
Score is there anything like XmlDocument.ImportNode but for SQL Server XQuery?
DR - 30 Oct 2007 11:01 PM - 1 message
is there anything like XmlDocument.ImportNode but for SQL Server XQuery? ...
Score How is fastest way to construct an XML node then a bunch of slow xquery
DR - 30 Oct 2007 8:54 PM - 1 message
How is fastest way to construct an XML node then a bunch of slow xquery modify statements? This SQL Server 2005 logic is rather slow to simply add a new item to an xml document. Any way to do this all in one statement and faster for creating a ...
Score FillSchema and stored procedure IF statements
Caitlin - 30 Oct 2007 4:22 PM - 1 message
I'm trying to use FillSchema to get the results schema for a stored procedure that, simplified, does this: CREATE PROCEDURE SomeProc @Flag    bit AS IF @Flag = 1   SELECT 'foo' = 'bar' SELECT TOP 5 'baz' = snafu FROM SomeTable ...
Score I set my database to trustworthy and deployed this clr stored proc as unsafe ok but when i run this
DR - 29 Oct 2007 11:18 PM - 1 message
I set my database to trustworthy and deployed this clr stored proc as unsafe ok but when i run this it returns 1 each time. as if ival keeps getting set back to 0 each time i call this clr stored proc. How to fix so that ival ...
Score Timeout expired. The timeout period elapsed prior to completion of the operation or the server is n
Rick - 29 Oct 2007 9:56 PM - 8 messages
We  have a several vb.net apps, that were recently upgraded from Framework 1.1 to Framework 2.0. Randomly these apps have started throwing the error below, the line of code is a connection.open, the connection string has a ...
Score I heard there is some trick to referencing statics in C# CLR stored procedure without having to mark
DR - 29 Oct 2007 8:48 PM - 1 message
I heard there is some trick to referencing statics in C# CLR stored procedure without having to mark the assembly as unsafe. Does anyone know this? This is usefull as the case of needing a little static shared variable here and there without having to compromise safety in the Sql Server 2005. ...
Score User default schema
AReel - 29 Oct 2007 3:57 PM - 2 messages
Hi Using SQLServer2005, connecting via sql server authentication. In the Instance I created a database (MyDatabase) and a Login. In MyDatabase I created a schema (MySchema), Tables (attached to MySchema) and a User (based on the Login). I set the Login's default database to MyDatabase. ...
Score Creating a new Access database file (.mdb) in .NET/C#
Frnak McKenney - 29 Oct 2007 12:18 PM - 8 messages
I'm making changes to a small, portable, single-user database application I wrote a couple of years back built around a muli-table Access database and written in C# and .NET 1.1.  Most of the changes are are minor, but one involves "subsetting" the database, that is, ...
Score How much of the functionality of SQL Server is mirrored in ADO.Net
B. Chernick - 28 Oct 2007 10:48 PM - 12 messages
Ok, bear with me.  This is a bit lengthy.  This roughly explains a real-life legacy data structure problem I’m having. Assume a SQL Server 2000 database with 2 tables, Table1 and Table2.  Table1 has fields id1 (Integer, primary key, but NOT an identity field)  and ...
Score Missing first record
EdwardH - 28 Oct 2007 10:26 PM - 2 messages
Using asp.net and .net framework 2 and SQL server 2000 I am using simple SELECT statement in SP to retrieve data and then bind to a datagrid but fail to pick up the first record in the dataset:         invConn = New ...
Score Save mix data in database
Husam - 28 Oct 2007 5:43 AM - 3 messages
Hi EveryBody: What is the data type that I have to use when I want to save mix data in database for example photos,music,text fiel,doc file and movies ? any help will be appreciated regard's Husam ...
Next »