Re: Filter Gridview that are bound to an XML file - C# Discussion Boards

22-Oct-09 2:19

Hi everyone.

I am currently playing around with XML files and gridview, and wondered if there were any easy way to filter data, so only rows with specific content are shown.

I have the following.

DataTable dt = new DataTable("Subscribers");
dt.Columns.Add("ID");
dt.Columns.Add("Email");
dt.Columns.Add("signup");
dt.Columns.Add("recent");
dt.Columns.Add("Amount");
dt.Columns.Add("Status");
dt.ReadXml(Application.StartupPath + @"\subscribers.xml");
dataGridView1.DataSource = dt;
dataGridView1.Refresh();

and would like to filter it so rows who fx. only have the value 0 in the columns "Status" would be shown.

Initially hoped that I could use dt.Select("Status == 0") but that didnt work.

so any supercoders out there? yes, yes i did try to google my issue, but didnt find any solution to my small challenge here...

other alternative that I will go back to my good old SQL Server, skip XML files and just use what I am used to - but that would be too easy...

stancrm22-Oct-09 2:30

stancrm

22-Oct-09 2:30

Try it with dt.Select("Status = 0")

Ronni Marker22-Oct-09 2:33

22-Oct-09 2:33

no, that didnt work either. (too bad though)

stancrm22-Oct-09 2:39

stancrm

22-Oct-09 2:39

See this example (it works):

DataTable dataTable = new DataTable("MyTable");
dataTable.Columns.Add("Column1");

DataRow dataRow = dataTable.NewRow();
dataRow["Column1"] = "0";
dataTable.Rows.Add(dataRow);

DataRow[] foundRows = dataTable.Select("Column1 = 0");
Trace.Write(foundRows); // <- Count = 1

Have you checked your dataTable ?
Are there rows with content 0 in Status ?

Ronni Marker22-Oct-09 2:58

22-Oct-09 2:58

Yes, well came to the conclusion that the error for me is that I thought it would be enough to add a line into the code and that would be that. But can see that I need to do more than that.

Basically tried to add

dt.Select("Status =1");

after reading the XML file and also tried to filter it like this

dataGridView1.DataSource = dtSelect("Status =1");

<- this actually gave an interesting output.

But seems that I wouldnt be able to get away with only a line of code thist time here.

So what would be the best way to do this? (just imagine that I have an XML file with more than 2000 Rows)

Henry Minute22-Oct-09 5:59

Henry Minute

22-Oct-09 5:59

No guarantees that this will work but you could try adding a BindingSouce component to your form and then the bindings become

datagrid.DataSource = bindingSource1;
bindingsource1.DataSource = dt;

BindingSource has a Filter property that you can use.

In fact, if you search MSDN for BindingSource.Filter, the example uses XML which should make getting your stuff to work a bit easier. Smile | :)

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Ronni Marker22-Oct-09 6:15

convert .xls file into image file or word image file

22-Oct-09 6:15

Fantastic, worked first time - ehm after I remembered that there is a difference between 1 and '1'. But thanks for the headsup on BindingSource.

Cheers,

Member 438836022-Oct-09 1:24

Member 4388360

22-Oct-09 1:24

Hello sir

I need to convert excel file into image file using c#.then send me sample code for converting word file into image file. Please send me immediately.

Thanks and regards
Vivek

Re: convert .xls file into image file or word image file

Ashfield22-Oct-09 1:30

Ashfield

22-Oct-09 1:30

Member 4388360 wrote:
Please send me immediately.

Upon receipt of 500 pounds sterling I'll send you the code. Until then, go to rentacoder.com. This is not the place to demand code.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Re: convert .xls file into image file or word image file

Wes Aday22-Oct-09 4:06

Wes Aday

22-Oct-09 4:06

Member 4388360 wrote:
Please send me immediately

You are joking right?

Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Individuality is fine, as long as we do it together - F. Burns

Help humanity, join the CodeProject grid computing team here

Re: convert .xls file into image file or word image file

benjymous22-Oct-09 5:03

benjymous

22-Oct-09 5:03

Here's some sample pseudocode:

* Open xl file
* Show messagebox "URGENTZ! PLZ PRS PRNTSCRN! KTHXBYE!"
* Paste into bitmap
* save dat shizzle

Help me! I'm turning into a grapefruit!
Buzzwords!

having problem in opening Ms Office files into webBrowser

muhammad_umair22-Oct-09 1:08

muhammad_umair

22-Oct-09 1:08

Hi, im trying to Open multiple Ms Office files like Excel,PowerPoint & Word in my webBrowser, it works fine when im using Ms Office 2003 in other pc, but when i try to run the same application in another pc having Ms Office 2007 then instead of showing the MS Office file in webBrowser, it Opens the file in Ms Office. Does anyone know the solution to overcome this problem..
thanks in advance Smile | :)

Re: having problem in opening Ms Office files into webBrowser

Richard MacCutchan22-Oct-09 1:50

Richard MacCutchan

22-Oct-09 1:50

muhammad_umair wrote:
Does anyone know the solution to overcome this problem..

Probably yes, but I do not think that they will be writing any C# code to solve it.

Please follow the guidelines[^] and post your question to the correct forum.

Using lock statement inside overloaded methods

Nuno Pacheco22-Oct-09 0:19

Nuno Pacheco

22-Oct-09 0:19

Hello to all.

I'm new in this message board, and I couldn't find this subject elsewhere.
The thing is, I need to know if I can use the lock satement inside an overloaded method, i.e.:

public static string MyString = 0;
private static object objMyLock = new object();

public static void DoSomething(int Index, string Field)
  {
  lock (objMyLock)
    {
    MyString = Field + Index.ToString();
    }
  }

public static bool DoSomething(string Name, string Field)
  {
  lock (objMyLock)
    {
    MyString = Field + Name;
    }
  }

Does the lock Statement used like this, ensures that the variable MyString is changed by one thread at a time?

Thank you!

NMFPacheco - Portugal

Covean22-Oct-09 1:12

Covean

22-Oct-09 1:12

"Does the lock Statement used like this, ensures that the variable MyString is changed by one thread at a time?"

Yes it should ensure.
But I wouldn't work with static objects / methods / etc..

Nuno Pacheco22-Oct-09 1:23

Nuno Pacheco

22-Oct-09 1:23

Thanks for your reply.

"But I wouldn't work with static objects / methods / etc.."

For any special reason? Unsafe code/other, or simply not the best way?

Covean22-Oct-09 1:48

Covean

22-Oct-09 1:48

At first I think, to implement a the basis of little modules/classes, is a better
way to solve problems.
Classes are in general more flexible through inheritance, access rights etc.

Example:

public class MultiThreadingClass
{
    public MultiThreadingClass()
    {
    }

    private object m_objSync = new object();
    private int m_nValueA = 0; 
    private int m_szText = string.Empty;

    public SyncObj
    {
        get 
        { 
            return m_objSync;
        }
    }

    public Value
    {
        get 
        {
            lock(objSync)
            {
                return m_nValue;
            }
        }
        set
        {
            lock(objSync)
            {
                m_nValue = value;
            }
        }
    }

    public Text
    {
        get 
        {
            lock(objSync)
            {
                return m_szText;
            }
        }
        set
        {
            lock(objSync)
            {
                m_szText = value;
            }
        }
    }
}

Thats not the best way to implement it, but out of this class you can be sure of the values (thread-safe). And if you need extern sync you just have to call lock([classInstance].SyncObj);
One more profit is, that you can have more than one instance of this class.

I hope I could explain you a little bit what I meant.

Nuno Pacheco22-Oct-09 2:36

Nuno Pacheco

22-Oct-09 2:36

Thank you Covean,

I did understand and agree with you. But, in my specific case, I can not change the class where I am using the lock.

Besides that, the question is, if it is possible to use the same lock for covering all overloads of the same method.

Nuno