Jul 13, 2010

how to get data in form dataset in asp.net using stored procedure

public DataSet getAlltheaters()
    {
        ds.Clear();
        con.Open();

        SqlCommand cmd = new SqlCommand("dbo.spgetAlltheaters", con);
        cmd.CommandType = CommandType.StoredProcedure;
        da = new SqlDataAdapter(cmd);
        da.Fill(ds, "Payments");
        con.Close();
        return ds;
    }

No comments:

Post a Comment