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 e.g. create spname ... SELECT * FROM table1 SELECT * FROM table2 GO and Dataadap...more >>

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: SqlParameter(string parameterName, object value)??? Regards Stephan...more >>

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 scope issue. How ca...more >>

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. The database in the Server Explorer is a db designed and ...more >>

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 is changed! Obviou...more >>

[ 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. With .NET 2.0, there are new properties to he...more >>

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 can see -- but where the width of a...more >>

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 go on. The problem is that when the table is too big, the Fill method avanz...more >>

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 data per user; and a large number of users. At the moment I...more >>

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 datatables. But while setti...more >>

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. The blob object i am trying to insert is a ...more >>

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!! After spending several hours, I found that the only kin...more >>

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. DefinedSize property. I have been searchin for something similar in ADO.NET but with...more >>

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 have problems with the update. Do you think I should just reset the r...more >>

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 one chunk. I'm using VB.NET 1.1. Thanks, Eric ...more >>

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 choose the parent record...more >>

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. http://www.dotnetwire.com/frame_redirect.asp?newsid=3171 using System; using System.Data; using System.Data.Common; using System.Data.OleDb; ...more >>

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. The problem is that the connection string ("Integrated Security=yes;Initial Catalog=Northwind;Data Source...more >>

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 consering columns of the type Date: Columns set to the value of Dat...more >>

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 row should subtract the q...more >>

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? Thank you, Alan ...more >>

Hi I'm hoping somebody can help me with the following problem that has occurred to me. Suppose I have two tables in an SQL Server database. Let's call these tables A and B. Assume that A has two fields: a primary key and another holding a string. In table B there are three fields: a primary...more >>

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

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

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 i would have thought it would be more like: DataTable dtEmp = New DataTabl...more >>

I have a datagrid (C# Windows Forms App) bound to a dataset. One column in the dataset is a calculated column based on an expression that simply subtracts the value in one column from the value in another column. I created the dataset using a dataset control and the properties dialog boxes. The ...more >>

This is a strange one. In ASP.Net v1.1 using VB, I'm using an ODBCDataReader to read from a CSV file. Most of the time it works, but if the "description" field contains more than 2046 chars, I get a NO_DATA error (see below for full error) when trying to read that row. If this field contains 2...more >>

Hi, I'm just coming from classic ADO (& still thinking that way) & I'm wondering how you can determine when you get to the EOF in a data table. This is what I've done below. It works, but I don't think it's the most elegant way of doing it. How is this normally done? Am I thinking the total...more >>

So I’ve got this dataset that was built with the designer. All is well except that the Select command needs to be generated at runtime for app-specific reasons. I thought I would do something clever, which was add a version of Fill() to the dataset class that takes the SQL string as a par...more >>

Hi, I would like to update an Sql Server database with Excel data. For this, I use2 identical typed datatables: dtSql, and dtXls. Here's my code simplified: TypedDataTable dtXls = new TypedDataTable; TypedDataTable dtSql = new TypedDataTable; dataAdapterXls.Fill (dtXls); dataAdapterSql.F...more >>

Hi, I have some difficulties in understanding how to use the connection, dataset, datareader in a form. Let's suppose I want to create a datareader and when I push a button to bring another row from the dataset. Supposedly I create under MyForm_Load event the connection, then a command an...more >>

I have a Windows Form written in C# with a non-edit DataGrid showing a list of records. When the user selects a row in the grid, the full details of the record display in a panel which contains textboxes and comboboxes. The underlying datatable that the detail panel is bound to only ever has one...more >>

Hi, I am new in VS.net. We try to migrate our VB6 application to .net. In our VB6 application, we have a middle tier data access object to handle the connection and stored procedures' calls. Do we still do middle tier DO in COM? or in just Assembly? why? Thanks in advance, DW ...more >>

I know this is easier to do with a datareader and a listview, but can it be done with a tableadapter and a dataset? I want to manipulate the data prior to it reaching the dataset, For instance, data is stored as Firstname and Lastname and sometimes there will be no firstname, so appending a ...more >>

I'm writing a Windows service that uses the new TableAdapter in .NET 2.0. I have several adapters that must be updated as an atomic operation, so I have wrapped them using the TransactionScope. When I run my code I get a TransactionManagerCommunicationException with the following message "...more >>

Hi everybody, i've a question for this group: i've developed a windows service that every x minutes count records present in a sql table and if those records are bigger than a fixed threshold start with clean operations. Workflow is this: 1) Load records in a DataSet: DataSet ds = ne...more >>

Hi everybody, i've a question for this group: i've developed a windows service that every x minutes count records present in a sql table and if those records are bigger than a fixed threshold start with clean operations. Workflow is this: 1) Load records in a DataSet: DataSet ds = new Da...more >>

Hi, I've created a relational group of tables using the designer for the Data Adapter. It decided to cross join all the tables, so I manually did it using Inner joins, nothing special just PK to FK. When I click preview data, then try to fill a dataset created by the Generate Dataset bu...more >>

Short question: how to fit TableAdapters into (true) n-tier development. More Info: In VS2003 in terms of *physical* n-tier development, I had a fairly nice pattern going. My DAL exists on a separate server and accessed via remoting. In order for the client machine to "know" about the classe...more >>

Hi I am supporting a client that gets 5-10 of the following errors each day: General network error. Check your network documentation. ----------------------------- Stack trace: at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) at System.Data...more >>

Hi, When I create a typed dataset containing multiple relational tables using Generate dataset, it creates a single set of records based on what was chosen when setting up the data adapter. If I have an orders table, an orderItems table, a customer table etc. set up in the DataAdapter, the ...more >>

Can someone please tell me how the following is possible? When I do this: System.Data.DataSet addedAndModified = myDataset.GetChanges( DataRowState.Added | DataRowState.Modified ); some of the rows in the resulting dataset have a RowState of DataRowState.Deleted. ...more >>

Hi EveryOne, What is the best approach for data access while developing applications using Windows Forms ? Is it opening, working with and closing a new SQLconnection and SQLcommand object everytime a DB access is needed , or maintaining a single open connection/command object at the applic...more >>

I have an ASP.NET project with a typed dataset (with table adapters). The table adapters' connection string property was set to get the connection strings out of the web.config file. I was able to add new table adapters, and all worked well for a while. Now I need to add another table ada...more >>

Hi Everyone, I'm currently working on a form that requires 3 stored procs to run (one of them several times), but these stored procs are in different functions (see below). The problem is that after the commit, the database doesn't reflect any of the changes. I open a new connection before ca...more >>

Hi I have problems when I try to connect to my Oracle db from VS 2003. I get this error: ORA-12154: TNS:could not resolve the connect identifier specified My tnsnames.ora-file I have this text: MALL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Z9100774.ne.ad.ner.capgemini.com...more >>

I have a stored procedure that returns xml data (using For XML), it returns about 9000 records. I use a datareader to write the data to a XML file. For some reason, the datareader doesn't write all data, it seems like the data returned has some size limit. here is my code, my code is based o...more >>

Hi everyone: I got simple aspx with a user control in it that posts some entered data to a database. The problem I'm seeing is that when the submit button is clicked the code is executed twice and I get duplicate rows in the database. The including aspx page is this: <%@ Page language="c...more >>

Dear all 1.)How can i save the stored procedure in sql 2005 server, into server and NOT in file location 2.)How can create folder in stored procedure to separate categories? 3.)How can view the created date and modify date of stored pro ...more >>

Hi, I'm wondering what the official Microsoft recommendation is for handling TransactionScope transactions when using TableAdapters within a DataSet. I have a dataset that various areas of my business logic uses, and at a higher level I'd like to wrap several business functions in a Tran...more >>