c # call stored procedure !!! help !!!

ddddd_00

Brothers help! Find a stored procedure and call the stored procedure (distribution function) code!
The function simultaneously receives the DataSet returned by the stored procedure and the number of records selected!

sunray

public DataSet filmdetails (int id)
{
SqlCommand Command = new SqlCommand (connection);
SqlParameter filmID = new SqlParameter ("@ MovieID", SqlDbType.Int);
filmID.Value = id;
Command.Parameters.Add (filmID);
Command.CommandText = "select_FilmDetails";
Command.CommandType = CommandType.StoredProcedure;
DataSet ds = new DataSet ();
DataAdapter da = ...;
.............................
da.fill (ds);
return ds;
}

Setting up stored procedures lies in these two sentences
Command.CommandText = "select_FilmDetails"; // The name of the stored procedure
Command.CommandType = CommandType.StoredProcedure; // Description command is a stored procedure in sqlserver
// Add parameters
SqlParameter filmID = new SqlParameter ("@ MovieID", SqlDbType.Int);
filmID.Value = id;
Command.Parameters.Add (filmID);

As for returning select records, you can set a read-only public property in the class
private int count
public int countRow
{
   get
{
   return count;
}
}

Use a function to get a DataSet to access records using only the attribute. You can also use the ref modifier. However, general object operations can still use method and property members. Simplicity is better

ddddd_00

The kind brother above! Can it be more complete? My dish! !! I beg you! !! !! !! !!

stone86

Use SQLHelper, it is quite easy to use.

神在咆哮

// you do this
public DataSet filmdetails (int id)
{
SqlCommand Command = new SqlCommand ("select_FilmDetails", connection);
Command.CommandType = CommandType.StoredProcedure;
SqlParameter filmID = new SqlParameter ("@ MovieID", SqlDbType.Int);
filmID.Value = id;
Command.Parameters.Add (filmID);
DataAdapter da = new DataAdapter (Command);
DataSet ds = new DataSet ();
da.fill (ds);
return ds;
}

ddddd_00

ALTER PROCEDURE [dbo]. [PageList]
(
    @PageSize int,-records per page
    @PageIndex int,-the current number of pages, starting at 1
    @Condition varchar (8000),-query conditions, including and, where, must have a condition such as where 2> 1
    @TheTable varchar (8000), --table name
    @SelectField varchar (8000),-the field to be selected
    @OrderBy varchar (8000), --OrderBy, including order
    @TableID varchar (8000) --table primary key
)
AS
begin
declare @Sql varchar (8000)
 
--Return record
set @ Sql = 'select top' + cast (@PageSize as varchar (10)) + '' + @SelectField + 'from' + @TheTable + '' + @Condition + 'and'
    + @TableID + 'not in (select top' + cast ((@ PageSize * (@ PageIndex-1)) as varchar (10)) + '' + @ TableID + 'from' + @TheTable + '' + @Condition
    + '' + @OrderBy + ')' + @OrderBy
exec (@sql)
 
--- return total
set @ Sql = 'select count (' + @TableID + ') from' + @TheTable + '' + @Condition
exec (@sql)
end
How to call such a stored procedure with C #! Return both recordsets and totals? Online etc