ansaurus

Question

Answer 1

A:

You could do that the following way:

When you click on one row from Grid 1 you should trigger an event on codebehind file (look at SelectedIndexChanged shown bellow). Inside this event you should query your XML file table to find the ones that have the same process Id of the row selected on Grid 1. With the result of such a query you bind it to Grid 2.

  void LOG_GridView_SelectedIndexChanged(Object sender, EventArgs e)
  {
    // Get the currently selected row using the SelectedRow property.
    GridViewRow row = CustomersGridView.SelectedRow;

    // Do your logic here to query and databind to Grid 2...
  }

Write this in your Grid1 declaration:

<asp:GridView ID="LOG_GridView" runat="server" AllowPaging="True" AutoGenerateColumns="False"
            CellPadding="4" DataSourceID="FS_PS2FS" ForeColor="#333333" Height="300px" Width="943px" HorizontalAlign="Center" CssClass="AlternatingRowStyle" PageSize="6" SelectedIndex="0" OnSelectedIndexChanging="LOG_GridView_SelectedIndexChanging" BorderColor="#999999" onselectedindexchanged="LOG_GridView_SelectedIndexChanged">

For more information on events of GridView, look at these pages at MSDN:

GridView..::.SelectedRow Property

GridView Class

Leniel Macaferi 2010-03-25 15:43:21

Answer 2

A:

Basically you want to create a Master/Detail screen... is this homework? On any case, you want to add an event (selected index changed) to the first grid. Then add code there that will either set the data source or "filter" the data in the second grid, you might also choose to make the second grid visible at this point if is not already.

The data source of the second grid needs a "WHERE" clause which will compare the processID in your datasource with the one selected in the first grid. You can set the first grid's data key to be this field (processID) for easy retrieval.

Good luck!

Ricardo 2010-03-25 15:43:57

no its not my homework I am working and got stuck as im not used to c#.net mostly worked with java

sweetsecret 2010-03-25 15:46:59

Cool! it was more of a j/k :)

Ricardo 2010-03-25 15:50:19

i really need help in it ... as im stuck and not able to figure out what to do. It is a master/detail grdview i wud say

sweetsecret 2010-03-25 16:51:20

the problem is that the processId in in the 1st table is named LOG_ProcessId and in the second table P2FV_ProcessId how can do it this way

sweetsecret 2010-03-25 16:52:45

Answer 3

A:

You should be able to do this all from markup. Here is a working example using the Northwind database

Define the master GridView:

<asp:GridView ID="master" runat="server" DataSourceID="sdsMaster" 
        AutoGenerateColumns="False" DataKeyNames="OrderID" AllowPaging="True" >
    <Columns>
        <asp:CommandField ShowSelectButton="True" />
        <asp:BoundField DataField="OrderID" HeaderText="OrderID" InsertVisible="False" 
            ReadOnly="True" SortExpression="OrderID" />
        <asp:BoundField DataField="CustomerID" HeaderText="CustomerID" 
            SortExpression="CustomerID" />
        <asp:BoundField DataField="EmployeeID" HeaderText="EmployeeID" 
            SortExpression="EmployeeID" />
        <asp:BoundField DataField="OrderDate" HeaderText="OrderDate" 
            SortExpression="OrderDate" />
        <asp:BoundField DataField="RequiredDate" HeaderText="RequiredDate" 
            SortExpression="RequiredDate" />
        <asp:BoundField DataField="ShippedDate" HeaderText="ShippedDate" 
            SortExpression="ShippedDate" />
        <asp:BoundField DataField="ShipVia" HeaderText="ShipVia" 
            SortExpression="ShipVia" />
        <asp:BoundField DataField="Freight" HeaderText="Freight" 
            SortExpression="Freight" />
    </Columns>
    </asp:GridView>

Define the details GridView:

<asp:GridView ID="detail" runat="server" DataSourceID="sdsDetail" 
        AutoGenerateColumns="False" DataKeyNames="OrderID,ProductID" >
    <Columns>
        <asp:BoundField DataField="OrderID" HeaderText="OrderID" ReadOnly="True" 
            SortExpression="OrderID" />
        <asp:BoundField DataField="ProductID" HeaderText="ProductID" ReadOnly="True" 
            SortExpression="ProductID" />
        <asp:BoundField DataField="UnitPrice" HeaderText="UnitPrice" 
            SortExpression="UnitPrice" />
        <asp:BoundField DataField="Quantity" HeaderText="Quantity" 
            SortExpression="Quantity" />
        <asp:BoundField DataField="Discount" HeaderText="Discount" 
            SortExpression="Discount" />
    </Columns>
    </asp:GridView>

Here is the SqlDataSource for the master table. Just basic stuff to select and display the records:

<asp:SqlDataSource ID="sdsMaster" runat="server" 
        ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>" 
        SelectCommand="SELECT [OrderID], [CustomerID], [EmployeeID], [OrderDate], [RequiredDate], [ShippedDate], [ShipVia], [Freight] FROM [Orders]" />

Now in the details SqlDataSource, use a SQL where clause bound to the selected primary key in the master GridView:

<asp:SqlDataSource ID="sdsDetail" runat="server" 
        ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>" 
        SelectCommand="SELECT [OrderID], [ProductID], [UnitPrice], [Quantity], [Discount] FROM [Order Details] WHERE ([OrderID] = @OrderID)" >
    <SelectParameters>
        <asp:ControlParameter ControlID="master" DefaultValue="0" Name="OrderID" 
            PropertyName="SelectedValue" Type="Int32" />
    </SelectParameters>
    </asp:SqlDataSource>

Notice the SelectParameters and the use of a ControlParameter which looks for the data key of the selected record in the master GridView.

EDIT Since you are using your own database with different field names then modifiy the SQL accordingly.

FROM [FS_LOG_PS2FS_Validation] WHERE ([P2FV_ProcessId] = @LOG_ProcessId)

and change the SelectParameter

<SelectParameters>
    <asp:ControlParameter ControlID="master" DefaultValue="0" Name="LOG_ProcessId" 
        PropertyName="SelectedValue" Type="Int32" />
</SelectParameters>

Also, you will need to set the DataKeyNames attribute in the master GridView

  <asp:GridView ID="master" runat="server" DataSourceID="sdsMaster" 
            AutoGenerateColumns="False" DataKeyNames="LOG_ProcessID" AllowPaging="True" >
        <Columns>

I don't think you need to set the DataKeyNames of the detail GridView. You can change it there too for completeness. I used the smart tag in Visual Studio 2008 design view to generate the example code. Let me know if this isn't clear.

EDIT 2 Here are some links that describe configuring ASP.NET data controls.

Master/Detail Using a Selectable Master GridView with a Details DetailView

Querying Data with the SqlDataSource Control

Data Access Tutorials

DaveB 2010-03-25 17:15:37

In your example you have the OrderID in both the table in mycase i mean question in the 1st table the processID is named LOG_ProcessId and in the second table P2FV_ProcessId how can do it this way

sweetsecret 2010-03-25 17:37:02

I have updated my answer. I hope this makes things clearer.

DaveB 2010-03-25 17:58:22

Let me try if it helps thanks alot

sweetsecret 2010-03-25 19:17:38

i cant change the name of the fields set in table though its my own database as this databse is used in different other programms handled by other people in the company any other way i can do other than modifying the sql

sweetsecret 2010-03-25 19:20:18

No need to change your field names. You NEED to replace the SQL I have shown in my sample code with your own. I recomend using the smart tag(that's what I call it anyways) for your controls in Visual Studio's design mode to configure the controls. If you want more information on this aspect. I have added some links to my answer.

DaveB 2010-03-25 21:53:41

i tried doing it the way you said it gives me a server errorServer Error in '/' Application.Object must implement IConvertible. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.InvalidCastException: Object must implement IConvertible.

sweetsecret 2010-03-29 14:39:31

Source Error:An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

sweetsecret 2010-03-29 14:40:05

Stack Trace: [InvalidCastException: Object must implement IConvertible.] System.Convert.ChangeType(Object value, TypeCode typeCode, IFormatProvider provider) +2514354 System.Web.UI.WebControls.Parameter.GetValue(Object value,

sweetsecret 2010-03-29 14:40:37

String defaultValue, TypeCode type, Boolean convertEmptyStringToNull, Boolean ignoreNullableTypeChanges) +264 System.Web.UI.WebControls.Parameter.get_ParameterValue() +66 System.Web.UI.WebControls.ParameterCollection.GetValues(HttpContext context, Control control) +254 System.Web.UI.WebControls.SqlDataSourceView.InitializeParameters(DbCommand command, ParameterCollection parameters, IDictionary exclusionList) +276

sweetsecret 2010-03-29 14:41:00

System.Web.UI.WebControls.SqlDataSourceView.ExecuteSelect(DataSourceSelectArguments arguments) +754 System.Web.UI.DataSourceView.Select(DataSourceSelectArguments arguments, DataSourceViewSelectCallback callback) +17 System.Web.UI.WebControls.DataBoundControl.PerformSelect() +149 System.Web.UI.WebControls.BaseDataBoundControl.DataBind() +70

sweetsecret 2010-03-29 14:41:40

System.Web.UI.WebControls.GridView.DataBind() +4 System.Web.UI.WebControls.BaseDataBoundControl.EnsureDataBound() +82System.Web.UI.WebControls.CompositeDataBoundControl.CreateChildControls() +69 System.Web.UI.Control.EnsureChildControls() +87 System.Web.UI.Control.PreRenderRecursiveInternal() +41 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Control.PreRenderRecursiveInternal() +161 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1360

sweetsecret 2010-03-29 14:42:30

@DaveB: Do you configure all your controls directly in the markup? I tend to use the designer more, any advantage in not using designer mode?

GenEric35 2010-07-04 02:16:09

@GenEric: I too use the designer which will generate a lot of the boilerplate markup for me. If the task is straightforward, I tend to use the designer/markup.

DaveB 2010-07-07 22:01:04

ansaurus

tags:

views:

answers:

GridViews in ASP.net; C#

related questions