What's the best way to import all the tables (w/data) from an SQL Server database (in production) to my SQL Express database (on my local dev machine)? ...more >>

Hi I have a terrible scenario. I had an ms access front end/back end app that searched on partial strings. I have coded the app in .net (access backend) and am using the below code to search on partial strings;. daCompanyLocate.SelectCommand = selCompanyLocate selCompanyLocate.CommandText...more >>

Hi, I have a dataset (vb.Net 1.1) that I need to go through and re-order based on the data. I'm wondering if there is a nice relatively automated way to do this, but I kind of doubt it. There is not currently a single field to use in a DataView's order by parameter. The data has two fields th...more >>

Part of the application which I am building must support either Access or Sql Server Databases. The code to generate the databases via sql scripts is done. However, I have a set of tables (they will all have the same columns, but have different results since they are doing seperate calcula...more >>

Hello Group I have made an application that can create Mail Merges with Word. The application creates a WordTemplate and set the Document.MailMerge.OpenDatasource's filename to a text (tab spe.) file. Containing all fields and data to merge with. I would like to change the MailMerge.Open...more >>

Any step by steps (or web links) on how to easily use an Access db for being the membership provider? I am using VS 2008 and .net 3.5. Thanks! ...more >>

I want to get a DataReader from a Linq Query so I wrote this Extension Method public static IDataReader QueryToDataReader(this System.Data.Linq.DataContext ctx, object query) { IDbCommand command = ctx.GetCommand(query as IQueryable); command.Connection = ctx.Connecti...more >>

Created a new Access mdb file. Created a Data Connection in Server explorer for it. Created a new "LINQ to SQL Class". When I try to drag/drop a table into the designer I get this error: THE SELECTED OBJECT(S) USE AN UNSUPPORTED DATA PROVIDED. Any idea why? Thanks! ...more >>

Dear Friends, can somebody tell me what is delphi dot net. Rgards Sridhar...more >>

In my language, Italian language, we have words with accent, for example "città" or "perchè"; can I create tables or columns in sql server with names that contain letters with the accent (i.e. "à" "è" "ì" "ò" "ù")? Is this absolutely not recommended? Or is it an acceptable practice? Thanks ...more >>

When I used VB6 & ADO I used GetChunk & AppendChunk to get/save large image data to SQL Server. In ADO.Net that is not available but I found the below link and it describes what to use as an alternative. Looking at the code I don't see how the data in saved/retrieved in "chunks", is it done ...more >>

Is it possible to create a post build event to encrypt my config file (which holds my connection strings)? The reason I would like to do this is that while we are developing I would like the developers to be able to see/modify the connection strings appropriately, but when we do a release buil...more >>

I have a TableAdapter linked to an SQL Server 2000 table. Some of the cells have null string values. In VS2005, I can preview the data linked by the TableAdapter in design mode, and all fields are displayed - even the ones with cells containing null values (they just show "null" in the cell...more >>

I have a task in an ASP.Net page that I think ought to work, but doesn't. It's fairly straightforward. It's an event scheduling site, and I want a user to be able to delete an event. When he clicks the delete button, it posts back to the page with the event id for the deleted event in the q...more >>

Guys, I have declared 2 dataRows and assigned New daraRows as below. Dim aRow as DataRow aRow = OutFormat.DataSet.Tables("demotbl").NewRow '*** Point 1 ---- ---- Dim bRow as DataRow bRow = OutFormat.DataSet.Tables("demotbl").NewRow '***Point 2 --- --- bRow = OutFormat.Dat...more >>

I've got a VB.net app that I'm loading up to a SSVR 2005 server. It was created in Visual Studio 2008, calling upon 3.5 framework. I created a setup file with the deployment wizard, and am trying to install it on the server. This thing is SLOOOOOOOOOOOOWWWWWWW. It's been a couple of hour...more >>

Guys, I have declared 2 dataRows and assigned New daraRows as below. Dim aRow as DataRow aRow = OutFormat.DataSet.Tables("demotbl").NewRow '*** Point 1 ---- ---- Dim bRow as DataRow bRow = OutFormat.DataSet.Tables("demotbl").NewRow '***Point 2 --- --- bRow = OutFormat.Dat...more >>

Hi, I'm using ACCESS + oledb with ado.net 2 and I'm having this behaviour when I execute the next sequence: 1. INSERT INTO customer ... 2. SELECT * FROM customer (I execute it inmediately) But the change of step 1 doesn't refresh in step 2, . However if I execute step 2 again after 1 o...more >>

I'm binding the dataView to a dataset (~400000 rows) and sorting it by a key (long type). I'm retrieving values from the DataView with FindRows(object key) which returns DataRowView[]. The problem is that rarely on Stress modes I get the following error: Source: mscorlib Message: Index ...more >>

Hi I moved an ASP.NET website to a new server an suddenly got the following error when connection to my MS Access database: "System.Runtime.InteropServices.SEHException: External component has thrown an exception". Searching the web and newsgroups for a solution I found several pages wit...more >>

I tried to loop through the datareader to find some data elements one at the time. The first time loop , it's fine. To avoid going to the database, I reuse the same datareader to search for the next element. However, the 2nd search starts from the place where I exit the loop, which causes t...more >>