I'm really new to vb.net. What I like to know is what would be the code to read the definition of table or view. Here is the piece of code in VB6 that try to find a column name called "year" in a view. How to write this in VB.net? For Each fldField In gdbOes.TableDefs(viewname)).Fields ...more >>

Hello. Developing a web site in VS2005, SP1, VB, .NET 2.0, ASP.NET 2.0 on XP Pro, SP2. I'm trying to write a file to the App_Data folder in my project using: Dim docPath As String = "~\App_Data\Trips.xml" Using sw As StreamWriter = File.CreateText(docPath) sw...more >>

Hello, I have to read data from an external file into a ado.net table ds.tblExternal.ReadXml(...) and I want to load this data into a table that resides in a sql server (2000) DB. I can do this if I loop through ds.tblExternal and add new rows to the ado.net table from the DB: da.Fi...more >>

I have a table where there are translations of various strings into different languages. I need to load this strings and allow some users to modify and update the strings back into the table. When I load a text written in polish, the application loads the data correctly and the user see all...more >>

Hi, We have an ASP.NET application that connects to a SQL Server database. Historically we have used a trusted connection, and during our database creation, created granted database access to the system account <SQLSERVERNAME>\ASPNET. This appears to work great on XP in that IIS appears...more >>

Dear Community, I'm using ADO.net to update a SQL Server 2005 table. The table has a an aggregate primary key made of two integers. I use the typcial SqlDataSet/SqlDataAdapter tools to perform updates and inserts, after an initial call to da.FillSchema(). My select command is 'select * from...more >>

Hi, I am doing maintenance work for a ASP .net application which uses ADO .net to access the data from database (SQL Server 2000).The functionality is something like that it uses SQL Data Reader to fetch the data and always open a new connection to do the same since only one Data Reader...more >>

I wrote simple application (C#) that use a database (MS SQL serwer) and I had very strage problem I want to have pramized query, so my code is... SELECT name FROM person WHERE (name LIKE N'%'+ @partOfName +'%') I used VS 2005 with MS SQL server Express Edition I used this...more >>

I have a few sprocs and I want to create a generic handler for them. Basically, I want to call any sproc and leave it up to the developer to know the parameters. To keep it simple, I would like to do it so that the only thing that the developer has to know is the appropriate datatype and NOT th...more >>

Framework: Visual Studio 2005, ASP.NET Programing Language: C#.NET I am using a Generic List Collection to fetch a particular master data from the database. Once collected, I use this Collection to bind it to a DataGrid. Now that I am using a Generic List Collection to populate the DataGrid...more >>

Hi I have prototyped a WinForms application that uses the Enterprise Microsoft Data Access block to load data into a strongly typed dataset. This works very well and is pretty fast. My problem is that our customers will probably complain about having the connections string (with username/pa...more >>

Hi, I was trying to sort dataview using the below process. It is throwing exception. Please help. Dim DSExcel1 As DataSet DSExcel1 = New DataSet Dim myView As DataView myView = DSExcel.Tables(0).DefaultView ...more >>

Hi there I'm developing a Windows Service that needs to take a specific action each time a new record is inserted in a database table. I can write a select statement that the Service executes recursively, but I was wondering if there is a more efficient way to 'monitor' a database table ...more >>

Hi, To capture changes in the database I am using SQLDependency. When the change is notified I update my UI. In the handler for OnChangeEvent I checked what type of info is passed to the method argument. I find out it is "Error" In MSDN I read it is an Internal Server Error. However,...more >>

Hello, I have the following problem: I have tableA, tableB A relation between tableA and TableB. So table B is the child of table A. In tableA, tableB may keyX be the foreingn key and Fk_tableA_tableB the relation. Now I have a DataView dvA pointed to tableA. Now I take a bindingSource bs...more >>

I am in the midst of converting some internal programs. Several of them, which still rely on some Access 97 databases, invoked the DAO 3.5 Object Library's DBEngine methods "Repair" and "Compact". Is anyone aware if this functionality is provided in any of .Net Framwork's System.Data classes? ...more >>

With a complex normalized database structure using surrogate PKs, sometimes to get a string name value, it's necessary to reach back through several PK-FK relationships. What I'd like to do is add a customer name to some datagridviews that are far down the sales process without setting up some...more >>

Hi, How do I free up the memory taken up by the .NET datatable and dataset after I finished working with them? How do I HELP the GC to do its job sooner to release memory taken up by DataTable/DataSet? I am worried about memory usage. Should I be using DataReader exclusively? But complex...more >>

Is there any harm (performance or otherwise) in using "Asynchronous Processing=True" in my connection string to a sql server 2005 database for both async db calls and non async calls? The idea behind it is taking advantage of connection pooling, and everything seems to work fine using the Async...more >>

Hi, 1/ I inserted new data to the database using SQLDataAdapter. All data are inserted, but the order of rows in db table is not identical with the order in DataTable used for the batch update. No sorting is made. This occures when I insert more then 800 or 1000 rows. 2/ I tried to...more >>