Hi, We have bunch of DataObejcts/BusinessObjects those used against database. Now we fetch some data from database into a dataset. How can we contruct a ConnectionString to connect to this dataset so we can use those DataObejcts/BusinessObjects? Thanks ...more >>

I'm working with the new Beta 2 of VS2008 and LINQ is really great but i'm searching for an opposite construct of the SubmitChanges() method to discard changes. Background: I have a form for editing a single data row and only if the user clicks the OK button the changes are saved into the DB....more >>

Is there any way to select a record and update a field in that record in the same statement? I have a table that several threads will be querying. Once the record has been selected by a thread, I don't want that record to be selected by any of the other threads. So my thought was to have a "bu...more >>

Hi, I'm creating a typed dataset based off of a SQL Server 2005 DB. There are 2 fields from one table that I'd like to bind to on an ASP.NET dropdownlist. Since I can't specify two fields in the "Datatextfield" proprety of the control, I'm trying to create an expression-based column. One thing...more >>

I have a dataset containing a datatable. Everything was working OK. Then I changed the definition of one of the columns from not null to nullable. Now when I update the adapter, the change is not being written to the DB. Just before the update, I looked at the data in the datatable by walking t...more >>

Hi There, What's the better way to follow when we use sql string sql = "Inset into table(f1,f2) values (@f1, @f2)"; then add and passing parameters or in the first place itselef assign the values to the string string sql = "Inset into table(f1,f2) values (" + tbName.text + ", " + tbCity....more >>

Hi, I've noticed that if I change my connectionstring in the app.config file, this isn't enough, a second change in the Global.System.Configuration is necesary!!! This means that after deployment and if the SQL server is changed, changing the code is necesary, ..............?.?? can I...more >>

I have a query that looks up the highest value for column a and then returns column a and column b. It uses a nested select in the from clause. I want to use bind variables for my parameters but have found out i can't use bind variables in the from clause. It keeps returning no records when i...more >>

If I delete rows in a DataTable and then do a DataSet.AcceptChanges, and then pass that DataSet to the client, will the client have any idea of rows that previously existed? I'm hoping not. If the client would still see those rows (but as deleted), I guess I will have to create a new DataT...more >>

To start, I'm using VB 2005 and SQL Server Express 2005. This almost appears to be a bug, but I've yet to find an actual bug and generally narrow my issues down to user-error on my part. I have the following code snippet (LogFile is a class I've created simply to output to a textfile): --- ...more >>

Is there a way I can compare two DataSets to see if they are identical? Thanks, Ron ...more >>

Hi; One of our testers is getting this now - and he is not running under a debugger. The error is: Exception(s):DataSourceException: executeQuery select=select CategoryName from Categories Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not...more >>

When I have a timeout on invoking a stored procedure against SQL Server, I have an exception returned that looks like the following: {System.Data.SqlClient.SqlException} System.SystemException: {"Timeout expired. The timeout period elapsed prior to completion of the operation or the serve...more >>

Hi! This code (using the System.Data.SqlClient namespace)... SqlCommand c = myConnection.CreateCommand(); c.CommandText = "INSERT INTO myTable (myField) VALUES (@myParameter)"; c.Parameters.Add("@myParameter", myValue); c.ExecuteNonQuery(); ....usually works perfectly fine for all kinds ...more >>

I am having an issue with getting my ds to update my db. I am pulling info from the NW db on my Default.aspx page. I then click the edit btn and pass the data to my Details.aspx page. That works fine. The issue is getting the ds to actually update the db. I know this is simple, but I can't see...more >>

Maybe a stupid one,...... is it still usefull to make indexes on the SQL server since in ADO.NET we work with complete datasets which contain complete or parts of tables??? -- Best regards Luc N...more >>

Please i'm new in VB.net and i'm designing a Cinema booking and purchase system..I need to load the seat ID from the database into an array.please how do i go about it.. or can anyone give me an idea of how i can show seats are availabele,booked or bought..i'll really appreciate input.... reg...more >>

I have a DataTable with one row and I did a Merge() from another DataTable and now I have two rows. How can I get the rows to be a single row (assuming row 0 is the "dominant" one). Thanks. ...more >>

I have a DataRow in a DataTable. I want to know if there is a value. I do this if ( this.Rows[0]["Col_A"] == null ) { throw new Exception ( "no" ); } However this condition is never hit. Why? Thanks....more >>

Hello, is there a possibility to get the ID of the last created or modified dataset of a table via ADO.NET? Is there a database independent way? In SQL Server you can call the scope_identity() function, but this won't work in Oracle, MySQL, Access a.s.o. Thanks in advance, Norbert ...more >>

Our project is using the System.Transactions.TransactionScope class to provide an ambient transaction which our DAL classes can leverage. I'm looking for some information about the TransactionScope class to answer a few questions about how it behaves when a transaction is promoted to a d...more >>

Hello, In order to avoid errors, I have all my DataReader-fields converted with a ..ToString. This in case some record could have Null-fields and an error would be thrown. This works fine, except for "money" fields in SQL-Server. When I enter e.g. ? 2,50 and I read it back with a DataRea...more >>

I have a GridView which is bound to a table. The user has the ability to change some defaults and then run a process from this. This all worked fine until I added in an auto postback to one of the controls to tie in some other functionality. After the post back, and at the end of page loa...more >>

Hi I'm not sure whether I've given this post the correct title, but I'm a bit unsure of where to put it. I have a database that holds information about several of our users. This database is stored on a central server, with an application that periodically performs some processing, which ma...more >>

Hello, When I have closed my appliciation in VB.NET, and I try to detach my database from SQL SERVER, I often get a message that the database cannot be detachted, because it is still in use. So I think there is some code missing in my application (in the MDI_FormClosing?) to make my da...more >>

Hello, How can I use an ExecuteNonQuery within the loop of a datareader? My code is as follows: Dim cmdToProcess As New SqlClient.SqlCommand Dim rdToProcess As SqlClient.SqlDataReader With cmdToProcess .CommandText = " SELECT * FROM tblDetails " .Connection = cn End With rdToP...more >>

i am looking for code sampe in aso.net 2 for encrypt/decrypt of paswr d withought using any external DLL (judt to use existing net2 tools) thnaks i nadvance peleg ...more >>

Hi I'm getting very occasional exceptions in an application when trying to open a SQLConnection. Does anyone know what this error means, or what I can do about it? The error has only occurred a couple of times, each time with a gap of more than a day, so I cannot replicate or even find a patt...more >>

Hi guys, could you please help me on my problem. >>>> --------------- <<<<<<<<< Datasource: MS Access 2003 Table1: Tbl_Employee Field1: Emp_name Field2: Position Field3: Contact# Field4: Address Table2: Tbl_Salary >>>>...more >>

I have an app that allows the user to build a query and then click on a button to execute the query and the results are then used to fill a grid. Can I have the retrieval run in a backgroundworker and have a button that would allow the user to cancel the query if it is running for too long of ...more >>

When I run the following code everything works fine (which proves the = stored procedure and the parameter: Dim cmdSQL As New SqlCommand cmdSQL.CommandType =3D CommandType.StoredProcedure cmdSQL.CommandText =3D "bdl_CustomerOrders_SELECT" cmdSQL.Connection =3D...more >>

I have something that works, but it only returns one row of data when i create an ObjectDataSource with it and bind it to a gridview so i need a little help with this (thanks) as simple as it gets 1. my class: Imports Microsoft.VisualBasic Public Class radioShowFiles Private _szFileN...more >>

Hi, Does TransactionScope need DTC in situations that the transaction is not distributed? I have a set of non-distributed transactions and I am not sure that TransactionScope is the best option for best practice perspective. Thank you, Max ...more >>

Hi, I have 2 datasets right now, say with the following structure: DataSet 1 has a row called ItemCode, index 1 DataSet 2 has a row called ItemCode, index 1 both are similar, but i need to merge them to make one dataset, which needs to have everything in DataSet1 plus anything from DataSet2 ...more >>

Hi, In Strongly typed datasets, when we preview a table adapter query, we cannot preview a stored procedure query that has GUID parameter. The error complains that cannot convert a string to GUID. What is the proper format for GUID parameters? Of course I tried {.} format. Thanks, Max...more >>

For a project I have a typed dataset created ( by dragging tables/ views and configuring the appropriate queries ). If the database schema for these tables is changed (e.g. few columns get added), is it possible to automatically refresh the DataSet. Right now, I see that the Fill query only ha...more >>

Everything was working fine until suddenly this problem appeared from nowhere: Boot up the pc and go into SQL Server Management Studio. The database is present and the data can be accessed. Go into VB2005 Express and run the project. Everything works fine. Open Database Explorer and c...more >>

I'm new to .net. It seems that those application blocks in Enterprise Library are very useful especially when one tries to build a new application. I want to know the pros and cons in using those blocks. Is MS going to release new Enterprise Library for future .net version/build? If I use ...more >>

Hi there, Firstly, I hope this is in the right place! I have a problem with a nested query I am generating at runtime. My table (tblIndexValue) has values in every cell in all rows including the createdUserID column. The createdUserID's datatype is a GUID, and the table is in Access usi...more >>

I am using VB.net The Error message is :Syntax error in INSERT INTO statement. vb.net Could this be casused by my primary Key? if my primary key is "ID" and it is (autonumber). I tried inseting a blank field, number in a field, and the example is with out the field at all. INSERT INTO E...more >>

Dear all, I would like to bind a datgrid control to an SQL view. How set SQL command type for a view ? Is it Text ? IN which form the sql view is returned, data set ? When I get my view bind to my grid, if new data is inserted in my database, does my view will be automatically refreshed ...more >>

Hello I need to write a stored procedure that executes a bunch of bulked and related(stock) trades. For example, the customer may have requested four trades to be placed. The trades are related because the money from selling one stock say needs to fund a new stock purchase. What is the r...more >>

Hello there, what is the best way to add an dataset and, then, to read out the ID value of the created dataset? ExecuteNonQuery() does not retrieve informations about the new ID of the dataset. Of course I can execute a statement like this: SELECT MAX(ID) from TableName, but this would not ...more >>

I use .Net 2.0 and connect to a database access, on the connection.open() I've this message "The type initializer for 'System.Transactions.Diagnotics.DiagnosticTrace' threw an exception" Code : public DataSet GetData(string SqlQuery) { using (OleDbConnection c...more >>

Dear Sirs. I have Client Server Application on Client Side i have .NET 1.1 WinForm Application on Server Side i have SQL Server 2000 I'm using "OLE DB PROVIDER FOR SQL SERVER" for the Data Access 1) I'd like to upgrade Server Side to SQL Server 2005 (I will copy same databa...more >>

Hi, Using Visual Studio 2005 and SQL Server 2005: I am trying to understand the stored procedures that Strongly Typed Datasets wizard generates for me. When we create a new strongly typed Datasets, and choose the following path: Choose connection-> Create new stored procedures -> Enter...more >>

In my client Windows application, I am receiving a DataSet containing one DataTable. This comes to my client via the business tier on a different physical machine (we're using WCF if that matters). After I make changes to the data in the underlying DataTable, I send the DataSet back to the...more >>

i am facing the probleum in running asp onmy machine. i am using window xp 2000 and also i have installed iis on my machine but the asp does't work plese guide me how can i remove this probleum...more >>

Hi, I'm trying to use an EnterpriseLibrary 3.1 and return recordset from oracle database using stored procedure. As you may know, oracle stored procedures have out parameter of type cursor in order to return a dataset. It seems like I need to add a paramenter of type cursor to execute this ...more >>

Is there an easy way to copy rows from one data set to another other than field by field copy? Thanks Brad ...more >>