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 >>

I have defined a dataset using the DataSource Configuration Wizard. I dropped 3 tables onto the design surface. It looks like this: Tbl1 Tbl2 Tbl3 PK FK========> PK FK=========>PK Table 1 is a Client, tbl2 is a Perso...more >>

Can anyone tell me why this code added automatically by C# does not work? I can add a record on the form or modify a record, but hitting the save button does not save changes back to the database table. I can see the chnages to the dataset as long as the form is still loaded. private void ...more >>

I don't think there is a way. There seems to be a black hole of info about this unless you are using the older ADO technology. If you know, please share...! Dennis ...more >>

Sir, We need some help in photoshop Add-in. Here i am sending the problem. Please do in favour in solving the problem. Through the .Net application we are activating the photoshop and sending the short cut keys to photoshop for activating the adjustment dialog boxes. in C#.net Inte...more >>

Hi, I'm wondering if it's possible to regenerate the increment id's in an AutoIncrement Column? My situation is this...I have a client application that is recieving a several DataTables from a service. The DataTables contain an auto increment column which is guaranteed to be unique withi...more >>

I have code as follows if((DataTable)read_union_database("retrieveSSN")).row[0][0] == DBNull.Value { orow[0] = "" } else{ orow[0] = ((Data Table)read_union_database("retrieveSSN")).rows[0][0].ToString(); } I keep getting the error "There is no row at position 0" and when I pl...more >>

I create a typed dataset by drag'n'drop in VS2005 (VB). I can use FillBy or GetDataBy methods to retrieve the record. The code is as follows: dataTable = tableAdapter.GetDataByCode(KeyFieldValue) MtrUnitBindingSource.DataSource = dataTable 'user edits the record 'press ok button to save Mt...more >>

Hello All, I use a dataadapter to fill a datatable from a sql server table. The datatable contains one column ROW_ID which is set as the PrimaryKey. The sql server table contains a single row and no new rows are added between refreshes. I refresh the datatable every 3 minutes using the da...more >>

Hi I am a asp.net 2.0 newbie and I was thinking how to update rows in a dataset? How to find rows and update these rows manually? thanks E ...more >>

I am quite new in programming an I have to develop an application (Project-Management-Software) with Visual Studio .NET 2005 and SQL Server 2005 (ADO.NET). My problem is how to map the sql-server table to the .NET Object/class! Does it make sense to use typed datasets or is it better to crea...more >>

Hi All, I am having the strangest and most frustrating time trying to load a recordset into a data table more than once. For some reason, when I execute the following code, the first messagebox displays a record count of 2 and a second call to it displays a count of 0. Why the incons...more >>

The below code is what I put together to open a XML persisted ADODB 2.8 recordset in an ADO.Net v2 DataSet. My question is if the below code the best why to go about this. Thanks Dan Reber ADODB.Recordset rs = new ADODB.Recordset(); rs.Open(fileName, Type.Missing, CursorTypeEnum.adOpe...more >>

Hello all, I'm having a performance problem using the DataTable.DefaultView.RowFilter. When setting the filter to MyField = "Something" this takes about 12 seconds (this isn't the issue). Next if I change the filter to MyField In ('SomethingElse') it takes about 1 second (still not the issu...more >>

We are working on a project where we are converting our client server application to a n-tier model to make it more scalable. The question I have here for the group is to see if I can get some ideas on how the security should be implemented for this kind of architecture. I am new to this n-tie...more >>

Hi there, If someone could just run me through the tasks involved in this simple example I would be grateful. (using asp.net 2.0 and vb.net, sql server 2000 database) I start with an xml string, which I load into a dataset as a single table. This is a single column of unique id's. So far...more >>

I have a unique situation and wondering if there's a different way of doing it. I have a strongly typed dataset for a disconnected environment. This dataset runs on a service so I want to clear the rows every now and then to keep memory usage to a minimum. But if dataset can't contact for the...more >>

Hi All, We have a website build in ASP.NET 2.0 and we are receiving the following error: System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the ...more >>

I have searched far too long for an answer to this riddle...and I know it's probably right in front of me. I have found articles using older versions of ADO that set Jet specific properties on the ADO connection object. In ADO.NET 2.0 the Connection does not have a Properties collection where ...more >>

I'm attempting to work with SqlDataSource to pull values from a database and populate a form, which by itself is no problem. However, I'm trying to visualize how to also iterate through values on a joined table. My situation is that there is a form representing a Rule filled out mostly from ...more >>

Hi; I need to call SqlCommand.ExecuteReader and then inside a while (reader.Read()) I need to call another SqlCommand.ExecuteReader. I need to do this because I have a FK:PK relationship and based on the FK read, then read the row in that related table - if the FK is not null. How can I ...more >>

Hi all, I've a DataTable, and from my UI a such user deletes one or more rows from it, I wish to get the deleted rows from the DataTable. I have to perform a loop trough the deleted rows and invoke the Row.Accept changes method, but if I try something like this: dim rX as DataRow For ...more >>

I've seen several posts in the archives regarding making your VB .NET application have a relative path connection string to an Access DB, but do not see a definite resolution to the matter. Here's what I'm trying to resolve: My VB 2003 .NET application connects and works just fine with an Ac...more >>

Hi, I am using transaction object with this code: connection.Open(); SqlCommand command = connection.CreateCommand(); SqlTransaction transaction; // Start a local transaction. transaction = connection.BeginTransaction("SampleTransaction"); // Must assign both transaction object...more >>