|
|
|
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 Parent-child + Datagrids Posted by patrickhuffer NO[at]SPAM hotmail.com at 2/7/2004 10:01:42 PM I used the Data Form Wizard in Visual Studio to create a form allowing
the user to edit a simple parent table. The parent and child tables
already have a cascade updates relationship in SQL Server on the
parent table's primary key. I accepted all the defaults in the wizard.
A dataset was generat...more >>
VS.NET Database Projects Posted by Roshawn at 2/7/2004 7:40:05 PM Hi,
I have a question regarding Database Projects. Can you only use this type
of project with a preexisting database or can it be used to create a new
database from scratch? (Forgive me if I'm posting to the wrong newsgroup)
Thanks,
Roshawn
...more >>
How can I get the data form DataView with sorted order? Posted by jennifer at 2/7/2004 7:36:05 PM Hi
I have some problem to get the data from data view
I created one table and sort one column in the dataview
DataTable myTable = new DataTable()
....Create Columns and add Record Values.
DataView myView = new DataView(myTable)
myView.Sort = "Price"
for(int i=0; i<myView.Table.Rows.Count...more >>
Do DataAdapter's dispose close the connection? Posted by poseidon at 2/7/2004 6:34:00 PM I know that DataAdapter opens the connection passed with parameter. However,
when I dispose DataAdapter, it seems its dispose doesn't close that
connection. Is this sensible?
...more >>
INSERT new values into 3 related tables - within grid control Posted by Marina at 2/7/2004 5:16:08 PM How should my CommandText be written to insert new values into 3 related
tables:
TblProject:
ProjectID - autonumber
CompanyID - number (fk)
EngineerID - number (fk)
TblCompany:
CompanyID - autonumber
ProjectID - number (fk)
tblEmployees:
EngineerID - autonumber
ProjectID - number (f...more >>
Help with Microsoft.ApplicationBlocks.Data SPOC Sample Posted by Stuart Shay at 2/7/2004 4:07:13 PM Hello All:
I am trying to retreve the Values from the following SPOC (Works in SQL QA)
And Return the Values into my ASP.NET (VB) Code.
---- SPOC Works -----
CREATE PROCEDURE getLoginCredentials
@Email nvarchar(50)
AS
SELECT UserName,Password FROM Users
WHERE Email = @Email
GO
--...more >>
ExecuteReader Help Posted by Jose Ines Cantu Arrambide at 2/7/2004 1:30:44 PM Hello,
When I do a SqlReader oReader = oCommand.ExecuteReader() the code
jumps to the next line until all the result set is retrieved, and for a
particualar view I have it takes about 40 seconds to do this.
*If I do a "Return all Rows" on the view on the SqlServer Enterprise
Managem...more >>
Connection Pooling with MS .NET provider for Oracle Posted by Chris Block at 2/7/2004 12:26:08 PM Can you do connection pooling with the Microsoft ADO.NET provider for Oracle. if so, how do you set it up. Is it similar to SQL Server where you definne it in the connection string
...more >>
Don't see what you're looking for? Search DevelopmentNow.com.
oleDataAdapter Error on Update (vb) Posted by Rich at 2/7/2004 12:15:00 PM Hello,
I get an error message when I try to update an
oleDBdataAdapter: "Syntax error in Update statement"
Here is what I have:
for this project I am using all data components from the
toolbox (instead of just writing code for them - VB 2002),
an oleDBconnection, oleDBdataAdapter, ...more >>
Generate Dataset does not carry over Default Values from Database Posted by tommy_s NO[at]SPAM msn.com at 2/7/2004 10:08:03 AM I'm working with VS.NET 2003 and SQL Server 2000.
After having created a sqlDataAdapter and a sqlConnection by dragging
a database table from Server Explorer onto the form's design surface,
I then generate a dataset from the sqlDataAdapter...you know, the
standard approach for generating a dat...more >>
Dataset and Cascading keys Posted by matpublic NO[at]SPAM ntlworld.com at 2/7/2004 8:54:43 AM I'm having difficult with these cascading keys, but it maybe I'm too
hopeful as to their capabilities.
Situation;
A typed dataset, containing two complex types which.
TableA, columns (AppID int , Reference string)
TableB, columns (AppID int , Description string)
If within the code I cr...more >>
Inside SqlCommandBuilder Posted by Girish at 2/7/2004 1:40:54 AM
CREATE TABLE [dbo].[person] (
[personid] [int] IDENTITY (1, 1) NOT NULL ,
[callsignid] [int] NOT NULL ,
[password] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[name] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL ,
[genderid] [int] NOT NULL ,
[ageid] ...more >>
SQL Server Applciation roles Posted by Tony at 2/7/2004 1:11:11 AM Has anyone tried to use SQL Server application roles from ADO.NET.
If I call sp_setapprole once per connection, I get a "General Network Error"
on the second connection (first works great). So I figured it is being
maintained after the initial connection has this set by the connection pool,
bu...more >>
|
| home · blog · groups | Questions? Comments? Contact the dn |