| 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 performance tableadapter access update Posted by John at 8/31/2006 9:05:39 PM Hi
I am working with an access database with more than 25000 records
(adresses).
In vb .net i use the tableadapter and it takes a long time to read all the
records (with access it doesnt take much time).
Also when I use the update-query it even takes much more time, more then 8
minutes, to ...more >>
Data binding combo box to a datagrid Posted by John Harcourt at 8/31/2006 6:17:01 PM I have a dataset with two data tables. I created a data relation object to
join the two tables by a common field.
On a Windows form, I set up the data binding to a combo
box for the first table. This is the "master". I set up the data binding for
a datagrid for the second table. This is the ...more >>
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding Posted by scott mcfadden at 8/31/2006 6:08:00 PM We use ADO.NET / SQLProvider against SQL2000 for our web application. We
have started to see more and more of these errors:
Exception Type: System.Data.SqlClient.SqlException
Errors: System.Data.SqlClient.SqlErrorCollection
Class: 10
LineNumber: 0
Message: Timeout expired. The ...more >>
Setting a breakpoint in sql server 2000 stored procedure from VS2005 Posted by Adrian Parker at 8/31/2006 3:23:30 PM Using..
Visual Studio 2005 Team Edition for Software Developers
SQL Server 2000 sp4 (on same machine)
Net.Framework 2.0
Windows XP (up to date with all patches)
Problem..
I'm trying to debug a stored procedure from within visual studio but when I
set a breakpoint and then start the app in ...more >>
Why can't I create a DataGridView whose datasource has > 1 table Posted by Juan Dent at 8/31/2006 11:11:02 AM Hi,
I am working inside the DataSet designer. I have 2 tables related by one
relation and FK. Both tables have been configured to be updatable
(insert,update,delete methods generated).
All this is nice. Yet, I need to display a join of these tables selecting
only certain columns on each ...more >>
AcceptRejectRule - what does it really do? Posted by Juan Dent at 8/31/2006 10:59:02 AM Hi,
How does AcceptRejectRule differ from Update rule and Delete rule?
--
Thanks in advance,
Juan Dent, M.Sc....more >>
NewRow, RowState, and Detached with a CommandBuilder Posted by Andy at 8/31/2006 10:09:22 AM Hi folks,
I'm using the ADO.NET 1.1 framework and have this ADO.NET dataset I
want to use to add and/or update records on the physical SQLServer
table it came from. I am using an ADO.NET commandBuilder to
automatically generate the update and insert SQL commands.
I start with a SQL stateme...more >>
How to refresh datatable from datasource Posted by alfred.sehmueller NO[at]SPAM gmx.de at 8/31/2006 9:43:05 AM Hello,
in a network-winforms-application based on a access database I've got
the following problem:
user A starts software
user B starts software
user A deletes row in db
user B changes data
application of user B makes an update dataadapter.update(datatable).
Now I get an concurrency...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
.NET2.0: Microsoft, you got something very wrong in data validation.. Posted by mcw8 NO[at]SPAM aber.ac.uk at 8/31/2006 5:51:36 AM Even Microsoft's own data-validation walkthrough article
(http://msdn2.microsoft.com/en-us/library/1120xds5.aspx) recommends
attaching a handler to the RowChanging event of the DataTable
The problem is, that when editing a row, the RowChanging is raised
after an attempt to update the row in th...more >>
Data Access Layer and Business Logic Layer in ASP.NET 2.0 Posted by asad at 8/31/2006 12:16:02 AM Hi friends, how ru all,
I have a question about creating Data Access Layer and Business Logic Layer
using ASP.NET 2.0 and VB.NET, which is the best way, and what is that best
and optimized solution for creating DAL and BLL.
Thanks,
...more >>
Sorting Posted by Adrian at 8/31/2006 12:00:00 AM When I sort a number I get a lexicographical sort
1
11
112
1
12
How can I code a sort that will produce
a proper numerical order?
Adrian.
...more >>
UDL in ADO.NET Posted by Anders Eriksson at 8/30/2006 2:23:13 PM Hello!
In ADO the preferred[1] way of specifying the connection string was using
an .UDL file.
What is the preferred way to do this in ADO.NET?
// Anders
--
English is not my first, or second, language
so anything strange, or insulting, is due to
the translation.
Please correct me so...more >>
Help with Output Parameter Statement Posted by Stephen Lynch at 8/30/2006 2:09:14 PM All:
I am running a stored procedure via code but need help with the sytax for
the output parameter as mine is wrong, Sorry, but I am just learning.
Here's my incorrect section, more is listed below:
OleDbParameter parameterContributionID = new
OleDbParameter("@Contributi...more >>
Connecting to Oracle Database. Posted by LineVoltageHalogen at 8/30/2006 11:49:33 AM Greetings All, I am writing a small test app in C# .Net 2.0 that needs
to connect to an Oracle 10g database. I need to use Microsoft's data
provide System.Data.OracleClient to connect to the database and I need
to connect as "SYS." There seems to be no provision for connecting as
"SYSDBA"? Am...more >>
why ever use structs vrs. classes? Posted by Juan Dent at 8/30/2006 10:58:02 AM Hi,
I have a hard time recalling what was the basic rationales for using structs
instead of classes in a C# program. Could anyone point out the reasons?
--
Thanks in advance,
Juan Dent, M.Sc....more >>
ADODB and .Net Posted by rclowser at 8/30/2006 9:27:02 AM I developed a .Net website for Windows 2k3, but the webhosting team doesn't
have a 2k3 environment ready to go. So I want to still push my .Net site, so
I'm attempting to get the site to run on W2k that is already set up. I'm
having a few difficulties on it. Current the site runs fine on 2k3 b...more >>
Closing a connection returned from separate class Posted by Ross at 8/30/2006 4:08:01 AM Hi
I have a solution - just a test one - where there are two projects. One is
a simple windows form with a text box called txtClient & a command button.
The command button eventually calls a SP that has a parameter @ClientName.
The other project is a class library that has a class calle...more >>
Question about SqlCommand.Parameters.Add() method. Posted by pedestrian via DotNetMonster.com at 8/30/2006 12:00:00 AM I'm currently programming an ADO.NET application for SQL server.
I notice that the SqlCommand.Paraterers.Add() method require 4 parameters
which are parameterName, SqlDbType, Size, and SourceCOlumn. The question is
with Size parameter:
What is the corrent Size value for SqlDbType.Int, SqlDbTyp...more >>
Inserting records from a DataSet into a second table Posted by Gordon at 8/29/2006 7:30:02 PM Hi;
This has me confused.
I have a dataset which was populated from one database. Can I insert this
dataset's rows into a different database table using the same dataAdapter
or would I have to create a second adapter?
Isn't a dataTable just an memory resident data table ?
So I am th...more >>
SQL Parser Posted by Joe at 8/29/2006 7:18:28 PM Are there any decent parsers around that can parse SQL? I'm looking for
something that can validate the syntax and also allow access to the columns
and tables from the select and where clauses?
Thanks for any help,
Joe
...more >>
HELP: can't stop using Named Pipes! Posted by Matt C. at 8/29/2006 5:07:27 PM I have deployed a test application (VS 2005) to several workstations.
They need to make a connection to our SQL Server 2000 server. Most work
fine. On one workstation, we keep getting the error:
"An error has occurred while establishing a connection to the server.
When connecting to SQL...more >>
CommittableTransaction leaves open transactions on server? Posted by Patrik Rosquist at 8/29/2006 8:45:02 AM System.Transactions: TransactionScope and CommittableTransactions leave open
transactions on server.
I'm having problems with commited or rolled back transactions leaving open
transactions on the database server.
The problem is on our web site using .Net 2.0, Windows 2003 server, SQL
Serve...more >>
Name change, can't find origin of error Posted by jamesn NO[at]SPAM jslocum.com at 8/29/2006 8:00:39 AM I've recently made a name change on a few database tables. I thought I
got all the name changes done in the front end reference. However,
this one eludes me. I've checked all the classes listed in the error
trace. I've done full text searches across all the documents of the
project and I sti...more >>
DataTable.Select problem in ASP.NET 2.0 Posted by manoj241176 NO[at]SPAM gmail.com at 8/29/2006 5:48:58 AM Hi,
I am having problem with DataTable.Select() method. I am using
ASP.NET 2.0.
I have DataSet which reads data from XML file using DataSet.ReadXML().
Now this
dataset has various datatable, created by XML file. I am taking one of
the datatable
from this dataset and want to filter on that d...more >>
OleDbException: Could not update; currently locked Posted by Luke Neumann at 8/29/2006 2:41:14 AM Hello,
I have a standalone windows application that uses MS Jet 4.0 to read
and write from MS Access database.
Rather randomly, I keep getting this exception:
System.Data.OleDb.OleDbException: Could not update; currently locked.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHan...more >>
What is wrong? Posted by Adrian at 8/29/2006 12:00:00 AM In the line marked *** "one" etc are not allowed.
Please tell me why and what I should do to make this code work.
Many thanks.
Adrian.
try
{
while (carry_on == true)
{
string one = binR.ReadString();
string two = binR.ReadString();
string three = binR.ReadString()...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |