Database

devboycpp wrote:

In two of my pages I have 6 roundtrips to sql server.In the other 3.Lets say in the worst case average of 3 roundtrips per page.All queries are simple queries that return records with few fields.and number of records are not more than 30.
Can problem be from my side ???? Is it that hard ?

SELECT AccountTypes.ATypeID, AccountTypes.AType, Accounts.OpDr +<br />
  SUM([Transaction].Debit) AS TDr, Accounts.OpCr +<br />
  SUM([Transaction].Credit) AS TCr<br />
FROM Accounts<br />
LEFT OUTER JOIN [Transaction]<br />
 ON Accounts.ATypeID = [Transaction].ATypeID<br />
 AND Accounts.AC = [Transaction].AC <br />
INNER JOIN AccountTypes<br />
 ON Accounts.ATypeID = AccountTypes.ATypeID<br />
GROUP BY Accounts.OpDr, Accounts.OpCr, AccountTypes.AType, AccountTypes.ATypeID

swgzj wrote:

where can find A ADOConnection CLASS

Ed.Poore wrote:

A parameter by the name of 'Id' does exist in the command's parameters (C# side of things)

ALTER PROCEDURE dbo.UpdateAssembler (@Id int, @Name char(20), @IsActive bit, @Stamp timestamp) AS
BEGIN
    IF EXISTS(SELECT * FROM Assembler WHERE ID = @Id)
        /* Check the TimeStamp */
        IF EXISTS(SELECT * FROM Assembler WHERE (ID = @Id AND Stamp = @Stamp))
            UPDATE Assembler
                SET Name = @Name,
                    IsActive = @IsActive
                WHERE ID = @Id
        ELSE
            RAISERROR('Different TimeStamps',10,1)
    ELSE
        INSERT INTO Assembler
            (Name, IsActive)
            VALUES (@Name, @IsActive)
END

// Build the Command
SqlCommand command = new SqlCommand("UpdateAssembler");
command.CommandType = CommandType.StoredProcedure;

command.Parameters.Add("Id", SqlDbType.Int);
command.Parameters.Add("Stamp", SqlDbType.Timestamp);
command.Parameters["Id"].IsNullable = true;
command.Parameters["Stamp"].IsNullable = true;

updateCommand.Parameters["Id"].Value = item.Id;			// an int? object
updateCommand.Parameters["Stamp"].Value = item.TimeStamp;	// byte[]
updateCommand.ExecuteNonQuery();

Ed.Poore wrote:

command.Parameters.Add("Id", SqlDbType.Int);
command.Parameters.Add("Stamp", SqlDbType.Timestamp);
command.Parameters["Id"].IsNullable = true;
command.Parameters["Stamp"].IsNullable = true;

rehan_cop wrote:

how to fill null data in textbox or other form controls in VB.Net

rehan_cop wrote:

I found error in dataset on runtime the application