Datagrid [modified]
-
Hello everybody, I have a database that has multiple rows and columns some of the rows share for the same value of fields(columns). So I want to merge or combine these two or more rows and make invisible the line(s) found between(among) them while the others are being visible, using DataGrid. Please any of you help me. I'm in need, it's urgent. Thank you.
modified on Tuesday, September 29, 2009 8:43 AM
-
Hello everybody, I have a database that has multiple rows and columns some of the rows share for the same value of fields(columns). So I want to merge or combine these two or more rows and make invisible the line(s) found between(among) them while the others are being visible, using DataGrid. Please any of you help me. I'm in need, it's urgent. Thank you.
modified on Tuesday, September 29, 2009 8:43 AM
Read Data from DataBase, merge the common fileds and save data in a datatable and then assign datatable to datagrid. It would be good if you provide some code.
-
Read Data from DataBase, merge the common fileds and save data in a datatable and then assign datatable to datagrid. It would be good if you provide some code.
Al right, but I want to merge for rows not for columns, any way here is the code. < command = new SqlCommand("sp_query", itsConn); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@IDNumber", SqlDbType.Int).Value = infoId; itsAdapter = new SqlDataAdapter(command); itsAdapter.Fill(itsDataSet, "Schedule"); itsDataGrid.DataSource = itsDataSet.Tables["Schedule"]; itsDataGrid.DataBind(); >