Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Troubles connecting with VMWare?
Bryce K. Nielsen - 24 Jun 2006 8:33 PM - 4 messages
Anyone use ADO.NET 2.0 connecting to a SQLServer through VMWare? We're getting strange, sparatic connectivity issues when we execute commands. Here's a short list of errors: - A connection was successfully established with the server, but then an ...
Score Error: The SqlDbType enumeration value, 4, is invalid.
Ben Fidge - 24 Jun 2006 1:22 PM - 4 messages
Hi I'm getting an error which says "The SqlDbType enumeration value, 4, is invalid." when calling one of my stored procedures. The SP doesn't actually take any parameters and my C# code doesn't attempt to pass it any. ...
Score Bussiness logic code
mjamala - 24 Jun 2006 3:30 AM - 4 messages
Hi Team, can anybody explain me how to organize the bussiness logic code in web service in relation to the actual asmx code behind? Thanks ...
Score Earn Honestly...Learn job skills
ammulu - 24 Jun 2006 1:59 AM - 1 message
All professionals, Take Note. Start your own firm or quickly get a job in a MNC, and start earning from today. Announcing "Application Series" of Books for the ERP Domain. Benefits of these books:    1. Become an Expert in Programming in a fortnight. ...
Score Earn Honestly...Learn job skills
ammulu - 24 Jun 2006 1:56 AM - 1 message
All professionals, Take Note. Announcing "Application Series" of Books for the ERP Domain. Benefits of these:    1. You can Start your own software firm.    2. Get a Job in Top MNC companies.    3. Work from home and provide data services to firms around you. ...
Score Asynchronous access to database using ADO.NET 1.1
Romio - 24 Jun 2006 12:03 AM - 2 messages
Hi i am using sql server 2000, i want to access the database asynchronously from a web service  using ado.net 1.1 i know there is Begin/End ExecuteNonQuery method in ADO.NET 2, but how can i achieve the goal using 1.1 framework. ...
Score Retrieve GUID on/after insert?
Patrick Bates - 23 Jun 2006 9:25 PM - 16 messages
I need to write a row into a SQL Server table, and then immediately retrieve the GUID which is generated for that row (it is the primary key).  I can't seem to find a way to do this with DataSets and DataAdapters, so I'm sure ...
Score Error during postback of web page related to SqlClient.SqlParamete
masmith - 23 Jun 2006 9:01 PM - 5 messages
I have a component in a ASP.NET 2.0 application trying to update a table in a SQL 2005 database.  From the trace below the problem appears to be within a internal methods in the framwork. I have already found that the framework does not handle timestamps very ...
Score Update Dataset oleDB
Mark Sandfox - 23 Jun 2006 8:08 PM - 1 message
Here is my code: Dim wwtID as integer Dim wwtEmailAddress as string Dim drEmailListWWT as System.Data.DataRowView Dim dvEmailListWWT as DataView Dim cnEmailListWWT as OleDbConnection Dim daEmailListWWT as OleDbDataAdapter = New OleDbDataAdapter Dim dsEmailListWWT as DataSet = New DataSet Dim SelectStatement as String ...
Score Multicolumn UniqueConstraint in typed dataset/datatable - How to implement?
Marcus - 23 Jun 2006 5:08 PM - 2 messages
I am trying to create a unique constraint for a typed datatable for multiple columns so the same group of values will not appear more than once for any one row (I can't make this group of columns a composite ...
Score [ANN] FirebirdClient v2.0 released.
Carlos_Guzmán_Álvarez - 23 Jun 2006 3:02 PM - 1 message
Hello: FirebirdClient v2.0 for Microsoft .NET 2.0 and the equivalent Mono version is available for download. Download information can be found here: [link] ...
Score refreshing datasets
Mark - 23 Jun 2006 1:30 PM - 9 messages
Hi, I am using VS.NET 2005 with SQL Server 2000. I have a Dataset that contains a DataTable that is populated using DataSet.Fill(). I need to periodically refresh this data. If I just do .Fill() again, I end up with issues of the DataGrid losing it's ...
Score problem with passing parameter
André - 23 Jun 2006 12:39 PM - 1 message
Hi, I made a detailsview for inserting data in the table. I also made a dropdownlist which the selected value must be used for one of the field in the detailsview. In the <InsertParameters> tag, i removed the parameter 'lo' because i added ...
Score No value given for one or more required parameters
André - 23 Jun 2006 10:51 AM - 1 message
Hi, I made a detailsview for inserting data in the table. I also made a dropdownlist which the selected value must be used for one of the field in the detailsview. In the <InsertParameters> tag, i removed the parameter 'lo' because i added ...
Score run database jobs on button click
ads - 23 Jun 2006 2:38 AM - 3 messages
hi, does anyone have an idea how to access and run scheduled jobs in sqlserver database using just a button click?can anyone point me to the right resources. Thanks, Ads ...
Score how modify table adapter update and insert
fanor - 23 Jun 2006 1:44 AM - 4 messages
I generated using the designer  the fill and GetData methods for a table, including  delete, insert, and update. I want to customize the insert and update command. How can i do that?? I tried from the designer but I couldn't figured it out. ...
Score table adapter fill problem
fanor - 23 Jun 2006 1:39 AM - 4 messages
i have a table with a GetData(Param1) method that has this select SELECT     empid, firstname, lastname FROM         employees WHERE     (empid NOT IN                           (SELECT     empid ...
Score Closing Connections
tshad - 22 Jun 2006 11:59 PM - 17 messages
I am confused on whether a connection is open or closed. I was told you didn't have to close a connection if you were binding to DataGrids, DataReaders, DropDowns etc - that they would close them themselves. Is this the same for both the DataAdapters and DataReaders? ...
Score dbcommand verssus sqlcommand
klumsy - 22 Jun 2006 8:25 PM - 2 messages
I am using the enterprise library for ado.net 2.0, and we are working out whether we should use the sqlcommand or dbcommand etc. If you are using a dbcommand, is it being serviced through the OLEDB provider or ...
Score How to change the connection string of a TableAdapter
ad - 22 Jun 2006 7:44 PM - 3 messages
I am useing the the TableAdapter of VS2005. I copy a DataTable form one project to another project. The connection strings in the two projects is different. I want to change the connection of the TableAdapter to the one of the new ...
Score Web Applications and Oracle
-JF- - 22 Jun 2006 6:15 PM - 2 messages
Hi there!, I'm developing an application in asp.net and Oracle, but I have the following problem, and is that the number of Sessions that connect to the databases from my app growing and growing until the database displays an ...
Score Connection issue
Earl - 22 Jun 2006 5:34 PM - 4 messages
Scenario: I have 2 apps, one VB6, one VS2003 (VB.Net). From the same workstation, on the same LAN, the VB6 app can connect to the SQL Server (running on an XP Pro box), but the VB.Net app cannot. Connection strings ...
Score Help-Joining two tables from two Access databases
Roy - 22 Jun 2006 5:07 PM - 2 messages
Hi all, What is a good way to Join two tables from two Access databases in dotnet? Thanks in advance, Roy ...
Score DataSet - GetChanges() and Merge() Questions
JimHus - 22 Jun 2006 3:36 PM - 4 messages
I need to collect a "delta" between two Datasets: DS1 and DS2. DS2 was created from DS1. We cannot use/rely on RowState because of the operations involved in generating DS2. Essentially all rows/columns are deleted and most are ...
Score DBFactory and Oracle Cursor
John Wright - 22 Jun 2006 3:25 PM - 2 messages
I am trying to create a generic DAL and I am almost there.  I can query the Oracle Database without any problem using straight sql, but when I try to call returning a cursor I get the following error: ...
Score Connection Pooling and Preparing Commands
Joanna Carter [TeamB] - 22 Jun 2006 3:17 PM - 8 messages
Hi Folks ..NET 2.0 and SQLServer2005 I am just trying to get my head around whether I can use a single SQLConnection for the life of the application or whether I should create it only when needed. I want to create cached SQLCommand objects that are then prepared to reduce ...
Score Safe way to close an SqlDataReader?
Bryan - 22 Jun 2006 2:23 PM - 7 messages
I'm sure this is a basic question, but I'm just not getting it. I'm using a Try / Catch block to surround my database access code.  For example: Try   cmdDBCommand = New SqlCommand("dbo.GetMonthlyBilling", oConnection)   cmdDBCommand.CommandType = CommandType.StoredProcedure ...
Score Access db fails to display data in datagrid after db exceeds 600k
glenn - 22 Jun 2006 12:10 PM - 1 message
Hi folks. My access db displays data into my datagrid control as designed until the db exceeds 600k in size.  The data is inserted into the db from my web form aspx page.  It continues to insert data into the db after it reaches 600k but ...
Score Enterprise Library June 2005 VS 2003
Rizwan Ahmed - 22 Jun 2006 11:59 AM - 1 message
Hi, We are working with Enterprise Library June 2005 Release. Now, we need to Encrypt our data configuration file for the production enviornment. All things seems to be working fine, but an issue arises when we generate a file key from one machine it does'nt run on the other machine with the same key ...
Score Reading and writing to DataTable question
J055 - 22 Jun 2006 11:26 AM - 3 messages
Hi If I fill an untyped DataTable from my SQL stored procedure to present into some web form for manipulation, how should I write the updates back to the DataTable for saving to another insert procedure? Should the schema be stored in memory somewhere? It would be nice to have it ...
Score A query runs 10 times slower from a .NET application the from Query Analizer
Boaz Ben-Porat - 22 Jun 2006 11:12 AM - 2 messages
Computer: 3.4 Ghz CPU, 1 GB RAM, 2003 Server database : MS SqlServer 2000 Enterprise. ~ 10 GB database file. Largest table in the database contains 11,000,000 records. Framework: .NET 2.0 I try to run a query against the database, selecting aggregated data from ...
Score datagrid operation
sai - 22 Jun 2006 4:31 AM - 2 messages
hi friends,                I am working on datagrid in windows application, I need to retrieve row from datagrid whenever I double clicked on it . so plz suggest ...
Score Designer Generated Code
Jessard - 22 Jun 2006 4:18 AM - 3 messages
Hi All, Does anyone know how to modify the rules visual studio (or the designer) uses to generate it's dataset, datatable, datarow, datatableadapter classes when you use the wizard to generate a strongly typed dataset from a database table/stored proc?  I want the code that it outputs to be slightly modified.  ...
Score Retrieving output params from stored procedure?
Djimbo - 21 Jun 2006 10:33 PM - 2 messages
Hi, for example on the follow procedure: create procedure myproced @id int as begin   select name,country from mytable where id=@id end i want to retrieve the output parameters from a stored procedure using sqlserver, the DeriveParameters only returns me the input param "@id", but i need ...
Score Insert Null Date
ann - 21 Jun 2006 9:46 PM - 4 messages
How do I insert a null date into sql 2000?  I tried this: DateTime expireDate =                 (txtExpDate.Text.Trim().Length <= 0) ? DateTime.MinValue : DateTime.Parse(txtExpDate.Text); ...
Score SqlCommand which INSERTS and then SELECTs single value
Edward Diener - 21 Jun 2006 6:52 PM - 3 messages
I want to do an SqlCommand which INSERTs a row with an Identity column and then SELECTs the single identity column with a SELECT ID from MyTable where ID = SCOPE_IDENTITY(). The CommandText consists of the INSERT followed by and separated by a ; from the SELECT. Does using the ...
Score Re: Connection to ORACLE: Need some explanations
tommaso.gastaldi - 21 Jun 2006 6:35 PM - 7 messages
Hi Paul. The Oracle client is installed because it has been installed on purpose for the connection and I have seen it being installed by the administrator. Note that the msdaora does not behave like if it were a full client, ...
Score How to: Query/Subquery against 2 datasets within application?
Tuna Fly - 21 Jun 2006 6:01 PM - 3 messages
I'm writing a .NET 2.0 windows forms application to do Phone maintenance. I have 2 databases that exist on separate database servers, Employees and Phones. They both use a common key, EmployeeNumber. I have been using a subquery approach to populate a combo box with the Employees not in the ...
Score Connection string for InterSystems Cache ODBC driver
Ronaldo Nascimento - 21 Jun 2006 4:34 PM - 2 messages
I want to form an ODBC connection string in C#. I know how to plug all the connection data into the ODBC Data Source Administrator, but want to do it programmatically. I assume it is something like: provider=InterSystems ODBC; host=127.0.0.1; port=1972; namespace=JDKKR; ...
Score Problems with Dataset
SEGACO - 21 Jun 2006 4:33 PM - 2 messages
Hi, I'm trying to use a DataAdapter with a complex query (in Oracle) to fill a Dataset, but the DataAdapter don't accept it, then I try to create the Dataset manually with the same fields that the query returns in the Designer ...
Score Trasaction and dataset
flavio - 21 Jun 2006 1:21 PM - 3 messages
hello i would like to know a information i've a form made to insert a new record in my database the ID is calculated as a result of max of existing record and than add by one (but in this ID there are other data is not a simple counter) ...
Score Connection to ORACLE: Need some explanations
tommaso.gastaldi - 21 Jun 2006 12:16 PM - 6 messages
Hi I have a question: I have been connecting to oracle on my own machine successfully by using either one of the 2 following:                        Me.ConnectionString = _ ...
Score Insert into Empty table problem
sun919 - 21 Jun 2006 11:29 AM - 5 messages
hi there, I have problem regarding insert data into empty table. i have two fields which is religionID and ReligionName i have try to insert data that generate use @@identity inorder to find and create id no. and it still doesnt work and i have try to do insert and update ...
Score Image Data retrieve from MSSQL200
ken - 21 Jun 2006 9:50 AM - 4 messages
Hi All, if I use MSSQL200 to store bitmap/image  files using datatype "image" how can I retrieve from DB and shown in my window forms (VB.NET 2005), and how can I save/upload those files into DB!? ...
Score Unexpected update to Access DB when using a Strongly Typed Dataset
Jim Parsells - 21 Jun 2006 5:31 AM - 1 message
I am working with a Strongly Typed Dataset which I Fill from an Access2000 DB. I am using VS2005 and VB.Net.  Perhaps I am missing something, but the observed problem is: Given a sub-set of Rows from a Table in that Dataset, code in the following ...
Score Datagrid help needed
Keith - 20 Jun 2006 9:01 PM - 6 messages
Can someone try and explain detail to me of how they would begin to tackle the following scenario: I would like to display two EDITABLE datagrids: 1.  The "master grid" - contains people's information - name, title, job description, etc.  Some of these columns will be IDs to other lookup-type ...
Score sqldatareader
Jeremy Chapman - 20 Jun 2006 8:52 PM - 3 messages
The most efficient way to get a recordset out of sql server is probably by using a sqldatareader.  I want to make a generic class that I can populate with data from a datareader (an extremely slimmed down datatable, with less ...
Score Concurrency violation and DateTime
Jim Brown - 20 Jun 2006 7:23 PM - 14 messages
I’m trying to design a front end program in VB.NET for a MS Access database. I’m getting Concurrency Violation errors when updating if there is a DateTime field in my table that has been edited in Access. Seems to be when there is a ...
Score saving null to nullable fields in typed dataset??
Kevin Yu - 20 Jun 2006 5:37 PM - 1 message
hi all, when passing null to the nullable parameter in the typed dataset table adapter, an exception is thrown saying "nullable type must have a value". is it a bug in ado.net 2.0? thx Kevin ...
Score Query runs slow from web app, but not from management studio
Jeremy Chapman - 20 Jun 2006 4:30 PM - 9 messages
This is odd,  when I run a stored procedure from query analyzer or sql server management studio my results return within about 3 seconds.  but when I run the same query from my web app I get sql timeouts sometimes and other ...
Score datatable write to xml file - visual studio 2003
Orr - 20 Jun 2006 3:17 PM - 5 messages
hi can anybody pls help me? i am trying to write a datatable to xml file in visual studio 2005 it goes like this: datatable dt = new datatable(); dt.writexml(saveFileDialog1.FileName); in visual studio 2003 dt doesn'n have this property "writexml" ...
Score Adding row to DataTable which has Sql Server identity column type
Edward Diener - 20 Jun 2006 12:51 PM - 5 messages
If I call NewRow() for a DataTable and add a row with an Sql Server identity column, whose value I set to null before calling DataTable.Rows.Add, does the identity value get created immediately in the new row of the DataTable ? If so, how do I determine the value of ...
Score A professional approach and customized solutions for business of all sites.
arvyly - 20 Jun 2006 10:19 AM - 1 message
A professional approach and customized solutions for business of all sites. Professional web design and other web development services is what Wicked Innovations specializes in, from complex integrated solutions for business and advanced multimedia products. We offer affordable prices, a professional approach and customized solutions for business ...
Score Detect when user modifies a value in a bound textbox
James Minns - 20 Jun 2006 8:37 AM - 5 messages
Hi, I have a form which views exactly one record from a dataset. It uses a BindingSource and has bindings linking several textboxes to the data. I would like to enable / disable the "Close" "OK" and "Cancel" buttons on the form according to the row status; What is the best way to do this?  I ...
Score Using a network path not working
Mike - 19 Jun 2006 7:23 PM - 7 messages
Hi all, I have a vb.net program running as a service that uses a network path to query a file. If System.IO.File.Exists(fpath & "\" & filename) Can anyone tell me why the above isn't working? When I place it in a none ...
Score Connect to SQL Server 2005 on a server in a workgroup
BobRoyAce - 19 Jun 2006 5:04 PM - 2 messages
NOTE: This is a modified repost of [link] I have a bunch of lcient PCs that are primarily running Windows XP and Windows 2003 and they all belong to the same workgroup. In addition, I ...
Score Connecting to SQL Server 2005 on a server in a workgroup
BobRoyAce - 19 Jun 2006 5:00 PM - 9 messages
NOTE: This is a modified repost of [link] I have a bunch of lcient PCs that are primarily running Windows XP and Windows 2003 and they all belong to the same workgroup. In addition, I ...
Score IDispatch Error #3127 when executing InsertSQL statement
Ganga Sridhar - 19 Jun 2006 1:52 PM - 1 message
Platform : Windows2000, XP, Microsoft Visual C++ .NET (Version 7.1),  MS Access (Office 2003), ADO Hi, Through my application I need to create a complete database using a source database and copy the data from it. I am achieving this by ...
Score MS Access Security
JosephByrns - 19 Jun 2006 1:04 PM - 4 messages
Can someone please advise me on Access security (generally I use SQL Server, where security is much more straight forward to set up). I have an Access db with users setup using Tools->Security->User and Group Accounts. ...
Score Do I need to close DataReader explicitly?
Matt - 19 Jun 2006 1:02 PM - 5 messages
If I close the connection, would the reader already open on the connection be automatically closed without explicitly closing the reader?  I have an ASP.NET app that on a daily basis generates 'there is already an open DataReader ...' exception. I search the code to see where I am calling a ...
Score Newbie Question from former DAO user --> my.settings and ConnectionString
Andre Rode - 19 Jun 2006 12:22 AM - 3 messages
Hi NG, I was working with VB6 and DAO till now, I'm trying some first steps with VB.NET 2005 and ADO.NET and some questions came up to me first: I defined in "My Project" - "Settings" a Connectionstring, ...
Score How to return counter value from MS Access
Henke - 18 Jun 2006 9:50 PM - 2 messages
Hi I'm using VS 2005 and TableAdapters to manipulate data in an Access 2003 database. For id-values i use a counter field in Access. How can the value of the id-field of the newly created row be returned? ...
Score DataAdapter and inserting into a table with a AUTO Counter field?
David - 18 Jun 2006 8:17 PM - 4 messages
When using a DataAdapter to insert new records into a table, can ADO obtain the value of a AUTO Counter field, eg. one generated by the database, and place it back into the datatable/row during the insert? The only way I can see to do this is to insert the information and ...
Score Help with: odbcdataadapte and update command
David - 18 Jun 2006 3:50 AM - 2 messages
I am having an issue with generating update command in a odbcdataadapter with VS 2003. (Eg dragging the table from the server and dropped on a form). The table has a primary key, but it does not appear to see the key or ...
Score ConnectionStringBuilder: Automatic quoting problem
Michael Russell - 18 Jun 2006 2:07 AM - 2 messages
I've got a form that allows the user to enter the information to build a connection string for various data connection types.  I've run into a problem testing the ODBC for a dsn-less connection, using a MS Access ...
Next »