| Thread | Last Post | Replies |
|
| Find Position within a DataSet | 08 May 2005 14:38 GMT | 10 |
I have bound form and am using a CurrencyManager to control navigation on the form. I want my initial display to be the data for a particular PrimaryKey. This key changes each time I bind the data. My problem is How do I find the position within the dataset which I can pass to ...
|
| Best practices for dynamic user searches | 07 May 2005 06:02 GMT | 4 |
Hi group, I'm building a high traffic web portal that will present a sizeable range of search options to the user. My plan is to use dynamic parameterized queries (as opposed to stored procedures) since you never know how many search arguments a user will enter. I could create ...
|
| SQL Data Adapter Will not update from ASP.net -- VB | 07 May 2005 00:32 GMT | 5 |
I have an asp.net application in which users need to fill in a form. Sometimes they do not have all the info to fill all fields. Since they do not always have the complete info, we need to have them come back, pull the existing fields from the database, and then perhaps add and ...
|
| Parent/Child ForeignKeyConstraint | 06 May 2005 22:13 GMT | 1 |
http://groups.google.com/group/microsoft.public.dotnet.framework.adonet/browse_t hread/thread/9d845dde0b8fb43e/f2e7addd569723d6?q=%22INSERT+statement+conflicted+ with+COLUMN+FOREIGN+KEY+constraint%22+child+key&rnum=3&hl=en#f2e7addd569723d6 I am experiencing this exact same problem ...
|
| Dataview Find not in sync with CurrencyManager | 06 May 2005 18:12 GMT | 5 |
I have incorporated a search function into my .NET application. I use the Find method in the DataView, and return the index of the associated record. I use this integer to set the Position property of my BindingManager on my form. Refer to the code snippet below. When I use the ...
|
| Lock Records | 06 May 2005 07:43 GMT | 8 |
I apologize for the cross post but I am using ADO.NET methods and such to access SQL and I am thinking perhaps both sides will have valuable input for this. I have two tables one called QUOTEINFO and one called QUOTEITEMS. One
|
| Memory leak(strings) in DbDataAdapter.Fill | 06 May 2005 06:51 GMT | 2 |
We have such problem When we using in C#-project(managed code) DbDataAdapter.Fill(unmanage code) (doing select operator many times) - several overloaded version - we have memory leak in strings(found it in profile). To my mind
|
| Bidirectional cursor navigation | 06 May 2005 04:56 GMT | 10 |
Is there any class supports bidirectional cursor in the ADO.NEt framework? I was looking some of the samples and only talks about SqlDataReader (forward only cursor). Or is there any way i can make use of database cursors in my dotnet
|
| Event Hander not firing | 06 May 2005 03:13 GMT | 1 |
I'm trying to create a "RowUpdated" event. I have Dim da As New SqlDataAdapter() and
|
| dataset WriteXML question | 06 May 2005 02:13 GMT | 1 |
I'm running SQLXMLBulkLoad from a vb.NET app supplying both and xml file and a schema (xsd) file. I'm moving data from a table in one database to a table in another database and expect the data in the destination table to be exactly as the source table. I want to preserve Nulls ...
|
| OnRowUpdated, Rollback in DB, ConcurrencyException and RowState question. Please give your opinions. | 06 May 2005 02:10 GMT | 5 |
If you think this post is too long to read please scroll to the bottom and read the last two sentences. Thank you :) I have a problem which I cannot find a good solution to and hopefully I can get some ideas from the readers of this group. I will first describe my
|
| Summarize Dataset values | 06 May 2005 02:01 GMT | 1 |
I have a Dataset that use created from an sql query. The dataset has about 6,000 rows. I want to create arrays or lists of information about the dataset. For example, the dataset has a column named 'State'. I would like to count the number of rows that are for each state and ...
|
| Installation and file path | 06 May 2005 01:58 GMT | 1 |
My program displays a Datagrid which is populated from an excel file. It is done to show the end user a sample file. How can I reference the excel file in the program connection string so that it can read it from the application folder after install. I guess my question would be, ...
|
| Problems with Errors (Is this a bug) | 06 May 2005 01:57 GMT | 10 |
Scenero: Run a batch file.. Multiple Querys... An error occours in 1 query and in QA all other querys will run and return
|
| Loading multiple tables and relationships | 06 May 2005 01:56 GMT | 1 |
I have a SQL database that contains multiple tables and various foreign key relationships and between those tables. The size of the database is very small (about 1 MB) but the relationships are quite complex.
|