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