مرتب سازی گرید براساس مقدار تکس باکس

[samira3]

سلام
من یک گرید دارم داری نا ونام خانوادگی است حالا یک تکس باکس بالاش می زارم تا با پر شدنش براساس اون مرتب شه
یعنی در حالت عادی مرتب سازی جدول براساس ا تا ی حالا اگر کاربر حرف ت زد بیاد اولش تمام نام های که با ت شروع می شود اول بیار ومابقی زیرش

من این با دستور بانکی ورفرش مجدد جدول انجام دادم
که اینم کدش

DataSet ds = new DataSet();
String conStr = "Provider=Microsoft.Jet.OLEDB.4.0 ; Data Source =" + System.Web.HttpContext.Current.Server.MapPath("~//App_Data//Commission.mdb ");
OleDbConnection con = new OleDbConnection(conStr);
con.Open();
OleDbDataAdapter adp = new OleDbDataAdapter(
" Select * From [Member] inner join [Council] on [Member].[Council_Id]=[Council].[Council_Id] WHERE [Name-Member] LIKE '" + txtemail0.Text + "%' OR [Family-Member] LIKE '" + txtemail0.Text + "%' " +
" UNION ALL " +
" Select * From [Member] inner join [Council] on [Member].[Council_Id]=[Council].[Council_Id] WHERE [Name-Member] not LIKE '" + txtemail0.Text + "%' AND [Family-Member] not LIKE '" + txtemail0.Text + "%' ", con);
adp.Fill(ds);
GridViewmemeber.DataSource = ds.Tables[0];
GridViewmemeber.DataBind();

کد در text change
مشکل مربوط می شه به post back شدن یعنی صفحه از اول لود مشه
من شی داخل upload panelگذاشتم
حالا اصلا صداش نمی زنه وتغییر در گرید اتفاق نمی افته
من الان 2 روز سرچ کردم
بهترین راه حل استفاده از js که بیام تو رویدادkey upتکس باکسم تابع جاوا صدا بزنم خیلی سعی کردم نشد :گریه:حتی با سرویس جواب نگرفتم .:گریه:با جی کوئری رفتم ولی تابع اون فقط رکورد که با حرف می خوره نشان می ده من بقیه رکوردها زیر رکورد مورد نظرم می خوام:ناراحت:

از شما دوستان درخواست کمک دارم

[samira3]

DataSet ds = new DataSet();
String conStr = "Provider=Microsoft.Jet.OLEDB.4.0 ; Data Source =" + System.Web.HttpContext.Current.Server.MapPath("~//App_Data//Commission.mdb ");
OleDbConnection con = new OleDbConnection(conStr);
con.Open();
//txtemail0
// OleDbCommand cmd = new OleDbCommand("SELECT * FROM Member WHERE [Name-Member] LIKE '" + txtemail0.Text + "%'", con);
// OleDbDataReader dr = cmd.ExecuteReader();
//OleDbDataAdapter adp = new OleDbDataAdapter("select t1.[ID-Member],t1.[Name-Member],t1.[Family-Member],t1.[Kdmly-Member],t1.[Tel-Home-Member]," +
// "t1.[Tel-Work-Member],t1.[Mobile_Member],t1.[Email-Member],t1.[Address-Home-Member]," +
// "t1.[Address-work-Member],t1.[Research-Expertise-Member],t1.[Id-Academic-Rank],t1.[Accoun-number]," +
// "t1.[Fax],t1.[Member].[Council_Id],t1.[Executive-positions-in-the-workplace],t1.[Join-Type],t1.[Council_Name] from"+
// "(Select [ID-Member],[Name-Member],[Family-Member],[Kdmly-Member],[Tel-Home-Member]," +
// "[Tel-Work-Member],[Mobile_Member],[Email-Member],[Address-Home-Member]," +
// "[Address-work-Member],[Research-Expertise-Member],[Id-Academic-Rank],[Accoun-number]," +
// "[Fax],[Member].[Council_Id],[Executive-positions-in-the-workplace],[Join-Type],[Council_Name]" +
// " From [Member] inner join [Council] on [Member].[Council_Id]=[Council].[Council_Id]" +
// " WHERE [Name-Member] LIKE '" + txtemail0.Text + "%' )as t1 full outer join"+
// "(Select [ID-Member],[Name-Member],[Family-Member],[Kdmly-Member],[Tel-Home-Member]," +
// "[Tel-Work-Member],[Mobile_Member],[Email-Member],[Address-Home-Member]," +
// "[Address-work-Member],[Research-Expertise-Member],[Id-Academic-Rank],[Accoun-number]," +
// "[Fax],[Member].[Council_Id],[Executive-positions-in-the-workplace],[Join-Type],[Council_Name]" +
// " From [Member] inner join [Council] on [Member].[Council_Id]=[Council].[Council_Id]" +
// " WHERE [Name-Member] NOT LIKE '" + txtemail0.Text + "%')as t2 on t1.[Council_Id]=t2.[Council_Id]", con);
OleDbDataAdapter adp = new OleDbDataAdapter(
" Select * From [Member] inner join [Council] on [Member].[Council_Id]=[Council].[Council_Id] WHERE [Name-Member] LIKE '" + txtemail0.Text + "%' OR [Family-Member] LIKE '" + txtemail0.Text + "%' " +
" UNION ALL " +
" Select * From [Member] inner join [Council] on [Member].[Council_Id]=[Council].[Council_Id] WHERE [Name-Member] not LIKE '" + txtemail0.Text + "%' AND [Family-Member] not LIKE '" + txtemail0.Text + "%' ", con);
adp.Fill(ds);
GridViewmemeber.DataSource = ds.Tables[0];
GridViewmemeber.DataBind();