Grid View BoundColumn DataField

 create table [user](Created_Date datetime,Username varchar(50),Status varchar(20))

insert into [user] values(getdate(),'swapnil','smart boy')

insert into [user] values(getdate(),'swapnil','smart boy')

insert into [user] values(getdate(),'swapnil','smart boy')

insert into [user] values(getdate(),'swapnil','smart boy')

insert into [user] values(getdate(),'swapnil','smart boy')

create procedure gridbound

as

Begin

select * from [user]

End

-----------------------aspx page----------------------------

<form id="form1" runat="server">

<asp:DataGrid ID="grdStatusHistory" runat="server" AutoGenerateColumns="False" Height="33px" Width="277px">

<Columns>

<asp:BoundColumn DataField="Created_Date" HeaderText="Date">

</asp:BoundColumn>

<asp:BoundColumn DataField="Username" HeaderText="User">

</asp:BoundColumn>

<asp:BoundColumn DataField="Status" HeaderText="Action">

</asp:BoundColumn>

</Columns>

</asp:DataGrid>

</form>

------------------aspx.cs page----------------------------------

protected void Page_Load(object sender, EventArgs e)

{

BindGrid();

}

public void BindGrid()

{

cls_PMPtables obj = new cls_PMPtables();

DataSet ds = new DataSet();

ds = obj.gridbind();

grdStatusHistory.DataSource = ds.Tables[0];

grdStatusHistory.DataBind();

}

--------------- cls_PMPtables .cs class file----------------------

-------Globally define connection cls_PMPtables .cs page

public SqlConnection sqlconn = new SqlConnection(ConfigurationManager.AppSettings["statecity"]);

SqlCommand cmd = new SqlCommand();

public DataSet gridbind()

{

DataSet ds = new DataSet();

try

{

sqlconn.Open();

SqlCommand cmd = new SqlCommand();

cmd.CommandText = "gridbound";

cmd.CommandType = CommandType.StoredProcedure;

cmd.Connection = sqlconn;

SqlDataAdapter sqlda = new SqlDataAdapter();

sqlda.SelectCommand = cmd;

sqlda.Fill(ds);

}

catch (Exception ex)

{

throw new Exception(ex.Message);

}

finally

{

sqlconn.Close();

}

return ds;

}

------------------------web.config file----------------------------------------------

<appSettings>

<add key="statecity" value="Data Source=TECH-SWAPNILM\SQLEXPRESS; Initial Catalog=master; Integrated Security=true" />

</appSettings>