Groups | Blog | Home


Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
December 2007
January 2008
February 2008
March 2008
April 2008
all groups > dotnet ado.net > may 2007 > threads for may 29 - 31, 2007

Filter by week: 1 2 3 4 5

Guid uniqueness and concurrency management.
Posted by BLUE at 5/31/2007 9:21:49 PM
A GUID is a 128-bit integer (16 bytes) that can be used across all computers and networks wherever a unique identifier is required. There is a very low probability that the value of a new Guid is all zeroes or equal to any other Guid. From MSDN we know that there is a possibility to have t...more >>


System.Transaction
Posted by Andrew Robinson at 5/31/2007 11:59:32 AM
I am receiving an exception while trying to use a TransactionScope. My code is as follows: using (TransactionScope scope = new TransactionScope()) { equipment.Save(); status.Save(); scope.Complete(); } This code is pretty basic and calls some dynamic sql updates using two ...more >>

What is the faster way to insert/buck insert rows into SQL Server
Posted by Hao at 5/31/2007 10:04:49 AM
I am developing a data center server in C#. We alaready have a legacy system that worked with great performance. The old system was unmanaged code in C++ and used ODBC driver SQLBindParameter to bind the data in the memory before dumping to the SQL Server. In the current C# version, I used the...more >>

SQL Injections and parameterized SQL
Posted by LtyChan at 5/30/2007 9:20:52 PM
This might be a stupid question - but can I be sure to avoid SQL injections by using parameterized queries? Will SQL Server or ADO.NET kill any attempts to drop or update data through sql injections (ei '; update ..... ;--), and can see a log of any attempts somewhere (will SQL Server warn or ...more >>

DOWNLOAD CRACKED 2007's SOFTWARE: ARCHICAD 11,UNIGRAPHICS NX5,SOLIDWORKS 2008,XSTEEL 13,AUTOCAD 2008
Posted by William Eistenach at 5/30/2007 2:53:21 PM
Our team provide different types of services such as: - proffessional cracking of any kind of software (CAD,CAM,CAE,EDA,GIS,PCB,FEA,FEM,CNC,CFD,PDS,3D,Optics etc.) designed for any kind of operating systems(Windows 95/98/ME/2000/XP, Linux, FreeBSD, OS/2, MAC OS etc.) - producing key...more >>

DataSet - Starting from scratch
Posted by Mark at 5/30/2007 10:04:00 AM
I have created a data entry form that will allow the user to enter in new data. The form has a binding navigator control, a binding source control, four label controls, four text box controls and one command button. The first objective I’m trying to accomplish is the scenario where the da...more >>

Selecting @@Identity from an Access Database
Posted by Marc at 5/30/2007 9:59:17 AM
Hi to the group. I am at my wits end with this problem. I am working in Visual Web Developer 2005, .NET 2, C#, MS-Access. I have created a dataset (xsd) with some datatables in for interacting with my database tables. I am attempting to create a new insert query in a table adapter which wil...more >>

[.NET1.1] datarow and itemarray
Posted by Freddyboy at 5/30/2007 8:55:04 AM
hi, I have an issue with datarow and itemarray. In a datatable I have followong datas : OPS 014E OPS <NULL> I perform a foreach on each datarow like this : foreach(DataRow dr in aTable.Rows) { object[] o = dr.ItemArray string s1 = (o[0] != DBNull.Value) ? Convert.ToStri...more >>



Connect to anothe database
Posted by Husam at 5/30/2007 1:40:01 AM
Hi EveryBody: How can I connect to another database instaed of the default database aspnetdb in the local SQL Server in the App_Data folder that exist in my web site application ? My database that I want to connect is in my local Machine and its name=Husam. Any Help or redirection will ...more >>

DDL via ExecuteNonQuery()
Posted by timexsinclair2068 NO[at]SPAM hotmail.com at 5/29/2007 2:07:13 PM
I'm trying to run an ExecuteNonQuery("CREATE TABLE...") and I get a -1. I'm using SQL Server 2000 and this has been happening since I installed VS2005 (which also installed SQL Server 2005). I'm starting to think it has to do with pemissions. Maybe SQL Server 2005 messed up with SQL Server 200...more >>

DataSet auto increment problem
Posted by Mark at 5/29/2007 11:02:01 AM
Hi Everyone: I have set up a dataset that uses an auto increment field that is set to start at minus one and step by minus one when I add a new record to the dataset. Example dataset: 1. Existing Record 1 2. Existing Record 2 3. Existing Record 3 4. Existing Record 4 5. Existing Record ...more >>

Lock confusion
Posted by shumaker NO[at]SPAM cs.fsu.edu at 5/29/2007 10:43:27 AM
I created a test case to exemplify an issue I'm having in a production application. Below are the scripts. The confusion for me is that if I run the statements with RepeatableRead isolation level in separate transactions, then the select statement blocks waiting for the update statement to com...more >>

Transaction problems
Posted by 4nd3r5 NO[at]SPAM gmail.com at 5/29/2007 1:35:32 AM
Hi All I've got a problem with some transactionhandling. I have a dual server setup: one webserver and one databaseserver. Because of the dual server setup i have configured MSDTC (distributed transaction coordinator) for the transactions. I have tested the setup with DTCPing successfully: h...more >>


DevelopmentNow Blog