Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score DataTable WriteXml is in consistent
Oldman - 4 Feb 2006 8:23 PM - 4 messages
The DataTable WriteXml produces different xml based on whether the table is part of a dataset or not. This means that anybody consuming the xml has to read it differently because it ends up with different root nodes based on the circumstances. ...
Score ADO.NET help - Filling a DataGrid with contents of a DataSet
thebison - 4 Feb 2006 3:22 PM - 10 messages
Hi, As a relative newbie to SQL Server/ASP.NET I'm hoping someone here can help with my problem. I'm developing a timesheet application in ASP.NET C# using Visual Studio 2003 with a database built in MSDE. ...
Score Question ADO with ASP.net
Jacky Ngew - 4 Feb 2006 1:39 PM - 6 messages
Hi all, I have some questions in regard to ASP.net and ADO.net. Is it resource extensive, to open a connection in Session_Start method in global.asax [and close when session stops] or to open connection whenever I need it? ...
Score (.)(.) Hot...
Se¤ÊS - 4 Feb 2006 4:08 AM - 1 message
Call +8613352960090 Free! Multi-lingual! ...
Score (.)(.) Hot...
Se¤ÊS - 4 Feb 2006 4:08 AM - 1 message
Call +8613352960090 Free! Multi-lingual! ...
Score DataGridView, can it display related from a relationship in dataset in heirarchical View
Marlon R - 4 Feb 2006 1:22 AM - 2 messages
Can the DataGridView display heirarchical data? If yes can someone please point me to some documentation or examples. ...
Score OleDbException
00unknown.user00 - 3 Feb 2006 11:39 PM - 7 messages
Is there any way to determine the cause of an OleDbException?  For instance. for "No value given for one or more required parameters."  is there a way to determine which parameter is missing?  Or for the "Data ...
Score filtering data view with row filter using boolean value
Brian Henry - 3 Feb 2006 8:27 PM - 3 messages
say i have a dataset called dv and i have a boolean value i want to filter by "b_DoesWork" while the column name in the data view that i want to filter on is called "Works" how would i filter this since the rowfilter is a string? i tried ...
Score How to close connection pool?
pearsons_11114 - 3 Feb 2006 7:57 PM - 7 messages
Let me say preemptively I've read up on this and searched postings here and haven't found an answer. Connection pooling doesn't provide a way to close all connections in the pool, short of exiting the process. This seems to me to be a designed-in ...
Score dataAdapter not updating - but sqlcommand works OK
Rich - 3 Feb 2006 5:48 PM - 9 messages
Hello, .... Dim DA As SqlDataAdapter, DS As DataSet, curPos As Integer Dim cmdSel, cmdIns, cmdDel As SqlCommand .... DA = New SqlDataAdapter() .... -----------------------this part works fine-------------------- conn1.Open() strSqlDel = "Delete From tbl1 Where rowID = 10" cmdDel = New SqlCommand(strSqlDel, conn1) cmdDel.ExecuteNonQuery() ...
Score storing formula in database
JDF - 3 Feb 2006 12:57 PM - 4 messages
Does anyone have experience creating a formula generator and storing the formula in a database for re-use? I want to give my end user the ability to create custom formulas. The end user would create the formulas in a grid ...
Score Best Way to filter two datatables
Ben Lam - 3 Feb 2006 11:44 AM - 1 message
This is my scenario I have a cached datatable of all Items in my database. When placing an order, depending on which branch or office you are entering the order for certain items can be available to be placed on the order. ...
Score Using the Data Adapter designer
Ant - 3 Feb 2006 11:40 AM - 4 messages
Hi, I am using VS2003. When using the design enviroment to create a data Adapter wth a single table, no problems but... I used a data adapter to join three 1 to 1 tables. First thing I noticed is that it immediately cross joins all the tables(?) . I had to manually create ...
Score Passing Parameter to a form
Nickl - 3 Feb 2006 11:28 AM - 3 messages
I have 2 forms Form1 has a datagrid with read-only data. Form 2 is for editing/inserting/deleting the data on Form 1. It shows many of the same fields that are on Form 1, but via a different Proc and dataset ...
Score OracleCommand ExecuteReader failing
Oldman - 3 Feb 2006 11:19 AM - 3 messages
I have a stored procedure that I pass some XML in as a parameter. I am using the OracleCommand object and when I execute the ExecuteReader method I get the following error: Internal .Net Framework Data Provider error 30. Stack trace: ...
Score Multiple Active Result Sets - general question
Griff - 3 Feb 2006 10:28 AM - 4 messages
Having worked through an example (I'm novice status), it seems that this is less efficient than using hierarchical recordsets in normal ADO. Can one still use hierarchical recordsets (using the SHAPE command) in ADO.NET? ...
Score Multiple Active Result Sets (MARS)
Griff - 3 Feb 2006 10:22 AM - 15 messages
Two questions relating to this: 1 - Do I require SQL Server 2005 or can this work with SQL Server 2000? 2 - My ASP.NET book says that I require MDAC 9.0.  My registry setting says that I'm using 2.8 but I can't find where I can download an update from. ...
Score How to bend ADO.Net to my liking...
cartoper - 2 Feb 2006 8:57 PM - 10 messages
Data: A line (row) containing multiple fields (columns) Requirement: 1: Allow new lines to be inserted at any point 2: Allow deletion of any line 3: Keep the lines in the correct order Examples: When given a table with three lines: ...
Score Use of DataRelation is locking rows in DataTables
dice - 2 Feb 2006 5:49 PM - 2 messages
I am using a DataSet generated using VS2003 .xsd files direct from db tables. I then add some DataRelations to the DataSet programatically. I am running into the following problem: any time I call GetChildRows() using a particular DataRelation the parent ...
Score performance of single database vs multiple databases
Francis Reed - 2 Feb 2006 5:46 PM - 13 messages
Hi I am currently working on a portal for an online university. The portal allows students, teachers, and administrators to access information, and perform certain tasks based on roles. We are currently developping tools for managing quizzes, assignments, news. What I realize if we have many courses, ...
Score ExecuteNonQuery against a stored procedure does not insert ntext f
Gavin Sullivan - 2 Feb 2006 3:27 PM - 3 messages
Hi, I have an SP that inserts some data including an ntext field for large strings (4 M chars) When executed, ExecuteNonQuery returns -1, but the insertion occurs with all but the ntext field populated correctly, the ntext field is blank. The string ...
Score VS2005, C#, DataBinding of SqlServer 2K TimeStamp datatype
ESmith - 2 Feb 2006 1:35 PM - 3 messages
Newbie Warning! There, out with the full disclosure. I have a datatable with a variable "CreationDate" of type TimeStamp. I'm trying to learning Data Binding, when I drag the table onto my Windows Form (2.0) and try to compile, I get an error about incompatible type ...
Score Information for writing an ADO.NET 2.0 Data Provider
Mark Itzcovitz - 2 Feb 2006 1:30 PM - 5 messages
I am in the process of writing an ADO.NET 2.0 Data Provider but I'm finding the lack of documentation is making the process rather slow. Can anyone suggest any sources of information? Thanks, Mark ...
Score DBConcurrencyException in Update()
latin & geek via DotNetMonster.com - 2 Feb 2006 9:49 AM - 7 messages
hi. im at wits end! my update command isnt working properly. im able to edit and delete data successfully with the same command builder, but when i add a new row and update, i get an "affected zero records" message. ...
Score Report question
ken - 2 Feb 2006 9:27 AM - 2 messages
Dear all, I want to create a crystal report like the following format, but don't know how to do this Date                 Expenditure 01-Jan             1832 ...
Score Best and quikest method to filter a dataview
Tim Harvey - 2 Feb 2006 4:57 AM - 2 messages
What is the fastest method to filter a dataview? ...
Score What could be causing this while updating a DataTable?
Benton - 2 Feb 2006 1:25 AM - 3 messages
Hi there, I am getting this exception "Deleted row information cannot be accessed through the row" when trying to update a datatable with an adapter: mAdapter.Update(mTable);  <== exception here After struggling with this for hours, I am now looking for a more generic ...
Score SqlException in Visual Studio 2005
ComputerGuyCJ - 2 Feb 2006 12:45 AM - 3 messages
First of all, I apologize if I'm not posting this in the appropriate group. This is my first time using these Newsgroups, so I'm trying to find my way around. That said, this is my problem: I have a stored procedure I'm calling from Visual Studio 2005. The query ...
Score Problem saving changes to table
iScanTeam@community.nospam - 1 Feb 2006 10:12 PM - 4 messages
I receive the following error when trying to update a table after editing.     System.InvalidOperationException was unhandled     Message="Update requires a valid UpdateCommand when passed DataRow collection with modified rows."     Source="System.Data" ...
Score Where to start?
cartoper - 1 Feb 2006 9:43 PM - 3 messages
* Plateform: .Net 2.0 * Question: Is ado.net the solution?  If so, what should I be looking into? * Data: schedule containing: 1 to n properties collection of lines line containing: 1 to n properties * Data Source:     An engine that needs to take the saving of the data to keep a version ...
Score DataRowView and objects don't match?
Benton - 1 Feb 2006 9:42 PM - 2 messages
Hi there, I have this method to search a DataView: public int FindIndex(string columnName, object key) { index = -1; foreach (DataRowView drv in table.DefaultView) {      if (drv[columnName].Equals(key))      {          index = i; ...
Score DataTableReader Problem
Joe - 1 Feb 2006 8:49 PM - 2 messages
Help: I am trying to use a datatable reader to loop through a datatable but I get the following error message when I try: System.InvalidOperationException was unhandled   Message="DataTableReader is invalid for current DataTable 'CABG_Transfer_to_Raw'."   Source="System.Data" ...
Score Large Text.
Steve - 1 Feb 2006 3:03 PM - 3 messages
I'm wanting to save and retreive text from a multiline textbox which I've been told can become extremely large and I'm not sure how this is to be done(c#). I'm guessing SqlServers Text type is ok and some kind of chunking of the ...
Score testhh for now
testy - 1 Feb 2006 2:59 PM - 1 message
[link] Ya puedes comprar cd y dvds verbatim traxdata princo tdk benq, a los mejores precios. Entregas por Seur 24 horas. Servicio y Calidad Visitanos!! [link] ...
Score Multithreaded access with TableAdapters
the whip - 1 Feb 2006 1:10 PM - 3 messages
We have an app under development processing data from com port events.  There can be multiple com ports all sending data back to this one method on one instance of a class “ld”.  This method gets a db object associated ...
Score SQL CONTAINS clause parameter substitution problem
Stargate4004 - 1 Feb 2006 12:44 PM - 4 messages
Hi, I'm in the process of parameterising the SQL SELECT statements in my ASP.NET application so that I don't directly include user input in the SQL (to protect against SQL Injection attacks). I've run into a ...
Score Serialized ADO.NET 1.0 dataset compatible with ADO.NET 2.0
Kay-Christian Wessel - 1 Feb 2006 9:33 AM - 6 messages
Is it possible to serialize an ADO.NET 1.0 dataset to xml and then to deserialize it back to an ADO.NET 2.0 dataset ? And visa versa ? Is this functionality supported for the Compact Framework also ? Best regards ...
Score Fill strongly type dataset from stored procedure
ken - 1 Feb 2006 4:10 AM - 8 messages
Dear all, I have a file-strongly type dataset, that have two independent table inside it. I want to fill the two table in the dataset by one stored procedure(have two select sql on it) how can i do ...
Score how to get output parameters using enterprise library 2.0
xisco - 1 Feb 2006 3:34 AM - 3 messages
hi, how do I get output parameters from sql 2005 query using the entlib 2,0? I noticed the dbcommandwrapper is not there anymore. thanks xisco ...
Score Using a design time connection from a class
Ant - 1 Feb 2006 1:15 AM - 6 messages
Hi, I've created an SQLConnection by dragging a DataAdapter onto the form. The connection was named sqlConnection1. When I try to reference this connection in code from another class, I cannot find it. Intellisense only finds the classe SQLConnection. This must be a ...
Score EARN OVER 9850 DOLLAR in 3 WEEKS !!!
EARN OVER 9850 EUR in 3 WEEKS - 1 Feb 2006 1:13 AM - 1 message
EARN OVER 9850 DOLLAR in 3 WEEKS !!! Hello friends, I´m Happy !!! I ordered the programm and it really functions. EARN OVER 9850 DOLLAR in 3 WEEKS !!! READ THIS: For everyone, who needs really money. Are you on the search for a lucrative source of income?  Would you like to ...
Score EARN OVER 9850 DOLLAR in 3 WEEKS !!!
EARN OVER 9850 EUR in 3 WEEKS - 1 Feb 2006 1:13 AM - 1 message
EARN OVER 9850 DOLLAR in 3 WEEKS !!! Hello friends, I´m Happy !!! I ordered the programm and it really functions. EARN OVER 9850 DOLLAR in 3 WEEKS !!! READ THIS: For everyone, who needs really money. Are you on the search for a lucrative source of income?  Would you like to ...
Score EARN OVER 9850 DOLLAR in 3 WEEKS !!!
EARN OVER 9850 EUR in 3 WEEKS - 1 Feb 2006 1:13 AM - 1 message
EARN OVER 9850 DOLLAR in 3 WEEKS !!! Hello friends, I´m Happy !!! I ordered the programm and it really functions. EARN OVER 9850 DOLLAR in 3 WEEKS !!! READ THIS: For everyone, who needs really money. Are you on the search for a lucrative source of income?  Would you like to ...
Score EARN OVER 9850 DOLLAR in 3 WEEKS !!!
EARN OVER 9850 EUR in 3 WEEKS - 1 Feb 2006 1:13 AM - 1 message
EARN OVER 9850 DOLLAR in 3 WEEKS !!! Hello friends, I´m Happy !!! I ordered the programm and it really functions. EARN OVER 9850 DOLLAR in 3 WEEKS !!! READ THIS: For everyone, who needs really money. Are you on the search for a lucrative source of income?  Would you like to ...
Score Looking for an alternative
Michael Jackson - 31 Jan 2006 8:57 PM - 6 messages
Current project is in .NET 2003 using SQL Server 2000. I use strongly typed datasets in this app, created by dragging a table form Server Explorer to a design surface, walking thru the SQL Data adapter wizard and generating Datasets. ...
Score DataTable.AcceptChanges error, "Destination Array was not long eno
Thomas W. Brown - 31 Jan 2006 7:21 PM - 1 message
I am encountering a situation where I'm trying to AcceptChanges() on a DataTable and this is throwing a   Destination array was not long enough.  Check destIndex and length, and the array's lower bounds. error from within this call.  Can someone shed some light on this?  What ...
Score Generating an SqlParameter from a value in a DataSet
Stephan Zaubzer - 31 Jan 2006 5:00 PM - 2 messages
How can I generate a Parameter if I cannot retrieve the SqlDbType from an item in a row of a DataSet? Is it safe to just take the object I retrieve from the DataSet and take the following constructor for the Parameter: ...
Score How do I set the DateTimeMode property when filling a DataTable
kenandcorey - 31 Jan 2006 4:59 PM - 2 messages
[ I posted this in Microsoft.Public.Data.Ado, but I haven't had a response. I thought I would try here too. ] I am investigating how best to manage UTC timestamps in ADO.Net.  We ran into a lot of issues with UTC DateTime serialization in .NET 1.1. ...
Score Bug in TableAdapter Code Generator?
Mark Olbert - 31 Jan 2006 4:31 PM - 2 messages
I've run into problems using TableAdapters under VS2005 where the underlying Fill() method fails due to a constraint violation. This occurs when there was no change to the data of the underlying table -- hence there shouldn't be a constraint problem, so far as I ...
Score How can I find the BindingSource has some changed data
A.M-SG - 31 Jan 2006 4:30 PM - 2 messages
Hi, In my WinForms application, I have a set of controls that are bound to a BindingSource control. When the user closes the form, I need to ask him if he wants to save data. The problem is I cannot find anyway to check if the value of any textboxes ...
Score SQLAdapter Timeout doesn't work
matteo - 31 Jan 2006 9:34 AM - 7 messages
Hi everybody, i've a problem with loading a dataset: i need to load entire contents of various tables into dataset, however i don't know size of this table. If table size is too big simply i need a timeout exception and ...
Score Web Service SQL Connection Model
Chris Arnold - 31 Jan 2006 7:50 AM - 3 messages
Hi All, I am near completion of a project consisting (broadly) of a web app, a web service and a SQL server - the usual sort of configuration. Both the SQL server and the web service are tasked with dealing with large amounts of ...
Score Dataset creation problem.........
sendtobiren - 31 Jan 2006 7:04 AM - 3 messages
Hi All, I have two access databases. First contains a table which contains userids. The second one contains the users records. I tried to create a dataset which will query in these two databases and get two datatables. I tried to add relation between these two ...
Score Using XML to read data from SQL Server
bill - 31 Jan 2006 1:33 AM - 1 message
Does anyone have a good, complete example code that would show the necessary steps for using XML to read data from a SQL Server database? I'm trying to switch from DataReaders and I have very little knowledge in the XML area.  I would be very grateful and I suspect it would help ...
Score Unable to insert BLOB in Oracle
Bala Nagarajan - 30 Jan 2006 11:23 PM - 4 messages
Hello,     I am unable to insert BLOB objects into Oracle 9i database from .NET. I get the following exception: "ORA-01460: unimplemented or unreasonable conversion requested". I have a table in the database that accepts a number and blob object. ...
Score ADO.NET 2.0, WebMethods and datatable strange behavior
A.M-SG - 30 Jan 2006 9:09 PM - 4 messages
Hi, I am using VS2005 and .NET 2.0 I have a WebMethod that accept a typed data table. I realized that whatever rows that client sends to the SOAP server through the datatable, the webmethod received an empty datatable!! ...
Score Saving contents of datatable to Access table without writing SQL
eric.goforth - 30 Jan 2006 5:49 PM - 3 messages
Hello, In ADO.NET is there anyway to save the contents of an datatable directly to an Access table without having to loop through and generate a SQL insert query string?  I figure there's probably a way to do it as ...
Score DataSet Question
ted - 30 Jan 2006 5:21 PM - 4 messages
Hi, I have a dataset that is filled with data from the db.  The user has modified that data in one of the tables where some of fields should now be null.  I have played around with delete the row and adding a new row but ...
Score SqlDataSource and Optimistic Concurrency Problems
stuart.d.jones - 30 Jan 2006 4:44 PM - 4 messages
Hi, I'm using a detailsview control with an SqlDataSource control.  My Update query isn't working, and I've narrowed it down to the optimistic concurrency parameters - i.e. when I comment them out of the query, it ...
Score DataColumn size
Kari Lappalainen - 30 Jan 2006 2:18 PM - 4 messages
Hi everybody! Do someone know the easiest way to obtain the datacolumn size in code (I mean the size that you define creating a text field in a table)? In VB6 you could get it by means of Recordset.Field. ...
Score AD.NET 2.0: BindingSource and Parent Child relationship
A.M - 30 Jan 2006 1:06 PM - 8 messages
Hi, I have two BindingSource(s) in my form, one for parent and one for child area. The unique situation in my form is that the child area chooses its parent by a ComboBox. The problem is when I use AndNew method in the child BindingSource, I cannot ...
Score How to write generic code access in ADO.NET
anonieko - 30 Jan 2006 12:38 PM - 4 messages
M. Chand is a .NET consultant, author and the admin and founder of C# Corner. He has been working with .NET technology since pre beta releases. [link] using System; using System.Data; ...
Score SQLconnection problem
jay - 30 Jan 2006 12:24 PM - 2 messages
I'm pretty new to asp.net and I'm having trouble just trying to set up a basic SQLconnection within visual studio, I'm sure the problem must be something basic but I can't seem to find it. ...
Score Binary serializing of dataset in framework 2.0
Anders - 30 Jan 2006 11:58 AM - 5 messages
I was eager to try the new binary serialization of dataset in version 2.0 of the framework. The new serialization seems to be very fast comparede to the "binary" serialization in framework 1.1. However I have a few problems ...
Score DataColumn.Exression and string formatting
A.M-SG - 30 Jan 2006 12:11 AM - 10 messages
Hi, I am truing to add a calculated column to my data table. The column must show something like: "Date: 2005-01-23" I underestand that we can use Convert to convert a DateTime value to string. How can I convert it in specific date format? ...
Score Updating a third table
Joyce - 29 Jan 2006 10:29 PM - 4 messages
Hi, I have learned how to successfully add, modify and update both tables in a master/detail form such as Customers and Orders. What I am having trouble with now is how to update the Qty field in a third table, Products, as we add lines to the child form. That is each ...
Score Can we use custom function in the DataColumn.Expression
ad - 29 Jan 2006 7:36 PM - 1 message
I am using VS2005. I add a column to a DataTable in a DataSet. Can Iuse custom function in the DataColumn.Expression? ...
Score excel datasource and gridview sorting
Len - 29 Jan 2006 12:56 PM - 1 message
Hi!             I am somewhat befuddled.             I have a gridview that I have filled using oledb datareader with data from an excel sheet.(code at bottom) ...
Score Accessing a field in untyped DS
Ant - 29 Jan 2006 4:48 AM - 5 messages
Hello, I have an copied data set. I'm trying to access a field. daOrder.Fill(dsOrderSheet); DataSet dsCopy = new DataSet(); dsCopy = dsOrderSheet.Copy(); // How do you do this part? output = dsCopy.Tables["orders"].Rows[0].ItemArray["orderDate"]; //or output = dsCopy.Tables[0].Rows[0].ItemArray[1]; ...
Score Adding a Datatable to a dataset
Ant - 29 Jan 2006 2:12 AM - 3 messages
Hi, I'm currently getting up to speed with ADO.NET & have a few questions on it. This question relates to why a data table is added to a data set such: DataTable dtEmp = ds.Tables.Add["employees"];  // From book ...
Score How do I assign a typed DataTable to its typed DataSet?
A.M-SG - 29 Jan 2006 1:23 AM - 7 messages
Hi, The following code: TypedDataSet typedDS = new TypedDataSet(); TypedDataSet.TypedDataTable typedDT; // // Code to fill typedDT // typedDS.TypedDataTable = typedDT; // Colmpiler error! gives me a compiler error: Property or indexer cannot be assigned to -- it is read only What is the proper way to assign a typed DataTable to its typed DataSet? ...
Next »