add data on grid view or list view

Question

0.00/5 (No votes)

See more:

I'm trying to create a form the will search through my database and add those data into a data grid view or list view. I have a text box where I input the product ID for example and when I click the button I want the data of that Product ID to show on the grid view (product name, product description for example). My problem is that instead of adding data on the grid view, it just replaces the old content of the grid view in to a new one. How do I add multiple data on a grid view or list view? Thank you!

Posted 24-Jul-11 20:22pm

shimaro82

Add a Solution

2 solutions

Solution 1

Hi,
just think about your code,after your first binding the data will seen in the gridview,then you are trying to bind the gridview with new condition.At that time the gridview contains only new data.

regards,
shefeek

Posted 24-Jul-11 20:59pm

shefeekcm

Comments

shimaro82 25-Jul-11 3:21am

I know, but I don't know a way on how can I add multiple data.. do you have any ideas? I can't find a way on how I can send the current data after post back.

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)

Raju Prajapati · Accepted Answer · 2011-07-24T21:12:00

Solution 2

In place of direct binding use the following ways

first put your filtered data in a dataset/datatable. then

C#

for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
  DataRow rw = ds.Tables[0].Rows[i];
  int cnt = rw.ItemArray.Length;
  string row1 = "";
  string[] cells = new string[cnt + 1];
  for (int j = 0; j < cnt; j++)
  {
     cells[j] = rw.ItemArray.GetValue(j).ToString();
  }
  dataGridView1.Rows.Add(cells);
}

Posted 24-Jul-11 21:12pm

Raju Prajapati

Comments

shimaro82 25-Jul-11 3:19am

Hmm I think this might do it... I'll try it when I get home.. Thank you :)

shimaro82 25-Jul-11 10:33am

@Raju.. I have a question.. what is that ds.tables? is that the data adapter? or the data table? because It doesn't come out in the code of data adapter and data table.

Raju Prajapati 1-Aug-11 5:46am

ds is a DataSet

shimaro82 25-Jul-11 11:59am

I get an error on DataRow rw = ds.Tables[0].Rows[i]; saying that Object reference not set to an instance of an object. I replaced ds with dt because I'm using a datatable...

Raju Prajapati 1-Aug-11 5:53am

Ok, If we use dataset(a collection of tables) then we need to specify table with its name or index that's why we write DataSet.Tabele[0].Rows. But if we use datatable(a single table) we need not to do so, here we can directly indicate i.e. Datatable.Rows