|
The DotNet helpfile does not explicitly state a limit on the number of columns. Some time ago I had the same questions 'how many columns can I add' so I wrote a simpel loop.
I was able to add more than 10,000 columns with unique names and of object type, so your 3,000 should be possible.
So the question becomes, how is it failing? What is the error message you are getting? Without this information we are just playing a guessing game. So please let us know...
Here are a few simple things to check:
Are you sure all your columnnames are unique?
Are you running out of memory? (How much memory are you consuming when the addition fails.)
Do you have any rows in the table already is is the table empty?
Thanx.
(EDIT: So I was a little slow typing this response, not changing the text though)
|
|
|
|
|
I would like to update the progress bar of form2 from MyClass.. please help me.. Thank in advance.
public partial class Form2 : Form
{
public Form2()
{
InitializeComponent();
}
private void Form2_Load(object sender, EventArgs e)
{
}
public ProgressBar ProgressBar
{
get { return this.progressBar; }
set { this.progressBar = value; }
}
}
class MyClass
{
void DoaLengthyJob()
{
int i=0;
while ( {
Form2 f = new Form2;
f.ProgressBar =i;
i++
}
}
}
|
|
|
|
|
You should make DoALengthyTask a public method with a Parameter that takes an instance of a progressbar, then when you call the method just pass in the progressbar property you created :-
public partial class Form1 : Form
{
public ProgressBar Progress { get; set; }
public Form1()
{
InitializeComponent();
MyClass myClass = new MyClass();
myClass.DoALengthyTask(Progress);
}
}
class MyClass
{
public void DoALengthyTask(ProgressBar progress)
{
int i=0;
while (true)
{
progress.Value = i;
i++;
}
}
}
Hope this helps
When I was a coder, we worked on algorithms. Today, we memorize APIs for countless libraries — those libraries have the algorithms - Eric Allman
|
|
|
|
|
Sorry .. here is more info.
<pre lang="cs">public partial class Form2 : Form
{
public Form2()
{
InitializeComponent();
}
private void Form2_Load(object sender, EventArgs e)
{
}
public ProgressBar ProgressBar
{
get { return this.progressBar; }
set { this.progressBar = value; }
}
}
class MyClass
{
void InitLengthyJob()
{
private void BackgroundWorker1_DoWork(
object sender,
System.ComponentModel.DoWorkEventArgs e)
{
DoaLengthyJob();;
}
}
void DoaLengthyJob()
{
int i=0;
DoaLengthyJob()
Form2 f = new Form2;
f.ProgressBar =i;
i++
}
}
|
|
|
|
|
ptr_Electron wrote:
void DoaLengthyJob()
{
int i=0;
while ( {
Form2 f = new Form2;
f.ProgressBar =i;
i++
}
}
There are a couple of issues here:
1. You are not showing the form at all (maybe you ar showing another instance of the Form2 class, but that doesn't help, they are distinct, and so are the progress bars)
2. a lengthy job should not run on the main thread as it would block the GUI, resulting in poor behavior: no window repainting, unable to move/resize the window, etc. You should use a different thread for long operations, a BackgroundWorker could help here.
3. And then, another thread shouldn't directly create or touch WinForm Controls. You need some kind of Invoke, see here[^].
|
|
|
|
|
Sorry .. here is more info.
<pre lang="cs">public partial class Form2 : Form
{
public Form2()
{
InitializeComponent();
}
private void Form2_Load(object sender, EventArgs e)
{
}
public ProgressBar ProgressBar
{
get { return this.progressBar; }
set { this.progressBar = value; }
}
}
class MyClass
{
void InitLengthyJob()
{
private void BackgroundWorker1_DoWork(
object sender,
System.ComponentModel.DoWorkEventArgs e)
{
DoaLengthyJob();;
}
}
void DoaLengthyJob()
{
int i=0;
DoaLengthyJob()
Form2 f = new Form2;
f.ProgressBar =i;
i++
}
}
|
|
|
|
|
OK you fixed one issue, now deal with #1 and #3.
And read up on BackgroundWorker and how it helps you in reporting progress.
|
|
|
|
|
Hi
Not sure if this is the right forum for this as its more of a general question, but it didnt seem to fit any other category, and since I am looking for a c# solution....
I am looking for ideas to handle possessive case for a multi-lingual site.
e.g
John Smith's photo's (the 's after smith).
Since the name is what the user entered, and in this case IN ENGLISH it requires an 's to make it possessive, but in some cases it will just require an apostrophe, without the (s).
Doing this for a single language is easy enough when you know the rules, but how would you implement this on a site using Localization?
Is there a better way than hard-coding the language rules per culture code?
Thanks
|
|
|
|
|
I don't think you can do that a generic solution. In English it's easy, but in Polish you would have something like this:
The name: "Jan Kowalski".
Possessive case: "Jana Kowalskiego".
You see, in Polish we have 7 (seven) cases. And those are applied to both first name and last name.
Similar situation also applies to Russian, Czech and other Slavic languages. Don't know many others, but generally, you can't create generic solution for all languages.
Don't forget to rate answer, that helped you. It will allow other people find their answers faster.
|
|
|
|
|
Thanks, I figured that would be the case.
I was just wondering if there was a better way than a whole bunch of "ifs" for each language we implement.
|
|
|
|
|
Well... Another way could be to do with String.Format.
<br />
string.Format(formattingString, "John Smith");<br />
And now for English you can have resource: "{0}'s photos".
For Polish you could have: "Zdjęcia należące do użytkownika {0}".
And although it is quite long, it is grammatically valid.
But you have to create a version for each language you support 
Don't forget to rate answer, that helped you. It will allow other people find their answers faster.
|
|
|
|
|
I am creating an organizer with basic add/delete/edit functions. I need to create an animated agent which talks to the user. I am stuck.
Any help guys? I'm really stuck 
|
|
|
|
|
What is it that you are stuck with exactly? Have you tried one of the CodeProject articles[^] on the subject?
Bastard Programmer from Hell 
|
|
|
|
|
why not just ask Clippy, it is his job after all?
|
|
|
|
|
|
I used to like his antics!
The difficult we do right away...
...the impossible takes slightly longer.
|
|
|
|
|
I am not too sure where to start, I have created a project in c# which is an organizer. I now need to add the agent to this which will make it easier for a user to use the software created. It must be animated and be able to speak to the user through a verbal means. I have looked at some articles but I still am confused. I am using Visual Studio 2010 c# Express and wondered what ways I could incoorperate an animated agent into this
|
|
|
|
|
macantony wrote: I am not too sure where to start
By reading the article I linked; it explains how to program against the Agent API.
macantony wrote: I have looked at some articles but I still am confused.
Well, if it's something specific that you're confused about then we can look into that. If the concept is still vague, then you'd have to follow one of the articles from top to bottom.
Programming an agent isn't explained with a few code-snippets, but you could have a nice result in a few days if you follow the article.
Bastard Programmer from Hell
|
|
|
|
|
Note 1: I just became aware of Luc Patyn's very interesting article: "WinForms AutoScroll Experiment"[^], and am diligently studying that code to see if it would meet my needs in this scenario.
Note 2: I thought about posting this on the WinForms forum, but that forum doesn't see much action, and, I consider it vaguely possible that a similar problem may occur in WPF/SilverLight (poor excuse ?).
Imagine you have a large Panel that fills most of a Form, the OuterPanel: at run-time you are creating/adding Panels into the Controls collection of the OuterPanel, and they are Docked Left. You put a custom drawn border around these inner Panels.
And, you have the auto-scroll property of the OuterPanel set to 'true.
At the point where a new inner Panel is added that exceeds the visible extent of the width of the OuterPanel, the Horizontal ScrollBar will automatically appear.
Unfortunately the H-Scrollbar appearing also reduces the vertical internal size of the OuterPanel's effective display area by about 17 pixels, which can result in the bottoms of your docked inner Panels being 'clipped' out of view.
I have a work-around for this based on detecting the change in the OuterPanel's size, and then just increasing the OuterPanel's height by 17 pixels, but that's ... errr ... not very elegant, since you've got a visible "bump" in the UI. I suppose I could enumerate the inner Panels and shrink their height, also, but I find that equally revolting a thought
The beauty of using Docking is the auto-alignment and re-sizing you get, the downside is you eliminate the other nice features provided by the 'Margin and 'Padding properties of controls.
I would love to have a set of DockedMargin and DockedPadding properties that paralleled the Margin and Padding properties for undocked controls !
I assume there is, but haven't tried to find, some pInvoke that could force a Panel to always show the horizontal scrollbar. I'd consider that a "last resort."
Any ideas ?
thanks, Bill
Scipio: "That's true, Berganza; and what makes the miracle greater is, that we not only speak, but hold intelligent discourse, as though we had souls capable of reason; whereas we are so far from having it, that the difference between brutes and man consists in this, that man is a rational animal, and the brute is irrational." Cervantes, "Colloquy of Dogs," 1613CE. The two talking dogs, Scipio, Berganza, are hallucinations in the mind of a soldier with plague fever undergoing a "sweating" cure.
modified 27-Nov-11 9:14am.
|
|
|
|
|
Who needs pInvoke?
myPanel.HorizontalScroll.Visible = true;
Ideological Purity is no substitute for being able to stick your thumb down a pipe to stop the water
|
|
|
|
|
How I wish this would work ! In my innumerable experiments I found:
1. if AutoScroll is set to 'true, setting both Visible and Enabled properties of somePanel.HorizontalScroll will have no effect.
2. if AutoScroll is set to 'false: yes, the HorizontalScrollBar can be forced to appear, as you show, but does not move the Panel when scrolled, at least not in my OuterPanel, which is completely filled at any moment in time with Docked inner Panels.
So, okay, you implement the Scroll Event, and as I drag the scroller, I can monitor the changing values of its position: they are changing.
But, when I mouse-up on the scroller, after moving it: it snaps back to far-left position in the scrollbar, and the Panel is not scrolled at any time !
I also tried, in the code in the main Form that creates a new inner Panel, and inserts it in the OuterPanel, calling:
OuterPanel.ScrollIntoView(newInnerPanel);
OuterPanel.Invalidate(); No result, there, either.
Which is why I did not pursue use of the Scroll event, or ScrollIntoView.
I appreciate your response, and perhaps I should re-direct my attention to: when a new inner panel is added, calculating where its right border is in OuterPanel co-ordinates, and trying to somehow force the horizontal scrollbar position so that the newly added inner Panel is fully visible ?
But, will "forcing" the h-scrollbar scroller position require a pInvoke, and/or actually move the Panel ? mmmm ...
At least when AutoScroll is set to 'true, and the scrollbar appears, the Panel will be moved when you move the scroller.
Looking forward to your continuing exercise of your (greatly admired) skills in finding the 'blind spots' in code.
thanks, Bill
"Anyone who shows me my 'blind spots' gives me the gift of sight." ... a thought from the shallows of the deeply shallow mind of ... Bill
|
|
|
|
|
Hey - you only said you wanted it to show the horizontal scroll bar! 
Ideological Purity is no substitute for being able to stick your thumb down a pipe to stop the water
|
|
|
|
|
One bullet to add to the forum guidelines: don't make your answer way shorter than the question was, right or wrong, it is just too discouraging for the enquirer...
|
|
|
|
|
So "Yes." is out of the question then?
Ideological Purity is no substitute for being able to stick your thumb down a pipe to stop the water
|
|
|
|
|
indeed.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
![Java | [Coffee]](https://codeproject.global.ssl.fastly.net/script/Forums/Images/coffee.gif)
