Need to split records in dropdownlist

Posted on 2008-10-28
Last Modified: 2013-12-17
i want to split records in dropdown list,

O/p is :
fid                   resname(dropdown list )
1                     RestaurantA,RestaurantB,RestaurantC,RestaurantD(it displays like ths only having all records in zero index , but dropdown shuould be populated by varying its index values from zero to three if it has 4 records )
3                     RestaurantD
4                     RestaurantA,RestaurantB(similarly for this)
5                     RestaurantB
9                     RestaurantA, RestaurantC(simalarly)
11                   RestaurantD

I think , am cleared with this one .

Only thing is, i need a split function , so that it populate the record one by one in dropdown list having diff index values .

Kindly suggest me ur valuable idea,...

Please if i made any mistake in codin , u can advice me wat to do ......
<div><asp:GridView ID="GridView1" runat="server" style="left: 157px; position: relative; top: 141px" OnRowDataBound="GridView1_RowDataBound" AutoGenerateColumns="False">


                <asp:BoundField DataField="fid" HeaderText="fid" />

                <asp:BoundField HeaderText="Fname" />

                <asp:TemplateField HeaderText="rname">


                        <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("resname") %>'></asp:TextBox>



                        <asp:DropDownList ID="DropDownList1" runat="server" Style="position: relative" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged">




                <asp:BoundField HeaderText="price" />






SErver side code( i want split function)

 protected void Page_Load(object sender, EventArgs e)


        GridView1.DataSource = resnameddl1().Tables[0];




    public DataSet resnameddl1()


        string constr = ConfigurationManager.AppSettings["constring"];

        SqlConnection myconnection = new SqlConnection(constr);

        DataSet ds = new DataSet();


        string cmd = "select distinct fid,dbo.resname(fid) as resname  from maintable";

        SqlDataAdapter da = new SqlDataAdapter(cmd, myconnection);

        da.Fill(ds, "maintable");

        return ds;


    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)



        DataTable mytable = new DataTable();

        DataColumn restid = new DataColumn("rid");

        DataColumn restname1 = new DataColumn("resname1");



        DataSet ds = new DataSet();

        ds = resnameddl1();

        int fid = 0;

        string expression = string.Empty;

        if (e.Row.RowType == DataControlRowType.DataRow)


            fid = Int32.Parse(e.Row.Cells[0].Text);

            expression = "fid = " + fid;

           DropDownList ddl = (DropDownList)e.Row.FindControl("dropdownlist1");

            DataRow[] rows = ds.Tables[0].Select(expression);

            foreach (DataRow row in rows)


                DataRow newrow = mytable.NewRow();

                string temprest = "resname";

                char[] sep = { ',' };

                string[] values = temprest.Split(sep);

                newrow["rid"] = row["fid"];

                newrow["resname1"] = row["resname"];





            ddl.DataSource = mytable;

             ddl.DataTextField = "resname1";

            ddl.DataValueField = "rid";




Open in new window

Question by:Rajar Ahmed
  • 2

Accepted Solution

aliwajdan earned 500 total points
ID: 22828977
protected void Page_Load(object sender, EventArgs e)
        GridView1.DataSource = resnameddl1().Tables[0];
there is mistake in your  Page_Load function

protected void Page_Load(object sender, EventArgs e)
        GridView1.DataSource = resnameddl1().Tables[0];

you'll not need any split function  or any thing else when you add items in the dropdown list it do these things autometically like making automatic index columns
LVL 18

Author Comment

by:Rajar Ahmed
ID: 22828991
hi , it shows with the same sort of displaying in dropdown with the use of postback also as u mentioned..
plz kindly suggest me any othr views ..

Thanks ..
LVL 18

Author Comment

by:Rajar Ahmed
ID: 22829028

this function i used to retrieve values for dropdown list  which is resname,


Create FUNCTION dbo.resname(@fid int)




DECLARE @keyword_Name VARCHAR(4000)

SET @keyword_Name = ''

SELECT @keyword_Name =

(CASE @keyword_Name

WHEN '' THEN resname

ELSE @keyword_Name + ',' +resname


from MainTable

inner join Resttable rest

on MainTable.rid= rest.rid

where fid=@fid

RETURN @keyword_Name


REsult is

fid  Resname(this field am storing in dropdown list)

56   Restaurant B,Restaurant C,Restaurant D	

63   Restaurant C,Restaurant A	

Open in new window


Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK ( for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now