viewing the items in grid view 

----------------------------------------

creating procedure

create proc sp_stockinview
as
select sno as SNO ,itemdesc as ITEM_DESCRIPTION,units as UNITS,ucost as UNIT_COST,total as TOTAL
from stockin

excuting procedure:

-----------------
exec sp_stockinview

appcode  Method

..............................
 public void viewStockin()
    {
        con.Open();
        cmd = new SqlCommand("sp_stockinview",con);
        cmd.CommandType = CommandType.StoredProcedure;
        dr=cmd.ExecuteReader();              
    } ...............................................

button click

protected void btn_viewadditems_Click(object sender, EventArgs e)
    {


        obj.viewStockin();
        GridView1.DataSource = obj.dr;
        GridView1.DataBind();
        obj.con.Close();
    }