|
|
|
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 31 virtual connection string? Posted by Martin Williams at 12/15/2003 11:55:43 PM How do you create a virtual connection string, so that the application will
always look in the local folder where it's stored? This is for vb.net.
Thanks for all replies.
Regards,
Martin Williams
...more >>
NEWBIE: Data Grid Formatting Posted by Alexander Fowler at 12/15/2003 9:01:50 PM Hello and thanks for taking a minute. I am just getting into ado.net and
still at the "experiment with wizard generated code" phase of self-teaching,
so please bear with any stupid mistakes.
I am trying to write a simple contact manager with an interface similar to
Act's opening contact screen...more >>
Adding information to a dropdownlist from a dataset Posted by Lennie at 12/15/2003 7:25:37 PM Hello.
i have tree dropdownlist that i want to add some information from a databas.
The sql questions is like this for the tree dropdownlist´s
SELECT distinct eventuser
FROM syslog..tblsecurityEvents
where eventuser like 'PHONERA%' and eventuser not like '%$'
SELECT distinct eventuser
...more >>
Concurrency via SqlCommand.ExecuteNonQuery Posted by anonymous NO[at]SPAM discussions.microsoft.com at 12/15/2003 6:36:44 PM When using a SqlDataAdapter generated Update StoredProc,
the DataAdapter.UpdateCommend (correctly) returns a
DBConcurrency error.
Using the same stored proc, instead of using the
dataAdapter, I create a SqlCommand object and add all of
the required parameters filled with the appropriate
...more >>
SqlConnection in WinApp Posted by Marco Liedekerken at 12/15/2003 4:26:09 PM Hi,
Are there some "Good practices" in how to use a SqlConnection object in a
windows application?
Because I always use the same DB I don't want to give the SqlConnection
object as a parameter to all of my methods who use the SqlConnection. I want
it to be like a global variable to my whole a...more >>
SQL Connections Posted by Laurent D. at 12/15/2003 3:53:51 PM Hi
After using a sql database, I want to detach it .
But some connection are still openned from the application.
My question:
How can I stop those connections ?
...more >>
Programming Excel Effiviently - HELP! Posted by ibeetb at 12/15/2003 3:21:21 PM My head is exploding with the 500 different ways shown on Microsoft's site
to program Excel (Office)
Can anyone offer the best solution to the following:
I want to program a couple of Excel reports for both Mac Users and PC users
and have them access from a web site. These users not only have di...more >>
Sorting an XML file Posted by Leszek at 12/15/2003 3:09:55 PM Hello,
I need to sort an XML file and then display the result in a drop-down list
on an ASP.NET WebForm.
What should I use? DataSet, DataReader, something else? Right now I have the
following code:
DataSet ds = new DataSet();
ds.ReadXml(Server.MapPath("categories.xml"), XmlReadMode.InferS...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
time entry in date field in ado .net, problem Posted by ray well at 12/15/2003 1:28:37 PM i have an access 2000 database, in which i log incoming calls by their date
and time, so they can be retreived according to the order they were called
in.
in the date-time field, i can store a date-time by typing "1/1/2002 1:13:00
PM" directly into the table when i open it in Access. if i then...more >>
Select based on multiple child records (SQL) Posted by Chris Perry at 12/15/2003 1:09:56 PM Hello all,
I want to select certain child records from a table based on the values of
other unrelated child records.
For the select Im using three tables from a Questionnaire database.
Respondant, Response, and txtOption.
Each respondant, has multiple responses and each response can...more >>
Non fatal SP error causes ADO recordset to be nulled? Posted by TJ Stirn at 12/15/2003 11:56:13 AM Greetings,
Here is the problem:
We have a stored procedure that selects a set of
candidate rows. It then attempts to lock the candidate
rows via inserts into a lock table. If a row is already
locked we handle the pk insert error within the stored
procedure and remove the candidate from...more >>
DataTable.Clear() throws System.ArgumentOutOfRangeException Posted by TALDeveloper at 12/15/2003 11:31:07 AM Clearing a datatable of all data, I would think be a simple task. Does anyone have an idea why the DataTable.Clear() method could throw a System.ArgumentOutOfRangeException. Also, this problem doesn't seem to be consistent or 100% reproducable. Perhaps it depends on the data in the table. Any su...more >>
Inserting a new row in merged dataSets Posted by deshimam NO[at]SPAM yahoo.com at 12/15/2003 10:48:02 AM Has anybody come across this?
I have a dataset with records of items and depending on itemID, I get
price of each item from another table. I am merging two datasets with
the primaryKey constraint. I have read all articles on this group to
see how to insert a new row in the item and then add a...more >>
sproc DataTable question Posted by neverstill at 12/15/2003 10:37:55 AM Hi-
I was just preparing to use some of the Stored Procedures that I've been
working on for my asp.net application.
it appears that you can't get a DataTable or DataSet back from
SqlCommand.Execute(). Why? I can get a DataReader, but I don't want to
have the connection still open.
How ...more >>
newby question about connection strings Posted by mkiger at 12/15/2003 9:41:20 AM Hi
Here is a sample connection string from one of my study guides
"data source=bean; initial catalog=Northwind;integrated security=SSPI; persist security info=false
What exactly does the 'SSPI' mean? I can't seem to find out anywhere...more >>
Timestamp Datatype issues Posted by IntraRELY at 12/15/2003 9:38:11 AM I am having difficulties with a SQL 2000 TimeStamp column and my vb.net
application. I am getting various Cast errors. It isnt clear to me what
datatype to use when assigning the TimeStamp return value to a variable.
Here is my code when recieving the return value from a stored procedure. I
d...more >>
Reading data from Oracle with Microsoft Managed Data Provider For Oracle Posted by Andrei at 12/15/2003 8:51:07 AM Hi all!
I have a strange problem with reading the data from Oracle 8.1.7 sever with Oracle 9.2.0.1 client using Microsoft Managed Data Provider For Oracle ver. 1.0, build 1.0.3300.0 (I'm using Framework 1.0). Furthermore I have experienced that problem on Win2003 Enterprise station but not on Win...more >>
Windows Form and Datagrid style functionality regarding adding new rows Posted by Mike Quernemoen at 12/15/2003 8:50:04 AM Hello,
I've got a form with fields bound to a datatable in a dataset. I'm using
the bindingcontext.position to determine which record in the datatable is
displayed.
To display the next record in the table I have a button click event perform
the following.
form1.bindincontext(dataset,datatab...more >>
Exception when closing SqlClient connection in a distributed transaction Posted by smo_news NO[at]SPAM hotmail.com at 12/15/2003 6:12:59 AM I am using distributed transactions without using COM+. My code works
with OracleClient and our home grown ODBC wrapper, but not with
SqlClient. I get a type cast exception when closing a SqlClient
Connection that participates in a distributed transaction:
Exception: System.Reflection.TargetIn...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |