Sorting Data

[rameshonweb]

Below is the code iam using to sort the data when i click the button links.
The problem is every time I click the button link, the code is connecting to database and sorting.How can I modify the code below so that everytime I click it should not connect to database and at the same time sort.

 public void ID_click(object s, EventArgs e)
    {
 
        Sort("XX " + state);
    }
 
 
 
    public void NM_Click(object s, EventArgs e)
    {
        Sort("XX " + state);
    }
 
 
public void Sort(string strSort)
    {
      OracleConnection conn = new OracleConnection(GetConnectionString());
 
      OracleCommand cmd = new OracleCommand("Stored Proc", conn);
      cmd.CommandType = CommandType.StoredProcedure;
      cmd.Parameters.Add("Number", OracleType.Char, 7).Value = "1234";
      cmd.Parameters.Add("cursor", OracleType.Cursor).Direction = ParameterDirection.Output;
 
      OracleDataAdapter da = new OracleDataAdapter(cmd);
      DataSet ds = new DataSet();
      DataView objDV = new DataView();
      DataTable objDT = new DataTable();
 
          da.Fill(ds);
          objDT = ds.Tables[0];
          objDV = ds.Tables[0].DefaultView;
          objDV.Sort = strSort;
          Repeater1.DataSource = objDV;
          Repeater1.DataBind();
 
 
      conn.Close();
    }

[kenobewan]

Prevent the postback, try using if !(page.ispostback) in you sort function. HTH.

[rameshonweb]

Prevent the postback, try using if !(page.ispostback) in you sort function. HTH.

Can you please explain in detail what you have said.?