Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score How can I populate table from listbox
Rino - 5 Aug 2006 11:05 PM - 1 message
Greetings, This is my first post and I hope it'll be the lucky one since I've been hurting my head with the following situation for a while now. I need to be able to populate a table from all of the items located in ...
Score Come with us
omar.abid2006 - 5 Aug 2006 6:52 AM - 3 messages
hi, This is the real workgroup of Visual Basic 2005 express goto : [link] thank you ...
Score Searchable Array.
Bishman - 4 Aug 2006 8:12 PM - 1 message
Dictionary<string, TestClass> JonsArray = new Dictionary<string,TestClass>(); TestClass NewTestClass1 = new TestClass(); TestClass NewTestClass2 = new TestClass(); NewTestClass1.Property1 = "Hello1"; NewTestClass2.Property1 = "Hello2"; JonsArray.Add("Obj1", NewTestClass1); JonsArray.Add("Obj2", NewTestClass2); JonsArray.TryGetValue("Obj2",out NewTestClass1); MessageBox.Show(NewTestClass1.Property1.ToString(), "Hello"); ...
Score Find & Update a DataTable created using the VS2005 DataSet designer
Bishman - 4 Aug 2006 6:16 PM - 1 message
Hi, I need to create a temporary 'work' table within my app. I have used the Dataset designer to create the table, apply a key etc. My issue is how do I Add and Update records when there is no 'FindBy' method ...
Score DataRelation / DataSet Question
corey.burnett - 4 Aug 2006 6:05 PM - 5 messages
Here is my situation: I have a .NET application that queries a WebService to get the data for the application.  The WebService does not support Joins of any type even though the data in the back end is relational.  The WebService ...
Score UpdateDB from DataSet
Al - 4 Aug 2006 3:45 PM - 4 messages
I have this scenario: 1. XML file with schema and data is created from SQL Server tables. XML file contains 6 tables, some of them have rows, some of them are empty. 2. XML file is given to the person with Pocket PC. ...
Score Extracting data from word and trasnfering to excel
Jeenu - 4 Aug 2006 12:48 PM - 1 message
I have to develop an application which will extract some data from word and transfer it to an existing excel doc. The data in word is in tabular format. The app need to transfer the data in a table (which can ...
Score Unable to get Count expression of DataTable to work !
VTOcin - 4 Aug 2006 11:26 AM - 1 message
Hi, I'm trying to convert my old VB6 code to VB2005. I was using a MDB database and a SQL statement to do a GROUP BY COUNT. I have been struggling to find a clear and simple VB2005 example on how to do that ...
Score WebService fails on Win03 when moved from Win2000 or XP
Tom - 4 Aug 2006 9:53 AM - 2 messages
Hi, We have a web service (developed in C# framework 1) that run for some time on Windows 2000. Recently we upgraded it to framework 2 and it runs successfully on Windows 2000 and XP. However, we need to run it on new Windows 2003 box and the web service just ...
Score Best way to rename column in Access database file
nvx - 4 Aug 2006 8:07 AM - 9 messages
Hi, I need to rename columns in an Access database file programatically (OLEDB provider). There is a way though (create a new column, copy data from the old column into the new one and delete the old column), but I was wondering if there is a simpler ...
Score Using oleDb/odbc text driver - trapping 'dodgy' records or errors
dan.t.matthews - 4 Aug 2006 8:00 AM - 1 message
Can someone adivse, if my source csv file has an erroneous quote or some other bit of data that the driver can't resolve I dont get any data returned for the rest of the line, fair enough but does the reader provide any means of ...
Score Timeout - max pool size reached
tshad - 4 Aug 2006 12:47 AM - 8 messages
I got the following message on my Sql Server 2000: Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached. ...
Score Compare 2 DataSets
Al - 3 Aug 2006 8:51 PM - 7 messages
I'd like to know if there were any changes in the DataSet which was populated by reading XML file. 6 DataTables with data or just structure with no data inside of it. I think about this scenario: I create 2 datasets and populate both from the same XML file. Then the first ...
Score .Net DB2 Connect
Jim Heavey - 3 Aug 2006 8:45 PM - 2 messages
I have now found and installed the drivers for db2.net.  I can see that there is an entry in WINNT/Assemblies for "IBM.Data.DB2".  But when I go into Visual Studio to create a reference to this assembly, it does not show up in ...
Score VS2005: TableAdapter - need to get the underlying DataAdapter
Jim Rand - 3 Aug 2006 7:27 PM - 6 messages
In VS 2005, table adapters are used as wrappers to underlying data adapters. Dragging the tables onto the dataset designer surface automatically creates table adapters. Unlike the data adapter, the table adapter throws no events such FillError, RowUpdated or RowUpdating. ...
Score Row removed from a dataset table is not removed from a database table during update
nvx - 3 Aug 2006 4:47 PM - 3 messages
Hi, I have a problem with updating a database table bound to a DataGridView. After I fill the DataSet with DataAdapter.Fill(), generate INSERT, DELETE and UPDATE commands using CommandBuilder, remove some rows from the DataSet.Tables["tablename"].Rows collection, call BindingSource.EndEdit() and DataAdapter.Update(), these removed rows are still present in the database file. In ...
Score Row removed from a dataset is not removed from a table during update
nvx - 3 Aug 2006 4:42 PM - 1 message
Hi, I have a problem with updating a database table bound to a DataGridView. After I fill the DataSet with DataAdapter.Fill(), generate INSERT, DELETE and UPDATE commands using CommandBuilder, remove some rows from the DataSet.Tables["tablename"].Rows collection, call BindingSource.EndEdit() and DataAdapter.Update(), these removed rows are still present in the database file. In ...
Score Error HRESULT E_FAIL has been returned from a call to a COM compon
M O J O - 3 Aug 2006 3:43 PM - 1 message
Hi, I'm trying to set up my web server (aspnet 2.0 application) to use transaction (MSDTC) to store data in my SQL Server 2005 (two different servers). I've set up the security on both servers ... Start->All ...
Score Typed DataSet Column Casting
J055 - 3 Aug 2006 1:35 PM - 3 messages
Hi I have a created a typed DataSet (VS 2005). A couple of columns return sql tinyint types which ideally need to be cast to predefined enums for use throughout the application. It seems that it would be good to do this in a ...
Score ADOX in .Net
Solel Software - 3 Aug 2006 11:43 AM - 2 messages
Hi, I am attempting to change an Access 2000 mdb's field's AllowZeroLength property to true using .Net 1.1 SP1 and having trouble getting it to work.  It seems that I am not adding the updated column to the catalog, and am not ...
Score creat a data table from the gridview
Etariq - 3 Aug 2006 11:27 AM - 1 message
hi all the usual way to bid a gridview is to data soursce is there a way to do  the folowing , creat a data table from the gridview shown valus " currunt page " thanks ...
Score Error 'General network error. Check your network documentation.' in adapter.fill
trialproduct2004 - 3 Aug 2006 4:44 AM - 2 messages
Hi all, I am filling sqldataadapter by executing one stored procedure. But while calling adapter.fill i am getting error 'General network error. Check your network documentation.'.  This application is working 2-3 times and then starts giving m error. ...
Score Display update in Grid (dataset) using procedure
thejamie - 3 Aug 2006 4:28 AM - 1 message
I have a complex sp and would like to allow the user to preview the results of the sp once it is applied without actually updating the dataset in the database.  I retrieve the dataset sample "test" back from the grid, but I am ...
Score Pass file to Oracle stored procedure
Bala Nagarajan - 2 Aug 2006 9:17 PM - 1 message
Hello,         Does anyone know how to pass a binary/text file from .NET 1.1 to an Oracle Stored procedure and parse the same file in the procedure? Any help will be appeciated. ...
Score Expression Column Or SQL Query
Steve, Putman - 2 Aug 2006 9:09 PM - 3 messages
Hi Gurus, Keeping it short - Suppose I have a Table with two columns- Column1 and Column2, and it got lots of data. Now I want to create another column(Column3) joining Column1 and Column2. I can do it in two ways, ...
Score Silly question .. "typed" connection strings
Earl - 2 Aug 2006 6:05 PM - 3 messages
I've started using these typed datasets, but of course, they automatically assign my dev. server to be the server name. However, I am using some XML methods to save and retrieve the connection string, so that I can deploy the ...
Score CAST,CONVERT,CELING,FLOOR DOES NOT WORK
Shiplu - 2 Aug 2006 4:08 PM - 3 messages
Hello all, select CAST(35.340 AS INT) the above sql doesn't work in ADO.NET, any idea ? Other functions mentioned in the subject does not work also I am handling a CSV file using ADO.NET and C#. ...
Score Create MDB in ASP.NET 2
Edwin Knoppert - 2 Aug 2006 3:20 PM - 10 messages
I need to create an empty MDB from code. Can't find it on google. ...
Score how to generate crystal report for remote database
sai - 2 Aug 2006 7:59 AM - 2 messages
hi all,           i am new to crystal reports.I am developing an application of remote database viewer,Front-end VB.NET Backend MS.Access. here the database schema and database tables  are same for all the databases in remote ...
Score clr 2.0 missing in iis log (& broken app)
frank - 1 Aug 2006 9:17 PM - 5 messages
We created an asp.net 2.0 app, which sends smtp email using System.Web.mail. The app is in an IIS 6 application pool isolated to 2.0 apps on a 2003 server. The app worked fine for a few days; recently however it began failing when ...
Score Pooling Connection String
ajay.kalyan - 1 Aug 2006 8:17 PM - 3 messages
I am trying to implement connection pooling on web application and was wondering what connection string I should use.  I currently use: Data Source=xxx.com,25000; Initial Catalog=xxx; UID=user;pwd=password Should I add anything to this connection string i.e pooling=true, max ...
Score Help: Transaction object not associated with Connection Object
driss - 1 Aug 2006 6:52 PM - 1 message
I'm stumped. I'm using .NET 2.0 with the Enterprise Library (January 2006 edition) for communicating with my Oracle backend.  I have a need to change a set of objects' saves together, and thus figured I would ...
Score Urgent help required error gdi+
amit - 1 Aug 2006 5:21 PM - 1 message
we have built a windows application,everything worked fine but untill seeing following error during testing stage i got this error System.Drawing at System.Drawing.Bitmap.ctor.ImageSave(string...) Everything works fine on machines which have visual studio 2005,but it ...
Score SqlBulkCopy class problem - Timeout expired!
CleverMindworks - 1 Aug 2006 3:50 PM - 6 messages
So, apparently there is a known bug: [link] A have applied the patch, and yet I'm now consistently getting the 'timeout expired' error. The symptoms match the article, yet the patch didn't seem to fix anything. ...
Score Generated strongly typed dataset - null date column - exception when Fill or GetData called on table
rharding - 1 Aug 2006 3:16 PM - 4 messages
Hi, Does anyone have a workaround for the this: This is all 2.0 vs 2005 - I generate a strongly typed dataset and table adaptor in vs2005 but the oracle table its based on allows a date column to be null - this shows up as "AllowDBNull = true" in the column ...
Score Problem with Count Expression and DataTable
VTOcin - 1 Aug 2006 1:44 PM - 4 messages
Hello, I created an XML file using the DataTable.WriteXML with the follwing format: Dim ACES_FLIGHT_SCHEDULE As New DataTable("ACES_FLIGHT_SCHEDULE") 'Add columns to the ACES FLight Schedule Table ACES_FLIGHT_SCHEDULE.Columns.Add("Origin_Airport_ID", Type.GetType("System.String")) ACES_FLIGHT_SCHEDULE.Columns.Add("Destination_Airport_ID", ...
Score Table Adapter and Xml DataType
Martyn Fewtrell - 1 Aug 2006 1:40 PM - 8 messages
I'm not really sure whether this is the correct group but here we go. The SQL 2005 supports a new datatype called xml. If I create a table adapter in Visual Studio 2005 for the standard insert/update/delete/select methods the table adapter generates a dataset ...
Score about CEILING
Shiplu - 1 Aug 2006 1:15 PM - 1 message
hi, I am trying to apply celing funcion. suppose, sec = 23 pulse = 10 output = 30 again, sec=29 pulse = 5 output = 30 to do this I did the folowing, select (CEILING(sec/pulse))*pulse as output but an error, Undefined function 'CEILING' in expression ...
Score Column Data Type problem (ADO.NET, C#)
nvx - 1 Aug 2006 6:57 AM - 3 messages
Hi, I need to be able to add or remove columns from an Access database table (table is bound to a DataGridView). I know I have to use ALTER TABLE to do this. After I add a System.String column (AllowDBNull = ...
Score Sql Server Migration
Nitin - 1 Aug 2006 6:42 AM - 3 messages
I used access as backend for a website and it worked perfectly fine. Now i have changed to MS SQL Server 2000. The page gives an error "Must declare the variable '@CategoryId'. "  (@categoryid is a oledb parameter) when I remove all the parameters and create the query using string.format it ...
Score displaying additions upadtes
Ant - 1 Aug 2006 6:03 AM - 3 messages
Hi, I need to display rows that have been updated AND added to a dataTable. I can use a dataviewto filter for ModifiedCurrent or Added, but how can I combine the results so as to be able to view them all? ...
Score how to check programatically wether a oracle stored procedure has default valued parameters?
hiten - 1 Aug 2006 5:13 AM - 3 messages
I want to get the collection OracleParameter[] of all the stored procedure parameters which are assigned default values in stored proc. The way in which I was trying out was to get the parameter array with the help of OracleCommandBuilder.DeriveParameter() method.  But this ...
Score Binding to two dataviews
Ant - 1 Aug 2006 2:50 AM - 4 messages
Hi, Why is it that if I have two seperate instances of a  DataView & use the defaultView of a table to set them, then filter each one by Rowstate in different ways for each, they are both set the same, to the last rowstate ...
Score DataTable, Delete, GetChanges, Merge....What's wrong?
PhilipH - 31 Jul 2006 9:31 PM - 3 messages
/*   The following code :   Creates a DataTable with four fields.   Copies the table in a DataSet.   Message Box displays 0 rows.   Adds three rows to the DataTable   Merges the DataTable into the DataSet   Message Box displays 3 rows. ...
Score Stored procedure w/multiple SPs - can I use DataSet Designer?
Eddie - 31 Jul 2006 8:38 PM - 3 messages
I've got a SP that actually executes 7 other SP's.  I'd like to use the DataSet Designer to create the DAL for this app, but I'm not sure it can be done with this type of SP?  Right now all I get is the initial resultset ...
Score Issue SQL Statement with a DataTable in VB 2005
VTOcin - 31 Jul 2006 7:40 PM - 3 messages
Hi, I'm creating a DataTable from an XML file: Dim ACES_FLIGHT_SCHEDULE As New DataTable("ACES_FLIGHT_SCHEDULE") ACES_FLIGHT_SCHEDULE.ReadXml(ACES_Project_Dir + "\FlightSchedule_" + CaseYear + "_Quarter" + Quarter + "_" + SATSAirportSetName & ".xml") Then I would like to execute the following SQL Statement on the DataTable and save the results in another DataTable: ...
Score Setting the order of rows stored in a DataTable
TomU - 31 Jul 2006 6:08 PM - 9 messages
Is there a way to specify the sort order of how physical rows are stored in a DataTable? I thought specifying a primary key would define the order but it doesn't. Using a DataView every time to insure the required sorted order ...
Score How to fetch data from Sql Server table for Comparison and how to do the table binding?
ajmera.puneet - 31 Jul 2006 5:31 PM - 1 message
If I have Calendar Control on Asp.net page  and I have a table for Fiscal years on sql server then, How can I check the dates from table to Calendar Control,so that I can format the Calendar control cells according to my need. ...
Score TableAdapter.Fill() Return Value Meaning
Scott - 31 Jul 2006 4:43 PM - 4 messages
All, I am using a TableAdapter Fill method to return a row(s0 into a data table: int return = daMyDataAdapter(myTable, 3); Where above will fill myTable when it's index = 3; However I cannot find any documentation on what the return value is for this ...
Score GetInsertCommand problems...
Rob R. Ainscough - 31 Jul 2006 4:11 PM - 3 messages
I've noticed that the OleDbCommandBuilder.GetInsertCommand often produces incorrect syntax which will generate errors.  I've had to override and provide my own commands.  Specifically the GetInsertCommand seems to have issues when dealing with "reserved" words -- as in a field name "Note" -- it ...
Score SqlClient Connections created don't get reused in the pool and cause error in ASP.NET Page
mc - 31 Jul 2006 2:23 PM - 17 messages
I have a ASP.NET app which I have recently converted from OleDB to SqlClient, however when I Get a connection, use and close it, It stays open (Process Info in Sql Server Enterprise Manager say the connection is sleeping) and very soon I hit the currently defined 100 connections ...
Score ODBC DataAdapter -> Strongly Typed Datasets
zackary.evans - 31 Jul 2006 2:14 PM - 1 message
I am having a problem using strongly typed datasets with the ODBC dataAdapter. The main problem is that I am connectiong to an Informix (IDS 10.0) database by calling a stored procedure. The procedure does not return column names, so I cannot run the .Fill() method against the ...
Score DB2 ODBC
Jim Heavey - 31 Jul 2006 2:13 PM - 5 messages
I am trying to figure out how to construct a Connection statement for DB2 via ODBC. According to the "ConnectionStrings.com", it should have the following information. driver={IBM DB2 ODBC DRIVER};Database=myDbName;hostname=myServerName;port=myPortNum;protocol=TCPIP; uid=myUserName; pwd=myPwd ...
Score Traverse a Many-to-Many relationship
Michael D. Reed - 31 Jul 2006 1:26 PM - 2 messages
I have two tables in an Access database with a Many-to-Many relationship, there is a connection table.  The tables are [Product Line], [Factors], and the connection table is [Product Line performance Factors] this is a standard Many-to-Many relationship in that the connect table only has two foreign key ...
Score MS Access Update Error
Jim Heavey - 31 Jul 2006 12:57 PM - 2 messages
When I attempt to do an updated to a MS Access Database, I get the following Error Code returend "-2147217900".  The error message says "syntax error on insert statement", but I can paste that SQL into Access and it works just ...
Score OleDB Exception Error codes
Reny - 31 Jul 2006 11:02 AM - 2 messages
Can any one list the OleDbException ErrorCodes ...
Score Free .Net data provider.
Joel Silva - 31 Jul 2006 8:21 AM - 1 message
Hi, here is information about a free, simple and effective data provider for Web and windows Forms. ..Net DatabaseHandler 1.1 was developed in C# and it may be used both with .Net 1.1 and 2.0 applications. It allows a developer to use the same API for accessing Sql Server 2000, ...
Score Binding to a datagrid
Ant - 31 Jul 2006 5:58 AM - 3 messages
Hi, I'm using C# VS2003 I need to bind either a Filtered data view or a data set of changed rows, to a datagrid programmatically to show changed rows before updating. I can't seem to do it. The Dataset I'm copying the changes from is typed. ...
Score How much is too much?
Earl - 31 Jul 2006 2:28 AM - 7 messages
I'm working on a project with a database normalized to 4NF. I'd like to use strongly typed datasets as much as possible on the main form, but it appears I may need as many as 20-25 data adapters. What's the best practice here and ...
Score LISTEN TO SEXY FREE NOW
mediapuri - 30 Jul 2006 12:36 PM - 1 message
English / Chinese / Franch / Germany / Japan / More World Largest, LIMITED TIME FREE TO LISTEN!!! 24-Hrs +91 9810577227 ...
Score SEX HOT LINE FREE TRIAL!
TCI SM - 30 Jul 2006 12:23 PM - 1 message
English / Chinese / Franch / Germany / Japan / More World Largest, LIMITED TIME FREE TO LISTEN!!! 24-Hrs +91 9810577227 ...
Score Buy 2nd handphone for India market
i - 30 Jul 2006 12:11 PM - 1 message
Highest rate for all type / brand 24-Hrs +91 9810577227 Puri ...
Score Using CreateDataReader to get a value from a field
jonefer - 30 Jul 2006 9:33 AM - 1 message
I have a tried and true method for grabbing a value in a field based on a parameter.  But I would like to use the CreateDataReader method, or any other efficient method for user with the graphical dataset designer objects created. ...
Score Handle OleDbException like Primarykey violation
Reny - 30 Jul 2006 8:05 AM - 2 messages
Can any one give me a clue on how to handle OleDB Specific exception .like Primary key violation I want to catch specific exception and inform the user in a friendly way that  this is the error ...
Score System.data.sqlclient namespace question
Sean - 30 Jul 2006 2:44 AM - 1 message
This question is going to relate to how SQL 2005 server uses this namespace on its side of the equation. So a good level of understanding on .net intergration with SQL 2005 I think will be extreemly helpful. Basically, SQL 2005 is sending me one too many parameters from a stored ...
Next »