Database

mhh112 wrote:

Exception Details: System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.

Johnkokk wrote:

i always get a date format like 17/2/2010 0:00:00 in the datagridview, obiously because this is the format of the access database which is databound to the grid.

I are Troll

dgv.Columns[1].DefaultCellStyle.Format="dd MMM yyyy";

Creamboy wrote:

However, i need to disallow the same name inputed again.

 ALTER TABLE [MyTable]
   ADD CONSTRAINT [UniqueConstraintName] 
UNIQUE (ColumnValue)

I are Troll

select * from [database].[owner].[tablename]

select * from nortwind.dbo.customers

select * from northwind..customers

order by id ,refParent,description

2	156		GunningM      	        0

Create table [#Nodes]
(id int IDENTITY(0,1),
 NodeID int,
 parent int,
 [Description] varchar(128),
 refParent int
)

INSERT INTO #Nodes
   (NodeID, Parent, [Description])
select distinct n.ID NodeID, n.Parent, nTyp.Descr [Description]
from tbl_node n
inner join tbl_node_type nTyp on nTyp.ID = n.Type and nTyp.Descr in ('Compulsory','One of')
where n.curr = 10 
union
select distinct n.ID NodeID, n.Parent, m.Descr [Description] --, n.Type, n.Curr, m.Descr 
from tbl_node n
inner join tbl_node_type nTyp on nTyp.ID = n.Type and nTyp.Descr = 'Subject'
inner join tbl_modl m on m.id = n.modl
where n.curr =10 

ID  NODEID	PARENT                DESCRIPTION		REFPARENT
=========================================================================
0	149		NULL      	Compulsory		NULL
1	155		149	        One of			NULL
2	156		149		GunningM		NULL
3	157		155		JonesJ			NULL
4	158		149		One of			NULL
5	159		158		D1127			NULL

select distinct  nP.id as [id], nP.NodeID, nP.parent, nP.Description, nRef.ID refParent 
into #nodes2 from #Nodes nP
left outer join #Nodes nRef on nP.Parent = nRef.NodeID	-- look up the reference id of the parent
order by  refParent,nP.Description

ID     NODEID	       PARENT         DESCRIPTION	    REFPARENT
============================================================================
0	149		NULL	       Compulsory	      NULL
2	156		149		GunningM		0
1	155		149		One of			0
4	158		149		One of			0
3	157		155		JonesJ			1
5	159		158		D1127			4

select id as [id2],NodeID,parent,Description,refParent  
 from #nodes2
order by  nodeid,parent, refParent 

SELECT *
FROM nodes2
CONNECT BY PRIOR Id = RefParent
START WITH RefParent IS NULL
ORDER SIBLINGS BY Id

WITH records AS
(
    SELECT
        Id,
        RefParent,
        CONVERT(VARCHAR(MAX), ROW_NUMBER() OVER (ORDER BY Id)) AS thePath
    FROM  nodes2
    WHERE RefParent IS NULL
        UNION ALL
    SELECT
        n.Id,
        n.RefParent,
        r.thePath + '.' + CONVERT(VARCHAR(MAX), ROW_NUMBER() OVER (ORDER BY n.Id)) AS thePath
    FROM records r
    JOIN nodes2 n ON n.RefParent = r.Id
)
SELECT *
FROM records
ORDER BY 
    thePath