| 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 foreign keys -> DataRelation Posted by Anonymous at 6/7/2007 10:16:21 PM Is it possible to get DataRelation-objects created automatically in a
DataSet,
based on foreign key constrains in the database?
...more >>
Wich DBMS supports TransactionScope and distributed transactions? Posted by BLUE at 6/7/2007 9:29:23 PM Only SQL Server 2005 or also DB2, Oracle and MySQL?
Thanks,
Luigi.
...more >>
There is already an open DataReader associated with this Command which must be closed first. Posted by BLUE at 6/7/2007 2:32:54 PM I've a TransactionScope in which I select some data and I want to do some
queries for each record retrieved with my select.
I'm using a DataReader and for each record I do factory.CreateCommand() and
then I execute the command, but I get the following exception message:
" There is already an ope...more >>
Getting error from store procedure ???? Posted by calderara at 6/7/2007 11:35:01 AM Dear all,
I am building a multi tiers application based on .-NET 2.0 and SQL server 2005
WHast is the best way to return data access error from the datalayer to
layer above...??
How to return erro to client call from strore procedure ?
Thnaks for help
regard
serge...more >>
Upgr asp.net/ado.net connection method from VS 2003 to 2005 Posted by EdwardH at 6/7/2007 7:07:02 AM Am upgrading SQL server access app from 2003 to 2005. Old code works but I
can see safer methods:
My web.config (ASP.Net 1.1)
<configuration>
<appSettings>
<add key="ConnectString" value="Data Source=Vaio1;Initial Catalog=IMA;User
ID=sa;Password="/>
<add key="ImagePath" value="/IMA/Ima...more >>
binding/formatting/parsing grid cell values to a DataTable Posted by EnerPeter at 6/7/2007 3:24:01 AM Hi,
i'm missing my question sent June 7th, so here it is again. I have a DataSet
(ds) a BindingSource (bs) and an [infragistic] grid (gr). When i setup these
three in the following manner: bs.DataSource = ds; bs.DataMember =
"some_table_name"; gr.DataSource = bs; everything works fine - the t...more >>
<newbie> creating typed DataSet, how?? Posted by Jeff at 6/6/2007 8:30:22 PM ADO.NET 2.0
I'm wondering how to create typed DataSet in Visual Studio 2005 (.NET 2.0)??
If you knows about a great article showing this, then please post the link
here!
Jeff
...more >>
Problems setting database field to null Posted by rosiew at 6/6/2007 2:55:25 PM I am having problems setting a field in my database to null. I tried
to follow some online advise on using a DataSet for setting the value
but I am gettting an error and not sure what I am doing wrong.
My table has only one row and no primary key. The "Frequency" field
is numeric and allows nu...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Dataset designer resetting query parameters from Single to Decimal datatype Posted by morleyc NO[at]SPAM gmail.com at 6/6/2007 2:12:12 PM Hi, i have a table with a number of real fields. I believe these
correspond directly to single/float types in C#. I create an insert
query in the dataset designer of Visual Studio 2005, and whilst in the
query builder screen i tried to test the query by hitting Execute
Query button. However, aft...more >>
SqlDataReader IndexOutOfRangeException -- randomly Posted by Kevin at 6/6/2007 1:05:06 PM After upgrading my VB.NET Windows Forms project from VS 2003 to 2005,
I'm noticing random errors with DataReaders on certain users' PCs.
For example, I'll have the select statement:
"Select lRevision From TQuestionnaire Where lQuestionnaireID = " &
Me.QuestionnaireID
Which is passed to a...more >>
best way to represent a regexopitons value Posted by gs at 6/6/2007 8:30:36 AM is it best as int or varbin(4). the database is sql express file. what
about the control binded to the field?
Actually I have a bunch of checkboxes for various regex options and thinking
bout a non editable control controlled by clicks on the checkboxes on the
...more >>
Guide for Connection Pooling of IBM DB2 .NET Data Provider Posted by masakiy at 6/6/2007 2:32:00 AM We are developing application with ASP.NET (Visual Studio 2005) and DB2
version 9.
We suppose that each application cannot have connection pooling sharing,
using IBM DB2 .NET Data provider, because connection pooling should be set up
by defining connection string.
So, I wonder if there is an...more >>
best way to move a possibly null value into object from Db Posted by Smokey Grindle at 6/5/2007 3:30:34 PM I am using .NET 2.0 with this and have loaded a row into a data table... now
I want to move the info in that row into the fields of an object... what is
the best way to do this for fields that I know could be null... right now
say I have it set up like this
Object has fields
Private m_IsNo...more >>
Simple transaction question ???? Posted by calderara at 6/5/2007 6:19:03 AM Dear all,
I am building a multi tiers application.
I have a remote object hosted by a Windows Service which is charge to store
certain data in an SQL databse. Works great.
After this operation I need to dispatch store data to some other tables. for
that opertaion I need database transacti...more >>
Multiple Stored Procedures in CR Posted by daniel_27 at 6/5/2007 1:16:50 AM hi. im just 'new' in .Net and currently using CR in creating reports..i have
a problem in one of my crystal reports. i have 4 stored procedures in my CR..
im using datatable in filling the report. actually, I have no problem when
dealing/populating a report that contain only 1 SP. here is my fun...more >>
Refresh a datatable afer an update so that child foreignkeys will be changed if necessary Posted by at 6/5/2007 12:08:16 AM hello,
my question is about relations and about refreshing datatable after a
update.
i've got 2 tables in a MSSQL database. tblOrder (parent) and
tblOrderProduct (child)
tblOder has a column ID <bigint, primary key, auto increase> and
tblOrderProduct also has a column ID<bigint, primary ke...more >>
Complex Select Posted by Jon Bilbao at 6/4/2007 10:15:32 PM I´m trying a select clause in two steps because it´s too complex.
First:
SELECT Reference, Results.idEnsayo, Results.Num_taladro, min(Results.dTime)
+ 500 AS tIni, max(Results.dTime) - 500 AS tLast
FROM Results INNER JOIN Ensayos ON Results.idEnsayo=Ensayos.idEnsayo
WHERE (Ensayos.Reference...more >>
maxRequestLength error Posted by jonefer at 6/4/2007 2:25:02 PM I have a parameterized query that returns results effectively to a datagrid.
These resultsets are usually between 50-2000 records.
The users have requested the ability to view ALL records which would return
100K or more records and now when I run the query with NO parameters, I can
get the...more >>
SELECT parent with all child rows with Typed Datasets Posted by morleyc NO[at]SPAM gmail.com at 6/4/2007 1:59:25 PM Hi, i have seen some example code which uses a stored parameter that
performs two selects and returns a SafeDataReader, a customer is
retrieved along with all of their orders. The stored procedure is
below:
SELECT CustomerID, CompanyName, ContactName, Country
FROM Customers
WHER...more >>
Error when calling the OleDbDataAdapter.Fill() method Posted by Nathan Sokalski at 6/4/2007 12:46:19 PM I am recieving the following error message when I call the
System.Data.OleDb.OleDbDataAdapter.Fill() method in ASP.NET/VB.NET:
IErrorInfo.GetDescription failed with E_FAIL(0x80004005).
I have looked for help on this error on the web, and every site I found said
it is caused by using a ...more >>
Output parameter Posted by Lubomir at 6/4/2007 10:12:01 AM Hi,
I have a stored procedure with an output parameter.
SqlCommand cmd = new SqlCommnad("ProcName", conn);
cmd.Parameters.Add("@myparam", SqlDbType.Int);
cmd.Parameters[0].Direction = ParameterDirection.Output;
Parameter param is an output parameter, but how can I read the returned value?...more >>
Another modifier for the datagridview column.Format() property? Posted by Earl at 6/3/2007 7:31:04 AM Somewhat of a trivial thing, but I have not seen this either on Google or in
the documentation: Is it possible to apply another modifier to the Format
property of a datagridview column?
I've got some expression columns that calculate decimal values which may end
up like "4.333333333". I'd l...more >>
From Counsole to MessageBox Posted by Allen Maki at 6/3/2007 12:26:58 AM /*
Console::WriteLine() I am trying to use message box instead of
Console::WriteLine() to upgrade my code from just using the console to using
GUI.
In the bottom 2 lines, #1 works, but I have hard time to make # 2 works. Can
anybody give a hand here to make the information to be shown on th...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |