| Groups | Blog | Home |
|
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 |
Filter by week: 1 2 3 4 5 Updating DataTable best practice question Posted by Jon Pope at 6/14/2007 2:34:30 PM Currently, I'm investigating various architecture designs which involve
maintaining a DataTable object within a background thread. I have various
grids which will feed from that DataTable via DataView objects. Thus the
layout is:
DataTable object (worker thread) -> DataView object (main t...more >>
error: an exception of type: {System.InvalidOperationException} occurred Posted by Elmo Watson at 6/14/2007 12:13:09 PM I have a class - I Dim a SQLconnection, then, in Sub New, I instantiate it,
so that it's available to me whenever I reference the class (correct?):
Conn = New SqlConnection(msConn)
Then, in my Subs/Functions, this section (inherited from previous author):
If Conn.State = ConnectionState.Close...more >>
Data Access Application Block for Compact FRWK Posted by Chevy at 6/14/2007 9:30:03 AM Hi,
there is a Data Access Application Block for .NET Compact Framework ?
I need for an Pocket PC app, I have Visual Basic .NET 2005 and SQL Server CE
I was looking for in Microsoft site but I not found that.
thanks in advance...
--
Chevy...more >>
Combined insert/update/delete Transactions for business object lis Posted by Chris at 6/14/2007 3:37:01 AM Hi, im using CSLA for my business objects. At my data layer tier i loop
through my list of business objects, if the object is new i insert a new
record, if its to be deleted i remove, and if it has changed i update the
details from the object and persist to the database.
Now if i have long ...more >>
SqlDataReader.Read() with image data type size 65,535 Posted by Thana N. at 6/14/2007 1:49:01 AM Hi Guy,
I've found that SqlDataReader.Read() (with do not read value from row) has a
problem when reading image data type from Ms SqlServer 2000 if data size is
65,535. I've found this error in .NET 1.1. Any suggestions?
Thanks,
The followings are sql script and VB.NET code:
----- s...more >>
Common Practice to Connect SQL Posted by wrytat at 6/13/2007 6:17:02 PM I'd like to ask for the correct way, or rather say the more advisable way to
connect to a SQL Server in a Windows application written in .NET 1.1 or 2.0.
When I develop my program, the database is located on my machine. But when it
is published, the database that it use will be on our server. ...more >>
Timeout Error Posted by Kalyan Nistala at 6/13/2007 6:08:00 PM I have a web application developed in asp.net v1.1; database is sql server
2005. In production envionment, we are receiving the following error:
System.Data.SqlClient.SqlException: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not responding...more >>
SET ARITHABORT ON makes ADO.NET query way faster. WHY? Posted by cmay at 6/13/2007 2:50:25 PM We have this SP that returns about 25,000 rows from a join of 4
tables.
These 4 are all tables, and not views, and none of them have
calculated fields.
>From Microsoft SQL Management Studio, putting SET ARITHABORT ON and
SET ARITHABORT OFF execute in the same time: fast, about 2 seconds.
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
"There is no Original data to access." ?? Posted by Jon Pope at 6/13/2007 2:36:54 PM I've got a worker thread in which I'm updating a DataTable instance. Within
my main thread, I'm hosting a DataViewGrid, which is bound to a DataView
object derived from the DataTable instance by using
DataView dv = new DataView(<DataTableInstance>);
<DataGridViewObject>.DataSource = dv;
...more >>
Reading Excel XML files Posted by Terry Olsen at 6/13/2007 6:38:40 AM Is there any way to connect to and query Excel files that are in XML format?
I've not run into these before but now I've got these files that have the
..xls extension but are actually XML files. I've read in other discussions
about this where the advice was to open them in Excel and save them ...more >>
Error Not Declaring Scalar Variable Posted by news.microsoft.com at 6/13/2007 1:40:08 AM I get an error on the variable @ObjectName. Can anyone suggest what is
wrong?
_name = _lvi.Text;
_type = "T";
_sql = "INSERT INTO QueryBuilderTableViews(ObjectName,ObjectType) VALUES " +
" (@ObjectName, @ObjectType)";
cmd.CommandText = _sql;
cmd.Parameters.AddWithValue("@ObjectN...more >>
Do you know that Norton antivirus is itself a virus..? Posted by anusharma99 NO[at]SPAM gmail.com at 6/12/2007 4:58:48 AM Hi Dear,
Do you know that Norton antivirus is itself a virus..??
it hangs PC more than it cleans..
Try the new Spyware Doctor's Starter Edition NOW....!!!!
http://www.tigerzclub.com/spyware.htm
...more >>
What thing to Go in my scenario (Recordset/DataTable)? Posted by Sachin Chavan at 6/12/2007 2:33:00 AM Hi SQL Gurus,
I have a scenario like following:
My DAL is sitting on a BOX with 4 GB RAM and calling the SQL Server BOX via
Network (Internal). The records returned are huge in range of say 30000 to
300000.
I am having 6 Columns on average in each row.
I am generating an XML in a SQL S...more >>
Primary and Foreign Keys Question Posted by news.microsoft.com at 6/11/2007 7:45:05 PM I have the following code that gets the primary and foreign keys from the
tables in my database. This works fine for tables that have only one
foreign key. My question is if a table has multiple foreign keys or
multiple columns make up one foreign key, will there be multiple rows coming
ba...more >>
ColumnMapping - Explicitly exclude a column Posted by Jonathan Orgel at 6/11/2007 12:00:38 PM In the middle tier I want to exclude some columns passed on to the client
layer. I would like to exclude a specific column from a datamap without
needing to specify all the column I do want. At design time I will not know
what the columns will be included in the select statement.
Any sugges...more >>
ODP.NET Ref Cursor Input to oracle Stored Procedure Posted by RCReddyCh NO[at]SPAM gmail.com at 6/11/2007 11:11:21 AM Hi ALL
I want to send an Input Ref Cursor from .NET to Oracle. The below link
gets the cursor from database as out parameter and sends the same
cursor back as Input which does not make any sense to me.
http://www.oracle.com/technology/oramag/oracle/06-jan/o16odpnet.html
My webservice has ...more >>
when to dispose a datatable? Posted by Smokey Grindle at 6/11/2007 8:39:18 AM I have a list box on my form, but I need to databind it to a data table that
is a private member of the form's class... so I basically have
Public Class MyForm
priate m_MyTable as new datatable
End Class
now where would I properly dispose of this? In the finalize method? I am
loading...more >>
Dataset serialization issue Posted by Nilkanth Desai at 6/11/2007 6:32:01 AM Hi,
I am passing my simple dataset to my webservice which accepts dataset
as an argument as follows.
myservice.webmethod(ds);
In my web service I receive the above dataset as mentioned below.
Public void webmethod(dataset ds);
Now my problem is when I trf dataset ...more >>
Connecting to SQL Server from a Web Service: login failed. Posted by BLUE at 6/10/2007 9:02:25 PM I'm using SQL Server 2005 Developer Edition on Windows XP SP2 with this
setting:
<add name="SqlServerTrustedConn"
providerName="System.Data.SqlClient"
connectionString="Data Source=localhost;Initial
Catalog=GTSDB;Integrated Security=SSPI;" />
All worked great ...more >>
Awesome Posted by baseballgolfbox NO[at]SPAM mail.com at 6/10/2007 2:02:23 AM Check it out: www.BrandonsMansion.com
...more >>
Which Method to Create a Database Do I Use? Posted by Jonathan Wood at 6/9/2007 6:37:14 PM It appears there are two methods for creating a database as part of an ASP
project.
I can use the Server Explorer and create a database that I can't easily see
as a file, and create a connection. On the other hand, I can right click in
the Solution Explorer window and select Add New Item, a...more >>
Why using command parameters? Posted by BLUE at 6/8/2007 7:25:41 PM DbParameter dateAndTime = this.factory.CreateParameter();
dateAndTime.ParameterName = "@DateAndTime";
dateAndTime.DbType = DbType.DateTime;
string utcDtString = nameValueCollection.Get("dateAndTime").TrimEnd('Z');
dateAndTime.Value = DateTime.ParseExact(utcDtString, "s",
CultureInfo.InvariantCu...more >>
SQL Server bug? Posted by BLUE at 6/8/2007 5:19:56 PM SELECT * FROM Actions WHERE NOT EXISTS
(SELECT Actions.ActionID
FROM Actions, Tracks
WHERE Actions.ActionID <> Tracks.ActionID)
SELECT * FROM Actions WHERE NOT EXISTS
(SELECT Actions.ActionID
FROM Actions, Tracks
WHERE Actions.ActionID = Tracks.ActionID)
Always 0 rows: I have to use ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |