On submitting ASP.NET form data from a multi-line textbox, how can the user formatting (i.e. line breaks, tabs, etc.) be maintained when the data is displayed retrieved from the database? Thanks in advance. Michael ...more >>

Hi, Iam trying to display data on windows form with data bindings attached to those control. When i try to update the use modified controls it gets updated in the database except for one text box contorl which is gettign its value from another textbox control multiplied by some number .... how c...more >>

Anyone know where i can find a comprehensive tutorial on creating a data access layer? After reading alot and suggestions from others i think i need to implement one into my MDI project to make it easier to acces data from several differnt forms. Heading to books a million now to get yet another ...more >>

Hi How can I have the same table, twice in my dataset with separate underlying select/update/insert/delete sql commands? Thanks Regards ...more >>

Hi, The code below is working all the way. The problem is that the Update method of the adapter doesn't update the mdb database. What am I doing wrong, anyone? string path = Path.GetDirectoryName(Application.ExecutablePath); string sConn = @"provider=Microsoft.Jet.OLEDB.4.0;data so...more >>

When trying to "copy" rows from one dataSet to another I get an exception that say: "This Row already belongs to another table". Any ways around this? I am trying to take a DS from a WebService and initially the RowState is unchanged. I went through the rows to fool the row state by iteratin...more >>

Folks, Can I update the value of a paramater used by a command AFTER adding the paramater to the command, and then update it to a new value? I want to loop through a set of values, and call a SP several times varying one of the paramaters each time. I had hoped to do something like this bit...more >>

I've used mySQL extensively but I'm new to SQL 2k (MSDE) and .NET. When inserting data I'm having data type issue but they are a little weird. I have 2 tables, Items and Subjects. Items Type Length Allow Nulls ---------------------------------------------- ID ...more >>

We have a simple LoginUser stored proc that returns the user name and other info to the calling code. BEGIN Tran SELECT ... FROM... WHERE... IF @@error <> 0 ... IF @@rowcount <> 1 begin RAISERROR.. RETURN -1 end COMMIT TRAN RETURN 1 The interesting th...more >>

Hi I have a table with all my contacts clients & suppliers. A 'company type' field specifies if a record is client or supplier. Can I have the table twice in my dataset once with company type clients and other with company type suppliers? If not, do I need two separate datasets for each occ...more >>

Is it possible to run a query against a Dataset or create a Dataview that only displays selected columns from the Dataset. ...more >>

Hi, I have a DataSet with some rows in the DataTables. Iam clearing everything in the DataSet (DataTables) and trying to add new rows. A DataTable has a foreignKey column from the parent table and a unique key column which takes AutoIncrement values from UI. So, for every new parent key...more >>

We're using the .NET OleDb classes to read meta data out of SQL Server, SQL has all of the proper SQL 92 Information Schema Views however the API in .NET doesn't return View information, it does for Tables and Stored procs? ====================================== ============== OleDbConnection...more >>

I'm trying to decide if I want to use a strongly typed DataSet or an Untyped DataSet with its definition in my DataBase module. The impression I'm getting about strongly typed DataSets is that they have a lot of design-time and RAD (Rapid App. Dev.) benefits. Basically I want to build objects ...more >>

I have a dataset with a DateTime field, each time i make an update i have to update also that field with the actual date time, but with the DB date and time, somthing like: UPDATE mytable SET datechanged=GETDATE() WHERE id=.... It's possible by setting something in the dataset or i have to ...more >>

all of the examples in the docs and books always show just one simple parameter when filtering datarows such as: .rowfilter = "city = Berlin". Is it possible to filter by more than one simple thing such as: "(city = Berlin or city = Paris) and UnpaidBalance > 0)" ? Thanks, T ...more >>

Can anyone tell me what the /reference: should be and what the using directive in the C# should be to build C# code integrated with ODP.Net? I'm having no joy with the following: $ csc -debug /reference:Oracle.DataAccess.dll foo.cs There is a Global Assembly Name of Oracle.DataAccess in the...more >>

I am trying to force update a DataSet which I retrieve via a Web Service. All the rows in the DataSetRowState are "unchanged". Since this property is read-only, I cannot use the DataAdapter.Update() method. How can I override the DataRowState Property since it is Read-Only??? ...more >>

Hi I have created a dataset by dragging tables over the dataset surface. The problem is, this ds does not appear in controls properties therefore I can not directly bind controls to this dataset. What do I need to do, to make this dataset available to controls such as datagrid for binding thr...more >>

The following loop is giving me a DeletedRowInaccessibleException on the very first delete. I am checking RowState and it is Modified. The documentation for this exception says that I am trying to access a row that has been deleted but it has not and I am ensuring that by checking the RowState...more >>

I have an xml document I'm trying to read in to an application using readxml(). ReadXML appears to have no problem reading the file. If I use WriteXML() to write a new document, it contains all the data from the original document. The problem comes when I try to read data out of the resulting...more >>

I'm trying to set the CommandType property of a SqlCommand to Stored procedure. My code looks like: using System.Data.SqlClient; SqlCommand cmd = new SqlCommand("MyStoredProcedureName"); cmd.Connection = myConn; cmd.CommandType = CommandType.StoredProcedure; I'm getting the following erro...more >>

I'm trying to figure out the best practice for opening db connections on an asp.net page. I have seen this done by opening one connection for the page and using it for all commands, and I have seen the connection open and closed each time you run a command. What is the best practice here...more >>

Hi Everyone, We have a problem that requires us to work around the RowState property of a DataRow. We have a DataTable in memory that we have modified certain rows and columns. Those rows were initially retreived from the database and as such now have their RowState set to Modified. We ha...more >>

I basically have an insert query that I am trying through the ODBC provider for ADO.NET. I use a DSN to connect and it works. Queries also work if I don't use parameters. I create the command and set the text to something like (it depends a little on the database): INSET INTO table1 (col1,...more >>

What is the difference between adding a primary key/unique constraint to a DataTable object using the Constraint.Add method vs. using the PrimaryKey property of the DataTable or Unique property of the DataColumn? Is it redundant to use both? If so which method is preferable?...more >>

We have a large VB6 system that uses an Oracle 8.1.7 database (we are about to migrate to Oracle 9.2). The system is built using COM+ components that interact using distributed transactions. We are considering migrating to VB.NET gradually by replacing the VB6 COM+ components with VB.NET COM+...more >>

There must be a simple way to generate xml from a dataset and have whitespace collapsed within string elements. I would have thought that this should be the default behaviour but apparently it isn't. If I generate the xml as follows : DataSet ds; ... load data ... ds.WriteXml(...more >>

All, I am writing an ASP.Net wrapper (C#) for a stored procedure library loosely disguised as an API that uses #mytemptable style tables in the tempdb to store stuff for a while, until another procedure is called that uses, then disposes of the #mytemptable table. This all works great in...more >>

OK i have came to the conclusion that since this app will be run on = multiple computers that loading a complete database and then updating on = exit is a moot point. I have tried several ideas submitted, but i am = unable to get one of them to work completely. Here is the code i had = before i ...more >>