Re: Length of a column of an SQL Table - C# Discussion Boards

Endien16-Jun-10 8:35

Endien

16-Jun-10 8:35

Thank you David for the reply.

Yes, i will keep it on my mind about BackgroundWorker. Until now, i had not use BackgroundWorker at my "large code" but suppose if i'm having trouble with the UI, i will try the BackgroundWorker.

Luc Pattyn16-Jun-10 6:57

Luc Pattyn

16-Jun-10 6:57

if you want a number of operations to be executed in sequence, but without freezing your GUI, you need exactly one extra thread (Thread, ThreadPool thread, BackgroundWorker) that executes those operations one after the other.

And your GUI thread should never wait on them (nor on anything else) and not call Thread.Join(); instead you should keep your GUI active, however also disable the features you want disabled for as long as the other thread is working for you.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use < PRE > tags for code snippets, it preserves indentation, and improves readability.

Endien16-Jun-10 7:30

Endien

16-Jun-10 7:30

Thank you for the reply Luc.

Ok, i see there's 3 key point here to solve the problem :

1. Thread
2. ThreadPool
3. BackgroundWorker

I will investigate it further.

Length of a column of an SQL Table

Luc Pattyn16-Jun-10 7:34

Luc Pattyn

16-Jun-10 7:34

Endien wrote:
3 key point here to solve the problem

No, the key points are to keep the GUI/main thread free, never to block it, and to hire as many other team players as you need, no more, no less.

The exact type of your additional team player is of minor importance. BackgroundWorker is slightly harder to set up, but offers advantages for reporting progress, completion, and exceptions.

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use < PRE > tags for code snippets, it preserves indentation, and improves readability.

Sebastian T Xavier16-Jun-10 5:58

Sebastian T Xavier

16-Jun-10 5:58

Hello...

How can I get the Length of a column of an sql table from my C# code....
In my application I am using databound controls. I want to know the length of the field in UI.
any help would be appreciated...

Thanks

Sebastian

Re: Length of a column of an SQL Table

Adam R Harris16-Jun-10 6:43

Re: Length of a column of an SQL Table

16-Jun-10 6:43

Query the schema of the table.
http://www.mayvelous.com/2008/02/13/listing-tables-and-columns-in-sql-2005-using-information-schema/[^]

The info in this article is specific to sql 2005, but it should still apply to other versions.

If at first you don't succeed ... post it on The Code Project and Pray.

PIEBALDconsult16-Jun-10 13:29

PIEBALDconsult

16-Jun-10 13:29

See this[^] recent thread.

Re: Length of a column of an SQL Table

Sebastian T Xavier16-Jun-10 22:52

Sebastian T Xavier

16-Jun-10 22:52

Thanks a lot

ToolStrip Background Color -- How do I make it the default color?

Susan Crayne16-Jun-10 5:50

Re: ToolStrip Background Color -- How do I make it the default color?

16-Jun-10 5:50

When I install the Code Project search toolbar, its background color is the default color for the Windows os it's running in -- that is, gray for XP, blue for Vista. I have made my own toolbar with a toolstrip in a Band Object, and everything works fine, except that I cannot get the background color to be the default. I can make a bitmap for the background, but if someone changes their theme my toolbar will then be the wrong color.

Susan

Adam R Harris16-Jun-10 6:40

Re: ToolStrip Background Color -- How do I make it the default color?

16-Jun-10 6:40

System.Drawing.SystemColors.WindowFrame Maybe ?
SystemColors Members[^]

If at first you don't succeed ... post it on The Code Project and Pray.

Susan Crayne16-Jun-10 7:29

Re: ToolStrip Background Color -- How do I make it the default color?

16-Jun-10 7:29

I tried WindowFrame, and a whole bunch of others, none of which look like the color of the toolbars in Vista, which is my development operating system.

Adam R Harris16-Jun-10 8:35

Re: ToolStrip Background Color -- How do I make it the default color?

16-Jun-10 8:35

Well i'm out of ideas ..... Is it just the transparency of the toolbar that is making the colours differant? or is the colour just way off?

If at first you don't succeed ... post it on The Code Project and Pray.

Susan Crayne16-Jun-10 10:37

Re: ToolStrip Background Color -- How do I make it the default color?

16-Jun-10 10:37

The color is way off -- but I'm not sure I understand what you mean by the transparency of the toolbar.

Adam R Harris16-Jun-10 12:17

Re: ToolStrip Background Color -- How do I make it the default color?

16-Jun-10 12:17

Well on Vista & 7 the toolbars have a slight transparency to them (Areo) which could mess with the colour.

Just a thought, have you tried enabling themes. I can't remeber where but I recal that being an issue with something I was working on awhile ago. I can't remember the object or actual property but I do remeber it was a problem. Might not help ... but you never know.

If at first you don't succeed ... post it on The Code Project and Pray.

Susan Crayne17-Jun-10 7:41

Re: ToolStrip Background Color -- How do I make it the default color?

17-Jun-10 7:41

Thanks for the tip. I did some research and found the "Application.EnableVisualStyles" method. I called it from the constructor of my toolbar, and after I called it I displayed "Application.RenderWithVisualStyles", the value of which was true. However, my toolbar and its controls are still gray. Do you know how I should be setting the background color to work with EnableVisualStyles?

Susan

Susan Crayne17-Jun-10 9:56

best way for onlne meeting

17-Jun-10 9:56

Now I have the controls painting in default Vista style, but the toolstrip itself is not.

Jassim Rahma16-Jun-10 5:10

Re: best way for onlne meeting

16-Jun-10 5:10

I want to know what's the best way to make a windows form application in C# to connect people for online meeting? and what are tools available; for that?

Ravi Bhavnani16-Jun-10 6:09

Ravi Bhavnani

16-Jun-10 6:09

The best way would be to design a client/server conferencing system that can handle duplex communication of audio, video and text, membership, authentication, and perhaps encryption. Some technologies you may want to examine are WCF, RIA services and Silverlight.

This is a non-trivial endeavour - your question is too open ended to provide a direct answer.

/ravi

My new year resolution: 2048 x 1536
Home | Articles | My .NET bits | Freeware

ravib(at)ravib(dot)com

Re: best way for onlne meeting

Luc Pattyn16-Jun-10 6:22

Luc Pattyn

16-Jun-10 6:22

Maybe use WebBrowser and Google Buzz?

Smile | :)

Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

Please use < PRE > tags for code snippets, it preserves indentation, and improves readability.

40 characters to let.

analog clock

Jassim Rahma16-Jun-10 5:05

16-Jun-10 5:05

I want to know how can I place the current time using analog clock on my windows form?

Re: analog clock

Johnny J.16-Jun-10 5:10

Johnny J.

16-Jun-10 5:10

What are you talking about?

Nevertheless, there are a lot of analog clocks here on the CP. A couple of links:

Yet Another Analog Clock[^]

Analog Clock Control[^]

If you search for articles using the search word "analog clock", you will get 6 pages of links. There are A LOT - some good looking, others less good looking...

Re: analog clock

Jassim Rahma16-Jun-10 5:53

URGENT HELP PLZ: many erros!!!

16-Jun-10 5:53

i was trying to do it my self Smile | :)

Re: analog clock

Johnny J.16-Jun-10 6:06

Johnny J.

16-Jun-10 6:06

OK, I misunderstood. But then you ought to post a more concrete question ("My problem is this...") instead of "How do I make an analog clock control"

The answer to the last question will always be "find an article and see how it's done there", because nobody is going to write a novel containing full explanations of what you should do.

If you have a specific, broken down problem, however... That's something people can help you with.

Jassim Rahma16-Jun-10 4:06