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

I test for a connection when I load a particular form, so as to prevent other more ghastly exceptions further into the logic. However, I've noticed that even with NO viable connection string, the connection object state shows open. Anyone see something I'm overlooking here? Here is the code...more >>

Hi I need to perform following querie in vb.net The queries are; NSERT INTO [destTbl] (field1, field2) SELECT srcTbl.field1, srcTbl.field2 FROM srcTbl WHERE (((srcTbl.entry_id) Not In (SELECT srcTbl.entry_id FROM [destTbl]))); In access I just run these query and job is done without...more >>

I am using ExecuteScalar, executing a stored procedure with two = commands: the first command is Select command,=20 and the second is Insert. Because of the Select command , The ExecuteScalar do not return an error = in case of the Insert(second command -see the stored pro. sample in the = bot...more >>

Hi I need to perform following querie in vb.net The queries are; NSERT INTO [destTbl] (field1, field2) SELECT srcTbl.field1, srcTbl.field2 FROM srcTbl WHERE (((srcTbl.entry_id) Not In (SELECT srcTbl.entry_id FROM [destTbl]))); In access I just run these query and job is done witho...more >>

Hi, Im using the VisualStudio 2005 designer to create typedDataSet (drag & drop from the service explorer). All the DataTables in the generated code inherit from System.Data.DataTable, I would like the dataTables to inherit from MyDataTable (a custom DataTable) instead. How can I do that witho...more >>

Hello, I just have a form in which there's a textbox for queries. I need to use the SQL statements for an Access db, like this, which works fine in a SQL db: SELECT * FROM table WHERE name LIKE @name + '%' I just need to query the db to find names that start with letters I digit in the textbo...more >>

Greetings, I'm fairly new to ASP.NET/ADO.NET and SQL. I worked out a few issues with the help of some nice folks here. Now, I'm starting a clean Web site project but am having trouble right off again. I'm trying to create a new database using MS SQL Server 2005. I entered localhost as...more >>

This never happened before in .NET Framework 1.0 nor .NET Framework 1.1, but connection leak happens if you don't close the connection when you use SqlTransaction. I would like to share this information with the MS dev community. We had this issue of SQL Server performing very poorly while run...more >>

Hello, I have a table as follows- BUILDING ROOM_NUMBER MAIN 100 MAIN 101 MAIN 102 SUB 200 SUB 202 The Resultset should be as follows- BUILDING SUMMARY_ROOMNUMBE MAIN 100,101,102 SUB 200,202 I know I...more >>

Hi, is there anyway of selecting rows with a particular date but ignoring the time within a date time column? something like... DataTable.Select("DateTimeColumn".Date = '28/12/06') ? thanks in advance for any advice. Sharat Koya ...more >>

Hi, I have VS.net 2005 express and I have created a new project. I made a new folder and added and existing MS Access DB (Maintenance.mdb). VS.net happily went and created a DataSet class for me (MaintenanceDataSet). My question is: How do I load the data from the Access DB so I can access it f...more >>

Hi All, I have a headache with SQL Server and .net application which I hope you can help with. I have this trigger on my table 'tester' in sql server 2000. It calls the external program exetest CREATE TRIGGER testTrig ON [dbo].[tester] FOR INSERT, UPDATE AS exec master..xp_cmdShell 'C:\E...more >>

Hi All, I have a headache with SQL Server and .net application which I hope you can help with. I have this trigger on my table 'tester' in sql server 2000. It calls the external program exetest CREATE TRIGGER testTrig ON [dbo].[tester] FOR INSERT, UPDATE AS exec master..xp_cmdShell 'C:...more >>

Hi I am a newbie in ado.net 2005. Is it possible to do a Group By in a dataset? thanks E. ...more >>

Hi, I have started using Typed Data Sets with VS2005 and so far so good, however I am having a problem with adding a row to a data table and returning the new Primary Key value. My data set has been auto generated from a DB table and has an auto generated Primary Key for the ID field. I cr...more >>