Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score LLBLGenPRO help
Anders K. Jacobsen [DK] - 8 Jan 2005 2:51 PM - 3 messages
(I hope its ok to ask here else please guide me en the right direction :) ) I want to use the getMulti with a RelationCollection so i can filter on related tables, a PredicateExpression wich specifies the filter expression on the related entity AND a prefetchPath wich i need so i dont get extensive ...
Score cannot contain a null value because the required property for this field is set to true.
gaffar - 8 Jan 2005 2:21 PM - 2 messages
Hello Sir, The below functionality is used for the database and table creation but while entering data in the tables from the textboxes if i left any textbox empty i am arising this error message. please give some piece of help where ...
Score cannot contain a null value because the required property for this field is set to true
gaffar - 8 Jan 2005 2:04 PM - 2 messages
Sir, I used this below code for the ms access database and tables creation  but if the table contains  20 fields and i would like to store 10 fields only then i am getting this error. error meesage: ...
Score difference between typed dataset and dataset ?
mirage83 - 8 Jan 2005 3:43 AM - 7 messages
hi , I want to know what the difference between a typed and untyped dataset is? suppose i use the generate dataset option in VS.NET data menu  to build a dataset and  then fill it using a data-adapter will it be a typed dataset? If ...
Score How to access SQL Server on another domain with Windows authentica
CyberDigger - 7 Jan 2005 10:51 PM - 5 messages
I have two computers, client and server.  The client is running Windows 2000 Professional and is in a workgroup, say "MyWorkgroup".  The server is running Windows Server 2003 Standard Edition and is in a domain, say "MyDomain".  ...
Score Please help!! How to get parameter back in ADO.NET
nashak - 7 Jan 2005 8:50 PM - 10 messages
Hi, We are not using Stored Procedures. I need to get back the value of the primary key (ID) field of the table once I've inserted a new record. I have a Insert statement as follows: cmdInsertStudy.CommandText = "Insert into " & TableName & "(" & _ ...
Score Mapping oledb data to odbc target
Josef Schneider - 7 Jan 2005 7:48 PM - 2 messages
Given: Data.oledb source, and a Data.odbc target The oledb data is read into a dataset. (1) Is there an easy way to copy that dataset to the target datasource ( I can look through the dataset and do INSERT statements, but is there a ...
Score VB Ado.net timing issue
dkalsow - 7 Jan 2005 7:33 PM - 4 messages
Good Afternoon, I get the following error when trying to add a record to and access table: An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll.  The code runs fine as long as I wait a second or two ...
Score Start preperation for MCSD .Net
Aseem Cheema - 7 Jan 2005 6:40 PM - 3 messages
Hey , I am planning to do MCSD .Net. I am relatively new to .Net. I would prefer to do it on C# track. Can someone please suggest me a starting point. Aseem ...
Score Duplicate fieldnames in Datareader
Beren - 7 Jan 2005 6:37 PM - 4 messages
Hello, I have an sproc to query a couple of tables, that have the same fieldnames, for example DateCreated. ------------------------------------- Select a.* , b.* From tablea a Join table b On b.keyfield = a.keyfield ------------------------------------- Now table A and B both have a field called "DateCreated", and I need both ...
Score ADO.NET Loop or SQL SERVER SP and Cursor for Complex Processing?
Rupang - 7 Jan 2005 6:29 PM - 3 messages
Hi, Scenario is; while developing a Web Application based on ASP.NET/C# and SQL Server 2K, usually we need to have a complex processing which requires multiple looping operations apart from math calculations! So which is the best approach to encapsulate the Logic in? ...
Score How to write into one table while reading from another?
Leonid Raiz - 7 Jan 2005 6:07 PM - 7 messages
Group, I am relatively new to ADO.NET and am trying to figure out how to do the following. I established OleDbConnection and now need to read all records from one of the tables. For every record in first table I need to insert ...
Score FillSchema works on one machine but not another???
Gerry - 7 Jan 2005 5:55 PM - 4 messages
I develop my ASP.NET application on a Windows XP (SP2) computer with MSDE (SP3) My application server is a Windows 2000 Server (SP3) computer with MS SQL 2000 (SP3) My code looks like this: Dim daRoom As New SqlDataAdapter("Room_Select", myConn) ...
Score Please help ADO.NET issue
nashak - 7 Jan 2005 3:30 PM - 6 messages
I have created a select statement and then used commandbuilder to generate other statements. However, I have landed with an issue that MSDN says cannot be handled. The table in my datasource created a identity value when a new row is inserted and I cannot get the value of ...
Score Storing data in DB field as XML (varchar field)
Curtis Justus - 7 Jan 2005 3:16 PM - 4 messages
Hi, I didn't quite know where to post this, so I figured I would start here. I am trying to look at the pros and the cons of storing XML in a single field of a database table.  Here is a sample structure: ...
Score new to vb - is this code ok ? - retrieving ID from SQL stored procedure
luna_s - 7 Jan 2005 1:06 PM - 2 messages
i've been playing with this code to return an ID on an insert - it seems a little dirty/hacky to me stored proc goes something like this (ive stripped out uneccesary sql code - the proc works fine) :- CREATE PROCEDURE uipersonal ...
Score Strange schema behaviour
scbate - 7 Jan 2005 12:07 PM - 2 messages
I have a schema that defines some tables. Table1 say, has columns A, B, C, D and E I would expect that when I create Table1 that the columns would be in the order specified i.e A,B,C,D,E. ...
Score system.data.odbc.dataadapter fill bug? (framework 1.1)
Candida - 7 Jan 2005 10:01 AM - 2 messages
Does anyone know of a bug within the fill method of the odbc data adapter. I can get data but when I go after a query which returns 2 resultsets I get an object reference is nothing error.  It ...
Score timestamp insert / update only stores date
David A. Schramm - 7 Jan 2005 3:06 AM - 3 messages
When I assign a DateTime value of Now to an MS Access Date/Time field, only the date is stored.  Anyone have an idea regarding how to get the whole timestamp stored other than changing the SQL from an input parameter (?) to ...
Score "transactions" on a DataSet object
cyourch - 6 Jan 2005 11:14 PM - 6 messages
Hi, What I want to do is to somehow start a "transaction" on a DataSet object. Once the "transaction" is started I will be making changes to the DataSet. If the user wants to save the changes then I essentially don't need to do ...
Score filtering the data collected in DataReader
Doug Zody - 6 Jan 2005 11:05 PM - 3 messages
I am populating the data into a datareader. After populating the data, can I filter the data through code, just like applying WHERE criteria TO THE QUERY. I am using .Net Framework 1.1 Thanks, Douz ...
Score ERROR: Invalid Object Name
chofra03 - 6 Jan 2005 9:29 PM - 3 messages
Hi, I'm currently trying to retrieve information from a specific table within a SQL Database using the following code: Dim oSqlCommand As New SqlClient.SqlCommand oSqlCommand.CommandType = CommandType.Text oSqlCommand.Connection = mSqlConnection oSqlcCommand.CommandText = "SELECT * FROM SOMETABLE" Dim oSqlReader As SqlClient.SqlDataReader ...
Score Writing a dataset to XML via a datadocument only writes one record?
James Ankrom - 6 Jan 2005 8:42 PM - 2 messages
Why does writing a dataset to XML via a datadocument only write one record?     Dim DatasetXML As New System.Xml.XmlDataDocument(mDataset)     DatasetXML.Save("c:\\temp\\xmldoc.xml") I have 4 tables and lots of data. dataset.writexmlschema writes a schema. ...
Score Session State and Behavior of DataView
W.G. Ryan eMVP - 6 Jan 2005 8:31 PM - 5 messages
I've found something that's really befuddled me.  I'm storing a DataView in Session state and when I call Delete on it (and I'm NOT calling AcceptChanges on the underlying Datatable) - it's reducing the rows count: ...
Score ADO.net Book
Jim - 6 Jan 2005 6:38 PM - 6 messages
Can anyone recommend a good book for ADO.net. I am a experienced VB-dao programmer. I am having trouble trying to accomplish simple tasks with ADO.net such as moving through a dataset. (eg. VB6 movenext, moveprevious) I also am having trouble accessing a specific field in the database. I know ...
Score Refresh update, select, and insert command parameter lengths in a dataadapter...
hyper_x_43 - 6 Jan 2005 5:17 PM - 3 messages
Hey guys, I have this column 'ShipmentEmail'.  Its 80 characters...  So, all the ins, upd, and sel commands have this parameter with length 80 chars. The user says 'Bump the length of this field up dammit...', so I go and ...
Score Refresh update, select, and insert command parameter lengths in a dataadapter...
hyper_x_43 - 6 Jan 2005 5:16 PM - 5 messages
Hey guys, I have this column 'ShipmentEmail'.  Its 80 characters...  So, all the ins, upd, and sel commands have this parameter with length 80 chars. The user says 'Bump the length of this field up dammit...', so I go and ...
Score Static Vs Instance Data Access Methods
michaeltours - 6 Jan 2005 3:57 PM - 4 messages
I've just finished writing a Data Access Layer for an n-tiered web application. However, a lot of the online literature I read whilst reading up on ADO.Net, espeially Microsoft Literature, had many code examples where the Execute methods were Static. Whilst I understand the basic principles and differences between Static and instance, I'm not sure what benefit one gets from using static methods for Data access ? Can anyone explain ? Thanks Mike ...
Score SqlExeption: Invalid object name 'TABLE'
chofra03 - 6 Jan 2005 3:47 PM - 4 messages
Hi, I'm using the following command to access information on a SQL Database and everything works fine. Dim oSqlCommand As New SqlClient.SqlCommand oSqlCommand.CommandType = CommandType.Text oSqlCommand.Connection = mSqlConnection oSqlCommand.CommandText = "SELECT * FROM TABLE" Dim oSqlReader As SqlClient.SqlDataReader ...
Score how to retrieve informatin from deleted row?
Ansari - 6 Jan 2005 11:38 AM - 5 messages
hi all, I have some deleted row in datatable and I want to process these rows following is the code:             With cmdDel                 dim drs() as datatable = dtDetail.Select(Nothing, Nothing, ...
Score Using a connection opened by another application.
ajitgoel - 6 Jan 2005 9:50 AM - 2 messages
Hi Everyone; I have a application (application 1) which is connected to a sybase database. I have another application (application 2) which will be issuing sql commands on the same database. However when I try to open a connection against the same database, I get the error "Request to ...
Score Using a connection opened by another application.
ajitgoel - 6 Jan 2005 9:50 AM - 4 messages
Hi Everyone; I have a application (application 1) which is connected to a sybase database. I have another application (application 2) which will be issuing sql commands on the same database. However when I try to open a connection against the same database, I get the error "Request to ...
Score REGDB_E_CLASSNOTREG(0x80040154)
Ramon - 6 Jan 2005 9:23 AM - 2 messages
I'm lost... This is the situation: -Win98se client with: Windows.Net Application (framework 1.1) MDAC2.8 Jet 4.0 Service Pack 8 for Win98 and the following connection string: "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\archive\db\app.MDB;User ...
Score Number of rows in dataset
tshad - 6 Jan 2005 1:31 AM - 5 messages
I have a dataset that I am going to navigate through and need to set up an array beforehand. ****************************************** Dim oData as new DataSet() Dim oAdpt as new SqlDataAdapter(sQuery,objConn) oAdpt.Fill(oData,"tempTable") for each dr as datarow in oData.Tables(0).Rows ...
Score How Get Paramenter information in Stored Procedure (DataType,Null
MrDotNet - 6 Jan 2005 12:51 AM - 5 messages
Hi I want information of Parameters in Stored Procedure, like DataType, Null or not... I am using for table SqlDataAdapter.FillSchema and that work fine, so I need some like that?? ...
Score SQL authentication attempt ignored
murphy - 5 Jan 2005 8:47 PM - 5 messages
I have a db server machine B set up with MSDE using mixed security. a database on B using SQL authentication. not connect.  The event log on B shows: Logon Failure: Reason:        Unknown user name or bad password ...
Score How to get a code of stored procedure ?
Gregory - 5 Jan 2005 8:21 PM - 8 messages
How to get a code of stored procedure ? I'm using System.Data.OleDb to connect to server. OleDbSchemaGuid.Procedure_Parameters returns only parameters but not a whole code. ...
Score Null returns from DataAdapter.Fill()
Michael Kellogg - 5 Jan 2005 7:44 PM - 5 messages
I'm populating a DataTable using a DataAdapter.Fill() statement.  It works just fine as long as the return is successful.  However, when my query returns no rows, rather than getting a "0" for rows returned (the function ...
Score Determine and update .MDB file version
LarryF - 5 Jan 2005 7:23 PM - 3 messages
I need to figure out which version of Access was used to create a .mdb file from within .Net, and possibly update it to a more recent version. In other words, I need to figure out if the file is from Access 97, ...
Score Bulk Insert Via SQLCommand?
Jason - 5 Jan 2005 6:46 PM - 12 messages
Hi. I am trying to bulk insert a text file into SQL Server 2000. The command works fine if run from the QueryAnalyzer, but when I run from within my code it fails with a "System Error". Bulk insert SQL (which works in QA) is: ...
Score GetChildRows - Finding Deleted ChildRows ?
Eric Barr - 5 Jan 2005 6:16 PM - 5 messages
Hi all, I've got a scenario that i can't seem to find a way around.  I have an order/detail type setup. My Order record is unmodified, but I have detail records that have been deleted. When i say : ...
Score Handling very huge data
Makarand Keer - 5 Jan 2005 5:25 PM - 9 messages
Hi All Wish all of u Happy New Year I am developing a application where in I retrieve data from Database which can go up millions records, do some processing on that and update the same in single transaction, now with limited RAM say 500MB how should I handle this data (I know one ...
Score DBnull, Date and DataAdapter
blue_nirvana - 5 Jan 2005 4:51 PM - 10 messages
Is there a way to assign a datetime column in SQL Server to Null using a SQLDataAdapter?  I know you can do it by calling a stored procedure and setting a parameter equal to DBnull.Value.  But it does not make since to me ...
Score typed dataset and sort order on save
Donal McWeeney - 5 Jan 2005 10:25 AM - 9 messages
Hi, Is it possible to force a typed dataset to write out records with a particular sort order on the WriteXml() method. Thanks     Donal ...
Score SQL Execution Overhead (Oracle ODP)
Tim Smith - 5 Jan 2005 4:34 AM - 3 messages
I noticed some performance degradation on a section of my code and I narrowed it down to calling Oracle for a sequence, which was executed 20 times or so. Our current design we pull a connection from the pool (as opposed to ...
Score How can I read a list of files from a folder into a DataTable?
Sasha - 5 Jan 2005 1:25 AM - 6 messages
Hi, What is the easiest way to populate a DataTable with a list of files from a folder? Thank you, Sasha ...
Score testing
Jennifer Perret [MSFT] - 5 Jan 2005 12:39 AM - 5 messages
...
Score Constraint violated but no exception thrown
davisonm - 4 Jan 2005 11:55 PM - 9 messages
I have a VB Windows form that calls the DataAdapter.Update method, passing a DataTable of one row with RowState = 'Added'.  This is the stripped-down code: Try     Dim Count As Integer = MySqlAdapter.Update(MyDataTable.GetChanges) ...
Score Getting off the ground with orace parameters
jon L - 4 Jan 2005 10:47 PM - 3 messages
Having a devil of a time passing a parameter to an oracle command in cnet .   If I substitute the :EXID for a string (Eg 'dogbreath') and remove the parm stuff it all works.  What I was expecting to happen was for the valiue in ...
Score Problem with Update Adapter
Steve Murphy - 4 Jan 2005 10:01 PM - 6 messages
I'm new to .NET, and I'm having problems creating an Adapter update command for a simple data set. I'm using the following code which compiles and runs, but does not update the database. This is just a barebones test using the Northwind database. Since this is a ...
Score Really need some help on this
Michael S. Kolias - 4 Jan 2005 9:45 PM - 7 messages
I have a stored procedure that I call from an aspx page but for some weird reason i get this error message: Procedure 'sp_insert_customer' expects parameter '@username', which was not supplied. Here is my stored proc CREATE PROCEDURE dbo.sp_insert_customer ...
Score ADO.NET problem
nashak - 4 Jan 2005 8:08 PM - 2 messages
Hello, I am trying to build a database project and have the following. I have one table "Subject" in sql server. I have a dataclass Data1 I have a business class Business1 I have a connection class Connection1 that instantiates and returns a ...
Score Getting XML as string
Steve Peterson - 4 Jan 2005 7:45 PM - 4 messages
Hi I'm a bit new to this so here goes my question: I need to get the XML from a dataset as a string. I've been beating my head against the wall trying to use the overload methods of the ...
Score a basic question
neptune3k - 4 Jan 2005 4:39 PM - 4 messages
Hi, I'm new to ADO.NET. I'm have a very basic problem and trying to figure out what is the best way to approach in .net. I just need to display some fields of a table (read only), but I need to choose which fields to display ...
Score Thread was being aborted Errors
Keith F. - 4 Jan 2005 4:17 PM - 5 messages
Hi, I have a web app that is intermittently throwing "Thread was being aborted." errors in my data access component. This seems to occur when the app is under a heavier than normal load. I would have thought if the DB call was timing out I would get a timeout ...
Score Best way to process millions of records
Peter Sedman - 4 Jan 2005 3:13 PM - 13 messages
I have a MS SQL Server database table that contains 5 million records.  The primary key of the table is a GUID. I need to write an application that reads each of these records and passes some values to another process. ...
Score MDAC and interop.adodb
Robin Patra - 4 Jan 2005 2:13 PM - 5 messages
Hi Gurus, I had a application in DOTNET which for D/B operations use "interop.adodb". I am facing hell lot of problem due to this. Can anybody please suggest me whats the best way to use interop.adodb beause i guess it depends lot on MDAC version.. ...
Score read datareader stream and read output parameters at the same time
ben - 4 Jan 2005 11:05 AM - 2 messages
Been working through a few scenario's where I have returned a stream of data to the datareader and also returned some output parameters from a stored procedure.  The question is in order to get the parameters returned from the ...
Score Cascading issues while updating multiple tables with SqlDataAdapter.Update method
geeksgk - 4 Jan 2005 10:10 AM - 2 messages
All, I broke my head over this for 18 hours now and tried out all the suggestions posted here but of no use. Here is what I'm trying to accomplish I have two tables, 1) Criteria 2) Regulator Criteria is a master table and Regulator is a child table. ie, the ...
Score Simple task, can't do in ADO.NET
pearsons_11114 - 4 Jan 2005 3:11 AM - 7 messages
Switching from ADO to ADO.net and I am totally lost and and frustrated. What I'm trying to do is so dirt simple: At RUNTIME, load an arbitrary database table into a datagrid for editing. Simple: create a SqlDataAdapter, ...
Score Is TDS used only if server is local?
Brett - 4 Jan 2005 2:41 AM - 14 messages
In order to use TDS via ADO.NET, does the SQL Server need to be on the same machine? If not, this will have to involve TCP/IP or named pipes correct?  How does TDS help in that case? ...
Score Testing for the existence of a table
Greg Shannan - 4 Jan 2005 12:35 AM - 6 messages
All: Is there some standard way I can test for the existence of a database table? I am using ODBC with an ingres database; and I don't really want to open a query like "select * ...." because I may end up reading the whole thing in, when all I ...
Score how to create a master detail display on the datagrid
Cecille Regidor - 4 Jan 2005 12:19 AM - 3 messages
When I read an xml file, the read data will be converted into different tables with the relationship.  But how can I display the data into a relational table like the data grid? ...
Score "Method '~' of object '~' failed" error
william - 3 Jan 2005 10:43 PM - 5 messages
Hi, I'm using ADO.NET command to execute a stored procedure which will do a bounch of deletes and inserts on database side. If the data is not too big, it's fine, but if there is a lot of data needs to be proceeded, sometime I ...
Score system.Data.OracleClient.dll 1.0.5 and TNSNAME longer than 16 char
David P - 3 Jan 2005 8:25 PM - 6 messages
There is a known issue with system.Data.OracleClient.dll 1.0.50000.0 that came with NET 1.1 framework: It cannot handle TNSNAME entries that are longer than 16 chars and produce the error below: ORA-00162: external dbid length 17 is greater than maximum (16) ...
Score non-labor intensive solution to Nulls in legacy DB
T Ralya - 3 Jan 2005 7:43 PM - 4 messages
I don't want to enter the religious wars about NULLS and whether they should or should not be allowed in Databases.  I have a legacy database and I can't change it.  NULLS are a fact of life for me. ...
Score Re: ADO.net Schem...
Srree - 3 Jan 2005 6:49 PM - 2 messages
Hi all gurus, I have question to clarify.. If get back a dataset. Will i get back the schema information and user rigths on the objects? Thanks Srree ...
Score Checking to see if SQL Service is running
TheNortonZ - 3 Jan 2005 6:18 PM - 4 messages
I have users who, as soon as they boot into XP, immediately try to run my app without waiting for all of the services to start. My app uses MSDE. Is there something I can do in code to check to see if the service is ...
Score Slow reads over VPN
Don Udel (ETC) - 3 Jan 2005 5:01 PM - 2 messages
Have an Access db.  When multiple user hit it on the LAN, performance is fine (response time <= 1 sec).  Application is in C# using ADO.NET.  When a remote user tries to access the db (via a VPN), their response time is fine ...
Score Several Questions on ADO.NET
cnSoftware - 3 Jan 2005 2:21 PM - 3 messages
Hi,there I get some problems when I am struggling in ADO.NET programming. I should really preciate your kindly advice. 1.How could I perform a data paging on master-detail datasets,especially the detail one? As I thought, ...
Score Using ADO.NET DataSet in Unmanaged C++ COM Code
AJ - 3 Jan 2005 9:39 AM - 4 messages
Hello, I am accessing the database using ADO.NET/Managed C++. I would like to use the returned data in form of cursors in Unmanaged C++ (standard C++ with COM). Through COM Callable Wrappers & Interop the Stored Procs will be ...
Score where can I download the ADO.Net object?
Victor Lung - 3 Jan 2005 9:15 AM - 4 messages
Dear All, I am newbies in .Net. I would like to ask do i need to download the ADO.Net objects for the database connection? just like need to download the ODBC driver for Java? If yes, where can I find the ADO.Net object? ...
Score Left join, cross-joined view, running forever
Viren - 3 Jan 2005 9:13 AM - 4 messages
Hi All, I am using VB.Net on a Pervasive.SQL database. I am trying to retrieve all Customers and Items, and only the related Sales for these Customers/Items. Because there isn't a link between the customer and items, I've created a cross joined view of the customers and items, which ...
Score Problem with running a SP that has input & a output parameter
Ross - 2 Jan 2005 10:55 PM - 2 messages
Hi folks I have a SQL Server SP that is eventually called from a command button on a form. The SP has one input parameter and one output parameter. The problem is that when I call the SP from the command button click event ...
Score ObjectSpaces, object persistence
Amit - 2 Jan 2005 3:38 PM - 13 messages
I'm looking for a good persistence framework to use with a new project. Gentle.NET looks promising but doesn't support SQL Server stored procedures as far as I can tell. Any tips on that? Is ObjectSpaces still scheduled to ...
Score Metadata about Foreign Keys ADO.NET 2.0
rob - 2 Jan 2005 3:27 PM - 2 messages
Hi, I can use "...Connection.GetSchema("ForeignKeys")" to get the name of an foreign key defined for a table. But how to get related/additional infos like the referenced table(name) and the corresponding fields ? Thx Robert Holler ...
Score binding a dropdown list in web app
rbutch@coair.com - 2 Jan 2005 1:19 AM - 2 messages
guys, i'm binding the results of a sql query to a drop down list in a web app in the usual way. dropdownlist.datasource= ds.tables(0) dropdownlist.datatextfield ="org1" dropdownlist.databind() now what if i wanted to concatenate other fields and combine them. ...
Next » 2 3 4 5 6 7 8 9 10