I want to create my own Aggregate function to be used in the DataColumn.Expression property. So for example, DataColumn col = new DataColumn("foo", typeof(String)); col.Expression = "my_custom(Child.Test)"; Anyone done this before? Any suggestions on where to start? thanks ...more >>

Hello. Developing a VS2005, VB, .NET 2.0, Windows form program. Is it possible to use flat files with fixed length fields as a datasoure. I would use one for input and another to update. Any help would be gratefully appreciated. Thanks, Tony ...more >>

I am trying to get returned the autogenerated primary key value from Oracle when I insert a row. I am using the Microsoft OracleConnection class. My code is: // cmd is an OracleCommand object. cmd.CommandText += "; returning " + column_name + " into :r1"; OracleParameter pkParam = new O...more >>

I am trying to populate a DataGridView Combobox column with a different data binding source (dataset) depending upon a selection made in a previous column. I can handle the previous column but how do I assign the following properties dynamically in code? DataPropertyName DataSource Displa...more >>

Hello I need to create a search form which allows the user to search for records using multiple criteria, and then they can select that record and when clicked ok, that particular record to be displayed in the main form. I have the main form, I need to implement the search feature for that...more >>

I'm working on a small, single user .net 2005 windows application in c# connecting to SQL Express. I'm trying to learn Typed DataSets, DataTables, DataAdapters, etc. What I need to figure out is a reasonable approach (doesn't have to be totally academic) to dealing with data. In other words, ...more >>

Hi I'm using AccessDataSources to access my .mdb file, like so... <asp:AccessDataSource ID="adsStory" runat="server" DataFile="~/App_Data/MyDB.mdb" SelectCommand="SELECT * FROM Table WHERE ColumID = ?"> <SelectParameters> <asp:QueryStringParameter Type="Int32"...more >>

Hi, I created a DSN (ODBC) to connect to a database in IBM DB2. I wanted to create a dataset for 'Select' Statement by wizard. When I add a query variable @strGeoID in 'where' statement - where (PRODDTA.F1755.ZAURRF = @strGeoID), I got the error message: ----------------------------- G...more >>

While trying to connect to SQL server using OleDb I am getting the following error. The connection string used is Provider=SQLOLEDB.1;server=ctsinprnslse;database=Sample;user id=140869; password=140869 The Error I received is A first chance exception of type 'System.Data.OleDb.OleDbExce...more >>

I would like to bind some datagrids to datasource and have them update the database when a row is changed. I don't like the disconnected mode. I am developing a Windows Form app, not an ASP.net app. Would like to have the same functionality as I did with VB6 and Delphi.... Thanks ...more >>

Hi Group. Is it at all possible to inherit from typed dataset in .net 2.0? I have a dataset defined in main project that will be distributed as dll. But I want to give others a possibility to inherit from this dataset and modify tables (add columns or other tables) in that dataset as they wish ...more >>

Hi Group. Is it at all possible to inherit from typed dataset in .net 2.0? I have a dataset defined in main project that will be distributed as dll. But I want to give others a possibility to inherit from this dataset and modify tables (add columns or other tables) in that dataset as they wish ...more >>

Hi Group. Is it at all possible to inherit from typed dataset in .net 2.0? I have a dataset defined in main project that will be distributed as dll. But I want to give others a possibility to inherit from this dataset and modify tables (add columns or other tables) in that dataset as they wish ...more >>

Hello, I followed the thread "Import large text file to MS Access Database" trying to solve a similar problem, but with no help. I have a CSV file called "orders.csv" which I want to export to a MS Access table. The CSV file has the following structure: ORDER,DATE,TIME,F_NAME,L_NAME 100...more >>

We have an application that makes use of a strongly typed dataset. However, some issues have come up with the database and tools. We would like to continue using it, but would prefer to populate it from a Genric List business object. Are these possible: 1) use a generic list of business obj...more >>

Hello, is there a way to fill a DataSet.DataTable with values from more than one table from a single database file? The thing I'd like to achieve is to get something similar to a result of the JOIN keyword in SQL. Thanks for any help... With regards nvx ...more >>

Hi all, I'm having a baffling problem with a windows service that I'm working on. Basically, I am using a typed dataset to insert a large number of rows into an SQL Server 2005 database. But there's a memory leak that seems to be to do with calling the data adapters update method. It's mak...more >>

I have a program which allows the user to graphically create SQL statements without having to know SQL. They just drag and drop fields to view, select criteria and sort order. When the user indicates that they want to execute a query, I parse the SQL statement to verify correctness and then ...more >>

We use strongly typed datasets, and thus our connection string is bound to an application setting. Currently we can deploy and alter the app.exe.config file at installation time to successfully install, and use some basic XML editing to allow the target database to be changed. Writing to...more >>

Your know the ones, you have a table and it has Create,Read,Update and Delete Stored procedures and the app always uses these to talk to the DB eliminating dynamic sql in your apps. Makes perfect sense when you have a table however when you have 500 tables its not so clever (thats 2000 st...more >>

Hello all. I'm reading the data from an XML file similiar to below, using the code below. When the file is edited in the datagridview and then re-written, it doesn't write the xml file as it was originally written. So what am I doing wrong? My code and samples are below. Any help would be g...more >>

I have two access database (with identical schema). One is the master and the other is SHOULD be a subset of master data (Let call them MasterDB and SubDB The user enters data into the SubDB and I need to bring the new changes to the MasterDB. Traditionally, I can get a the new changes (into ...more >>

For i = 0 To dtSubOpt.Rows.Count - 1 intOptNo = dtSubOpt.Rows(i)(1) strSelectSubOpt = "select tblOptions.strOptName as OptionName,tblOptions.intParent ,tblMOMT.strMOTag as MessageSentFromServer,tblMOMT.strMTTag as MessageSentToServer from tblOptions inner join tblMOMT on tblMOMT.intOp...more >>

I have an SQL table(MS SQL 2005) with a field called SignInDate and have created this as DateTime. When I save the current time using the Now function, it does not save the value in 24 hour format. For example, if it is 2:15:36 PM (i.e. 14:15:36) it saves the value in SQL Sever as 2007-03-08 0...more >>