Hi everyone, Before I begin I should point out that I am quite new to programming and VB.net and am using VS2003 with SQLExpress 2005. I have two data tables a staff table and an office table, the linking field is office_id. I have created a form and added a datagrid, when the form loads...more >>

Hello, I'm working on an Access db in VS2005. I have a table, called tblPatients, in which I have three columns: PatientID (primary key), PatientName and DoctorName. This table is filled with more than 4.000 records. I load this table on a form, I make queries, updates, deletion, it does w...more >>

I'm trying to get the results of a stored proc (with no input parameters) into a datagridview. I'm able to get the results into a messagebox but i'm nor sure how to get them into a DataGridView Using cn As New SqlConnection(strConn) Try cn.Open() Ca...more >>

I have an SQL statement that uses the Command method ExecuteNonQuery and it is returning twice the number of rows (24) actually updated. When I run the same statement using SQL SELECT I get 12 rows. Below is my ASP.NET SQL code: strSQL = "UPDATE File_Mst" & _ " SET CheckedOut = 12345" ...more >>

Dear all. I'm wondering why it's so hard to bind a lookup value from a related table into a textbox on my form. Say I've got two tables, product and productcategory. I'm paging through product information using the bindingnavigator, one product per page. Everything on the form is bound to fie...more >>

Hi, C# App. VS2005 I have a detail table ordered descending on a field called DetailRowID ie ArrayIndex Detail RowID 0 3 1 2 2 1 I add a new row but it goes to the end of the dataset so does not ArrayIndex ...more >>

Hi, I created two datasets in dataset designer in VS 2005. Both of them contain the same datatable. I think, having two classes for one DB datatable is stupid and badly maintaining. So I need manually add DataTable class from first dataset to second. So I modified designer.cs of second dataset...more >>

Hi, I m a newbie to VB.NET. So, i have problem in doing some tasks like Master/Detail working with DATAGRID VIEW object along with BindNavigator. How can i implement Master / Detail that work with the BindingNavigator? Your advice will be highly appreciated. Adnan A. -- Message poste...more >>

Hi. Is there any way to run sql commands on the same connection that SqlDataSource uses to select data before the select? Apaprt from trying to build a multi-command CommandText. Overriding the class would be ok but I can't find the way to do it ...more >>

Hi, My .NET application writes to an Access 2003 db through OleDb. I'm using a stored query in Access to insert a new row. The app's C# code sample includes: myCommand.CommandType = CommandType.StoreQuery; myCommand.CommandText = "InsertName"; myCommand.Parameters.AddWithValue("@FIRST...more >>

I am working through the manual for course 2524 (Developing XML web services using ASP.NET). It is at least 4 years old so hopeless outdated (:-) but I think I can salvage it to still be useful. I actually tried this with just the express editions of visual web developer, C#, and sql server 20...more >>

Hi All, I created the following code, it is working, simple update of DataTable, populating data to datatable/dataset is outside/before. Problem: when I tried to use the transaction it doesn't. It prompt error message "Execute requires the command to have a transaction object when the c...more >>

I have an application that is localized into a number of cultures (Turkish is one) and a number of stored proc calls are failling when the site is run in Turkish but not in any other language, but not all procs fail. I am using framework 1.1, standard datasets and table using SQLDataAdapter ...more >>

I'm using VBExpress and SQL Server 2000 which means that I can't use the wizards/database explorer to do this stuff. It has to be done in code. I've figured out how to connect to the database and execute a query, but so for I've Only been able to put the results into a messagebox. I want to...more >>

I'm converting over a ADO.NET provider I wrote in 1.1 .NET to 2.0. I don't understand why the DbCommand.ExecuteReader methods (it's overloaded) is not virtual or abstract. This method would most likely need to be modified by any class inheriting DbCommand. On the other hand, DbCommand.ExecuteS...more >>

Hi all, I've a standard DataTable, is there a way to get an array of value like that one I obtain in SQL Server suppying the SELECT DISTINCT [field] statement? Have I to loop trough the datatable to build the array or is there a simpler way? ...more >>

Which was updated by the sql UPDATE instruction. Is there some objects returning the number or I have to do explicit SELECT nevertheless? Thanks in advance....more >>

Hi, I've been tasked with the following: We need to add elements to app.config and web.config to be able to specify the CommandTimeout for SQL Commands. Since there is no option in the connection string to set this property globally, this means that every time we execute an SQL command ...more >>

Hello, Can somebody explain to me in plain language what is the meaning of each value in the LoadOption enumeration? Or some clear articles about DataTable.Load and DataRowVersion. Thanks, Carly ...more >>

I am working on a project where we need to join data from a SQL Server db with data from Oracle. I have searched and have not found any good method to accomplish this. Here is what I have to work with: User table in SQL Server with Names, addresses, etc. The key is UserID Asset table i...more >>

Im getting that error (It is strange. I Run my programme step by step pressing f11. im looping SqlCommand in a while loop. The First step runs but when a enter 2nd step in my loop it returns error ? ) any idea ? System.Data.SqlClient.SqlException: Procedure or function sp_adduser has too ...more >>

I received the following error: Concurrency violation: the DeleteCommand affected 0 of the expected 1 records. on the Update method of the adapter below: Me.ClientBindingSource.RemoveCurrent() Me.Validate() Me.ClientBindingSource.EndEdit() Try Me.client...more >>

I've defined a dataset containing 3 tables via the DataSource Configuration Wizard. In the UserControl.Load event, I place: Try clientAdapter.Fill(DsClient.Client) personAdapter.Fill(DsClient.Person) addressAdapter.Fill(DsClient.Address) Catch ...more >>

I've written a small app which has 2 buttons. The 1st button goes away to a directory full of SQL Scripts, and then runs them against the database. The 2nd button has code to do some modifications to the database, looking like the code below: ______________________________________________...more >>

Hello, What I want I fairly simple (I guess), but I can't work it out. In one application I export data from a SQL Server database to an XML file. I have used the DataSet.WriteXML method to do this. My XML file looks like this (simplified): <?xml version="1.0" standalone="yes"?> <broke...more >>

I have a DataSet with two tables in it, with a relation between them. I fill the tables with records programmatically with these commands: System.Data.DataRow newRow = myTable.NewRow(); //give values to each column in the row myTable.Rows.Add(newRow); I want to create a DataGridView that is bo...more >>

Hi, I wrote a simple application that opens and closes connections to an Oracle DB using the standard ODP.NET API. The ODP version is 2.102.2.20 and the DB version is 9.2.0.7 This application works fine on Windows XP, but when running on Windows 2000 (SP4) it takes about and hour and fin...more >>