| 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 Day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 Extreme performance issues (SQL Server 2000/ADO.NET/C#) Posted by Jon Rista at 9/13/2004 7:50:04 PM I'm using ADO.NET in a windows service application to perform a process on
SQL Server 2000. This process runs very quickly if run through Query
Analyser or Enterprise Manager, but takes an excessively long time when run
through my application. To be more precise, executing stored procedures and
...more >>
how to get database list? Posted by Lloyd Dupont at 9/13/2004 5:05:02 PM I have some connection problem and wonder if I do everything correctly.
I'm trying:
I created a SqlConnection with the ConnectionString:
Address=myIp,myPort;User ID=sa;Pwd=password
and with this connection i "PLAN" to run sp_databases stored procedures.
However when I open the connection I ...more >>
Extended Properties Not Showing Up Posted by localhost at 9/13/2004 4:50:24 PM
I have created a table in MSSQL2K and added an Extended Property to
it.
I want the Extended Property to show up in the result DataSet. What
should I change to make this happen?
TSQL:
Create Table dbo.ZTestTable (
"ZTestTable_Id" int not null, "Col-1" varchar(184) null,
"Col-2"...more >>
db grid Posted by Paps at 9/13/2004 4:47:12 PM Hi all,
I have populated my grid from a dataSet.
1) I want to enter certain values and in Caps in my second col. Like I want
to enter only 'PAT' or 'SAT'. is this possible.
2) When my Grid populatyes the fourth col is not fully visible. I will have
to increase the width each time whe...more >>
Make it stop! Posted by Carter at 9/13/2004 3:48:12 PM How do you make visual studio stop rearranging my stuff? I indent my html
pages the way I want, and then it throws everything all haphazard. I have
turned off tabs, and the grid layout, turned off word wrap and everything I
can think of, and it still insists on moving everything around.
...more >>
Oracle Data Provider for .NET (ODP.NET) Posted by Ollie at 9/13/2004 2:49:56 PM I have an Oracle 8i database that I have to access via .Net (C#) So is there
a ODP.Net provider for Oracle 8i or can I use Oracle 9i Release 2 Data
Provider for .NET 9.2.0.4.0 to access the database?
I have d\l the above .net provider and installed it and it is throwing the
well known error wh...more >>
Problems with simultaneous connection to Access DB Posted by Strange Cat at 9/13/2004 2:38:39 PM Hello everyone!
I have some apps (aspnet and windowsforms) that need to connect at the same
time to an access db.
It used to work fine before I installed the framework 1.1 service pack 1.
Now the problem is that the connection is opened by one of the two
applications, but sometimes I get on...more >>
OracleClient and pls-00306 error message Posted by Darren Guy at 9/13/2004 2:36:41 PM I am getting the following error message when trying to execute an oracle
stored procedure with in and out parameters only.
ora-06550 line 1, column 7:
pls-00306 wrong number or types of aurguments in call to 'GETUSERDETAILS'
pl/sql statement ignored.
The code for the sp is a follows:
cr...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Autonumber Primary key value Posted by Nathan Carroll at 9/13/2004 2:04:06 PM Attempting to implment solution to for autonumber primary key for Access DB.
As seen below I call the add record procedure to add new record to the
table. Then I update the changes (RowState.Added) to the database. This
causes the Dataadapter update event: to fire which returns the TimeID from
...more >>
Using a dataset's rowstate functionality in .net Posted by GrantMagic at 9/13/2004 1:44:25 PM I tend to use the SqlDataAdapter class in WinForms projects because once the
inital data is loaded any modifications can be easily added/updated through
a call to the Update() method. I've found in aspnet that the same thing is
possible but because of the stateless nature of the web in order to ...more >>
DataAdapter.Update??? Posted by Darryn Ross at 9/13/2004 10:45:13 AM Hi,
I am getting the following error when calling the Adapters update method
after i have done some deletions from my dataset through a datagrid.
"Delete row information cannot be accessed through the row."
Can anyone please tell me what i am doing wrong?
Regards
Darryn
...more >>
db2 connection problem Posted by bill yeager at 9/13/2004 9:52:18 AM I am having a problem when trying to add a DB2 data
connection using the IBM DB2 provider for a backend AS400
system.
On the "Add DB2 DataConnection" window, I'm entering the
following:
- I'm entering the IP address of the server
- I just put in any alias name
- I put the "UserName" and "P...more >>
Let the adapter handle the connection? Posted by jhcorey NO[at]SPAM yahoo.com at 9/13/2004 6:57:53 AM I inherited some code that looks like this:
mConnection = New OdbcConnection(GetConnectionString())
mConnection.Open()
mAdapter.SelectCommand.Connection = mConnection
'Can execute reader or execute nonquery
mAdapter.Fill(mDataS...more >>
newbie question Posted by aerts_frederik NO[at]SPAM hotmail.com at 9/13/2004 6:50:59 AM Hi all,
I've been working a little with data binding in ASP.NET, but know I
have to make a console application using C#. The way of filling a
DataGrid seems a bit different. I can't see a DataBind() method for
the DataGrid object. What I have is the following code:
/ * start code snippet */...more >>
Weird SqlDataReader: Invalid attempt to read when no data is present. Posted by DotNet Ed at 9/13/2004 2:17:43 AM I'm having a strange problem with the SqlDataReader and it is as follows.
First of all I have a stored procedure called sr_companies, it searches a
table for entries matching the given criteria. When I execute the stored
procedure using the Query Analyser (exec sr_company @Type=40) I get a list
...more >>
Manipulating DataSets through XML Posted by Val at 9/13/2004 12:05:56 AM Hi all,
Im trying to make a lil database server, it communicates with clients
through tcp connections.
Its pretty cool so far, but manipulating with the DataSet is messy:
There is a function which loads xml data (and schema) into the dataset but
whats the way to delete records from a dataset ...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |