Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score copying an object by value
Hemang Shah - 7 Apr 2007 10:06 PM - 8 messages
I think what i'm trying to do is passing by value. Here is the scenario: Main Form - which calls a Search form. - I pass Mainform as a reference so that I can pass data between the two. Code: public frmSearch(Form1 f) ...
Score Concurrency Problem: Two separate dynamic SQL queries.
Jim Light - 7 Apr 2007 8:45 PM - 3 messages
How could I resolve the following concurreny problem, assuming that this procedure is not written as one stored procedure in T-SQL, but as two separate, dynamic SQL queries. QUERY 1: Check if username is already taken, return value to signify ...
Score No component code in the form class
Hemang Shah - 7 Apr 2007 8:00 PM - 2 messages
I'm creating a new form in visual studio 2005 I'm adding a component to it and when I go inside the form's code, there is no code for that component Is that feature changed ? Where is the code now. ...
Score ADO.NET Abstraction Layer: Basic SQL building blocks?
Jim Light - 7 Apr 2007 7:26 PM - 2 messages
Hi, I'm in the process of creating a light-weight object abstraction layer (not an ORM) over ADO.NET, to encapsulate the most commonly used SQL queries (as an exercise). Classes are as follows: Sum.cs, Insert.cs, Count.cs,... etc. ...
Score masters welcome
Jesse Aufiero - 6 Apr 2007 1:15 PM - 1 message
Hello, I'm looking for someone with mastery of ado.net 2003, particularly in the areas of concurrency and transactions against a sql server database, to consult me in certain aspects of my application's architecture. Experience with DevExpress controls, which I will be using in my application ...
Score Editing XSD files
Ant - 6 Apr 2007 3:14 AM - 2 messages
Hi, I am working on an ASP app. that uses Crystal reports. I need to edit the report but the data is exposed by xsd files. I tried to manually alter the xsd files but this of course didn't work (I guess the Data adapter & ...
Score Lookup Field Values Upon Combobox Change
Randy - 6 Apr 2007 1:44 AM - 1 message
Hi, I'm trying to get textbox values to change upon a change in a combobox selection.  I'm using the Publishers table in the Pubs sample database as a simplified example.  Here is the code: Private Sub cboPubID_SelectedIndexChanged(ByVal sender As ...
Score Multiple relation in dataset.
zb - 6 Apr 2007 12:27 AM - 6 messages
Requirement: Number of comma separated *files* (CSV) all related to each other have to be read in such a way that they could easily be read to find related data. My idea: Write a class with a method to add files which would be read split at ...
Score DB2 Connection Problem
JimHeavey - 5 Apr 2007 10:00 PM - 1 message
I am using OleDB to connect to DB2 my provided in my connection string is set to "Provider=IBMDADB2.1;". I am able to connect perfectly fine to one database on one "mainframe" box. When I attempt to connect with the DB2 database on another "mainframe" box, ...
Score Increase Connection\ Command timeout globally
sameer - 5 Apr 2007 2:02 PM - 8 messages
environment : .net framework 1.1, ado.net, visual studio 2003, vb, sqlsever 2000, winforms, webforms I want to increase the connection and command time out for all stored procs in the application which might be around 200 or more and this woudl take me ...
Score RichText in asp.net
Tomo - 5 Apr 2007 1:03 PM - 6 messages
How to use RichText in ASP.NET application. I need to make web page where user can write some text, click save and than this content must be saved as html content. Can I find some richtext control or I need to use javascript? ...
Score Adding a non unique index to a datatable
mudGil - 5 Apr 2007 9:28 AM - 6 messages
I have a large datatable in a typed dataset, on which I run the select method with three different filters.  I'm looking for a way to have three NON UNIQUE indexes so that the select method is much more eficient.  The dataset ...
Score Dataadapter and where clause.
Shum - 5 Apr 2007 8:49 AM - 4 messages
Hi! I want to restrict the selected records with a WHERE clause in dataadapter... but when i do that no rows are retrieved... Any alternatives?? Any suggestions? (using sql server 2005 and c#) .. .. .. .. while (drr.Read()) {         hosp=System.Convert.ToString(drr["HospitalName"]); ...
Score How to Create a Database When User does not have Permission
Scott - 4 Apr 2007 8:34 PM - 4 messages
This question is related to SQL Server Express SP2. When the four gig limit of an SQL Express database is approached it is desired to have another database created at run time with no user interaction. The problem is that the user running the application may not have ...
Score Yet another designer issue
SAL - 4 Apr 2007 7:24 PM - 4 messages
Bill, Thanks for helping with my last designer issue. Now, I execute the following query in the Query Builder and it returns one record: SELECT     ReportedWeeds.RID, Weeds.Name, ReportedWeeds.Density, BioAgents.BName, ReportedWeeds.Assr_SN,  ReportedWeeds.TownRange, ReportedWeeds.LotSize, ...
Score Can anyone help with Data Designer issue?
SAL - 4 Apr 2007 6:13 PM - 3 messages
Hello, Using the designer in my project, I created a DataTable for one of the tables in an Access database. I created a TableAdapter for that DataTable by adding queries. For the most part, the queries are executing correctly but ...
Score Offline Oracle Applications
daokfella - 4 Apr 2007 4:51 PM - 1 message
My client currently has a main FoxPro database at their office. I created a mobile offline winform application using FoxPro datasource tables for them. The offline application was for creating new records only and never needed a connection to the main database. It had an ...
Score adding a column to a table
David Thielen - 4 Apr 2007 4:46 PM - 8 messages
Hi; Is there a way to add a column to a table, preferably not at the end, via ADO.NET? And hopefully in a vendor independent way as I have to do this for Sql Server, Oracle, DB2, and MySql. ...
Score Performance problems with OracleDataReader
Henning Fiese - 4 Apr 2007 1:56 PM - 9 messages
Hello NG, I'm using the Oracle Data Access Components and I've encountered serious performance problems with the OracleDataReader. The following function fills the memberfields of an object with the content of a reader: internal void FillFromReader(IDataReader Reader) ...
Score Connection string / design question
Jens Weiermann - 4 Apr 2007 1:30 PM - 9 messages
Hi, I have a question regarding the handling of connection strings. I have (finally) written a data access assembly that does all the reading / writing from/to the database. Basically, this is a Dataset.xsd type thingie with all the table adapters and stuff. ...
Score ADO.NET 2.0 - Binding a Second Form to the Same Data Source
Brice - 4 Apr 2007 1:14 PM - 5 messages
He is binding a second form to a Binding Source that is being passed as a parameter.  However, he is performing all Data Bindings for the second form, manually in code.  Is there an easier way? For example, I have created a new form.  From the "Data Sources" tab, ...
Score One sheet workbook, two TABLEs in schema
Grinning Crow - 4 Apr 2007 10:48 AM - 2 messages
I'm using GetOleDbSchemaTable(OleDb.OleDbSchemaGuid.Tables, New Object() {Nothing, Nothing, Nothing, Nothing}) to get the names of the worksheets of my oledbconnection to excel 2003. In some of the workbooks, there is only one worksheet, say Sheet1, yet it the ...
Score Question about the ADO.NET Oracle Provider
fabien.molinet - 4 Apr 2007 9:34 AM - 3 messages
Hi, I have a question about the Microsoft ADO.Net Oracle Provider Sometimes (only sometimes) I get exceptions like these : ------------------------- Invalid operation. The connection is closed. :    at System.Data.OracleClient.OracleCommand.GetStatementHandle()    at System.Data.OracleClient.OracleCommand.ExecuteScalarInternal(Boolean ...
Score ADO.net 2.0 and XML web service
Peter - 4 Apr 2007 1:36 AM - 2 messages
What is the relationship between ADO.net 2.0 and XML web service?  Does it make sense to create a desktop application using ADO.net 2.0 and then enhance it later with web interface using technology like xml web service? ...
Score Multiple thread access to a single tableadapter
foolmelon - 3 Apr 2007 10:38 PM - 2 messages
Say if I have a single myTableAdapter instance has a myUpdate() function accessed by 2 threads,  is it possible to have folloiwng seneriao? 1. Thread 1 calls myTableAdapter.myUpdate(), it checks whether the connection of the table adapter is open.  If not, it opens the ...
Score 3rd Repost - Issue in Importing Excel spreadsheet into dataset
dinoo - 3 Apr 2007 4:52 PM - 6 messages
I am sorry but I am reporsting this because It was little urgent. I need some one to help me out here to understand the problem. I am trying to read an excel sheet and I am using the following connection ...
Score AS/400 OleDB provider supporting OledbSchemaGuid - HELP!
pamela fluente - 3 Apr 2007 4:24 PM - 1 message
I am looking for an OleDB provider for AS/400 which * for sure * supports well the .NET class OledbSchemaGuid. I have already seen that the IBM provider for AS/400 is unsuitable for .NET, because it does not support this class, fundamental to ...
Score SQL Stored Proc's
AMDRIT - 3 Apr 2007 3:55 PM - 6 messages
couldn't find a group just for SQL Server.  Anyone know if it is possible to retrieve the name of the stored procedure that is currently executing? What I would like to do is record usage in a table everytime a stored proc ...
Score Connection string question
Tony Girgenti - 3 Apr 2007 1:58 PM - 7 messages
Hello. Developing a web site in VS2005, SP1, VB, .NET 2.0, ASP.NET 2.0, SQL Server Express on XP Pro, SP2. In my web.config file, if my connection string looks like this: "connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Documents and ...
Score Rowchanging exception don't propagate (ado.net 2)
francesco.fantoni - 3 Apr 2007 1:29 PM - 2 messages
if i throw an exception in datatable rowchanging (using strongly typed dataset) this exception don't propagate in debug mode (at runtime it seems work instead) in details, im using vs2005 with sqlserver 2005 express and i have a strongly typed dataset with customer datatable and a form with ...
Score DB2 Connection Issue
JimHeavey - 2 Apr 2007 7:34 PM - 1 message
I am using OleDB to connect to DB2 my provided in my connection string is set to "Provider=IBMDADB2.1;". I am able to connect perfectly fine to one database on one "mainframe" box.  When I attempt to connect with the DB2 database on another "mainframe" box, ...
Score DataSet RemotingFormat and Channel formatter
Satish Itty - 2 Apr 2007 6:26 PM - 1 message
I have a application developed in .net 1.1 which uses .dotnet remoting and uses httpchannel . We use DataSets to send data between client and remote server all the time. Now we are migrating this to .net 2.0 once in a while ...
Score Post Revised: A Desperate Plea for Help
billmcintee:VB NOOBIE - 2 Apr 2007 4:12 PM - 8 messages
Can anyone give me a thorough explanation on how to use my data adapters to insert new records into a SQL database that I have connected to my app. I am very new to SQL and a little familiar with VB. The purpose of the app is to ...
Score Issue in Importing Excel into Dataset
dinoo - 2 Apr 2007 2:32 PM - 1 message
I am sorry but I am reporsting this because It was little urgent. I need some one to help me out here to understand the problem. I am trying to read an excel sheet and I am using the following connection ...
Score C# Delete Problem
Chris - 2 Apr 2007 1:42 PM - 2 messages
Using Datagridview databound: If I add two rows with data, save (using navigator), refesh that dataset, then delete the two newly added rows, then Save, everythign is OK. if I add two rows with data, save (using navigator), then delete those two ...
Score A desperate plea for help....
billmcintee:VB NOOBIE - 2 Apr 2007 8:14 AM - 5 messages
Hello, Currently, I am a spring chicken in VB and I am writing a program concerning vb.net 2003 and SQL Server 2005. This program is basically a data collection app in which collects data from a wedge scanner via barcodes. I have two ...
Score RE: GAC
rezazadeh43 - 1 Apr 2007 1:48 PM - 1 message
hi From [link] Posted via DevelopmentNow.com Groups [link] ...
Score Is there ever a reason to have a transaction around a select...
David Thielen - 1 Apr 2007 7:28 AM - 10 messages
1) that will always return 0 or 1 rows? 2) that will retun N rows? In each case where the results will be displayed to the user and so there can be changes that occur to the DB after the select completes. ...
Score Deployment issue - Error 26
Flomo Togba Kwele - 1 Apr 2007 2:34 AM - 6 messages
I am developing a forms app on a Windows XP machine with VS 2005 and also a copy of SQL Server 2005 Developer. The target environment is a dedicated server running SQL Server 2005 Standard and client machines running the VS2005-developed code on Windows XP. Initial ...
Next »