HELP! problem with DataGrid sorting - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

HELP! problem with DataGrid sorting

dan1015dan1015 Posts: 1Member
I have done whatevery I can think of but it still doesn't work....please help me

void my_SortCommand(Object sender, DataGridSortCommandEventArgs e){
BindDataGrid(e.SortExpression);
}


void BindDataGrid( string strSortField )
{
con = new SqlConnection( @"Server=Rabbit;Integrated Security=SSPI;database=pubs" );

query = "Select * from organizations order by city";

SqlDataAdapter myCommand = new SqlDataAdapter(query, con);

DataSet ds = new DataSet();
myCommand.Fill(ds, "organizations");

DataView Source = ds.Tables["organizations"].DefaultView;
Source.Sort = strSortField;

companyInfo.DataSource=Source;
companyInfo.DataBind();

}






Anything wrong?

Comments

  • FlakesFlakes Posts: 642Member
    : I have done whatevery I can think of but it still doesn't work....please help me
    :
    : void my_SortCommand(Object sender, DataGridSortCommandEventArgs e){
    : BindDataGrid(e.SortExpression);
    : }
    :
    :
    : void BindDataGrid( string strSortField )
    : {
    : con = new SqlConnection( @"Server=Rabbit;Integrated Security=SSPI;database=pubs" );
    :
    : query = "Select * from organizations order by city";
    :
    : SqlDataAdapter myCommand = new SqlDataAdapter(query, con);
    :
    : DataSet ds = new DataSet();
    : myCommand.Fill(ds, "organizations");
    :
    : DataView Source = ds.Tables["organizations"].DefaultView;
    : Source.Sort = strSortField;
    :
    : companyInfo.DataSource=Source;
    : companyInfo.DataBind();
    :
    : }
    :
    :
    :
    :
    :
    :
    : Anything wrong?
    :
    :

    I am not much in DotNEt, but:
    Shouldnt this line:

    query = "Select * from organizations order by city";


    Be:

    query = "Select * from organizations order by "+strSortField;

    ??


Sign In or Register to comment.