Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Application needs replication
John - 6 Oct 2007 6:02 PM - 14 messages
Hi We have an MS Access application which runs on the server but some laptop users need the app to work offline. Our solution has been to use Access replication which automatically syncs data (both ways) when laptop is connected to the network. We are looking to rewrite the app to vb.net/sql ...
Score IAuthorizationExtension and RolePovider
gover - 5 Oct 2007 10:47 PM - 1 message
We have developed a  custom asp.net 2.0 RoleProvider to Authorize access to different areas of our web app so that administrators of our application could control access rather than IT staff.  The custom  RoleProvider reads ...
Score Major problem involving primary key constraints
B. Chernick - 5 Oct 2007 4:26 PM - 3 messages
I'm writing a Winforms project under Dot Net 2.0.  One of my tables has a multiple field primary key.  One of the key segments is a fixed char field used to determine the order in which the records are displayed in a grid.  (S ...
Score ADO.Net transaction and ExecuteDataset
sam345.345 - 5 Oct 2007 12:33 PM - 2 messages
Hi, I have clarification about ADO.Net transaction and ExecuteDataset; In the "Microsoft Data Access Application Block for .NET" project the following code uses transaction for ExecuteDataset() What the purpose of using transaction in the ExecuteDataset()? I think transaction is not use when retrieving data from a DB. ...
Score Datatable how trap enter to Edit Mode?
mtczx232 - 5 Oct 2007 10:51 AM - 2 messages
Datatable how trap enter to Edit Mode? ...
Score Linq
Jorgebg - 5 Oct 2007 10:02 AM - 7 messages
Hi All, I want to start some kind of debate or poll on Linq, the question is: Do you think is a good idea to work with Linq in the future? Most of the articles out there are not very impartial, and are embracing ...
Score ADODB.Stream.Open now with VS2005 gives wrong type error message
Sarah M. Weinberger - 4 Oct 2007 8:34 PM - 1 message
Hi, Sorry about the fragmented previous post. I tried to get rid of the extra spacing but pressing Ctrl+Enter wound up sending my post. Ooops. I have some code that with the previous vesion of Microsoft Visual Studio 2002 worked fine, but now I receive an error message. ...
Score ADODB.Stream.Open now with VS2005 gives wrong type error message
Sarah M. Weinberger - 4 Oct 2007 8:29 PM - 1 message
Hi, I have some code that with the previous vesion of Microsoft Visual Studio 2002 worked fine, but now I receive an error message. public void MyFunction() ...
Score Transaction behavior when connection is lost
Allen S. - 4 Oct 2007 2:05 PM - 3 messages
How do I ensure that all database operations are rolled back when database connectivity is lost during the middle of a transaction?  using (DbConnection connection = db.CreateConnection()) {     connection.Open();     DbTransaction transaction = connection.BeginTransaction(); ...
Score SetModified not persisting to db.
marc.l.caron - 3 Oct 2007 10:26 PM - 4 messages
It appears to me that using the SetModified() doesn't force the data changes into the database.  I'm thinking it is doing comparisons between the DataRowVersion's.  I say this because of my following problem. I have a scenario where the best way to handle the data is to take ...
Score How Do You Organize Your Data-Access Code
Jonathan Wood - 3 Oct 2007 10:03 PM - 3 messages
I was just wondering how most of you organize your data-access code. I know there's stored procedures, data source objects, data controls, and plain old C# and VB that we can choose from. Although I prefer a simple ...
Score Passing type Object to SqlParameter.Value
cashdeskmac - 3 Oct 2007 7:45 PM - 5 messages
Hi, I am creating my own data access layer (I know I am re-inventing the wheel but I like the challenge). At the moment I am able to pass in a HashTable with the key and parameter value and I use the key to get the SqlDbType from a config file.   From there ...
Score Creating a Dataview from a Dataset using SQL?
Simon Verona - 3 Oct 2007 11:07 AM - 4 messages
I'm probably missing the obvious. I have a dataset that is built in code (it has a single datatable) that I want to populate a datagrid based on an SQL statement that I want to run against the dataset. ...
Score .NET-Noob and Databinding (DataSet, DetailsView)
Martin Frey - 3 Oct 2007 8:02 AM - 1 message
Hello guys, im new to asp.net and im trying to get me used to it. I've managed to create webpages with detailviews, databinding and datasources. Adding or inserting data went very well and, after a while, very fast. ...
Score LOOKING FOR CASPOL.EXE
MarathonMike - 2 Oct 2007 10:18 PM - 8 messages
After a decade of experience with VB versions, I recently installed VS.net 2005 professional.  I ran into security roadblocks when I moved a small test app off my C: drive and onto a network file server. Searching through support.microsoft.com gives lots of complicated ...
Score Combining and relating DataTables from different typed DataSets in
Marc Woolfson - 2 Oct 2007 11:54 AM - 2 messages
We have been provided with a set of typed DataSets which we wish to merge into the one DataSet, adding any additional relationships between DataTables as appropriate. We wish to use Visual Studio.NET 2005 to visualise and manipulate the various tables in order for all of the typed methods that deal ...
Score SqlParameter.Size - When to use?
Amy L. - 2 Oct 2007 4:12 AM - 2 messages
When using Stored Procedures and SqlParameters when do you need to specify the SqlParameter.Size property? From the documentation and examples I have seen where Integers had a size set and examples where Integers did not have a size set. ...
Score Web Developer ConnectionTimeOut
Mantvydas - 2 Oct 2007 1:05 AM - 5 messages
Hello, I've got a webpage, done with visual studio express web developer, which shows the result of a store procedure. I've got a problem, that sometimes my sql server 2000 replies with the results of the stored procedure quickly enough, but sometimes it's busy and ...
Score Parameter size for NVARCHAR(MAX) data type?
pedestrian via DotNetMonster.com - 2 Oct 2007 12:56 AM - 2 messages
I have an ASP.NET 1.1 page to call a stored procedure in the SQL Server 2005. If I use the NVARCHAR(MAX) data type in a SQL Server 2005 stored proc, What should I use for parameter size for SqlParameter in Visual Basic.NET ...
Score Default DataTable Constraints with SQL Server 2000 vs 2005
Jeff - 1 Oct 2007 8:34 PM - 5 messages
Hi, We are in the process of upgrading from SQL Server 2000 to 2005.  We have one stored procedure that returns the result of a join on two tables, table A and B.  Part of the result set is the primary key for Table A.  Because of ...
Score Need Help with Paging in GridView
BillG - 1 Oct 2007 6:40 PM - 1 message
I have turned on paging in my gridview which is tied to an ObjectDataSource. The ODS has a select method called GetEventSteps and a select parameter called id.  In the selecting event of the ODS I set the parameter to the ...
Score Accessing a DataKey that has more than one value
Nathan Sokalski - 1 Oct 2007 4:25 PM - 4 messages
I am attempting to access a DataKey that has more than one value. The code I use to create the table and where the error occurs are: Creating the DataTable: cart.Columns.Add(New DataColumn("productid", GetType(Integer))) cart.Columns.Add(New DataColumn("producttable", GetType(Integer))) ...
Score when update database, i must wait few second!
Tark Siala - 1 Oct 2007 1:36 PM - 7 messages
hi i'm using VS.NET 2005 +SP1 C#, and i connect access database by ADO.NET 2.0. i'm using Dataset to (insert,update,delete) and in get data i use (Datareader), but my problem when i do this: ...
Score ORA-00904 error on good select
David Thielen - 1 Oct 2007 4:16 AM - 15 messages
Hi; We have a select that does work on Oracle, but does not work when going through the OracleConnection ADO.NET connector. One column name is 28 chars long and the other is 30 so they should be ok. Does the connector count table + column name length when we do table.column ...
Score Transactions
dontspammenow@yahoo.com - 30 Sep 2007 7:52 PM - 2 messages
Transactions with .NET 2.0. If I code this in C# method: Customer objCust = new Customer(); using(TransactionScope scope=new TransactionScope()) {      objCust.UpdateData();  // updates customer record via stored procedure with a standard excutenonquery      scope.Complete(); ...
Score Creating and calling a pl sql file from vb.net
Ag - 30 Sep 2007 4:51 PM - 1 message
I want to combine several sql queries into a pl sql file,I want to buld a pl sql block which creates a file which has these queries and outputs results  as 1.csv, 2.csv  etc.I want to call this pl sql block ...
Next »