Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Why isn't my SCOPE_IDENTITY() working?
news.microsoft.com - 17 Nov 2007 9:26 PM - 4 messages
I have a table called Activities with a primary key of ActivityId which is an identity field.  I can see the value after the insert is there.  But my return back from the ExecuteScalar method call is not working. ...
Score Getting a subset of DataRows from a DataTable
Nathan Sokalski - 17 Nov 2007 1:19 AM - 10 messages
I have a DataTable from which I only need a certain range of the DataRows. What I would like to do is copy a range of rows from one DataTable to a new DataTable like the following: For i As Integer = start To last ...
Score Membership Database Suggestions
Jonathan Wood - 16 Nov 2007 11:05 PM - 1 message
Greetings, I'm trying to come to terms with the membership database created automatically in ASP.NET applications that use membership functionality. My problem is that I need to implement more information than is stored in the default membership database. ...
Score how does SqlCommandBuilder work?
Andy Fish - 16 Nov 2007 7:29 PM - 3 messages
hi, I have seen by example that in order to use an SqlCommandBuilder, you just have to instantiate it. however, when trying to figure out what was happening, I looked in reflector, and I can see that the SqlCommandBuilder constructor doesn't ...
Score Fill typed dataset with one stored procedure call
Gene - 16 Nov 2007 4:45 PM - 4 messages
Is it possible to fill a strongly typed dataset with multipe tables single stored procedure command? ...
Score Serialized Typed DataSet Versioning
sjones204g - 16 Nov 2007 4:26 PM - 1 message
Hello all, I'm working on a smart client application for my company. The client uses .NET 2.0 typed datasets to store it's data. It works both in 'online' and 'offline' mode. When the application starts in online ...
Score Bind Property of Child-Objecty to DataGridView
Pieter - 16 Nov 2007 9:17 AM - 5 messages
Hi, I want to bind a proeprty of a child object to a DataGridView, but it doesn't work. For instance: Imagen that I have an object Company, and this object company has a child object Address. Address has a property Street. ...
Score Question: About showing a formview in each gridview row
Cirene - 16 Nov 2007 3:05 AM - 1 message
I have a gridview that displays a listing of cars for sale.  It's based on a "Cars" table. (The "Cars" table has a 1 to many relationship to "CarPictures" table.) On each gridview row (ie for each car) I want to show just 1 picture from ...
Score Trouble appling filter to datatable.defaultview
moondaddy - 15 Nov 2007 3:44 PM - 3 messages
Using vb.net 2.0 I'm trying to filter a dataview.  From the code examples I've seen, it looks correct, but its not having any effect.  The datatable has about 250 rows of data.  after I apply the filter and set the dataview ...
Score Linq to SQL Custom Paging
Mike - 15 Nov 2007 12:15 PM - 1 message
Not sure if this is the right group.  Please point me to alternatives if it isn't. I'm playing with the Linq To Sql designer in VWD Orcas, and am looking at how to apply custom paging to a GridView for display on a web page. I want ...
Score OleDbCommandBuilder - Data type mismatch in criteria expression
john - 15 Nov 2007 9:00 AM - 2 messages
Hi, i'm using an OleDbCommandBuilder to update data from a dataset to a access database. It work fine, but if i use a table with a decimal column data type, i get this error, when performing the update Data type mismatch in criteria expression ...
Score syntax for filter in datatable.select
moondaddy - 15 Nov 2007 3:55 AM - 5 messages
Where can I find documentation for the syntax allowed in the filter used in datatable.select("some filter")? I want do something like this: dim str as string = "men" datatable.Select("colName Like "*" & var & "*") which would allow data like ...
Score prompt user to select from recordset.
Kevin O'Brien - 13 Nov 2007 8:56 PM - 16 messages
Hey guys, I am querying a sql database for a matches using wild cards.  If I return more than one record I want to prompt the user to choose the best match. What is the best way to do this?  I thought I could put the matching records ...
Score Performance issue with vS2005
touf - 13 Nov 2007 5:39 AM - 3 messages
Hi, I've migrated from VS2000 (1st version of VS.NET) to VS2005,I'me having some performance isssues for example a query "Select * from table" that return 70000rows is taking more than 1 min (instead of 5 sec in the previous version) ...
Score ADO.NET Sync Partial Table
JStorm - 12 Nov 2007 10:25 PM - 4 messages
Is it possible to use the ADO.NET 2008 Sync Framework to sync only a portion of a table? Syncing the entire table is not an option for the app I am working on due to the sheer size of the table, so I was wanting to apply business requirements ...
Score Reading a SQLCLR Stored Proc. Result
Scott M. - 12 Nov 2007 7:48 PM - 15 messages
How do you consume the result of a SQLCLR stored procedure when it returns a SQLDataRow? Thanks. ...
Score Help! Stored Procs don't show as Data Sources In Data Source Window
Scott M. - 12 Nov 2007 4:39 PM - 4 messages
a.   I have some SQL CLR stored procedures and a connection to that SQL database in my Server Explorer. b.   I use the Add Data Source Wizard and select my stored procedures as the items I'd like to add. ...
Score data cache invalidation: the old sql 2000 polling way or the new sql 2005 notification way?
JX - 12 Nov 2007 7:05 AM - 1 message
about "SqlDependency changes for RTM", in [link], Sushil Chordia wrote: "Push Model to Pull Model In Beta2 we had an HTTP/TCP listener that was active on the client that ...
Score Data reader / Serverside cursor
rbrowning1958 - 11 Nov 2007 4:13 PM - 2 messages
Hello, New to ADO.NET so apologies in advance for repeating what I am sure has been asked been before. I have read that a data reader is much like a Server Side cursor. I understand this but have one questtion. I ...
Score sql server setting concat_null_yields_null
touf - 11 Nov 2007 5:16 AM - 3 messages
I'm migrating from ms-accss to sql server 2005 for a vb.net application. the problem is that the queries like "select field1+field2 from table" arereturning NULL if one of the fields is null. I like to have the concatenation containing the not null values. ...
Next »