Problems with DataGrid

[PIAS]

In my web application i have one page that uses DataGrid component. This DataGrid is connected with database trough a dataSource with common select statemant ( select * from table). I set properties of DG AllowPaging on True and AllowSorting on True.

When i compile program and open this page it shows me data in mentioned DataGrid, paging and sorting doesn't work. It shows paging control and collumn name as link, but when i click on it just refreshes the grid but it doesn't changes the content of the grid.

Can anyone tell me what can be wrong?

Thanks!

PIAS

 

[Guru7777]

Where are you binding the datasource to the datatable? Are you doing it on page load without adding

if (!IsPostBack)
{
}

?

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

TWljcm8kb2Z0J3MgIzEgRmFuIQ==

 

[PIAS]

yes....

so?

 

[Guru7777]

If you are doing it upon page load without it being in the !IsPostBack if statement, the datagrid will re-bind on every post back to its original state.

To do paging, the original binding needs to only happen upon the very first time the page loads.

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

TWljcm8kb2Z0J3MgIzEgRmFuIQ==

 

[PIAS]

But i do use


if (!IsPostBack)
{

}

so why is not working?

 

[Guru7777]

I asked if you were doing it without !IsPostBack and you said yes, hence my confusion.

Can you post your code so that we can examine what might be wrong?

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

TWljcm8kb2Z0J3MgIzEgRmFuIQ==

 

[PIAS]

Sory, my bad...

here is the code:

protected void Page_Load(object sender, EventArgs e)
{
//Put user code to initialize the page here
funkcije.preverisession();
if (!Page.IsPostBack)
{
ViewState["sort"] = 0;
ViewState["sortField"] = "a.Adv_name";
bindDataGrid();
if (Cache["tabelaTip"] == null)
{
bindAdvType();
}
advType.DataTextField = "Type_name";
advType.DataValueField = "Type_id";
advType.DataSource = Cache["tabelaTip"];
advType.DataBind();
lnkDelMedia.Attributes.Add("onClick", "vbscriptreveriMedije '" + lstMediji.ClientID + "'");
lnkDelProduct.Attributes.Add("onClick", "vbscriptreveriIzdelke '" + lstProducts.ClientID + "'");
}
else
{
Int16 vrsta;
vrsta = Convert.ToInt16(Request.Form["vrsta"]);
if (vrsta == 1)
{
fillMedije();
}
else if (vrsta == 2)
{
fillProducts();
}
}
}