Databinding in Gridview while we select a value from dropdown

Posted by Ganesh under ASP.NET on 11/25/2008 | Views : 4467 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

Dears,

I have 2 controls like dropdown (named ddl) and gridview (named gridview1) and a xml file (named AppCatalog.xml).

My xml look like
<appcatalog>
<appname>
<field1>tamilnadu<\field1>
<field2>chennai<\field2>
<field3>tnagar<\field3>
<\appname>
<\appcatalog>

Already I have bind this record in gridview using dataset. And I have bind the node (<field1>tamilnadu</field1>) in dropdown.

Now what i want is... when I select a value (like tamilnadu) in dropdown, then the full records relevant to "tamilnadu" will be display in gridview (that is my gridview show one record only contains "tamilnadu chennai tnagar"

Guys who is help me earliest is thankful.

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Jayakumars on: 9/30/2012 [Member] [MVP] Bronze | Points: 25

0	hi ds.readxml using the dataset and concatenate your data. Mark as Answer if its helpful to you Kumaraspcode2009@gmail.com Ganesh, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Majith on: 11/25/2008 [Member] Starter

0	Hi Ganesh, Create an Datatable ,data row in order select the particular element. Codebehind DataTable dt = new DataTable(); // creating data table DataColumn dc = new DataColumn("Id"); //xml element1 DataColumn dc1 = new DataColumn("Name"); // xml element2 dt.Columns.Add(dc); dt.Columns.Add(dc1); string ct = ddl.SelectedItem.ToString(); // dropdown selected item string dataPath = Server.MapPath("place.xml"); // xml file path DataSet dSet = new DataSet(); // new dataset dSet.ReadXml(dataPath); // reading xml file DataRow[] rows = dSet.Tables[0].Select(" Name = '" + ct + "'"); // selecting particular record // searching record foreach (DataRow dr in rows) { DataRow myRow = dt.NewRow(); myRow["Id"] = dr["Id"]; myRow["Name"] = dr["Name"]; dt.Rows.Add(myRow); } grxml.DataSource = dt; // binding from data table grxml.DataBind(); Inline code: <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Readxml.aspx.cs" Inherits="Readxml" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title>Untitled Page</title> </head> <body> <form id="form1" runat="server"> <div> <br /><br /><br /> <asp:DropDownList ID="ddl" runat="server"></asp:DropDownList> <br /> <br /> <br /> <br />  <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox> <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" /></div> <asp:GridView ID="grxml" runat="server"> </asp:GridView> </form> </body> </html> hope this help Ganesh, if this helps please login to Mark As Answer. \| Alert Moderator

Hi Ganesh,

Create an Datatable ,data row in order select the particular element.

Codebehind

  DataTable dt = new DataTable(); // creating data table

        DataColumn dc = new DataColumn("Id"); //xml element1

        DataColumn dc1 = new DataColumn("Name"); // xml element2

        dt.Columns.Add(dc);

        dt.Columns.Add(dc1);

         string ct = ddl.SelectedItem.ToString();   // dropdown selected item              

        string dataPath = Server.MapPath("place.xml"); // xml file path

        DataSet dSet = new DataSet(); // new dataset

        dSet.ReadXml(dataPath); // reading xml file

        DataRow[] rows = dSet.Tables[0].Select(" Name = '" + ct + "'");

        // selecting particular record

// searching record

        foreach (DataRow dr in rows)

        {

            DataRow myRow = dt.NewRow(); 

            myRow["Id"] = dr["Id"];

            myRow["Name"] = dr["Name"];

            dt.Rows.Add(myRow);



        }



        grxml.DataSource = dt; // binding from data table

        grxml.DataBind();

Inline code:

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Readxml.aspx.cs" Inherits="Readxml" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">


<html xmlns="http://www.w3.org/1999/xhtml" >

<head runat="server">

    <title>Untitled Page</title>

</head>

<body>

    <form id="form1" runat="server">

    <div>

    <br /><br /><br />

    <asp:DropDownList ID="ddl" runat="server"></asp:DropDownList>&nbsp;<br />

        <br />

        <br />

        <br />

        &nbsp;<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

        <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" /></div>

     <asp:GridView ID="grxml" runat="server">

      </asp:GridView>  

      </form>

</body>

</html>

hope this help

Ganesh, if this helps please login to Mark As Answer. | Alert Moderator

Latest Posts