Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score how does ado.net read values from a sql server 2005 output clause.
smHaig - 28 Oct 2006 10:42 PM - 1 message
I would like to use the really useful output clause in a stored procedure.  How would I capture these values.  Are they returned like a select statement into a dataset? Here is a sample sp.  The three values would be the values in the OUTPUT ...
Score Simple multiple table design question
Danny Liberty - 28 Oct 2006 8:23 PM - 6 messages
Hi, I'm building a relatively simple Windows Forms application that supports displaying and editing of data from multiple RELATED tables. To simplify my question, I'll supply an example: The windows forms should display a store's sales data. The data is ...
Score Procedure or function has too many arguments specified
Mike - 28 Oct 2006 8:09 PM - 4 messages
I posted this is m.p.d.f.aspnet last night, but got no useful response.  I have also googled this group (and a lot of others), and have not found a satisfactory explanation. I have a stored proc with one parameter: ...
Score Dot Net 2.0 or SQL Server 2005 problem?
B. Chernick - 28 Oct 2006 1:46 AM - 11 messages
I have rather hastily installed VB 2005 Express and SQL Server 2005 Express on my machine and I haven't much experience with either. So far as I can remember I have mostly used default settings.  SQL Exp. is set to use Windows ...
Score convert funtion
gurvar - 27 Oct 2006 11:01 PM - 4 messages
Hi I try this funation in SQL2K It works fine. But I'm getting the following error in my ASPX Page There was no problem with following statement when talking to SQL7. Please advice. & Thanks Select CONVERT(varchar(20),SUM(CONVERT(numeric(20),F.Fee_Amount_VC))) 'Fee ...
Score intermittent Unspecified error on Microsoft Jet Database Engine
Johndow - 27 Oct 2006 9:12 PM - 4 messages
It is a very strange issue.  I try to use oledb to access a flat text file on the file system, and got intermittent error: I dump the error into a log, which does not show much information: Message: Unspecified error ...
Score Creating a cross-database command
BBM - 27 Oct 2006 6:31 PM - 7 messages
Hi, I need to use the SqlCommand object to execute a query that copies records from one MSSQL Database to another.  I'm not using stored procedures, I'm setting the CommandText property of the command in code. The SQL is pretty simple.  Given two databases A and B, both of which have ...
Score Using DAAB 1.0 in ASP.NET application
settyv - 27 Oct 2006 5:43 PM - 1 message
Hi, Please help me how can i use Datareader using EnterpriseLibrary. I have written something like this,Will that works?? public void LoadCaseCategory() {     Database db=DatabaseFactory.CreateDatabase();     string sqlCommand= "SELECT CASE_CATEGORY FROM CASE_CATEGORY";     DBCommandWrapper dbCommand = ...
Score Passing DateTime to sp via OleDbDataAdapter
thorax - 27 Oct 2006 1:21 PM - 2 messages
[Originally posted in Sybase newsgroups but received no response.] I'm having trouble passing a .NET DateTime value to a stored procedure (parameter type datetime).  Regardless of how the value is specified, it seems to get truncated so the stored procedure receives the wrong value.  ...
Score Typed Dataset event handling problem
Lucas Ponzo - 27 Oct 2006 4:08 AM - 12 messages
I have a standard typed dataset (.net 2005). And created a separete class file to handle the RowChanging event. The dataset name is dalCadastro and the datatable is pessoa. The code I wrote to extend the dataset and handle the ...
Score Help needed: Custom data-bound control modifies Rows just by navigating through DataTable
herceg - 26 Oct 2006 11:41 PM - 2 messages
I have a problem with a custom data-bound control which inherits from TextBox. Its code is basically class MyBox: TextBox {     public string MyText     {         get { return base.Text; } ...
Score DataReader.GetDateTime
David Thielen - 26 Oct 2006 11:41 PM - 3 messages
Hi; When I get a DateTime object from DataReader.GetDateTime() - what TimeZone is it set to? ...
Score Typed DataSet Relationships
TigerMan - 26 Oct 2006 10:28 PM - 3 messages
Hi, I have 2 datatables on my typed dataset: 1) Reads all records form a table 2) Is a join query based on 3 tables Each one works perfectly on their own. I want to be able to set a ...
Score Creating new database 'Views' in Server Explorer
Seven - 26 Oct 2006 8:24 PM - 1 message
Hi, I am going through the Kalani book for exam 70-315. At the moment I'm dealing with the databind chapter where on one of the examples it says do the following in Server Explorer(in visual studio) on an already created database ...
Score TableAdapter Preserve Original Values on Update (no Accept Changes
twahl - 26 Oct 2006 6:46 PM - 8 messages
Is there a way that I can prevent the SqlDataAdapter associated the with TableAdapter from issuing an AcceptChages?  The only way I can see how to do this is to create a partial class for the TableAdapter.  The associated ...
Score Oracle & binary serialization -- BLOB or CLOB?
matt - 26 Oct 2006 6:32 PM - 4 messages
hello, does anyone know if, when inserting a serialized object into an Oracle db, i should be using a BLOB or a CLOB? thanks, matt ...
Score Binary Serialization -- how to actually insert into database?
matt - 26 Oct 2006 4:54 PM - 10 messages
hey all, ive read some good articles on the tenents of serialization and when & why youd want to do it, as well as the types. great! now id like to put it to practice. however....none of the articles i ...
Score Oracle FGAC and .NET
Mark Peters - 26 Oct 2006 4:44 PM - 1 message
A client of mine wishes to migrate their Oracle forms client applications (UI-business tier) to the .NET Framework 2.0 and Windows Forms while maintaining their Oracle datastore. They are currently on 8.1.7.4 but will be migrating to 10g in the foreseeable future, they say. ...
Score TableAdapter - fails when database name changed
John - 26 Oct 2006 2:48 PM - 1 message
Hi, I have a project that includes a number of Table Adapters. When I publish my web site on another machine, I am configuring it to point to a database on that machine. This database has a different name to the one on my ...
Score InsertParameters.Add doesn't function ainan ASP.NET application
Roland - 26 Oct 2006 1:01 PM - 4 messages
In my application (ASP.net) I use the following: MyDataSource.InsertParameters.Clear(); MyDataSource.InsertParameters.Add("AdvID", TypeCode.String, sAdvID); MyDataSource.InsertParameters.Add("Name", txtName.Text); MyDataSource.InsertCommand = "INSERT INTO markt.advertizers " +                "(AdvID, Email, Name) VALUES (@AdvID,@Name)"; ...
Score storing database connection strings
djc - 26 Oct 2006 12:43 PM - 6 messages
is it still customary to use web.config and global.asax to store connection strings? For example storing the string in web.config and using application start procedure in global.asax to declare a global app variable? I'm an off and on hobby programmer and this was the last method recommended ...
Score 'Number filling'
Edwin Knoppert - 26 Oct 2006 12:30 PM - 3 messages
MDB, doing a max of a field which resultrs for example 12. Now i want to simulate rows somehow (temptable?) with values 1 2 3 etc like: 1 2 3 4 5 6 7 8 9 10 11 12 It's all oledb asp.net 2, i'm not sure how to make such a temptable(memory ...
Score DataSet sum
amarrr - 26 Oct 2006 12:29 PM - 4 messages
Hi, I have just started working with ADO.NET and VB.NET and have a question. I have dataset with tables.. This table contains a 4 column called ID,name,IDacc,price. How can I sum value in columns price where values in columns IDacc is equal.... ...
Score Probem with DataSet.GetXml()
lucky - 26 Oct 2006 8:32 AM - 2 messages
Hi guys! i'm facing very strange problem. i've a DataSet object in which i add some tables the some logic finishes successfully. and after then i tried to get the XML string from the DataSet but it returns only first 2 tables in that string. ...
Score SQL Server Notification Services
Xavier Decoster - 26 Oct 2006 5:54 AM - 3 messages
Hi, I'm working on a Windows-application (c#) and an ASP.NET (c#) website. The application handles new subscriptions of students in an academy. This academy had two different locations that uses this same software. The ASP website can be used by the students to subscribe for a new ...
Score Last minute Beginner's question
B. Chernick - 25 Oct 2006 10:20 PM - 7 messages
I'm inexperienced in Dot Net 2.0. I have in the past 24 hours installed SQL Server Express, VB Express, and C# express mainly because I have to lead a study group on a chapter in the 70-431 manual.  ...
Score changing ordinal position in access table
adiel_g - 25 Oct 2006 7:43 PM - 4 messages
I want to re-arrange some of the fields in an access table.  I know this could be done from the previous microsoft database objects.  I am not sure if ADO.NET can do this.  Can you change the ordinal position ...
Score How to switch databases using ADO.NET?
deathtospam@gmail.com - 25 Oct 2006 2:46 PM - 4 messages
I have a webpage, developed as a utility (and "Hello World"-type ASP.NET project) to allow our developers to select a database name from a dropdown list.  Once a database has been selected, a list of all user-defined stored procedures in the database is displayed.  I've ...
Score TableAdapter - Refresh the data table option
cwineman - 25 Oct 2006 2:25 PM - 1 message
I'm having some trouble receiving the identity value after an insert. I've seen several posts about this, and the solution that seemed the most obvious was to enable the advanced TableAdapter option - "Refresh the data table". Well, I tried that  After I insert a row and call update, the table still ...
Score System.Data.OleDb.OleDbPermission issues with Access and VB 2005
Bill Sempf - 25 Oct 2006 12:46 PM - 1 message
I have a reader that is getting a OleDbPermissions error on an Access database.  I know I have fixed this before, but I completely forget how and I can't seem to find anything about it except unanswered questions on the ...
Score Use of SQL express ??
serge calderara - 25 Oct 2006 11:18 AM - 4 messages
Dear all, I have a big application which is based on different EXE files made with VB5 accessing data from an access database. Now we plan to move those application under .NET annd SQL express 2005 instead of access. The quetsions are : ...
Score VB6 memory recordsets to .NET
Garry - 25 Oct 2006 5:59 AM - 9 messages
WE are doing the big leap. We have a very large VB6 app, Standalone, Access orientated and we want to start Re-Writing it in .NET We make extensive use of code defined and generated memory recordsets which allow us multiple sort keys with various data types, (Dates etc). And it has ...
Score Debugging Dataset XML
Phil Galey - 24 Oct 2006 10:53 PM - 1 message
In VB.NET, I add a Dataset to the Solution Explorer and start adding elements, complex and simple types, and so forth.  I then go to Form1 and try to create a new dataset object based on that dataset definition; ...
Score asp.net 2.0 with Oracle
george - 24 Oct 2006 10:51 PM - 1 message
Hi all - I am trying to use ASP.NET 2.0 to delete a row in an Oracle database table    GC_LOG (see following, note that my connection string is fine, everything else like updateCommand is working) The ID and ACTION are varchar2(10) and varchar2(200) respectively: ...
Score DataSet help -- .Merge() & .GetChanges()
matt - 24 Oct 2006 7:16 PM - 9 messages
hello, i have two datasets (only one DataTable each) representing the same set of data, but from two different historic points of time. so they are of the same structure, but there may have been rows added, removed, or changed. each row has a unique ID column. i need a way to show my users ...
Score Can't databind hierarchical data
Justin Magaram - 24 Oct 2006 5:34 PM - 1 message
I am trying to databind some hierarchical data stored in a DataSet. The top-level is a DataView on a table. I generate lower-level views by calling CreateChildView on individual rows (traversing the appropriate DataRelation objects). This works fine BUT NOT IF the primary key of a parent row ...
Score Using DataAdapter.Fill()
Micus - 24 Oct 2006 5:29 PM - 5 messages
[Win XP Pro, SQL Server 2000, VS 2005 Pro, C++/CLI]        I'm having a problem with using the SqlDataAdapter->Fill() method. I have 2 tables, Orders & Customers which are related by a CustomerID. I have ...
Score History Summary Analysis and Inspection Periods!
Jay Balapa - 24 Oct 2006 4:37 PM - 3 messages
Hello, I have two tables- TBLHISTORY with the following fields- BARCODE  ITEMTYPE PASS DATEINSPECTED 1000                    x         YES  01/12/2004 ...
Score Can't access to a remote SQL Database through a web service
Brian Roisentul - 24 Oct 2006 3:14 PM - 3 messages
Hello, I'm developing a web service in c#, and I can't make it access to a remote sql database. I entered the correct username and password into the connection string of the web service, but when I try to access to the db remotely I get ...
Score Update unable to find TableMapping
sxsrira - 24 Oct 2006 2:22 PM - 1 message
Dear friends,        I ran into this exception while trying to update excel through Ado.Net. When i searched google found there are similar queries left unresolved. I identified the mistake i have done. Hence i thought to ...
Score Dataset.GetXml incorrectly renders XMLNS tag, breaks XSLT
Bill Sempf - 24 Oct 2006 2:01 PM - 3 messages
I have a very simple dataset, just 4 fields in one table.  I am using the GetXml method of the dataset to render the XML into an XmlStream, and then XmlCompiledTransform to implement an XSLT, then save it to an HTML file. ...
Score TableAdapters and Transactions again!
J055 - 24 Oct 2006 11:20 AM - 9 messages
Hi I've read various articles/blogs/posts about adding transactions to TableAdapters, mainly from Sahil Malik. I'm certainly not an expert in ADO.NET but I understand what transactions, commands and connections are. Sadly I've been unable to get the examples I found to work. ...
Score gridview with childnodes
jeff.dupont - 23 Oct 2006 10:41 PM - 2 messages
Ok, I've been all around the web looking for code on how to do this on ..net 2.0 and have not found exactly what I'm looking for. And for the few examples that I did happen to come across I was unable to get them ...
Score sqlite provider
Jon Paal - 23 Oct 2006 10:07 PM - 9 messages
anyone have any success with a provider for sqlite3 ? I've tried here: [link] but it crashes ASP.net 2.0 all others I've looked at are for .net 1.1 or are undocumented alpha's ...
Score Read and update a table
David - 23 Oct 2006 8:56 PM - 5 messages
Using VS2005, ASP.Net and SQL Server.  What ADO command set do I need to both read and update selected records in a table?  I want to do something with each one and then update a column on that record before moving to the ...
Score Filtering Question
Nathan Guill - 23 Oct 2006 7:32 PM - 3 messages
I'm not sure if this is the correct forum, but I am searching for an example of how to perform an MS Access "filter by form" style query.  In other words, I want the user to click on the "Filter" button and the UI controls ...
Score binding tables in many-to-many relationships
Ryan - 23 Oct 2006 5:05 PM - 5 messages
Hello all.  I'm having some (mis?)adventures in databinding a winforms app and need some guidance. My data model has 4 tables, let us call them Leases, Terms, LeaseTerms, and LeaseTermTypes.  The idea is that you can setup several definitions of Terms, ...
Score Datagridview Binding/Update Question
mkd1919 - 23 Oct 2006 4:09 PM - 4 messages
I have two questions. 1.  Is there a way to keep the datagridview datasource constantly bound to a sql db?  So that as soon as a change takes place in the db by any user, it is updated on all screens.  If so, how is that done?  If not, what is the best ...
Score Original table of view column
siftee - 23 Oct 2006 3:17 PM - 1 message
I need to know the underlying table of a column in a view.  Using getschema("Columns") i can get a list of the columns in the view, but not the table that they come from.  Using getschema("ViewColumns") gives me the table that they come from but not if they are visible or not in the view... it includes all columns from all tables in the view regardless if they are visible in the view or not. ...
Score T-SQL vs ADO.NET Transaction?
brianpmccullough - 23 Oct 2006 3:08 PM - 4 messages
Hello, I have an application that is currently using a T-SQL stored procedure that uses a transaction to perform an update to a single record and then INSERT, what could be HUNDREDS OF THOUSANDS of records, into a related table.  My ...
Score Failed to convert parameter value from a Guid to a String
Crown - 23 Oct 2006 9:09 AM - 1 message
Hi, I am trying to use the Microsoft Oracle data provider to store a GUID as a string. Get this message: Message: Failed to convert parameter value from a Guid to a String. Inner Message: System.InvalidCastException: Object must implement IConvertible. ...
Score TableAdapter does not refresh after update
Calvin Westervelt - 23 Oct 2006 2:58 AM - 2 messages
I have a DataGridView bound to a TableAdapter with which I am updating data using optimistic concurrency.  When I insert a new row, or update an exsting row, the TableAdapter doesn't get refreshed even though the final line in the ...
Score DataAdapter & AddWithKey
Micus - 22 Oct 2006 7:07 PM - 1 message
[Win XP Pro, SQL Server 2000, VS 2005 Pro, C++/CLI] Hi All,     I'm having a problem with using the SqlDataAdapter->Fill() method. The following is a simplified version of the error TableA aColA (Primary Key, Identity) ...
Score Dataset and Nested Class???
LW - 22 Oct 2006 4:22 AM - 3 messages
Hi! I have a DataSet and a class in my Web Service. My output for example is: <OrderInfo>     <CustomerID>VINET</CustomerID>     <OrderID>10248</OrderID> ...
Next »