passing parameters with help of stored procedure??

[hemantc87]

i created a function give below and passed a parameter to it.i used a simple query to access the database..is there any way to do it with a stored procedure with parameters instead of a simple query as stored procedure is a better method

public bool isoffsetexist(int offset)
    {
        conn.Open();

        SqlCommand cmd = new SqlCommand("select * from tb_offset where offset= " + offset + "", conn);

        /*SqlCommand cmd = new SqlCommand();
        cmd.Connection = conn;
        cmd.CommandType = CommandType.StoredProcedure;
        cmd.CommandText = "sp_offset1";*/

        SqlDataReader dr = cmd.ExecuteReader();

        int i = 0;
        while (dr.Read())
        {
            i++;
        }
        if (i == 1)
        {
            conn.Close();
            return true;
        }
        else
        {
            conn.Close();
            return false;
        }

[Frinavale]

It looks like you've commented out the code that uses the stored procedure....

Please review the following article that outline how to use a database:
Database tutorial Part 1
Database tutorial Part 2

-Frinny

[hemantc87]

the comments were put there by mistake...dont consider them in the code
thnku frinavale but i still havent got the exact method how to achieve it??

[Frinavale]

Well the code that you have in comments uses the stored procedure....so you're going to want to uncomment that.

To supply parameters to the stored procedure you use the SqlCommand.Para meters.

-Frinny