Sorting Gridview at binding different datasource

Hi guys,

here is the problem.

i have one web user control mediagrid.ascx and i have 3 data source as dataset which am binding in page load.

i have one webform gridviewpage.aspx where am calling this grid in three place's am successfully binding the data and showing in gridview with respect to their datasource

problem is i need to do sorting now but am unable to do it its giving error

here is my code: of mediagrid.ascx

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

BindData();

}

else {

}

public mediarid()

{

//Create Student List

_students = new List();

_student = new Student();

_student.RollNumber = 11;

_student.Class = "5Th";

_student.Div = "A";

_student.Name = "Raju";

_students.Add(_student);

_student = new Student();

_student.RollNumber = 13;

_student.Class = "6Th";

_student.Div = "A1";

_student.Name = "Chanki";

_students.Add(_student);

_student = new Student();

_student.RollNumber = 21;

_student.Class = "5Th";

_student.Div = "A3";

_student.Name = "Amit";

_students.Add(_student);

_student = new Student();

_student.RollNumber = 61;

_student.Class = "9Th";

_student.Div = "A4";

_student.Name = "Suresh";

_students.Add(_student);

dataTable = new DataTable("Student");

//Add column

// Add columns.

for (int i = 0; i < 4; i++)

{

dataTable.Columns.Add();

}

// Add rows.

foreach (var item in _students)

{

string[] obj = new string[4];

obj[0] = item.Name;

obj[1] = item.Class;

obj[2] = item.Div;

obj[3] = item.RollNumber.ToString();

dataTable.Rows.Add(obj);

}

public void BindData()

{

ds = new DataSet();

ds1 = new DataSet();

DataView DV = new DataView();

if(MediaType=="A1")

{

SqlCommand cmdgrid = new SqlCommand("select * from reg", con);

con.Open();

SqlDataAdapter adacust = new SqlDataAdapter(cmdgrid);

adacust.Fill(ds);

ViewState["dataset"] = ds;

GridView1.DataSource = ds;

ViewState["A1Data"] =(DataSet)GridView1.DataSource;

con.Close();

}

else if (MediaType == "B1")

{

SqlCommand cmdgrid1 = new SqlCommand("select * from Booked", con);

con.Open();

SqlDataAdapter adacust1 = new SqlDataAdapter(cmdgrid1);

adacust1.Fill(ds1);

GridView1.DataSource = ds1;

ViewState["B1Data"] = (DataSet)GridView1.DataSource;

}

GridView1.DataBind();

}

public void SetSortDirections(string Direction)

{

if (Direction == "ASC")

{

_sortDirection = "DESC";

}

else

{

_sortDirection="ASC";

}

protected void GridView1_Sorting(object sender, GridViewSortEventArgs e)

{

DataSet ds2 = new DataSet();

DataSet ds3 = new DataSet();

SetSortDirections(SortDirections);

ds2 = (DataSet)ViewState["B1Data"];

if (ds2.Tables[0].Rows.Count != 0)

{

ds2.Tables[0].DefaultView.Sort = e.SortExpression + " " + _sortDirection;

GridView1.DataSource = ds2;

//ds.Clear();

}

ds3 = (DataSet)ViewState["A1Data"];

if (ds3.Tables[0].Rows.Count > 0)

{

ds3.Tables[0].DefaultView.Sort = e.SortExpression + " " + _sortDirection;

GridView1.DataSource = ds3;

}

GridView1.DataBind();

}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

vinayak ghanti10y ago
Hi Gouri Shankar thanks a lot
but still not working i dont know why am able to bind it but unable to sort it even am following the which is given in that links i debugged it it will accept the sort exp and sort direction but it wont sort ?

any other way ?

thanks a lot
Gouri Shankar10y ago
Hi,
try these links:
http://stackoverflow.com/questions/6657627/bind-column-to-a-different-entity-source-than-the-gridview-is
http://stackoverflow.com/questions/138412/how-to-sort-columns-in-an-asp-net-gridview-if-using-a-custom-datasource