how to fetch data in gridview from listbox

Question

2.50/5 (2 votes)

See more:

I have a gridview and a listbox.Now I want to filter the data of column "symbol" from listbox which has a list of symbols.Dataview is not working because each time it
replaces the previous row of gridview.

Posted 24-Dec-11 4:35am

souvikcode

Add a Solution

Comments

R. Giskard Reventlov 25-Dec-11 4:38am

The question makes no sense: please rephrase more clearly.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

souvikcode · Answer 1 · 2011-12-25T05:00:00

public void datafetch_of_currdate() //1ST FUNCTION...............................................................................
{
if (this.Page.IsPostBack == false)
{
DataSet ds = new DataSet();
da = new OleDbDataAdapter("select sr_no,call_time,b_s,symbol,entry,exit_sl,exit_target,instrument,curr_status,call_type from emp where curr_date=#" + DateTime.Now.ToShortDateString() + "# order by sr_no desc", cn);
da.Fill(ds, "table");
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
ds.Tables[0].Rows.Clear();
for (int i = 0; i < ListBox1.Items.Count; i++)
{
foreach (GridViewRow gr in GridView1.Rows)
{
if (gr.Cells[3].Text == ListBox1.Items[i].Text)
{

DataRow dr = ds.Tables[0].NewRow();
dr["sr_no"] = gr.Cells[0].Text;
dr["call_time"] = gr.Cells[1].Text;
dr["b_s"] = gr.Cells[2].Text;
dr["symbol"] = gr.Cells[3].Text;
dr["entry"] = gr.Cells[4].Text;
dr["exit_sl"] = gr.Cells[5].Text;
dr["exit_target"] = gr.Cells[6].Text;
dr["instrument"] = gr.Cells[7].Text;
dr["curr_status"] = gr.Cells[8].Text;
dr["call_type"] = gr.Cells[9].Text;

ds.Tables[0].Rows.Add(dr);

}

}
}

GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}

}

call this function in form load event.

Nigam Patel · Answer 2 · 2011-12-25T20:14:00

you can try below code :

 DataSet ds = new DataSet();
 DataTable dt;
 DataTable dtnew;

 OleDbDataAdapter da = new OleDbDataAdapter("Your query", "connection Object");
 da.Fill(ds, "table");
 string strfilterexpretion="";
 // Write a code for get filer expretion like below example
 foreach(ListItem lsitem in ListBox1.Items)
 {
     if(lsitem.Selected )
     {
         if(strfilterexpretion ==string.Empty)
         {

         strfilterexpretion +="'"+lsitem.Text+"'";
         }
         else
         {
         strfilterexpretion +=",'"+lsitem.Text+"'";
         }
     }
}

 // you get selected Row only.
 DataRow[] drs = dt.Select("symbole in (" + strfilterexpretion +")";

 // Create a new table
 dtnew.Rows.Add(drs);

 // Bind the grid view
 GridView1.DataSource = dtnew;
 GridView1.DataBind();

Let me know if it is helpfull to you or not.

how to fetch data in gridview from listbox

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0