| Protected Sub gvProjects_ItemCommand(ByVal source As Object, ByVal e As Telerik.Web.UI.GridCommandEventArgs) Handles gvProjects.ItemCommand | |
| If e.CommandName = RadGrid.EditCommandName Then | |
| Session("TaskId") = e.Item.OwnerTableView.Items(e.Item.ItemIndex)"TaskId").Text | |
| End If |
| <asp:SqlDataSource ID="dsCheckFile" runat="server" | |
| ConnectionString="<%$ ConnectionStrings:DBPortal %>" | |
| SelectCommand="SELECT tblFiles.FileId, tblFiles.FileName, FilesPerTask.FileId AS FileToTask, FilesPerTask.TaskId, tblFiles.ProjectId | |
| FROM tblFiles LEFT OUTER JOIN FilesPerTask ON tblFiles.FileId = FilesPerTask.FileId | |
| WHERE (tblFiles.ProjectId = @ProjectId)"> | |
| <SelectParameters> | |
| <asp:SessionParameter Name="TaskId" SessionField="TaskId" Type="Int32" Direction="Input" /> | |
| <asp:SessionParameter Name="ProjectId" SessionField="ProjectId" Type="Int32" Direction="Input"/> | |
| </SelectParameters> | |
| </asp:SqlDataSource> |
{
if (!e.IsFromDetailTable)
{
RadGrid1.DataSource = GetGridData();
}
}
protected void RadGrid1_DetailTableDataBind(object source, Telerik.Web.UI.GridDetailTableDataBindEventArgs e)
{
GridDataItem dataItem = (GridDataItem)e.DetailTableView.ParentItem;
switch (e.DetailTableView.Name)
{
case "Element":
{
string CustomerID = dataItem.GetDataKeyValue("CustomerID").ToString();
e.DetailTableView.DataSource = GetDataTable(
"Element", CustomerID);
break;
}
case "Criteria":
{
string OrderID = dataItem.GetDataKeyValue("OrderID").ToString();
e.DetailTableView.DataSource = GetDataTable(
"Criteria", OrderID);
break;
}
}
}
public DataTable GetDataTable(string Type, String Id)
{
DataSet myDataSet;
DataTable myResultsView = new DataTable();
if (Type == "Element")
{
myDataSet = aw.sn.
GetElementListByUnit.ExecuteDataSet (dbConnString,Convert.ToInt32(Id));
myResultsView = myDataSet.Tables[0];
}
if (Type == "Criteria")
{
myDataSet = aw.sn.
GetCriteriaListByElement.ExecuteDataSet(dbConnString, Convert.ToInt32(Id), isignpostId);
myResultsView = myDataSet.Tables[0];
}
return myResultsView;
}
Please help..
Many Thanks
Ash