Datagridview problems with datatable as datasource

Question

0.00/5 (No votes)

See more:

HI!
i have a data grid view that has as datasource one data table of dataset. when i try to add a new row to datatable sometimes datagridview is not displaying any rows. when it happens, it does it just from the application startup(form shows) i mean that the datagridview does not display lines from the beginning, not after displaying some and the rest are not being displayed .
I have to close the application to fix the issue.

plz any advice

Posted 13-Dec-12 4:48am

90jeri

Updated 13-Dec-12 7:50am

v2

Add a Solution

Comments

[no name] 13-Dec-12 10:55am

can you post a sample code about what you actually doing?

90jeri 13-Dec-12 11:48am

i set the datasource of dg with
<pre>
dataset.Tables["BillLinesDt"].DefaultView.RowFilter = "ID = " + id;
dgBill.DataSource = dataset.Tables["BillLinesDt"].DefaultView;</pre>

i create new row with this :
<pre>
DataRow newRow = dataset.Tables["BillLinesDt"].NewRow();
</pre>
i set the values of each column
<pre>
newrow[0] = value1;
newrow[1] = value2;
</pre>

and then i add this new row to the datatable with this
<pre>dataset.Tables["BillLinesDt"].Rows.Add(newRow);</pre>

1 solution

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)

Jibesh · Answer 1 · 2012-12-13T06:45:00

Solution 2

You have RowFilter set to the dataset to filter out the data based on ID. remove the filter and check your display.

Check this line of code in your source.

C#

dataset.Tables["BillLinesDt"].DefaultView.RowFilter = "ID = " + id;

Posted 13-Dec-12 6:45am

Jibesh

Comments

90jeri 13-Dec-12 13:18pm

in dataset.Tables["BillLinesDt"] it keeps lines of bills so i need to get only the rows of a specific bill thats why i need that filter

Jibesh 13-Dec-12 13:21pm

I understand that but since you said some of the rows couldnt added to the grid view can you also check the Id's of the newly added row.
Are you able to reproduce this problem all the time?> If yes for what value the grid doesnt display your data. You can use the 'Improve Question'link to update your questions if you want.

90jeri 13-Dec-12 13:54pm

no i can't reproduce this problem it just happens some times. i know that rows are saved in dataset.Tables["BillLinesDt"] but they aren't displayed. so if i close the form and open it again everything is okay

Jibesh 13-Dec-12 14:03pm

From the above code What i can read is you will see the problem(actually it's not a problem because we asked to do so by filtering the view) when records that doesnt matches the 'Id' value set to the filter. try to debug your code for what values it failed to display on the grid. you can use the System.Diagnostics.Trace class to log your output for debugging.

90jeri 13-Dec-12 14:19pm

i've checked that is the same id ('id' is a foreign key to the id of the actual bill that is created so when i have only one bill it happened)

Jibesh 13-Dec-12 14:28pm

you need to provide some more details about your problem. i would say this is a design issue nothing to do with the datagridview control you need to overlook your system design and what we have here is limited knowledge about your system and we cannot read your mind. better provide more detail about your system rather someone guessing all the possible cases one by one.