I'd like to create a typed dataset based on a db-defined structure (ie defined in records in the db, not in metadata!) I tried a stored procedure (SQL Server 2005) that's creating some dynamic sql based on the queried structure, something like: create procedure test as exec ('select c...more >>

How can I re-sort a the rows in a data table? Here is the example: I read a data set that is sorted by probability. Then some algorithm recalculates the probability field in each record.. As a result of the new probability value, the rows very often are no longer sorted. to continue the pr...more >>

Since System.Data.GetOleDbSchemaTable does not support the querying of SPROC parameters in MDAC 2.7, does anybody know of a work-around? Does anybody know of a specific SQL query that can return the details of sproc parameters?...more >>

BACKGROUND INFO: I'm using the common DbConnection object in my application because the user can have data hosted in Excel, Access, SQL Server, or Oracle. I'm using the common DbProviderFactories.GetFactory(providerName); to get the appropriate factory object for creating a specific connect...more >>

hey guyzz !! actually i had installed Microsoft visual studio 2005 along with Oracle 9i enterprise edition, jus wanted to know how can i connect it thru VS when i makin a project in c #. when i put a namespace using.System.data. ?? then in place of ?? oracle client should come but it does...more >>

Hello All I'm using OraOLEDB.Oracle provider for accessing Oracle. Now I have a column of GUID type that is stored as RAW in Oracle. How do I pass value/type for that parameter. ?? I was using the type of the parameter as OleDbType.Guid but it fails. My query has this end string pd.oid=? ...more >>

Hi, I have an application running on a Windows Mobile 5.0 device and am using the following code to update tables in a SQL Server Mobile database . For some tables, the following code works fine but for others the database does not get updated. The Update method returns the number of record...more >>

The MSDN document http://msdn2.microsoft.com/en-us/library/tchktcdk.aspx explicitely states that it is possible to use the SqlBulkCopy class with a transaction created using the classes in the System.Transactions-namespace. However, I notice that the SqlBulkCopy constructor only accepts an inst...more >>

Newbie with this stuff. Trying to start small and just read a line in from a database to see what happens. Not even really trying to do anything with it yet. When I try to read in the return statement using GetString, I get a System.InvalidCastException. I thought handling the null case wou...more >>

While using SqlBulkCopy to insert data into a table which has a compupted column it fails, throwing an error about not being able to insert data into a computed column which is understandable, The only way you can insert data into a table with a computed column is by not specifying the column ...more >>

I was trying to insert 3Gb binary file to oracle 10g BLOB Field using ADO.Net The application uses Oracle Transaction . Now I have tried to read the file using following code (C#) string filePath = aFilePath ; FileStream fls = new FileStream(aFilePath,fileMode.open,FileAccess.Read); byte[ ] ...more >>

Hi All Very new to ADO.Net & SQL When I create a data adapter to SQL 2005 server I get the meassages. Generated SELECT Command Generated TABLE Mappings Error creating INSERT command Error creating UPDATE command Error creating DELETE command If I create a data adapter to a SQL 2000...more >>

VistaDB 3 CTP has been released as the world's first fully managed SQL database engine for Microsoft .NET, Compact Framework, Windows Vista and Mono. Unlike the new SQL Everywhere, .NET developers can use VistaDB 3.0 to build 100% managed WinForms and ASP.NET database applications that run on ...more >>

I'm a new comer to the vb.net field. & I'm looking for some help on these questions. 01) Is there any limit to the number of form which can add to a certain project ? 02) I want to know how to connect a number of forms, like 1, 2, 3, 4 etc together. I want it to happend when I'm clicking ...more >>

sp_foreign_keys_rowset Does anyone know how to call this from csharp? I've profiled that the correct sql is going to the server (and it runs in QA) but ADO will not return a DataReader when I know there are results. Any help is MUCH appreciated. Thanks! Patrick ...more >>

hi, This is the real workgroup of Visual Basic 2005 express goto : http://groups.google.com/group/VB2005 thank you ...more >>

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. 3. XML file is used to populate DataSet on the Pocket PC. 4. User adds new ro...more >>

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 only allows you to select data from one table at a time. So I'm t...more >>

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 fails to run. The service ...more >>

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 technique. Thanks in advance... With reg...more >>

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 ...more >>

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. I understand what this is when dealing with Web A...more >>

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 one is used as Data...more >>

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. In VS 2003, you ...more >>

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 partial class of the typed DataTable. I would also need to convert...more >>

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 the ".Net" componets. I am assuming that I must create a reference...more >>

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 sure how to do this. Any help would be greatly appreciated! ...more >>

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. I am not getting why this is happenin...more >>

I need to create an empty MDB from code. Can't find it on google. ...more >>

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, 1. Doing SQL "Select Column1+Column2 as [Column3] From TableName". 2. Or add...more >>

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 app anywhere. The silly question is how to "redirect" the string fro...more >>

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#. I have posted previously but no answer. I need it. PLEASE HELP ! ...more >>

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 machines.I need to generate the crystal report for the data base so...more >>

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 pool size, min p...more >>

So, apparently there is a known bug: http://support.microsoft.com/?kbid=913177 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. Does anyone have any insight into this proble...more >>

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 properties but when I call Fill o...more >>

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_FL...more >>

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 with the dataset field value o...more >>

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 wo...more >>