|
Hello
If you want general lessons about C# try This link[^]
If you want only web development Try these videos[^]
For more google for "C# tutorials"
Regards![Rose | [Rose]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/rose.gif)
|
|
|
|
|
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!
|
|
|
|
|
I guess this would be more of a datarow combining/merging question./..
|
|
|
|
|
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
|
|
|
|
|
that works like a charm. Thanks!
|
|
|
|
|
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 , I've been awake for almost two days now!!
Regards
|
|
|
|
|
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.
|
|
|
|
|
Hello
int Sum = (int)MyDataTable.Rows[RowIndex].ItemArray[Index].Value + (int)MyDataTable.Rows[SecondRow].ItemArray[SecondIndex].Value;
And so on...
Regards
|
|
|
|
|
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)
{
}
}
BUT, be carefull to check whether selected cells has an integer value!
Vitaliy Tsvayer
Tikle
|
|
|
|
|
Thanks for your help. That worked great.
|
|
|
|
|
??
A strange request i know, but there it is.
|
|
|
|
|
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
|
|
|
|
|
Yeah, sorry divisable.
Well the keys are next to each other arn't they?
|
|
|
|
|
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 !!
|
|
|
|
|
What error do you get?
Vitaliy Tsvayer
Tikle
|
|
|
|
|
The error is Cannot convert the type WS.Person to Dll.Person
|
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
string fontpath = Environment.SystemDirectory.Replace(@"\system32", "") + @"\Fonts";
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
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]](https://www.codeproject.com/script/Forums/Images/rose.gif)
|
|
|
|
|
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."
|
|
|
|
|
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.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
