Home All Groups Group Topic Archive Search About

ADO.NET

microsoft.public.dotnet.framework.adonet
Score how to update the database using SqlcommandBuilder
mohanaranga - 24 Dec 2005 9:42 AM - 3 messages
Hi All,      I want to update the values into database.And i get these values from a xml file.I have done the coding for that but its not getting updated.Plz tell me whats wrong in my program.if possible provide me ...
Score Multiple database support
Me - 24 Dec 2005 2:12 AM - 6 messages
How do most people support multiple database types such as SQLServer, Oracle, Access, etc.? Mainly I am wanting to just support MS (SQLServer and Access) but may need others in the future. I am currently looking at creating a simple class that has a few methods for ...
Score Where is my Data Adapter in 2005
Gary Blakely - 23 Dec 2005 10:29 PM - 2 messages
I notice that after converting a vs.net 2003 ASP application to vs.net 2005 that my DataAdapters are gone from the design view along with the ability to enable the Data Adapter Configuration Wizard !! Surly you are not going to tell me that my Data Adapters can no longer be ...
Score TableAdapter and Transactions
Jonathan Seidner - 23 Dec 2005 10:05 PM - 5 messages
I saw a lot of people were having a problem with this and I found an elegent solution to this problem so I decided to post it. Use the following Example: ---------------------------------------      private void BindingNavigator_OnSaveItemClick(object sender, ...
Score DataColumn.Expression not re-evaluating after a RejectChanges call
Oldman - 23 Dec 2005 7:10 PM - 1 message
Background: Using ADO.NET 2.0 with VS2005 RTM. I have a data column with the following set for its expression property: Count(Child(SearchItemCollMmbr).intChildItemID) I have a Dataset with a parent and child table, linked via a relationship ...
Score Inheriting from DataGridTextBoxColumn and CancelEdit
Joe - 23 Dec 2005 5:05 PM - 2 messages
I have a combo box that inherits from DataGridTextBoxColumn. Everything works fine with the control except a CancelEdit(). The underlying rows' value is rolled back but the DataGrid column still displays the new value which was cancelled. Am I missing an event my control needs to receive the cancel? ...
Score Create Runtime SQL Query
Steve B. - 23 Dec 2005 11:51 AM - 4 messages
I have to create an SQL statement at run time based on the items the user selects on a report menu.  The SQL statement gets quite complex if you have 13 menu items each having associated WHERE cretria. I'm using StringBuider to ...
Score Connection Pool and Connection time out
Anupam - 23 Dec 2005 7:37 AM - 5 messages
Hi all, i am using Sql Connection  with SqlHelper class; it is working fine with windows xp and MSDE; when i developed the application and tried it with Sql server200+ windows 2003 it gives Error message "The timeout period elapsed prior to obtaining a connection from the pool. ...
Score Problem with .Net Framework 2 on certain machines
Programatix - 23 Dec 2005 7:14 AM - 8 messages
Hi, I'm trying to distribute my application written using .NET Framework 2.0. It uses a MDB file for it's database. On certain machines with Windows XP (I have also tried updating them to SP2), I received this exception when the application tries to connect to the ...
Score Update According To DataRowState
Yossi And Inbar - 23 Dec 2005 6:41 AM - 2 messages
Hi, I Want to update My Database , i using sqlDataAdapter and i have all the command (Insert/select/delete/update). I dont want to use update method cause i want to delete first from one table and then insert to the other ...
Score connect remote Access database
wind - 23 Dec 2005 3:41 AM - 26 messages
Hello I want to ask how to connect a vb.net window client application to a remote MS Access databae which is located on a server? How to set the connection string in order to do so? Thank you ...
Score Control Refresh Not Working on AddNew
JohnT - 23 Dec 2005 2:30 AM - 1 message
When binding a control to a BindingSource and executing .AddNew on the binding source, then setting default values on the row, the bound controls do not show the default values until .ReadValue() is called from the control binding, even though ControlUpdateMode is set to OnPropertyChanged: ...
Score DataTable with Column Default Values not working as execpted
William F. Kinsley - 22 Dec 2005 10:47 PM - 2 messages
I was having a problem using a DataTable targeted against a table with columns that have default values and do not allow nulls.  When you added a new row to the DataTable, and call Update on the adapter.  It uses the ...
Score THE > SUPER-MONEY-SOURCE <
THE > SUPER-MONEY-SOURCE < - 22 Dec 2005 10:42 PM - 1 message
THE  > SUPER-MONEY-SOURCE < Would store / would copy this text or side before the administrator could remove this letter. This special program is acquire copyrighting-protected, only with the participation you the copyrighting at this program.  Prohibited utilization ...
Score enumerating sql servers in sql server 2005
Brian Henry - 22 Dec 2005 8:50 PM - 7 messages
Is there anyway new in SQL Server 2005 to enumerate all the servers on the network without sqldmo? I'm working in .NET and want to get the list, im doing it now in sqldmo and it works fine, but would like to do it with ...
Score Wire RowChang events in C# using partial classes (Easy in VB - Not
edge@nospam.nospam - 22 Dec 2005 4:19 PM - 6 messages
Any advice on how to use partial classes in C# to subscribe to RowChanging or ColumnChangine events???? [link] is an excellent VB.Net article on using partial classes to validate changes ...
Score Simple table mapping?
David Veeneman - 22 Dec 2005 1:27 PM - 3 messages
What is the easiest way to map table names when filling a dataset? I am filling a dataset from two tables. My command text looks like this: "Select * from FooTable; Select * from BarTable". After the fill, the dataset tables are named 'Table' and 'Table1'. So, I rename the tables using ...
Score Error Reading Excel Numeric Column Names
Rohit - 22 Dec 2005 7:01 AM - 2 messages
I am using GetOleDbSchemaTable to read the data from the Excel file. It is working fine with all workbook/worksheets except the one that has numeric column names as headers. The connection string is strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + ...
Score Error Reading Numeric COlumn Names from Excel
Rohit - 22 Dec 2005 5:36 AM - 1 message
I am using GetOleDbSchemaTable to read the data from the Excel file. It is working fine with all workbook/worksheets except the one that has numeric column names as headers. The connection string is strConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + ...
Score Constructing a Union query for a DataGrid
jonefer - 22 Dec 2005 1:45 AM - 3 messages
How would I do the following for a datagrid? I want a Union Query to be my DataSet for a datagrid: 1) The Union Query qBenefitsUnion ============ SELECT * FROM qIN UNION SELECT * FROM qOUT 2) The Pieces that make up the Union ...
Score Relational dataset strategy?
David Veeneman - 22 Dec 2005 12:22 AM - 3 messages
I'm trying to figure out how best to solve the following problem: I have a database with two tables, Projects and Steps, that I want to read into a dataset. Projects contain Steps, so I will create a data relation between ...
Score referring to an Adapter like a table or query?
jonefer - 21 Dec 2005 9:06 PM - 3 messages
In Microsoft Access, it is possible to create a query and then refer to it inside another query... how would I do this in ADO.NET? I'd like to create a simple select query and call it something like: ...
Score New Server
john wright - 21 Dec 2005 8:56 PM - 2 messages
I just received my new report server for the company.  It is running Server 2003 with SQL Server 2000 and Oracle.  Report server is running great.  Now I want to design reports and post them.  I downloaded the Eval version of ...
Score Re: Data management form
Jerry H. - 21 Dec 2005 7:41 PM - 1 message
Sounds like you're asking for "best practices" with regards to building a list form, and accompanying edit form, yes? You could start here: [link] ...
Score DataGridView Problem...
Xtek - 21 Dec 2005 7:20 PM - 1 message
I've been messing around with ADO.NET a lot lately and I recently ran into a problem. So I put a DataGridView on my form and bind it to a DB.  It's working great... except for when it needs to use the Vertical Scroll bar.  Whenever ...
Score objectdatasource.update() fires System.InvalidOperationException
Markus - 21 Dec 2005 3:47 PM - 2 messages
hello, we have a strage error message here: I've written a small detail sample page, where I can update one reocrd with an objectdatasource control and the detailsview control. the objectdatasource.confictdetection is set to 'CompareAllValues'. The Updatemethod is UpdateXY and I've set two updateparameters classX and ...
Score Multiple db access in vb.net
CarterM - 21 Dec 2005 3:20 PM - 2 messages
I need to pull data from two separate DBs in SQL Server with the ability to store a value (id) from db as a foreign key in the second db and display a name associated with that id. I don't want to duplicate the Customer table ...
Score Invalid_character_(=BF)_gets_saved_in_DB_using_ADO.Net_for_Hexadecimal_value_('-')_['Alt_+_0150']
Sunil Menon - 21 Dec 2005 2:02 PM - 4 messages
Dear All,    We have developed a WinForm application where a user enters some free text if the free text contains Hexadecimal value ('-') ['Alt + 0150'], then after saving and getting back the value, the ¿ is shown in its place. ...
Score ASP.Net DataGrid: How to retrieve input values in template column?
Richard - 21 Dec 2005 1:31 PM - 1 message
I have added a template column of dropdownlist to the datagrid, with 2 options ("No Change" and "Delete") in each dropdownlist. "No Change", the first list item, is selected by default during design time. The user will mark the grid items to delete by selecting the "Delete" ...
Score IErrorInfo.GetDescription failed with E_FAIL(0x80004005).
JimO - 20 Dec 2005 10:02 PM - 1 message
I'm working through this Wrox book chapter about .Net data access.  I'm using an Access Database and I keep getting this error when using the OleDbCommand and OleDbDataAdapter.  It works as a stored procedure but not ...
Score dynamic change theme using datanase?
Tony Dong - 20 Dec 2005 9:18 PM - 1 message
Hi there I use C# write preInit as follow to set theme dynamically by dropdownlist and it is working for me, but how can I get theme from database first time and second time using dropdownlist value(+ save into database)? any good ...
Score ADO.NET 2.0 Dataset based on XML schema file
JohnMSyrasoft - 20 Dec 2005 6:45 PM - 5 messages
Hi, I'm trying to use a typed DataSet based on an XML schema file.  Here is a sample XML schema file for a "Location" with four typed-defined elements:   <xs:element name="Document1">     <xs:complexType> ...
Score Enlist attribute in connection string in absence of MTS
Bhupesh - 20 Dec 2005 5:24 PM - 2 messages
Hi, Is there any effect of Enlist attribute in the connection string if there is not DTS environment, No COm+ or MTS. I am facing a problem where the connections I receive from a connection pool has pending transaction. is this anyway possible? ...
Score CrystalReport Viewer Export in asp.net
rbutch@coair.com - 20 Dec 2005 5:02 PM - 3 messages
hey guys, any idea(s) why this code would only export the first page? it works perfectly - just if the report has multiple pages, it only exports one. thanks for any help ive been all over the web and this seems to be the code everyone is using. ...
Score Altering a serialized DataSet
Arian T. Kulp - 20 Dec 2005 4:34 PM - 2 messages
I created an application that makes use of a typed DataSet for holding its data.  This DataSet is saved out with simple XML serialization.  Now, after having deploying the application to a number of people, I'd like to add a ...
Score mdb read only - not the usual problems
cjb - 20 Dec 2005 2:46 PM - 7 messages
Hi, I originally posted this on public.data.ado, and someone nicely informed me that this group is probably better suited to my question, so here goes: I have an mdb that I open using asp.net. I edit these pages and code ...
Score ASP.Net - Adding User Controls to DataGrid
Richard - 20 Dec 2005 2:39 PM - 4 messages
Instead of button columns, I need to add a column of dropdownlists to my datagrid, with options such as ADD, EDIT, and DELETE to each row of data. How can I do that? Thanks, Richard ...
Score Can't use the automatic UPDATE (SQLDataSource) in GridView for ASPNETDB?!
stockblaster - 20 Dec 2005 11:44 AM - 5 messages
Hello I am displaying into a GridView the ASPNETDB content (that was created with the login control of ASP.NET 2.0) why doesn't  the SQLDataSource let me use the UPDATE method.. When i click Advanced on the SQLDataSource configuration those options ...
Score DataTable refill problem
mspzzz - 20 Dec 2005 10:27 AM - 9 messages
I am using a DataGrid with a dataset and the OracleDataAdapter.Fill(dataset,"Tablename") method. All is fine: a table is created and mapped to the dataset and data is shown in the datagrid. When I clear the table, dispose it and remove it from the dataset, and then ...
Score Get ID (Identity field) from a new record
fantavir - 20 Dec 2005 9:24 AM - 2 messages
Hi, I'm trying to insert a new record in a Table (the field ID is numeric, counter and primary key) and get the value of the field ID, using ADO.NET. Accessing recordset (rst below) by ADO I can do: ...
Score Disconnected DataSet and DataTable
Amnon Rapoport - 20 Dec 2005 7:01 AM - 5 messages
Anyone have code that generates a DataSet  and DataTable from scratch using code with a given connection, to MSAccess. Does this disconnected DataTable track changes??? Can I turn off the "Tracking". Help would be appreciated ...
Score ado.net 2.0?
Brent - 19 Dec 2005 10:13 PM - 3 messages
Ok please somone correct me if im wrong. I think a lot of the changes to the underlying structure to ado.net in version 2.0 are for controls. The new features make it much easier to bind controls to the database with almost no ...
Score TableAdapter connections when filling multiple tables
JohnMSyrasoft - 19 Dec 2005 10:11 PM - 2 messages
When filling multiple tables with DataAdapters, I explicity open the connection object that is passed to the DataAdapter before and close it after the tables are filled. Now, in 2.0, I'm filling multiple tables with TableAdapters and making use ...
Score TableAdapter instead of Object-Relation mapping model
ad - 19 Dec 2005 7:43 PM - 5 messages
TableAdapter is a new feature of VS2005, is it good to use TableAdapter to replace Object-Relation mapping model? ...
Score "COM object that has been separated from its underlying RCW cannot be used."
Steve - 19 Dec 2005 6:34 PM - 1 message
I've started getting this exception since installing vs2005 The code this is causing the exception is: <code>     try     {         m_command.CommandText = GetAccessSprocString(m_spDeleteProtocol);         m_command.Parameters.Clear(); ...
Score Is it possible to set a datacolumn's datatype by using a string value?
Benton - 19 Dec 2005 5:43 PM - 4 messages
Hi there, I want to create some DataColumns using the following approach: string datatype = "int"; DataColumn intCol = new DataCoulmn(); intCol.DataType = typeof(datatype); string datatype = "string"; DataColumn strCol = new DataCoulmn(); strCol.DataType = typeof(datatype); I know it doesn't work quite like this, but, is there a way to accomplish ...
Score Transaction Error on Sql Server with instance name.
apiringmvp - 19 Dec 2005 4:59 PM - 7 messages
Everyone, I am trying to load a bunch of records into a Sql Server 2005 Database using (TransactionScope ts = new TransactionScope()).  I keep getting an error message saying MSDTC on server 'SOHO/SQLEXPRESS' is unavailable. my SOHO server is a Win2K3 Server with SQL Server 2000 using the ...
Score ArgumentException on setting ConnectionString
Michael.Suarez - 19 Dec 2005 4:10 PM - 9 messages
I am currently making the jump from VB6 to C#. We have a login prompt that returns an ADO connection. Eventually I will have to re-write this login prompt in C#, but for now I have to use it for a C# program that ...
Score Convert Data Reader into DataSet
Chris Davoli - 19 Dec 2005 3:32 PM - 6 messages
Environment: VB.Net, SQL Server 2000. I've used both data readers and also datasets with tables in them. I would like to use a data reader (because of its speed) to retrieve using a stored procedure with TWO selects in the stored proc (two result sets), then go thru ...
Score User Permissions
Ferdinand Zaubzer - 19 Dec 2005 3:27 PM - 2 messages
Ho can I get user permissions on a certain table to see if the user is allowed to delete or update or insert records on a table. It would be helpful to have this Information this before trying to make ...
Score How to increate data loading performance?
abc my vclass - 19 Dec 2005 2:36 PM - 9 messages
In my application, it reads several tables from database when loading the form.  Many users feel the application hang.  How can I improve the performance of this application. The application load data table by table.  I known ADO.NET can read all ...
Score ConnectionString
Josep Solà - 19 Dec 2005 12:56 PM - 7 messages
Hi, I'm using a connection string what has this DataSource : "PCNAME\INSTANCENAME,1884". In my application if I don't use name instance and port, it works fine, but if  I use instancename and port don't work. ...
Score Probem: No size set for variable length data type: String, using OracleDataAdapter
Benny - 19 Dec 2005 11:41 AM - 5 messages
Hi all,         Anyone face this problem on oracle 10g and Visual Studio.Net 2003 ? The following code works fine if using the mysql4.1 with the library of the MySQL.Data. But error occured while using the library of ...
Score What to use: RowFilter or Query?
Frederik - 19 Dec 2005 10:14 AM - 4 messages
Hi all, I have a database that contains almost 10,000 records. It's an Access DB that's only being used on a single computer (no access from multiple users at the same time). The front-end is a windows form app. It has a ...
Score Sort without displaying Duplicates
den 2005 - 19 Dec 2005 7:57 AM - 16 messages
Hi everybody,    I like to asked anyone who is very good at sql to help me display this data in a table format that duplicate headings, subheadings or other columns won't appear twice or more. Can anyone help me? I need to sort them and load ...
Score How can I get SqlDependency to work with CLR Stored Procedures
Robert Zurer - 19 Dec 2005 3:57 AM - 1 message
I set up a test application using SqlDependency. It worked very well as long as I was using simple Stored Procedures entered via Sql Server Management Studio. When I wrote the same procedure in a Visual Studio 2005 Sql Server Project ...
Score Any Suggestions on how to do a multiple change to data?
Mr. B - 19 Dec 2005 12:22 AM - 10 messages
I'm open to suggestions on how to accomplish this easily (VB.net... MS Access): I've an MS Access db.  It has a column indicating if the row has been Exported or not (the Column is a Boolean). ...
Score How to store object created with C# in SQL Server 2000
basulasz - 18 Dec 2005 10:15 AM - 2 messages
I want to store the objects that i create in run time in database. In a way that, for a product a create an object from a class written with C#, define its properties and functions that it has, and want to store it in a database ...
Score How to convert a datareader to datatable?
abc my vclass - 18 Dec 2005 8:08 AM - 8 messages
How to convert a datareader to datatable? ...
Score How can gather a table's schema from SQL Server 2005?
abc my vclass - 18 Dec 2005 8:04 AM - 2 messages
How can gather a table's schema from SQL Server 2005? ...
Score installed 2.0.50727 now I get a sql express error message
deltalimagolf - 18 Dec 2005 12:08 AM - 7 messages
I now get the following error message after copying an asp.net application to the deployment web server.  I don't have SQLExpress or any version of SQL 2005 installed.  I found the "LocalSQLServer" connection string in the ...
Next »