Orhan Türk

public partial class _Default : System.Web.UI.Page
{
    private MySqlConnection conn;
    private DataTable data;
    private MySqlDataAdapter da;
    private MySqlCommandBuilder cb;
    private string SortString = "";
    private string SortOrder;
    private string SortExpression;
 
    protected void Page_Load(object sender, EventArgs e)
    {
        SortOrder = (string)Session["SortOrder"];
        SortExpression = (string)Session["SortExpression"];

        if (SortOrder == null)
            SortOrder = "ASC";

        if (SortExpression == null)
            SortExpression = "productID";
       
        if (!IsPostBack)
            QueryServer("SELECT * FROM database.table ORDER BY " + SortExpression + " " + SortOrder);
    }

    protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)
    {
        SortString = e.SortExpression;

        QueryServer("SELECT * FROM database.table ORDER BY " + SortString + " " + SortOrder);

        if (SortOrder == "ASC")
          SortOrder = "DESC";
        else  
          SortOrder = "ASC";

        Session["SortOrder"] = SortOrder;
        Session["SortExpression"] = e.SortExpression;
    }

    protected void QueryServer(string cmd)
    {

        if (cmd == "")
            cmd = "SELECT * FROM database.table";

        string connStr = String.Format("server={0};user id={1};

password={2}; database=mysql; pooling=false", "localhost", "username", "password");
        try
        {
            conn = new MySqlConnection(connStr);
            conn.Open();

            MySqlDataReader reader = null;

            try
            {
                da = new MySqlDataAdapter(cmd, conn);
                data = new DataTable();
                da.Fill(data);

                GridView1.DataSource = data;
                GridView1.AllowSorting = true;
                GridView1.DataBind();
            }
            catch (Exception ex)
            {
                throw new Exception("Failed to populate database list: " + ex.Message);
            }
            finally
            {
                if (reader != null) reader.Close();
            }

        }
        catch (MySqlException ex)
        {
            throw new Exception("Error connecting to the server: " + ex.Message);
        }
    }

    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        int index = e.RowIndex;
        string id = GridView1.Rows[index].Cells[1].Text;

        string command = "DELETE FROM database.table WHERE logID = " + id + " LIMIT 1;";
        command += "SELECT * FROM database.table ORDER BY " + SortExpression + " " + SortOrder;

        QueryServer(command);
    }
}

evet arkadaşlar bir makkalenin  sonuna daha gelmiş olduk  yeni bir makkalede görüşmek  üzrere herkeze başarılar

Saygılarımla Orhan Türk