Re: How do I add Selected Cells - C# Discussion Boards

jeweladdict21-Aug-06 8:52

21-Aug-06 8:52

I have a dataset of items (UPC, price, quantity, name) that I would like to combine based on like items. For example, all items with the same name, I would like to combine so that the quantity and prices are changed accordingly. Are there any built in functions that will let me do this? Or do I have to create a routine which will sort the dataset, create a new set, and then go through the old dataset and combine like items and then add to the new dataset?

thanks!

Datarow combining

jeweladdict21-Aug-06 9:50

jeweladdict

21-Aug-06 9:50

I guess this would be more of a datarow combining/merging question./..

Re: dataset sort and combine/consolidate

Nader Elshehabi21-Aug-06 10:59

Nader Elshehabi

21-Aug-06 10:59

Hello

jeweladdict wrote:
Are there any built in functions that will let me do this?

Well, maybe you're talking about Stored Procedures?

Anyway, here is an approach to do something like what you want -even though I don't like it but I can't really think of something better-.

1- Make a datagridview and feed it with your table
2- Sort it according by the name -if that's what you want
3- Iterate through the rows comparing each row with its previous one -except the first row of course-
4- Find similar rows and combine their values, then delete the second one

NB. You don't have to make the DataGridView visible to the user

Please, if someone has a better approach post. I believe there should be a better way. but this should work!

Regards Rose | [Rose]

Re: dataset sort and combine/consolidate

jeweladdict21-Aug-06 12:50

jeweladdict

21-Aug-06 12:50

that works like a charm. Thanks!

Re: dataset sort and combine/consolidate

Nader Elshehabi21-Aug-06 13:28

Nader Elshehabi

21-Aug-06 13:28

Hello

An Even much better approach is to use the DataView class instead of a DataGridView!! Sorry that such a simple solution didn't cross my mind Blush | :O

, I've been awake for almost two days now!!

Regards Rose | [Rose]

How do I add Selected Cells

kornstyle21-Aug-06 8:30

kornstyle

21-Aug-06 8:30

I am using a datagridview control. I want to select multiple cells that contain numbers and add them. What would be the best way to do this?

Thanks.

Re: How do I add Selected Cells

Nader Elshehabi21-Aug-06 11:01

Nader Elshehabi

21-Aug-06 11:01

Hello

int Sum = (int)MyDataTable.Rows[RowIndex].ItemArray[Index].Value + (int)MyDataTable.Rows[SecondRow].ItemArray[SecondIndex].Value;

And so on...
Regards Rose | [Rose]

Re: How do I add Selected Cells

Vitaliy Tsvayer21-Aug-06 12:09

Vitaliy Tsvayer

21-Aug-06 12:09

If I understand you right, you use DataGridView control with MultipleSelect set to true and when you select some cells you want to add numbers within them. To do that you can handle SelectionChanged event like below:

private void dataGridView1_SelectionChanged(object sender, EventArgs e)
{
  foreach (DataGridViewCell cell in dataGridView1.SelectedCells)
  {
    //NOTE: we should check whether value in cell is a numeric value
    //add values of cell
  }
}

BUT, be carefull to check whether selected cells has an integer value!

Vitaliy Tsvayer
Tikle

Re: How do I add Selected Cells

kornstyle22-Aug-06 9:00

kornstyle

22-Aug-06 9:00

Thanks for your help. That worked great.

Is there any way i can make sure the length of a string is dicisable by 9?

Anthony Mushrow21-Aug-06 8:24

Anthony Mushrow

21-Aug-06 8:24

??
A strange request i know, but there it is.

Re: Is there any way i can make sure the length of a string is dicisable by 9? [modified]

Dave Kreskowiak21-Aug-06 8:31

Dave Kreskowiak

21-Aug-06 8:31

You're kidding, right? Or am I missing something? I hope you're asking if it's divisible by 9.

if( str.Length % 9 == 0 )
    return true;
else
    return false;

Or the old way:

if( (float)(str.Length / 9) == (str.Length / 9.0) )
    return true;
else
    return false;

Dave Kreskowiak
Microsoft MVP - Visual Basic

Re: Is there any way i can make sure the length of a string is dicisable by 9?

Anthony Mushrow21-Aug-06 9:01

Anthony Mushrow

21-Aug-06 9:01

Yeah, sorry divisable.

Well the keys are next to each other arn't they?

DLL and Web Service Problem

Phoen2521-Aug-06 7:05

Phoen25

21-Aug-06 7:05

Hello, I have a problem and may be you can help me. I've a DLL in a WS and the same DLL in a winform. I need to invoke a WS method that return for example a Person object, from the winform. The problem is that it can't convert the WS.Person to the DLL.Person. How can I convert that type? I try to cast but I still the errors.

Thanks a lot !!

Re: DLL and Web Service Problem

Vitaliy Tsvayer21-Aug-06 7:45

Vitaliy Tsvayer

21-Aug-06 7:45

What error do you get?

Vitaliy Tsvayer
Tikle

Re: DLL and Web Service Problem

Phoen2521-Aug-06 8:06

Phoen25

21-Aug-06 8:06

The error is Cannot convert the type WS.Person to Dll.Person

Re: DLL and Web Service Problem

Phoen2521-Aug-06 10:10

Phoen25

21-Aug-06 10:10

Any idea?

Re: DLL and Web Service Problem

Vitaliy Tsvayer21-Aug-06 10:58

Vitaliy Tsvayer

21-Aug-06 10:58

Well, first let me explain the reason of this problem.
When you add WebReference to the WebService, proxy class is created with all the types that come from WSDL(generated by ASP.NET for your WebService). BUT, although generated classes have the same fields as your original class from DLL, they are abolutely different entities, that is why you cannot cast from WS.Person to DLL.person for instance.

One of the solutions would be to modify the generated proxy class so that return type of the WebService method is the class from your shared DLL and not generated one. You need to modify Reference.css under Web References.

Another solutions is to write code that takes WS.Person class and creates new DLL.person class by copying all the fields, etc. You could use reflection to shorten the code as all field names are the same in both types.

Maybe there are more elegant solutions, but hope this helps.

Vitaliy Tsvayer
Tikle

Fonts - name/filepath

Gomac21-Aug-06 6:34

Gomac

21-Aug-06 6:34

Hi,

In the Font object I can see no way to retrieve the filepath for a font. (I need to do this as some third party loads fonts from the filepath).

My knowledge of the Win32 API is very scratchy. Is there anyway I can retrieve the filepath for a font in .NET or is there a method on the Win32 API I can invoke to retrieve this information.

Thankyou

Re: Fonts - name/filepath

stancrm21-Aug-06 6:51

stancrm

21-Aug-06 6:51

string fontpath = Environment.SystemDirectory.Replace(@"\system32", "") + @"\Fonts";

SplitContianer. How to customize splitter

Bob_Tasa21-Aug-06 6:23

Bob_Tasa

21-Aug-06 6:23

I want to modify the split container to add a button to the
splitter and to alter the shading of the bar but I can not find any
information on this topic Help?

Bob

DatagridView Custom Column Events

Itanium21-Aug-06 6:19

Itanium

21-Aug-06 6:19

Hi All,

I have created a custom datagridviewColumn control containig a TextBox+Button. I want to access the events of these controls directly, for example TextBox_textChanged, Button_MouseHover.i have found that In DataGridViewButtonColumn we have to access the button through Cell_Click event, but this doesn't resolve my problem. Can someone please tell me how to access the events of controls contained in DataGridViewColumns?

Thanks

sorry for my bad English.

Re: DatagridView Custom Column Events

Nader Elshehabi21-Aug-06 6:26

Nader Elshehabi

21-Aug-06 6:26

Hello

If you've created that custom control then you control its events. You can do this in two approaches:

1- Make a custom event in your custom control. Handle whatever events you want to handle of the button and textbox private inside your control. From these handlers, fire the public event. Now handle that public event in your form.

2- Just declare your button and textbox as public members of your control. Then you will have access to their events as well. Programatically only of course -ie. you may not access their events using the PropertyGrid by default-.

Regards Rose | [Rose]

Regex to fix img tags

Stephen Adam21-Aug-06 6:02

Stephen Adam

21-Aug-06 6:02

Hi there,

I'm writing an XHTML site and i'm using FreeTextBox to do it, unfortunately is has a nasty habbit of breaking XHTML rules with upper case tags and removing closing slashes from image tags.

Now i've written a function which fixes allot of HTML errors which it (or the user) may create. The functionalitu i'm missing is a regex which will turn

<img src="foo" alt="foo" title="foo" anyotherattribute="anyother value" >

into

<img src="foo" alt="foo" title="foo" anyotherattribute="anyother value" />

Can anyone supply a regex replace pattern which will do this?

This is my function so far in case anyone else finds it useful.

public static string MakeHTMLValid(string strInput)
{
strInput = Regex.Replace(strInput, "<P>", "<p>");
strInput = Regex.Replace(strInput, "</P>", "</p>");
strInput = Regex.Replace(strInput, "<EM>", "<em>");
strInput = Regex.Replace(strInput, "</EM>", "</em>");
strInput = Regex.Replace(strInput, "<DIV", "<div");
strInput = Regex.Replace(strInput, "</DIV>", "</div>");
strInput = Regex.Replace(strInput, "<IMG", "<img");
strInput = Regex.Replace(strInput, "<LI", "<li");
strInput = Regex.Replace(strInput, "</LI>", "</li>");
strInput = Regex.Replace(strInput, "<H1>", "<h1>");
strInput = Regex.Replace(strInput, "</H1>", "</h1>");
strInput = Regex.Replace(strInput, "<H2", "<h2");
strInput = Regex.Replace(strInput, "</H2>", "</h2>");
strInput = Regex.Replace(strInput, "<H1 class=HeadingOne>", "<h1 class=\"HeadingOne\">");
strInput = Regex.Replace(strInput, "<P class=MsoNormal>", "<p class=\"MsoNormal\">");
strInput = Regex.Replace(strInput, "<UL", "<ul");
strInput = Regex.Replace(strInput, "</UL>", "</ul>");
strInput = Regex.Replace(strInput, "<BR>", "<BR />");
strInput = Regex.Replace(strInput, "<BR />", "<br />");
strInput = Regex.Replace(strInput, "<BR>", "<br />");
strInput = Regex.Replace(strInput, "<br>", "<br />");
strInput = Regex.Replace(strInput, "class=normalText", "class=\"normalText\"", RegexOptions.IgnoreCase);
strInput = Regex.Replace(strInput, "</A>", "</a>");
strInput = Regex.Replace(strInput, "<HR>", "<hr />",RegexOptions.IgnoreCase);
strInput = Regex.Replace(strInput, "<A ", "<a ");
strInput = Regex.Replace(strInput, "<SPAN", "<span");
strInput = Regex.Replace(strInput, "</SPAN>", "</span>");
return strInput;
}

"Gödel proved that any formal system that defines the primitive recursive functions must be either incomplete or inconsistent. In particular one could not prove from within the system that the system itself was consistent even though the question could be formulated within the system."

Re: Regex to fix img tags

User 665821-Aug-06 6:33

User 6658

21-Aug-06 6:33

Parsing nested tags with regular expressions is not a trivial task, but for the tag it should work fine:

string to find: <img(?<content>[^>]+)>
string to replace: <img${content} />

regards

modified 12-Sep-18 21:01pm.

Re: Regex to fix img tags

Stephen Adam22-Aug-06 2:34

Stephen Adam

22-Aug-06 2:34

Thanks for that it worked like a charm Smile | :)

"Gödel proved that any formal system that defines the primitive recursive functions must be either incomplete or inconsistent. In particular one could not prove from within the system that the system itself was consistent even though the question could be formulated within the system."

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