datagrid paging

[srinivassam]

hi all, In my application iam using datagrid ,in that i want to do navigation but my code is not reflecting .and also i want to edit the row , how to do this in properties iam using allow paging=true;

private void DataGrid1_PageIndexChanged(object source,System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
DataGrid1.CurrentPageIndex =e.NewPageIndex ;
//DataGrid1.CurrentPageIndex = e.NewPageIndex;
String connection = "uid=sa; password=sa123; database=usermanagement; server=c113";

        SqlConnection con= new SqlConnection (connection);
        //SqlCommand cmd=new SqlCommand ("select \* from tbl\_user\_management
        SqlDataAdapter da=new SqlDataAdapter ("select \* from tbl\_user\_management",con);
        con.Open ();
        DataSet ds=new DataSet ();
        da .Fill (ds ,"tbl\_user\_management");
        DataGrid1 .DataSource =ds.Tables\[0\];// ("tbl\_user\_management");
        DataGrid1 .DataBind ();            
        con.Close ();

    }

srinivas

srinivas