| Thread | Last Post | Replies |
|
| Ensuring uniqueness of a record when using a DataSet schema | 10 Oct 2004 03:37 GMT | 1 |
Ignore the previous post, this dumb OE sent my posting prematurely... Anyway, the problem is I have an XML schema where I have specified that a particular element is to be UNIQUE. This schema is read with the DataSet's ReadXmlSchema() before reading the actual data with ReadXml().
|
| DataBound UserControl Always Modifies DataRow Upon Focus | 10 Oct 2004 00:37 GMT | 4 |
I'm trying to create a UserControl that is databound using Bindable Properties. I bind DataColumns to those properties. My problem is that once the data is bound to the control, it immediately marks the DataRowState as Modified whether or not any data was modified. Anyone
|
| Grid in a form | 09 Oct 2004 19:23 GMT | 1 |
I need to add grid to an enquiry form. I have not done grids in asp.net before. The data in the form/grid needs to be appended to a database. Could you someone please give me some simple steps on how to implement a grid in asp.net in a form scenario?
|
| InvalidCastException Hangs W/ Stored Procedure Output Parameter | 09 Oct 2004 17:09 GMT | 10 |
I have a SQL Server stored procedure that returns an int. Sometimes a null value is returned which causes the problem. //This is what I did: return (int)cmd.Parameters["nextCount"].Value;
|
| Querying multiple tables | 09 Oct 2004 16:32 GMT | 2 |
I have been programming in C# for a while but have not done much with ADO.Net. I am running into a problem that I am not sure how to solve. In my database I have 3 tables with 2 junction tables relating them. Here is the basic structure
|
| using an alias in a where statement as a parameter | 09 Oct 2004 14:14 GMT | 1 |
I have the following tables and have setup the following sql statement as part of my data adapter. The problem is that I need to do a statement that will find the records selected in my list box. I cannot figure out how to use the "name' alias in the parameter statement.
|
| Create database | 09 Oct 2004 08:01 GMT | 8 |
I need create database (MsSql) within my application, when it run. What is the best metod to do it.
|
| Adding SQL records using dataset | 09 Oct 2004 02:20 GMT | 6 |
I need to read from a sql table all rows with '1' in userid column. I am able to do this and put them in a dataset. I then need to ADD to the sql table the same information in all rows, except replace the userID column of 1 with another int value.
|
| Cursors in ADO.net | 09 Oct 2004 00:03 GMT | 3 |
I have a situation to use cursors in SQL Server. I need to populate DataSet for the returned rows. So that i could use DataGrid to display the values in the front end. Is it possible to populate DataGrid, if i use Cursor in SQL Server. Can
|
| oledb and csv | 08 Oct 2004 22:13 GMT | 1 |
hi I want to load from a csv file, all the data to a dataset using oledb connection. when i use:
|
| Huge data | 08 Oct 2004 21:49 GMT | 27 |
i'm trying to retreive the data from a table that has lots of columns and thousands of records. The problem is that I have to display all of it, so I need to retreive it all in one time. When I tried it using a dataset, I received the exception "Out of memory". Is there any other ...
|
| Connection object versus Connection String | 08 Oct 2004 20:03 GMT | 6 |
At work, we have built a Director object that fires off processes. Any number of jobs can be run at the same time through its own Director instance. Currently, there is a philosophical discussion about either passing in a Connection String or a Connection object to the individual ...
|
| Using Begin (Async call) with ORACLE | 08 Oct 2004 19:36 GMT | 3 |
Is possible to execute Asynchroneus calls to Oracle DB from .net framework 2.0? System.Data.OracleClient don't have this feature, but maybe the ODP.NET 9.2.0.4.01 from ORACLE has
|
| How can I retrieve data from SQLServer with a specify network | 08 Oct 2004 19:27 GMT | 7 |
I have to develop database client to retrieve data from SQLServer from a machine that have 2 network adapters. How can I do this with .NET programming to specify SQLServer on 1 network card. Once it can retrieve data from SQLServer, the program have to send this data out to ...
|
| dbo. in vs generated code for stored procedures. | 08 Oct 2004 19:19 GMT | 2 |
We have a team development environment and we just moved to vs.net 2003 Enterprise so we are now able to create stored procs right out of visual studio. In the past we had to use enterprise manager. Our normal procedure for db access was to set up a sql user based on the application ...
|