C# Discussion Boards - CodeProject

Manish7922-Sep-09 2:50

22-Sep-09 2:50

Dear Thanks for ur reply.
I have one Table Name Element.in this I Have to insert 32element.Everye element have diffrent Values for that I am using 150 TxtBox.

Thanks

Re: Bind txt Box to database

Programm3r22-Sep-09 3:00

Programm3r

22-Sep-09 3:00

Huh ?

Manish79 wrote:
Everye element have diffrent Values for that I am using 150 TxtBox

And all these elements must be shown to the user?? Maybe make use of a different control instead of TextBoxes...

Kind regards,

The only programmers that are better C# programmers, are those who look like this -> Green Alien | [Alien]

Programm3r
My Blog: ^_^

Re: Bind txt Box to database

Manish7922-Sep-09 3:14

Manish79

22-Sep-09 3:14

Dear Can u pls suggest me how i can do with other

Re: Bind txt Box to database

Programm3r22-Sep-09 3:19

Programm3r

22-Sep-09 3:19

Like the other member are saying ... it is very hard to help. We aren't exactly sure what you are trying to accomplish. You must try and explain your problem better.

Regards,

The only programmers that are better C# programmers, are those who look like this -> Green Alien | [Alien]

Programm3r
My Blog: ^_^

Re: Bind txt Box to database

Keith Barrow22-Sep-09 3:16

Keith Barrow

22-Sep-09 3:16

Your question is not clear at all. Are the lengths of the table column 32 and the textbox 150 characters? Is the width of the text box 150px? (If so, you can restict the number of characters to 32 to help.

As for binding, try googling the phrase "c# textbox binding", you get lots of results.

Re: Bind txt Box to database

Manish7922-Sep-09 3:23

Manish79

22-Sep-09 3:23

Dear Kaafb,
Thanks for ur reply,
I have one Table name Element.In this I want to insert 32Rows with 6 coloumns.For that I am using Textboxes.

Re: Bind txt Box to database

Programm3r22-Sep-09 3:31

Programm3r

22-Sep-09 3:31

I think you must have a look at the following tutorials:

The C# Station ADO.NET Tutorial[^]

DataView Binding to TextBox[^]

Regards,

The only programmers that are better C# programmers, are those who look like this -> Green Alien | [Alien]

Programm3r
My Blog: ^_^

Re: Bind txt Box to database

OriginalGriff22-Sep-09 3:32

OriginalGriff

22-Sep-09 3:32

The last time I looked, 32 * 6 wasn't 150. Why 150 textboxes (we ask again)?

No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.

This message is made of fully recyclable Zeros and Ones

Re: Bind txt Box to database

Manish7922-Sep-09 3:46

Manish79

22-Sep-09 3:46

yah it's32*6=192 Text Boxes

Re: Bind txt Box to database

Keith Barrow22-Sep-09 3:50

Keith Barrow

22-Sep-09 3:50

This is far too many for the user to comprehend or fill in reliably in one go.
At the very least I suggest you create a wizard to enter each row at a time and ensure they add 32 rows somehow. Better yet, it sounds like an interface re-design might be appropiate.

Re: Bind txt Box to database

OriginalGriff22-Sep-09 3:56

OriginalGriff

22-Sep-09 3:56

As keefb says, that is way too many. Plus, what happens when suddenly you need to up it from 32 to 40 rows? Or add another column? Just what are you going to call these textboxes, that makes it easy to work out what is going on?

Think again. When did you see a database example that used textboxes for each row? What do database examples use?

No trees were harmed in the sending of this message; however, a significant number of electrons were slightly inconvenienced.

This message is made of fully recyclable Zeros and Ones

Re: Bind txt Box to database

Robert_Pan22-Sep-09 4:13

Robert_Pan

22-Sep-09 4:13

Total of 720 controls on the page, and I need the same functionality

Custom progressbar doesn't update

teknolog12322-Sep-09 1:56

teknolog123

22-Sep-09 1:56

Hi there,

I use a custom progressbar with text in a custom control and I update the text with a timer.The text is shown and everything works but the text over the progressbar mess up instead of being updated.When I minimize the main form and maximize it back, it updates. All of my attempts(using update(),refresh() and invalidate()) are useless.Could you please tell me what I should do?
note: I use the same control on another form but this time not in a custom control and it works like a charm

Re: Custom progressbar doesn't update

Programm3r22-Sep-09 3:21

Programm3r

22-Sep-09 3:21

Is it possible to post some of the code?

Regards,

The only programmers that are better C# programmers, are those who look like this -> Green Alien | [Alien]

Programm3r
My Blog: ^_^

Re: Custom progressbar doesn't update

teknolog12322-Sep-09 4:02

teknolog123

22-Sep-09 4:02

//this code is in a custom control's class and the custom control is in main form

DateTime dt_starttime; //this takes the start time from a button on mainform when clicked
TimeSpan ts_elapsed;

public void tmrSure_Tick(object sender, EventArgs e) //this is triggered from the main form
{
// taking the elapsed time
DateTime dt_now = DateTime.Now;
ts_elapsed = dt_now.Subtract(dt_starttime);

theBestProgressBarEver1.CenterText = string.Format("{0:00}:{1:00}", ts_elapsed.Hours, ts_elapsed.Minutes); //CenterText is to show text
}
//normally the code is spreaded,I collected the pieces together to be able to post
thanks for your interest

Re: Custom progressbar doesn't update

Programm3r22-Sep-09 21:21

Programm3r

22-Sep-09 21:21

Try setting the text within the progressbar with this piece of code: http://www.codeproject.com/Messages/3207094/Text-over-Progressbar[^], I think it will work!

The only programmers that are better C# programmers, are those who look like this -> Green Alien | [Alien]

Programm3r
My Blog: ^_^

Re: Custom progressbar doesn't update

teknolog12323-Sep-09 9:26

teknolog123

23-Sep-09 9:26

thanks Programm3r
I solved the issue by putting ProgressBar.Refresh() on top in the timer event before the text property of the progressbar gets changed. But before, I had put it in the bottom of timer and didn't work. Anyway, thanks for dealing.

Binary Serialization of Dictionary

FJJCENTU22-Sep-09 1:28

FJJCENTU

22-Sep-09 1:28

I want to Serialize a Dictionary in Binary format but I get an error message telling that this objecto is not Serializable, is there any way of do it or I need to create my own dictionary class.

Regards

Re: Binary Serialization of Dictionary

Henry Minute22-Sep-09 1:44

Henry Minute

22-Sep-09 1:44

There is an article here on CP about serializing Dictionaries (amongst other things). Unfortunately, for you, it uses XML Serialization. In case it may offer you some clues, here is a link Yet Another XML Serialization Library for the .NET Framework[^]

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Text over Progressbar - Question

Programm3r22-Sep-09 1:25

Programm3r

22-Sep-09 1:25

Hi all,

I found the following code, that allows one to write a string on a ProgressBar ... Only thing is that I can't get it to work Confused | :confused:

Can anyone else make it work, and if so ... what am I doing wrong?

// call the method
SetProgressBarText(progressBar1, null, ProgressBarTextLocation.Centered, Color.Black, SystemFonts.DefaultFont);

// Set the ProgressBar Text method
private void SetProgressBarText(System.Windows.Forms.ProgressBar Target,
    //The target progress bar
string Text,
    //The text to show in the progress bar
ProgressBarTextLocation Location,
    //Where the text is to be placed
System.Drawing.Color TextColor,
    //The color the text is to be drawn in
System.Drawing.Font TextFont
    //The font we use to draw the text
)
{
    //Make sure we didn't get a null progress bar
    if (Target == null)
        throw new ArgumentException("Null Target");

    //Now we can get to the real code
    //Check to see if we are to add in the percent
    if (string.IsNullOrEmpty(Text))
    {
        //We are to add in the percent meaning we got a null or empty Text
        //We give text a string value representing the percent
        int percent = (int)(((double)(Target.Value - Target.Minimum) / (double)(Target.Maximum - Target.Minimum)) * 100);
        Text = percent.ToString() + "%";
    }
    //Now we can add in the text
    //gr will be the graphics object we use to draw on Target
    using (Graphics gr = Target.CreateGraphics())
    {
        gr.DrawString(Text,
        TextFont,
            //The font we will draw it it (TextFont)
        new SolidBrush(TextColor),
            //The brush we will use to draw it
            //Where we will draw it
        new PointF(
            // X location (Center or Left)
        Location == ProgressBarTextLocation.Left ? 5 :
            //Left side
        progressBar1.Width / 2 - (gr.MeasureString(Text,
            //Centered
        TextFont).Width / 2.0F),
            // Y Location (This is the same regardless of Location)
        progressBar1.Height / 2 - (gr.MeasureString(Text,
        TextFont).Height / 2.0F)));
    }
}

public enum ProgressBarTextLocation
{
    Left,
    Centered
}

Many thanks in advance
Kind regards,

The only programmers that are better C# programmers, are those who look like this -> Green Alien | [Alien]

Programm3r
My Blog: ^_^

Re: Text over Progressbar - Question

Programm3r22-Sep-09 1:36

Programm3r

22-Sep-09 1:36

Nevermind

.... just through the method call within a Timer Tick and everything works ....

The only programmers that are better C# programmers, are those who look like this -> Green Alien | [Alien]

Programm3r
My Blog: ^_^

Re: Text over Progressbar - Question

firda-cze18-Apr-10 22:21

firda-cze

18-Apr-10 22:21

public class ProgressLabel: ProgressBar {
	private static StringFormat sfCenter = new StringFormat() {
		Alignment = StringAlignment.Center, LineAlignment = StringAlignment.Center };
	private Color textColor = DefaultTextColor;
	private string progressString;
	public ProgressLabel() { SetStyle(ControlStyles.AllPaintingInWmPaint, true); }
	protected override void OnCreateControl() {
		progressString = null;
		base.OnCreateControl();
	}
	protected override void WndProc(ref Message m) {
		switch(m.Msg) {
		case 15: if(HideBar) base.WndProc(ref m);
			else {
				ProgressBarStyle style = Style;
				if(progressString == null) {
					progressString = Text;
					if(!HideBar && style != ProgressBarStyle.Marquee) {
						int range = Maximum-Minimum;
						int value = Value;
						if(range > 42949672) { value = (int)((uint)value>>7); range = (int)((uint)range>>7); }
						if(range > 0) progressString = string.Format(progressString.Length == 0 ? "{0}%" : "{1}: {0}%",
						value*100/range, progressString);
					}
				}
				if(progressString.Length == 0) base.WndProc(ref m);
				else using(Graphics g = CreateGraphics()) {
					base.WndProc(ref m);
					OnPaint(new PaintEventArgs(g, ClientRectangle));
				}
			}
			break;
		case 0x402: goto case 0x406;
		case 0x406: progressString = null;
			base.WndProc(ref m);
			break;
		default:
			base.WndProc(ref m);
			break;
		}
	}
	protected override void OnPaint(PaintEventArgs e) {
		Rectangle cr = ClientRectangle;
		RectangleF crF = new RectangleF(cr.Left, cr.Top, cr.Width, cr.Height);
		using(Brush br = new SolidBrush(TextColor))
			e.Graphics.DrawString(progressString, Font, br, crF, sfCenter);
		base.OnPaint(e);
	}
	public bool HideBar {
		get { return GetStyle(ControlStyles.UserPaint); }
		set { if(HideBar != value) { SetStyle(ControlStyles.UserPaint, value); Refresh(); } }
	}
	public static Color DefaultTextColor {
		get { return SystemColors.ControlText; }
	}
	public Color TextColor {
		get { return textColor; }
		set { textColor = value; }
	}
	public override string Text {
		get { return base.Text; }
		set { if(value != Text) { base.Text = value; progressString = null; } }
	}
	public override Font Font {
		get { return base.Font; }
		set { base.Font = value; }
	}
}

Re: Text over Progressbar - Question

Scott Sherin28-May-10 4:15

Scott Sherin

28-May-10 4:15

Thanks firda, been looking for that code all over.

how to use a macro in c#

Ajithevn22-Sep-09 0:58

Ajithevn

22-Sep-09 0:58

how to use the same macro of excel in c#
Private Sub Worksheet_Activate()
Range("A1").Select
End Sub

Re: how to use a macro in c#

Programm3r22-Sep-09 1:39

Programm3r

22-Sep-09 1:39

Hi,

See How To Create an Excel Macro by Using Automation from Visual C# .NET[^] ... hope I understood the question correctly....

Kind regards,

The only programmers that are better C# programmers, are those who look like this -> Green Alien | [Alien]

Programm3r
My Blog: ^_^

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