| 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 Inserting rows into a Datatable fires two actions: Add and Change Posted by Roger Tranchez at 5/28/2007 9:48:01 AM Hello,
When I insert a new row into a datatable, the following event fires:
RowChanged, with the action DataRowAction.Add
So, within the sub that handles this event I call another sub to update the
datatable with its sqldataadapter (the update command only affects one
database table)
...more >>
Datareader to Datatable gets stuck... Posted by jonefer at 5/28/2007 2:04:00 AM The following Function used to return a DataSet.
After much reading regarding being able to use sorting within the table of
a gridview, I rewrote my function so that it returns a datatable.
All compiles well, but it always times out at the
'Dim reader As SqlDataReader = cmd.ExecuteRe...more >>
Results to textbox Posted by backwards15 NO[at]SPAM gmail.com at 5/27/2007 8:41:17 PM Hi all,
Just having a bit of trouble in returning the results of the SQL
SELECT statement to a textbox
This is only to return one row and i'm not sure how to get it to
display in the text box.
here is my code so far
Private Sub Btn_find_Click(ByVal sender As System.Object, ByVal e
...more >>
Failed to enable constraints Posted by robert.ferkel NO[at]SPAM enterprise-computer.com at 5/27/2007 11:13:00 AM Whenever I make a change to the definition of one of my SQL2000 tables
(just a length for instance) I have to run the data source
configuration wizard to remove the table and then rerun to add the
table back.
This of course always fixes the 'Failed to enable constraints' issue.
Is this the ...more >>
Connection pooling isn't happening? Posted by Russ at 5/27/2007 6:59:57 AM Hi there,
I've got a website that I'm trying to test using the MS Web
Application Stress tool, but performance seems to be really poor
(about 6 requests/second). I've done some testing, and it seems that
as soon as I drop any database requirement into the application,
performance instantly d...more >>
Dataview with calculate colums. Posted by Nilkanth Desai at 5/26/2007 5:40:00 AM Hi,
I am using a dataset with a table which contains following colums.
ccode barcode pcs weight
1 1 12 200
1 1 2 120
1 2 4 32
On above table I want to build a dataview which sums cols of PCs ...more >>
Finding the Text value of a column... Posted by cc_crash at 5/25/2007 10:31:02 AM Hello all, I creating a Temp DataSet and Adapter, populating it and then
doing an Insert to move data from this table back into the orginial table I
copied it from but with a new DATE. I have it all working fine so far but
when I get to trying to list the value of one of my columns (the most
...more >>
Connection string error Asynchronous Processing=true Posted by staffan at 5/25/2007 12:00:00 AM Hi
Maybe I have missed something easy but I cant get Async = true fo function,
I am getting the: "An error has occurred while establishing a connection to
the server. When connecting to SQL Server 2005, this failure may be caused
by the fact that under the default settings SQL Server does ...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Timeout Posted by Lubomir at 5/24/2007 11:59:00 AM Hi,
My application sometimes conenct to database without any problems, sometimes
the next day I get frequently exception saying about timeout.
My connection string is:
Data Source=.\sqlexpress; Initial Catalog=MyMdfFile;Integrated
Security=True;Pooling=true;
1/
I think with this conen...more >>
Access FilterExpression problem Posted by Scott Starker at 5/24/2007 11:44:55 AM I am using MS Visual Web Developer 2005 Express Edition, MS Access DB, XP
Pro and IIS 5.1 on my local XP Pro.
What I want to know is how to set the FilterExpression which the parameter
is an integer (not ControlParameter). Right now I have:
AccessDataSource1.FilterParameters.Clear()
Dim p...more >>
Copy records, change date, save new... Posted by cc_crash at 5/24/2007 8:40:03 AM I am working with VB.Net 2005 going to an Access 2003 database.
I want to give my user the ability to copy a list of Orders (based on MR #
and PreviousVisitDate) to a new VisitDate when they are creating one. I have
everything ready but I am stuck on how to construct an SQL statement to do
...more >>
Carriage Return in DataColumn.Expression Posted by JT at 5/23/2007 10:27:01 PM Hi all,
When concatenating strings in a datacolumn.expression for a computed
datacolumn, is there a special character I can insert to specify that I want
a carriage return (Environment.NewLine) between two of the strings?
Thank you.
--
John...more >>
Non traditional database connections and datasets Posted by Mike Mike at 5/23/2007 12:36:02 PM I have an old COM Object that contains a link to a preparatory database. We
are using VS2005 VB.NET and are looking for ideas to work with it using the
new ADO data methods.
For example, our COM Object contains methods like, FirstRecord, NextRecord,
PriorRecord, etc. This COM object also c...more >>
Access 2007 Connection String Posted by Alex Maghen at 5/23/2007 8:06:01 AM Hi. I've been using Access 2003 (.mdb files) from ADO.NET for a while now.
I'd like to start connecting to the new .accdb files instead.
I've tried using the same connection string but changing the file name to
end with .ACCDB. It looks like:
ConnString = "Provider=Microsoft.Jet.OLEDB.4.0;...more >>
problem in using autosproc !!! Posted by Nuzi at 5/23/2007 3:08:44 AM i m using autosproc, which uses reflection to dynamically gernerate
wrapper classes.
i m getting exception when i m going to create instance of that class
which implements the interface(it is dynamically generated class)
"
sprocFactory.CreateInstance(typeof(interfaceName),DBprovider.sqlserver...more >>
unique string column on DataTable ? Posted by Richard Chandler at 5/23/2007 1:59:00 AM Hi All,
I'm trying to make the following code not throw an exception ... (C#, .Net
2.0)
System.Data.DataTable tab = new System.Data.DataTable();
System.Data.DataColumn col = new System.Data.DataColumn("one",
typeof( System.Data.SqlTypes.SqlString ) ) ;
...more >>
viewing datatble data in the watch window Posted by Jerry J at 5/22/2007 1:11:00 PM
Is it possible to view the data contained within a datatable in the watch
window?
I have been finding it quite inconvenient that I haven't been able too.
--
Jerry J...more >>
Add table prefix programmatically Posted by Lupus at 5/22/2007 8:09:22 AM Hi!
I'm working on a webapplication which uses some SQL tables. In some
cases, we need to install different versions in one database. That's
why we add prefixes to all tables (iee. cl1_users and cl2_users).
At the moment we add %PRE% in the querystring. The DAL performs a
simple replace() t...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |