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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|