Still working with the same program (DB in VB.NET 2003). I've got the DataView down (Thanks Mona), I also have the binding to the text boxes figured. What I need now is how to move to the next record when clicking on a command button. I tried doing it the same way you would through a data...more >>

I'm building a program that will Open up a form and ask for the user to input a checklist name. After they input this name the form will only display the records containing that checklist name. I'm stuck at this point. Anyone have any ideas on how I can filter a dataset within code? Or som...more >>

When accessing FoxPro 2.6 tables from ADO.Net by OLDDB with Microsoft Visual FoxPro OLEDB Provider, Will it support begin, commit and rollback transaction ? We test it... no exception are raised.... but after rollback.... inserted row still in the database file ... :( Is it supported ? ...more >>

Is it possible to have a "relative" path to an Access DB that will satisfy all 3 cases:- (1) Running from IDE (2) Running exe with db in same directory (anywhere) (3) Running exe in IDE bin directory with db in project root Thanks ...more >>

hi I am trying to create a new DS from an incoming (ex DBase query). The Incoming one has data, which spawns (should) multiple records, depending on the data in the pertinent field. ie Incoming has 18 rows, 6 of which indicate the need to create 2 - 7 new rows, and drop that old incoming row. ...more >>

Our organization has implemented an ASP.net application with an n-tiered architecture, made up of a business/data layer that calls T-SQL Stored procedures. We are attempting to better manage the many stored procedures we have written over the life of the application. To do this, we would like...more >>

According to the docs, for the following code, I should get 5 rows returned. However, when I run this, n = 10. Is that a bug, or something I don't understand? Dim conn As SqlConnection Dim cmd As SqlCommand Dim dr As SqlDataReader conn = New SqlConnection(Lookups.connStr) conn.Open() ...more >>

Hello, I need some help finding out what I am missing here=2E I= have a connection to a SQL server, which I hope I am closing= correctly, leaking memory=2E The function is called from a Timer= and it is leaking 4 to 8k per cycle=2E I thought it was the GC= not cleaning up but after a 24 h...more >>

Hello, I am starting to visit .NET development. Surfing through all the information I think I am getting confused between using the RAD environment and when to use code. I would like to re-create a form that was originally done in Access. I need to open the form, be able to scroll(back and fo...more >>

I have created a stored proceedure in Query Analyser and saved it to my SQL Sevr2K DB. The SP deletes and recreates a table then inserts rows to it based on parameters sent to it when it is called. SP works fine when called from QA. When called from VB it does not delete and recreate the table...more >>

I'm running into a problem grabbing some text from a MySQL database in my C# website. All the fields defined as "varchar" are working just fine, but I'm using longer text fields defined as "text" in some cases and I get the following error when I try to populate a DataSet with data that inc...more >>