Re: Swap items in a list - C# Discussion Boards

Re: Multiple column soritng on filtered datagridview

polachan23-Feb-12 12:17

23-Feb-12 12:17

Many thanks for the reply . Please can you advice how to impliment custom multiple column filter in c# . The user will select the columns to sort

for example if the datagridview has code, name , rank it is filtered . and the user will give the priority of the column to sort

Either user will first sort rank then name and code . He will decide the order

Please advice how I can impliment

Re: Multiple column soritng on filtered datagridview

Pete O'Hanlon23-Feb-12 12:35

Pete O'Hanlon

23-Feb-12 12:35

Are you writing code for a living here. It sounds like you are trying to get us to write all your code for you. At some point you are either going to have to learn this stuff for yourself, or admit you are in the wrong career.

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos

My blog | My articles | MoXAML PowerToys | Mole 2010 - debugging made easier - my favourite utility

Re: Multiple column soritng on filtered datagridview

polachan24-Feb-12 3:11

polachan

24-Feb-12 3:11

I am admitting that , I am getting wrong reply and in appropriate answer .

I am also admitting that I am learning and also I am trying to use C# effectively with the advice from C# experts . If you dodnt want , you can ignore my question. I understand, all support forum is also other way of learning suit.

video chatting using udp

Hinnawi8723-Feb-12 2:51

Hinnawi87

23-Feb-12 2:51

I want to know how to use udp protocol in creating video chatting project using c#

Re: video chatting using udp

BobJanova23-Feb-12 2:54

BobJanova

23-Feb-12 2:54

Don't. Use TCP. A chat session is intrinsically a persistent and streamed connection, and is perfectly suited for TCP. If you use UDP you'll just have to rewrite most of TCP.

Re: video chatting using udp

harold aptroot23-Feb-12 3:51

harold aptroot

23-Feb-12 3:51

A chat session in text would be, but no one streams video over TCP. Ok some do, but they are wrong. The dropped packets represent an irrelevant couple of millisecond, or at worst a slight hickup, a retransmission would introduce an epic lag. Certainly not suited for TCP.

The OP would have to rewrite most of RTP though .. or use RTP. (over UDP of course)

Swap items in a list

nitin_ion23-Feb-12 2:09

nitin_ion

23-Feb-12 2:09

i am creating a list like this

vd.Department = (from dept in vd.Employees
                            select new Department
                            {
                                DepartmentID = dept.DivisionID,
                                DepartmentShortName = dept.Division
                            }).Distinct();

DepartmentShortName will have multiple values [Accounts, Production, Technical etc..]
What i want to do is to change the values so if it is Accounts =1, Production = 2.

How can i change this without doing foreach loop?

Re: Swap items in a list

BobJanova23-Feb-12 2:53

BobJanova

23-Feb-12 2:53

Set up a map:
Map<string, int> divisions = { "Accounts" => 1, "Production" => 2, ... etc };
(you can do this once, probably in a static initialiser)

and then use it in the query:

vd.Department = (from dept in vd.Employees
                            select new Department
                            {
                                DepartmentID = dept.DivisionID,
                                DepartmentShortName = dept.Division,
                                DivisionIndex = divisons[dept.Division]
                            }).Distinct();

Re: Swap items in a list

BillWoodruff24-Feb-12 20:53

BillWoodruff

24-Feb-12 20:53

Bob, please excuse my ignorance here, but is this Map code SQL ? Or am I hallucinating C# has a type of object similar to Dictionary I've never heard of before ? At first I thought "VB," but, then, the presence of semi-colons in both OP's, and your code, ruled that out.

Please enlighten.

thanks, Bill

"Every two days we create as much information as we did from the dawn of civilization up until 2003". Eric Schmidt of Google.

how to avoid string notation from filter

polachan23-Feb-12 2:01

polachan

23-Feb-12 2:01

Hi all,

first thing , Sorry for posting my question again as another thread.

ResultFilterExpression = this.DataGridViewColumn.DataPropertyName + "not IN (" + FilterValue + @")";.

The above filter is working fine but only the problem , I have to give the filter parameter as NOT IN('CATAGORYA,'CATAGORYB') instead of NOT IN (CATAGORYA, CATAGORYB)
How I can modify the above filter condition for that

Pls help
Pol

Re: how to avoid string notation from filter

GParkings23-Feb-12 5:14

GParkings

23-Feb-12 5:14

if i understand the question you want to convert "CATAGORYA, CATAGORYB" to "'CATAGORYA,'CATAGORYB'" (i.e. wrap the individual values in single quotes)

try

string[] values = FilterValue.Split(',');
StringBuilder bldr = new StringBuilder();
bool isFirst = true;

foreach (string s in values)
{
    if (!isFirst)
    {
        bldr.Append(",");
    }

    bldr.Append(string.Format("'{0}'", s));

    isFirst = false;
}

FilterValue = bldr.ToString();

Pedis ex oris
Quidquid latine dictum sit, altum sonatur

Re: how to avoid string notation from filter

polachan23-Feb-12 6:23

polachan

23-Feb-12 6:23

Many Thanks
Working fine

Datagridview filter using 'IN' and ' NOT IN' Pls urgent

polachan22-Feb-12 23:32

polachan

22-Feb-12 23:32

Anybody can help me to sort out this problem
When I give multiple value , it doesnot filter for example

case "in":
ResultFilterExpression = this.DataGridViewColumn.DataPropertyName + " IN ('" + FilterValue + @"')";
break;

It works only one parameter . After comma it will not work

For example the catagory column, When I give

in('CatagoryA') - it will work but
in('CatagoryA, CatagoryB) - it doesnot work

Pls you or anybody can give a solution it would be appreciate.

With Thanks
Pol

Re: Datagridview filter using 'IN' and ' NOT IN' Pls urgent

Shameel22-Feb-12 23:45

Shameel

22-Feb-12 23:45

You've already asked the question. Repeating questions does not guarantee a quicker response. See my response to your other post.

Re: Datagridview filter using 'IN' and ' NOT IN' Pls urgent

Abhinav S23-Feb-12 0:00

Abhinav S

23-Feb-12 0:00

Do not repost.

To filter datagridview using like IN and NOT IN

polachan22-Feb-12 20:50

polachan

22-Feb-12 20:50

Hi I want to add 'IN' and 'NOT IN' condition along with following program to filter datagridview

case "LIKE": ResultFilterExpression = this.DataGridViewColumn.DataPropertyName + " LIKE '%" + FilterValue + "%'"; ResultFilterCaption += "\n = '.." + FilterValue + "..'"; break;I want to add the condition 'IN' and 'NOT IN' filter cindition with datagridview Please help

FilterValue = 'A','B'

case filter = "IN"

ResultFilterExpression = this.DataGridViewColumn.DataPropertyName + " IN + FilterValue + ";

case filter = "NOT IN"

ResultFilterExpression = this.DataGridViewColumn.DataPropertyName + "not IN + FilterValue + ";

Please how I can impliment the filter 'IN' condition with datagridview.

With Thanks

Re: To filter datagridview using like IN and NOT IN

Abhinav S22-Feb-12 21:21

Abhinav S

22-Feb-12 21:21

Try ResultFilterExpression = this.DataGridViewColumn.DataPropertyName + "not IN (" + FilterValue + @")";.
Here filtervalue is should be a list of comma separated values e.g 1,2,3,4.

Re: To filter datagridview using like IN and NOT IN

Member 370819022-Feb-12 23:24

Member 3708190

22-Feb-12 23:24

Thats not working I given your code as follows. It should be string

case "in":
ResultFilterExpression = this.DataGridViewColumn.DataPropertyName + " IN ('" + FilterValue + @"')";
break;

It works only one parameter . After comma it will not work

For example the catagory column, When I give

in('CatagoryA') - it will work but
in('CatagoryA, CatagoryB) - it doesnot work

Pls you or anybody can give a solution it would be appreciate.

With Thanks
Pol

Re: To filter datagridview using like IN and NOT IN

Shameel22-Feb-12 23:43

Shameel

22-Feb-12 23:43

Member 3708190 wrote:
in('CatagoryA, CatagoryB)

should be

Member 3708190 wrote:
in('CatagoryA', 'CatagoryB')

Re: To filter datagridview using like IN and NOT IN

polachan23-Feb-12 0:16

polachan

23-Feb-12 0:16

I tried by both

"CatagoryA"
'CatagoryA'

but not working

Re: To filter datagridview using like IN and NOT IN

polachan23-Feb-12 0:21

polachan

23-Feb-12 0:21

Very Sorry It is working fine, Many Many Thanks.

Please

How the condition in code can be modified by way to avoid the giving string notation " " in filter .

Just we need to give like CatagoryA, CatagoryB. not 'CatagoryA','CatagoryB'

Many Many Thanks
Pol

Re: To filter datagridview using like IN and NOT IN

Shameel23-Feb-12 2:20

Shameel

23-Feb-12 2:20

Strings must always be enclosed within delimiters (either ' or "). How else can the expression parser know the beginning and end of the string?

Re: To filter datagridview using like IN and NOT IN

polachan23-Feb-12 4:52

polachan

23-Feb-12 4:52

after comma will start another catagory. There is no any comma inside the name of a catagory.
So after the comma will start another catagory. Only thing I have to put the " mark before and after of each comma.

I am beginner in C# . So I am seeking a help
With many thanks
Pol

Re: To filter datagridview using like IN and NOT IN

Shameel23-Feb-12 8:22

Shameel

23-Feb-12 8:22

You cannot do that. That is how strings work in programming, they need a delimiter.

Re: To filter datagridview using like IN and NOT IN

Abhinav S23-Feb-12 0:00

Abhinav S

23-Feb-12 0:00

Try with "" on the CategoryA.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.