Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score Beginning question for Access OLEDBUpdate command
Dave - 18 Nov 2006 3:36 PM - 7 messages
I used the wizard in VB.NET 2003 to generate a data adapter and it created the following update command. It seems like the WHERE clause would never evaluate to true? Am I reading this wrong? The member_ID is the key for the table but it looks like the 2 statements ...
Score Migrating from MS ACCESS 97 to SSEv
Garry - 18 Nov 2006 5:20 AM - 2 messages
I am writing an application to migrate an Access 97 database file to SQL Server Everywhere database file in VB.NET I have code that builds the required tables in a new SSEv database file, "CREATE TABLE", but am stumped at not being able to detect if the Access ...
Score please help! Error in update Access database
Rabi - 17 Nov 2006 9:13 PM - 5 messages
I have been trying to update in Access Database. I get this error "Syntax error in UPDATE statement." What could be the problem or can somebody suggest different solution. I call this function from my main page. Public Shared Function UpdateScholarship(ByVal ID As String, ByVal Name As ...
Score MS Access DAO -> ADO.NET Migration
moomoofatcow - 17 Nov 2006 8:41 PM - 13 messages
I have an VB6 program that I wrote that access Microsoft Access databases using DAO. DAO has methods and properties that are Access specific (such as viewing and editing relationships or indexes  on the tables) I want to write a new version of the program in VB 2005, and I ...
Score webservice - dsn - sql server
TheMaxx - 17 Nov 2006 10:14 AM - 2 messages
I've created ODBC DSN for sql server. When i connect from win application works OK. When i make WebService (on same machine) that connects to that ODBC connection fails: Error: Server was unable to process request. --> ERROR [28000] [Microsoft][ODBC SQL ...
Score connection strings problem solution
R.A.M. - 17 Nov 2006 12:21 AM - 3 messages
[link] ...
Score Can anyone explain this: Numeric or Value Error Line 1
david.j.park - 16 Nov 2006 9:45 PM - 1 message
I have a stored procedure that starts out like so: PROCEDURE test_proc(param1 IN VARCHAR2, param2 IN VARCHAR2, param3 OUT SYS_REFCURSOR) IS v_var varchar2(5); BEGIN SELECT * FROM. . . The procedure tested fine in PL/SQL Developer.  When calling from ...
Score Problem following first example in "Programming MS ADO.NET 2.0" by David Sceppa
Ted - 16 Nov 2006 8:46 PM - 1 message
I did the example twice with two different databases (Adventure works using MS SQL Server 2005, and an MS Access database). Although the data sources I used were different than Mr. Sceppa's, the SQL Server DB (AdventureWorks) wored flawlessly while the trial using ...
Score DataAdapter for Insert
BoM - 16 Nov 2006 8:36 PM - 2 messages
Hi, I'm using a DataAdapter with sqlserver(Express) in a server app. The SQL Insert is generated with an additional Select when not checked off. How can the result of this generated select be accessed? GetData() with get all the data in the table and not the just inserted data. ...
Score 2.0: well-written sample application?
R.A.M. - 16 Nov 2006 6:57 PM - 2 messages
Hello, I am learning .NET 2.0 (C#, VB, ADO.NET, ASP.NET) and I am looking for a well designed and coded database application - prefably using SQL Server 2005 and ASP.NET. Could you give me a link to such appliacation or send me source? ...
Score TransactionScope exception handling
Darren - 16 Nov 2006 6:30 PM - 2 messages
Is there any way to have an DataReader.Read part of a TransactionScope but not cancel the transaction if the read fails? I'm using a DataReader to get the result of a stored procedure which increments a counter.  I'd like to add the read to ...
Score DataSet has no rows when proc is returning rows??
teewebco - 16 Nov 2006 6:15 PM - 4 messages
Hello, Im going insane with this problem. I have a stored proc that returns 2 recordsets to a dataset. In the dataset i reference the recordsets by their tables like below. ds.tables[0] ds.tables[1] In the first table it says their are 0 rows. The columns get populated ...
Score DaatSet has no rows when proc is returning rows??
teewebco - 16 Nov 2006 6:15 PM - 2 messages
Hello, Im going insane with this problem. I have a stored proc that returns 2 recordsets to a dataset. In the dataset i reference the recordsets by their tables like below. ds.tables[0] ds.tables[1] In the first table it says their are 0 rows. The columns get populated ...
Score Optimize DataTable Select Method
Javier Gonzalez - 16 Nov 2006 5:38 PM - 2 messages
Hi all, How can I optimize the DataTable Select Method to make it faster Can I create a Text Index Search ? Thanks alot Regards ...
Score Opening PDF document in new window on click of linkbutton column in datagrid
settyv - 16 Nov 2006 5:02 PM - 1 message
Hi, I need to open PDF document in new window when i click on linkbutton in datagrid.For that i have written code as below: But the problem with this code is that it opens the new window ,but not ...
Score BindingSource1.AddNew()
Neil Steventon - 16 Nov 2006 2:17 PM - 2 messages
Help, I have created Windows app with VS2005. I then drop the datanavigator control and bindingsource control to the form. I bind a dataset tablet to the binding source and set the navigator to the bindingsource control , all wonderfull. The Problem ...
Score MS Data Application Block
C - 16 Nov 2006 12:37 PM - 2 messages
Hi, In .NET 1.0 and 1.1 I used the Microsoft Data Application Blocks for executing Stored Procedures etc. In .NET 2.0 is there a newer version of these blocks or has the way Data Access works been changed? ...
Score Why 1990 for ShortDate
ad - 16 Nov 2006 11:49 AM - 3 messages
I use a update command to update a smallDateTime filed: Update [Checks] set Checks.CheckDate='' It udpate the CheckDate field to 1990/01/01 Why? ...
Score Concurrency violation
Dave - 15 Nov 2006 9:50 PM - 6 messages
I'm just starting to try and learn ADO.NET and was following along in Murach's VB.NET/ADO.NET book samples for typed databases with unbound controls. When I try to execute an update with the my data adapter and the data table ...
Score update values to excel data source using ADO.NET
christian.isaacs - 15 Nov 2006 9:40 PM - 2 messages
I've been able to connect to my excel spreadsheet using ADO.NET and display the data in a Datagrid.  Now I need to know how to take the values in the datagrid and repopulate the excel spreadsheet. The end ...
Score convert DataColumn.GetType() into a DbType or SqlDbType?
Chris Bordeman - 15 Nov 2006 9:32 PM - 5 messages
I have a DataColumn, want to derive the DbType.  I can do column.GetType() but that's a system type, not a db type.  How do I convert it to the corresponding type? Thanks much! Chris B. ...
Score Typed DataTable Question
Bree - 15 Nov 2006 9:28 PM - 2 messages
Someone told me that I could create a Typed DataTable WITHOUT first creating a Typed DataSet. I may be new to .NET programming, but I know that, based on what I've learned, this isn't correct. Am I right or not? ...
Score More advanced examples for the impatient "newby"
Ted - 15 Nov 2006 8:01 PM - 32 messages
Well, I've taken poetic license with "newby" having been programming for more than a couple dozen years, but I have recently started studying .NET and ADO.NET, leveraging my experience with other frameworks such as Borland's VCL, and MS' MFC, and technologies such as ...
Score changing the text of linkbutton column in Datagrid
settyv - 15 Nov 2006 7:31 PM - 1 message
Hi, I have the problem with the datagrid display. I want to change the display text of linkbutton.Please help me how can i do that. <asp:TemplateColumn HeaderText="Minute Order" >         <ItemTemplate> ...
Score ado.net connection class?
Rico - 15 Nov 2006 3:48 PM - 3 messages
Hello, I'm fairly new to ADO.net and completely new to object oriented programming. Could anyone point me to a good resource for creating specifically a connection class using VB.net and ADO.net?  If anyone could provide a code ...
Score How can I get the value of an autoincremented column when adding new rows to a DataTable?
0to60 - 15 Nov 2006 3:11 PM - 7 messages
In the following situation: System.Data.DataRow row = dataTable.NewRow(); row["someField"] = someValue; // Set some more fields dataTable.Rows.Add(row); dataAdapter.Update(dataTable); If the primary key of my table is an autoincrementing number, can I get to it from here? ...
Score How to Connect to SQL server 2005 ???
serge calderara - 15 Nov 2006 1:11 PM - 5 messages
Dear all I try to retrive a set of data from an sql server 2005 database  with VS 2003 Following code is used : m_sqlCon.Open()         m_sqlCmdObj = New Data.SqlClient.SqlCommand         m_sqlCmdObj.CommandType = Data.CommandType.Text ...
Score Slow access to data
Quina - 15 Nov 2006 12:55 PM - 4 messages
Hi, I'm building an windows forms app in C#, in wich I need to store & retrieve data. It's a very simple use of data but the to retrieve a few records, at the first time access, it takes about 4 to 5 secs (?!!). to ...
Score Best approach, Loading Tables
HLong - 14 Nov 2006 11:39 PM - 4 messages
I need to create a sqlclient app to modify look up tables on a sql dbase, there are some 8~10 tbls I think.  I have some general idias of what to do, but I have never done something like this, I am using VBExpress 2005.  I ...
Score DataColumn Expressions
Lorenc - 14 Nov 2006 9:28 PM - 6 messages
I have a typed DataSet with a DataTable where I added a column FullName that simply returns the concatination of 2 other columns FirstName and LastName. There is also a DataAdapter that returns this DataTable populated from the DataBase. If i Preview this data from the DataSet Designer, everything shows up fine ...
Score OleDbDataAdapter vs. SqlDataAdapter
CompSci - 14 Nov 2006 6:23 PM - 2 messages
I am wondering which DataAdapter to go with OleDbDataAdapter or SqlDataAdapter? We are using this in a webservice using sql server 2005 and .net 1.1 Ruchir ...
Score Urgent Please-Help me
settyv - 14 Nov 2006 5:52 PM - 1 message
Hi, How do i call the below function on click of datagrid row.I want to use hyperlink column.How do i call this function from hyperlink column in a datagrid. BLL method: public MemoryStream GetMinuteOrderPdf(SearchParams sp)                { ...
Score DataSource when using System.Data.OracleClient
hayes.seamus - 14 Nov 2006 4:53 PM - 3 messages
Hi, I am trying to connect a c# application to an Oracle 10i database. I have not worked with Oracle before. When using System.Data.OracleClient, willthe DataSource in the connection string point to a DSN on the client machine, or does it need ...
Score Random database connectivity failure
hskan - 14 Nov 2006 4:53 PM - 3 messages
Hello We have a strange problem that someone maybe could help us with. We have an ASP.NET application (NET 2.0) that uses Enterprise Library (2.0) and nHibernate (1.2.0). It’s compiled for any processor and runs in a native ...
Score update DataSet - transaction
TheMaxx - 14 Nov 2006 2:13 PM - 6 messages
I have two tables in dataset, and appropriate TableAdapters. How can i update both tables, but in transaction? I other words: THIS: MyDSTableAdapters.Table1TableAdapter a1 = new ... MyDSTableAdapters.Table1TableAdapter a2 = new ... a1.Update(dt1); a2.Update(dt2); but where to put transaction ? ...
Score Another question about memory : System.IO.StringWriter and Dispose
fabrice - 14 Nov 2006 1:32 PM - 7 messages
Re hello, I m' sorry for my questions .. Under framework 1.1 with vb.net, i m using a StringWriter object to export in .xls file. To empty memory, I would like to use the propterty dispose on the object ...
Score Strange problem reading Excel (xls) file with OleDB
globus2410 - 14 Nov 2006 12:13 PM - 4 messages
Hi , I was looking for how to read an excel (xls) file when i thought to use ado.net. This is my code :                System.Data.OleDb.OleDbConnection dbConnection =new ...
Score Handling multiple calls to sql2005 inside TransactionScope
Carlo Folini - 14 Nov 2006 11:31 AM - 1 message
Hi, I'm developing an helper object to connecto to sql2005. A problem arise when I'm trying to use transactions. Say that I have this object structure BusinessMethod       - DataAccessMethod1 -> sqlHelper       - DataAccessMethod2 -> sqlHelper ...
Score Rows filtered out by a BindingSource
Malhavoc - 14 Nov 2006 10:36 AM - 1 message
Using the .select method of DataTable I can filter out a row who match certain criteria, and I make it the current one on the datagridview which display that datatable. However the datagridview does not bind directly to the datatable, but ...
Score Bulk Copy Fail
ad - 14 Nov 2006 5:08 AM - 3 messages
I use SqlBulkCopy to write a DataTable into a table of a database, but it fail with message: Can not convert a string type of datasource  into bit type of Destination Table. I want to know which filed cause the problem. ...
Score How to deal with 'text' columns in ADO.NET
Paul Bradshaw - 13 Nov 2006 10:03 PM - 4 messages
From what I can tell, when I "fill" a DataTable with a table that contains 'text' columns, I have no way of distinguishing these columns from regular nvarchar(x) columns.  Does it truncate the values returned to 8000 characters?  Or is the full text loaded? ...
Score How many datatable/adapter should be put in a DataSet?
nkw - 13 Nov 2006 9:56 PM - 3 messages
What's the best practise to put DataTables in DataSet designer? Should it be partitioned by Business Logic Layer or one for each database table? or something in between? Thanks, ...
Score DeriveParameters
Chuck P - 13 Nov 2006 9:06 PM - 10 messages
I understand when I add a paramete like (name, value)    p = new SqlParameter("@someINT", 111); that behind the sceens, a trip to the db is made to derive the parameter. When creating a parameter what values must be specified to prevent the trip ...
Score Get SqlDbType
Chuck P - 13 Nov 2006 6:45 PM - 4 messages
Is it possible to get a SqlDbType from a string? like:   SqlDbType  myType = Type.GetType("SqlDbType.int"); You can do this for framework types but couldn't figure out how to do it for sql types. thanks, ...
Score Connect to Oracle
adodotnet20 - 13 Nov 2006 3:56 PM - 3 messages
Is there a way to connect to an Oracle server in remote from a win app, through OracleClient or OleDb without having to install the client runtime on the user machine? ...
Score Help - Dataset.Getchanges(DataRowState.Deleted)
Neil Steventon - 13 Nov 2006 3:13 PM - 9 messages
Hi All, I can get values from a dataset that have been changed by using the following ; Dim tempDataSet As DataSet = _        dataSet.GetChanges(DataRowState.Modified) but I want deleted rows. So I try ...
Score Multiple Database Transactions
Tom - 13 Nov 2006 3:01 PM - 2 messages
Using fw 2.0.... Any ideas on how (if at all) to use a single transaction scope against 2 (or more) database connections..??   My app interacts with SqlServer, and Oracle, using OleDB model for DB i/o.  ...
Score Slightly OT - Addressable Data Sizes?
xeroxero - 13 Nov 2006 2:25 PM - 5 messages
Jet/MDB has a limit of 2gb per database. Visual FoxPro has a limit of 2gb per table. SQL Server has no size limit. Can anyone explain why the first two databases have limits? Is there something related to their ISAM nature that limits them? ...
Score Dataset WriteXML aborts
Ralf Mayer - 13 Nov 2006 10:20 AM - 1 message
Hello! I did search for this one quite a while, but I cannot seem it mentioned anywhere else... so let me ask here if someone saw this problem before. The behaviour is confirmed several times with Framework Version 1.1 (with all ...
Score Is there an easy way to copy a DataRow object for use by the DataAdapter.Update method?
Jen - 13 Nov 2006 5:30 AM - 2 messages
I need to copy a DataRow because I can't use the "donor" DataRow for the DataAdapter.Update because it throws the "this row already belongs to another table" exception.  Is there an easy way to create a new DataRow from ...
Score DS.RejectChanges
Ant - 13 Nov 2006 2:21 AM - 5 messages
VS2003 C# Hi, I have a list box showing the 'master' records & a datagrid displaying the 'details' of the master records. These are databound to a dataset. I'm trying to use the  RejectChanges method to remove rows that I've added. ...
Score Two questions about moving data between a SQL DB and XML
Jen - 13 Nov 2006 12:34 AM - 9 messages
1)  I am exporting data from a SQL DB to an XML file.  It works great but it appears that null data in database records does not get put into the XML. Is there a way to force  it to always put the null data there instead of ...
Score using ENTER key to move to the right cell datagridview
Scotty - 12 Nov 2006 7:01 PM - 1 message
Hi, Can someone help me for next problem How to for using ENTER key to move to the right cell instead of the TAB key Many thanks in advance Marc. ...
Score using ENTER key to move to the right cell datagridview
BisterBooster - 12 Nov 2006 6:52 PM - 2 messages
Hi, Can someone help me for next problem How to for using ENTER key to move to the right cell instead of the TAB key Many thanks in advance Marc. ...
Score Inconsistent behaviour of System.Transactions
Matthijs ter Woord - 12 Nov 2006 1:32 PM - 1 message
Hi, I'm working on an opensource project, which encapsulates System.Transactions. (and does many other things...). See [link] The part which covers Transactions is tested for 96%. When running the tests ...
Score Select statement in Asp.Net project?
ARTMIC - 12 Nov 2006 6:04 AM - 5 messages
I have the following code on my pageLoad event:             taComp = new dsCompTableAdapters.CompTableAdapter();                    dtComp = new dsComp.CompDataTable(); ...
Next »