Hi all: I have an ASP.NET form that reads an Excel file and populates a datagrid. If I load the form in IE on the server, and select a local file, the code works fine. However if I load the form in IE from a client (http://server/readexcel.aspx) and try to read a local Excel file, the file ...more >>

I use SqlCommandBuilder to auto-generate update commands (INSERT, UPDATE, DELETE) before calling data adapter's Update method. I view the Sql statement using SQL Server Profiler tool. The following is the update statement: exec sp_executesql N'UPDATE [tblEmployee] SET [FirstName] = @p1 W...more >>

Hi. I wrote the code to insert a new record into an Access database. I get no errors. However a new record is not inserted. Any ideas? Please help. Thanks.Emil. ...more >>

dear ... I'm using crystal reports 8.5 with vb.net ... and my problem is that when a larg number of parameters passed to the report, using this code : Private Sub ReportsViewer2_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Me.CrystalRepor...more >>

I am helping develop a SQL Server 2005 application with a C# front-end. Originally I was using untyped datasets and stored procedures and it worked fine. Now I have been told to used typed datasets and table adapters. Is it a good idea to use typed datasets on a database with about 25 tables?...more >>

I am helping develop a SQL Server 2005 application with a C# front-end. Originally I was using untyped datasets and stored procedures and it worked fine. Now I have been told to used typed datasets and table adapters. How do I get the identity for new rerecords? Is it a good idea to use typ...more >>

I am new to vb.net. I have a multidimensional array that I want to reference and replace current data in a combobox with each line of data from the array in the combox on an click event. I am having issues getting the data to be displayed in the combobox. Any help/ideas?? I can't get it to ...more >>

I have somewhat of an interesting scenario: The form allows the user to select a service, which populates a a grid of product information related to that service ("service grid"). The user can then select from the products in the first grid and those choices populate the second "choices gri...more >>

If I sort a dataview using dataview.sort = "sort string", can the dataview.table change? -- Jerry J...more >>

Is it possible to do a Group By in the Select method of the DataTable object? ...more >>

Hi I am creating a db connection using the below code. Is there a way to check if the connection is open? Thanks Regards = Code Below ==================== Dim LocalConn As OleDb.OleDbConnection Dim St As String = My.Settings.LocalDBConnectionString LocalConn = New OleDb.OleDbC...more >>

Hi I have a vb.net app that opens an access database runs several sql action queries on the tables and closes the db. This is done every few minutes. The problem is that sometimes I get an error 'ExecuteNonQuery requires an open and available Connection. The connection's current state is cl...more >>

Hi, I like to use .SetDataSource() to load several data tables from different datasets to a crystal report. I was thinking to create a new dataset to have all these tables. But is there a way to load them directly? Thanks in advance. Li ...more >>

Hello, I have the situation that many users on the same db , table have access and make changes. Ok for this there is optimistic concurrency. So I am able to check for cocurrency and get (in the moment) a messagebox, which says that there is a concurrency violation. I have searched in...more >>

the sp_help command doesn't return descriptions as far as I can tell. Any other ideas? -- thanks - dave david_at_windward_dot_net http://www.windwardreports.com Cubicle Wars - http://www.windwardreports.com/film.htm ...more >>

I'm developing a Provider Independent Data Access program using ADO.NET and Ole DB Providers in VS2005. I am using OLE DB Provider for Visual FoxPro for the VFP data source, and the Jet 4.0 OLE DB Provider fot the Excel source. The program works fine with the VFP data source. However, ...more >>

I have an ODBC connection to a folder where a few dbf files reside. In Visual Studio I'm trying to create a DataSet for this table ZIPS with the following fields: ZIP char PROV char CITY char The default Fill and GetData using a SELECT zip, prov, city FROM zips are created fine, no proble...more >>

Hi; Please, please, please tell me there is a way to do this. For a foreign key, say Orders.CustomerId I need to know that it maps to Customers.CustomerId. I need to be able to get this metadata both from when I first read all the tables & views from a database and more critically, when I ...more >>

I am having wierd transaction problems where the transaction holds a lock in SQL Server 2005 even after i perform the transaction.commit... anyone know why ADO.NET would be doing this? this is a sqltransaction object that i am working with.. thanks ...more >>

Hi, I have three different data types coming out of my SQL tables that I need to align with my VB code and the data set properties. I'm getting an error message that reads "SQL exception unhandled. The data types text and nvarchar are incompatible in the equal to operator." Here is the relev...more >>

Hi all. Is there any way using ADO.net that I can send an entire datatable (with multiple rows) through the adapter and in one round trip accomplish multiple updates/inserts (using stored procedures)? If not, is there any other way to accomplish that? I have seen people send strings like "...more >>

VS 2005 & Firebird DB 1.5 I have a query for Customer orders that has several inner joins to show things like Terms name (from termsnum) and Sales Rep name (from repnum) etc. I have written the custom SQL insert statement and this works with no problem, but I want to get the updated values...more >>

Hello, I have the following: a form, a datasource, in the form I have tabs, menus, listboxes, a datagridView and textboxes. All is bound to the datasource and works fine. Now I have (beside other) with the textBox-events Valdiating and Validated the validation of the textboxes which must...more >>

I hope this is the right place for this, if not please move it. I have developed a windows application which uses an Oracle database for storage. In order to communicate with the DB, I am using the ODP .NET provider from Oracle. This works well on my development platform, however when I try to...more >>

If I create two datasets using the visual designer which both contain the same table, the generated datasets will each have their own nested copy of the same table class. Ideally I would like to be able to have datasets use a single copy of a class for a common table, so that I can write commo...more >>

Hi, To send the result table from the stored procedure back to a client, I have to create SqlDataRecord and send the rows one-by-one. The constructor fro SqlDataRecord needs an instance of the SqlMetaData. To create this instance I need the type definition for a particular column. For e...more >>

Scenario: SQL Server 2005 w/table that has 4 million rows. There is a column that we need to run through, format it and update the row with the new string. Using VS2005 we have an application that will do this. We are using a P4 3.2G w/2Gig RAM connected via 100M Ethernet. The program uses...more >>

Hi All, Many moons ago, I remember the ASP.NET Pro magazine publishing an article about a Winform utility that generated stored procedure .net calling code. i.e. if you have stored proc had 5 params it would generate some text you could copy & paste into your code, like this (just a sample...more >>

I know that when we write a Stored Procedure we can add a default value to the parameter so that if it's not set when we call this SP the default value should be used. It gives me some additional flexibility and a simple way to manipulate the same SP in different ways. I also know that in m...more >>