Hello I am trying to create a "easy to use" gridview with filters (dropdownlist in headers), sorting...and much more.... In order to do that, i prefer to use a objectdatasource (ODS) beacause filters and sort are automaticly managed.... I would like that my own gridview (inherited from ...more >>

I am having a problem with a recent console application. I can not connect to the database server (even when it is a local server), but it connects just fine in debug mode on my development platform. I have set the connection string properly in the app.config file. I can connect to the data...more >>

Hi I had a working vs 2003 application with access backend. I added a couple fields in a table in access db and then to allow user to have access to these fields via app I did the following; 1. Regenerated the data adapter sqls by running the data adapter wizard and pasting the resulting...more >>

Hi I am trying to set-up an app log file that needs to be created if does not exists but opened for append if exists. How does one go about doing this? ..net seems to have many ways to do io stream, boggles the mind. Thanks Regards ...more >>

Hi I have a data adapter bound to a table. How can I loop through the table via and access each record's column values on the way? Thanks Regards ...more >>

I've been working on an SQL project with MDI. I have a progress bar on the parent form. I know how to control it if I know the size of data I'm updating. If I am moving/copying a file I can increase the progress bar just fine. How do I get a byte count of what I'm updating to the SQL dat...more >>

Hi I have opened a data connection to an access db in my vb.net windows form app. I need to do the following but am not sure how to do it in code; 1. Open one of the tables 2. Read value from a record. 3. Insert the record into a second table in the same db. 4. Delete record from first ta...more >>

Hi I have two data adapters bound to two separate tables. How can I; 1. Loop through all records one by one in one of them while reading column values, and 2. Insert a record from data adapter A into data adapter B via code? Thanks Regards ...more >>

Ok I have a VB.NET 2005 application that is connecting to a SQL 2005 database. The application itself is going to go out and run SP, Views, etc. The users will be able to update records. My main concern is I do not want the user to be able to go out and Access the very same SQL server inde...more >>

Hi I have a check list box.When user selects a specific value '(All)' I want to uncheck all other check boxes in the list. How can I achieve this in code? Thanks Regards ...more >>

Hi For my db app, I need to save the location of the db (really a windows path) which normally only needs to be set at the first app start (I can check if the setting is missing and ask user for a value). Occasionally (once in a blue moon) I may need to change this setting in case db is mov...more >>

Is it possible to make a combobox in e DetailView and GridView? I have a table with a foreign key to another table lets say it AppartmentID. I would like to be able to set the foreign key by using a dropdown list in the DetailView or GridView. If that's not possible, does anyone have any ...more >>

I just installed ODP.net 10.2.02 on my local machine (Windows XP Pro) running IIS. I have created a sample webservice in VS2003, connecting to localhost. I am getting: Oracle.DataAccess.Client.OracleException ORA-12154: TNS:could not resolve the connect identifier specified at Oracle.Data...more >>

Hi all, I've got a rather strange problem with a query on an Access 2000 database which I access using ADODB. The Query is: "SELECT RecordID,Text FROM trans_strings as t WHERE Language = (SELECT TOP 1 t.RecordID FROM languages As l, trans_strings As t WHERE l.RecordID=t.Language AND l.L...more >>

Hi Is it possible to access connections strings from web.config from within the application? I'm using VS2005 and VB Sub LogVisit(ByVal network As String, ByVal IsValidNetwork As Boolean) Dim sqlCmd As SqlCommand Dim sqlcn As SqlConnection 'this on works, it's a public variable sq...more >>

I'd like to know if there were any changes in the DataSet which was populated by reading XML file. 6 DataTables with data or just structure with no data inside of it. I think about this scenario: I create 2 datasets and populate both from the same XML file. Then the first one is used as Data...more >>

I'm a .net newbie. I'm programming a telephone list to help me transition - here's my problem: I have a Search form (the user searches for an entry) and a Name/Address form that displays a single entry for the user. I'm trying to use a public class to hold the database fields. When a r...more >>

I am using the table adapter to add a new item to a table. One of the items is an ID for a another table. At this point that item in the other table doesn't exist so how can I enter Null or similar? I have been receiving this error when I try dbnull.value : Error 1 Value of type 'Syste...more >>