Database

clint1982 wrote:

Is there away that after I make insert I will get the ID of the row ?

INSERT ....
SELECT SCOPE_IDENTITY() AS Id

BEGIN TRANSACTION
IF NOT EXISTS (SELECT * FROM SomeTable WHERE SomeColumn = @SomeValue)
BEGIN
    INSERT ....
END
END TRANSACTION

WHERE (CustType = 1 OR CustType = 6)
 AND CustName >= @BNAME AND CustName <= @ENAME

WHERE CustType IN ( 1, 6 )
 AND CustName >= @BNAME AND CustName <= @ENAME

SELECT so.name AS 'Constraint Name', so1.name AS 'Parent Table'
,so2.name AS 'Child Table'
FROM sysobjects so
INNER JOIN sysforeignkeys sf
ON so.id = sf.constid
INNER JOIN sysobjects so1
ON so1.id = sf.rkeyid
INNER JOIN sysobjects so2
ON so2.id = sf.fkeyid
WHERE so1.name = 'MyTableName'

public static string GetRelationshipName( string ParentTable, string ChildTable )
{
    foreach ( System.Data.DataRelation relationship in dataset.Relations)
    {
        if ( relationship.ParentTable.TableName == ParentTable
            && relationship.ChildTable.TableName == ChildTable )
            return relationship.RelationName;
    }
    return string.Empty;
}