Refresh Binding - C# Discussion Boards

Judah Gabriel Himango15-Aug-06 5:15

Judah Gabriel Himango

15-Aug-06 5:15

First, you need to get the data out of your database. To do that, use ADO.NET. If you have an ADO.NET-specific question, ask in the ADO.NET forum[^].

Once you've got your data out of the database, you can provide a constructor that takes an integer for each form you want to pass:

class MyForm : Form
{
    public MyForm(int integer)
    {
       ...
    }
}

You can then construct it like

MyForm form = new MyForm(5);

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: And in this corner, the Party of Allah
The apostle Paul, modernly speaking: Epistles of Paul

Judah Himango

TAREQ F ABUZUHRI15-Aug-06 5:40

15-Aug-06 5:40

hello Judah Himango

i know how to connect to database
and i know how to open form with parameter

the probelm now if i want to generate button on form load what i must do to get parameter 5 on Click on the second button ...

Palestine

Judah Gabriel Himango15-Aug-06 5:47

Judah Gabriel Himango

15-Aug-06 5:47

Let me make sure I'm understanding. You want to get parameter 5 once the button is clicked?

To generate a button from code and listen for a click event:

// inside your form code
Button b = new Button();
this.Controls.Add(b);
b.Click += new EventHandler(OurClickHandler);

...

void OurClickHandler(object sender, EventArgs e)
{
    // The button was clicked.
}

Does that answer your question?

Tech, life, family, faith: Give me a visit.
I'm currently blogging about: And in this corner, the Party of Allah
The apostle Paul, modernly speaking: Epistles of Paul

Judah Himango

TAREQ F ABUZUHRI15-Aug-06 6:25

15-Aug-06 6:25

thankssssssssssssss

Palestine

TAREQ F ABUZUHRI15-Aug-06 6:30

15-Aug-06 6:30

http://www.codeproject.com/script/comments/forums.asp?forumid=1649&select=1626035&df=100&msg=1626035[^]

plz see this question Smile | :)

Palestine

TAREQ F ABUZUHRI15-Aug-06 6:44

Datatable and compute(Sum)

15-Aug-06 6:44

sorry this plz

http://www.codeproject.com/script/comments/forums.asp?forumid=1649&select=1626022#xx1626022xx[^]

Palestine

Refresh Binding

elefrancois12315-Aug-06 3:58

elefrancois123

15-Aug-06 3:58

Hi,

I have a Typed DataSet that is bind to some winform controls. TextBox, Labelx etc....
At some point, my dataSet values are updated being the scene. The probleme is that my binded controls are not updated automatically when DataSource is updated.
What I have to do to force the rebind of my controls ?

..Etienne Lefrancois

Saamir15-Aug-06 3:18

15-Aug-06 3:18

Hi guys,
I need some help, please.

I am trying to get the sum of two columns in a dataset table.

Here is what I have so far and it seems to be giving me a aggregate error.

SqlDataAdapter adp= new SqlDataAdapter();
SqlCommand cmd= new SqlCommand();
cmd.Connection=cnn;
........
adp.SelectCommand=cmd;
DataSet ds=new DataSet();
adp.Fill(ds,"tbACJE");

System.Data.DataRow rd= ds.Tables["tbACJE"].Rows[0];
Double fTemp=Double.Parse(ds.Tables["tbACJE"].Compute("SUM(rd[0]+rd[1])", "").ToString()); //this doesn't seem to be working.
if(fTemp==0.00)
{
MessageBox.Show(this,"Error");
}

Please help.

sasa

Guffa15-Aug-06 4:18

Guffa

15-Aug-06 4:18

Why don't you let the database do the calculation, instead of first fetching all the data and make the Table object loop through it?

Example:

cmd.CommandText = "select sum(field1 + field2) as total from tbACJE";

---
b { font-weight: normal; }

Saamir15-Aug-06 4:26

15-Aug-06 4:26

Because I am doing a lot more than just this calculation to the data.

sasa

Re: Datatable and compute(Sum) [modified]

Ennis Ray Lynch, Jr.15-Aug-06 4:22

Ennis Ray Lynch, Jr.

15-Aug-06 4:22

(double)ds.Tables["tbACJE"].Compute("SUM(rd[0]+rd[1])", "") probably works as good.

DataTable table = ds.Tables["tbACJE"];
rd[0] and rd[1] are not fields in your db so try

SUM(" + table.Columns[0].ColumnName + "+" + table.Columns[1].ColumnName + ", "")

might work

A man said to the universe:
"Sir I exist!"
"However," replied the Universe, "The fact has not created in me A sense of obligation."

-- Stephen Crane

Saamir15-Aug-06 5:09

15-Aug-06 5:09

Hi there,
I tried both your methods and I still get the same error which says,
Syntax error in aggregate argument: Expecting a single column argument with possible 'child' qualifier

Any ideas please will be highly appreciated

sasa

Saamir15-Aug-06 5:29

Placing User Control on Form shut down visual studio 2005

15-Aug-06 5:29

Hi there,
I finally got the error message not to show by doing this, but I am worried if my logic is correct, any suggestions?

Double fTempCR=0.00;
Double fTempDB=0.00;
Double fTemp=0.00;
DataTable table = ds.Tables["tbACJE"];
object sumObjectCR;
object sumObjectDB;
sumObjectCR = table.Compute("SUM(AmtCr)",string.Empty);
sumObjectDB = table.Compute("SUM(AmtDb)",string.Empty);
fTempCR=Double.Parse(sumObjectCR.ToString());
fTempDB=Double.Parse(sumObjectDB.ToString());
fTemp=fTempDB-fTempCR;

if(fTemp==0.00)
Show message

sasa

thunderbirdje15-Aug-06 1:16

thunderbirdje

15-Aug-06 1:16

Hi everyone

I'm pretty new to visual studio 2005 in combination with C#... I did some GDI+ research en tried to make my own User Control (which contains a circle, a pin and a rectangle that simulates te rotations of a DC motor).

The control works fine (motor rotates, you replace te motor bij an image of an motor...) But when I place this User Control (named MotorGUI) on a form, visual studio shuts down!!!

I have a solution with 2 projects
- client (test form)
- Simulation.Motor (Motor User Control -> compiled into an DLL)

When I drag the Motor User Control which is displayed in the toolbox after building this solution on the form, VS shuts down. Also when I finally got the control on the form by luck... When this control received a focus (in visual studio @design time... VS shuts down too Cry | :((

Can anyone help me? Or give me a suggestion? May be I am making a critical mistake? I can always copy/paste the code of my motorGUI user control.

Thanks in advance!

Rising Sun

Re: Placing User Control on Form shut down visual studio 2005

Christian Graus15-Aug-06 1:32

Christian Graus

15-Aug-06 1:32

VS itself shuts down ? What if you write code to create the control dynamically and run the exe ? Does the exe work ?

VS2005 kind of sucks, it now will crash with user controls that work perfectly at run time, for example, your rendering code needs to always work, even if no properties have been provided.

There is a property you can use, but I forget it's name. IsDesign, or DesignMode, something like that. That will allow you to write code that doesn't get run in design mode, which is where the problems are.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog

Re: Placing User Control on Form shut down visual studio 2005

thunderbirdje15-Aug-06 5:20

thunderbirdje

15-Aug-06 5:20

Creating the control dynamically solved the problem half. When compiling/building the solution, VS still shuts down Frown | :(

After a deeper search -it must be somewhere in the code- the shut down problem arised because one property of my motor hasn't a instance variable and the name of the accessing get/set method was the same name as the veriable!
(I added the method with the class designer (I would say: dangerous)).

But after all, strange that VS just shut down on that kind of a problem? (VS kind of sucks, indeed) I guess when dropping my motor control on a form, VS 'activate' the control and shuts down because the problem above WTF | :WTF:

.

Is is always so that a control is running (getting active?) at design time(like my motor DLL component)? It is not a static view Sleepy | :zzz:

I guess? But a sort of 'runtime' view?

Thanks for the DesignMode property hint! That's how I came upon this solution. Everyting works fine after fixing the get/set method.

Thanks Christian!

Configuration with Enterprise Lib 2.0 [modified]

Frygreen15-Aug-06 0:53

Frygreen

15-Aug-06 0:53

Dear gurus,

I'm dealing for a while now with Enterprise Library 2.0 (EL). I'm almost totally lost.

If I search for samples I always find the same samples which seem to be created by exactly three gurus (Alois Kraus, Tom Hollander and David Hayden). This shows me that I'm not the only who does not understand this stuff. It's a greaty pity, because I think EL is nice and interesting. It seems to me as if Microsoft had created EL only for themselfs

Ok, enough complained.

Can somebody help me with classes as FileConfigurationSource or IConfigurationSource in concert with ConfigurationManager and reading from different configuration files.

Thanks a lot in advance

-- modified at 10:15 Tuesday 15th August, 2006

Re: Configuration with Enterprise Lib 2.0

Dustin Metzgar15-Aug-06 8:42

Dustin Metzgar

15-Aug-06 8:42

Yes, there is certainly a lack of good samples for working with enterprise libraries. Most dev shops that need an enterprise framework probably already have one in-house, so adoption of entlib is kinda low. I'm a fan of entlib but not much chance to use it. Perhaps if you post a specific question this forum can be more helpful.

Logifusion[^]
If not entertaining, write your Congressman.

Adding button on titlebar

Imtiaz Murtaza15-Aug-06 0:48

Imtiaz Murtaza

15-Aug-06 0:48

Friends,
We all know that there are three buttons on titlebar i.e minimize, maximize and close.
I want to add my custom button on the titlebar near minimize button. How can i do so ?

Imtiaz

Ed.Poore15-Aug-06 1:25

Ed.Poore

15-Aug-06 1:25

With Interop wizardry Poke tongue | ;-P

Formula 1 - Short for "F1 Racing" - named after the standard "help" key in Windows, it's a sport where participants desperately search through software help files trying to find actual documentation. It's tedious and somewhat cruel, most matches ending in a draw as no participant is able to find anything helpful. - Shog⁹

Ed

Imtiaz Murtaza15-Aug-06 1:27

Imtiaz Murtaza

15-Aug-06 1:27

But how ? What APIs to call ?

Imtiaz

Ed.Poore15-Aug-06 1:38

Ed.Poore

15-Aug-06 1:38

Try typing in your question (in the subject line) as it is into Google. Take a look at the fourth or fifth result which is the first CodeProject hit. That should explain it all (but it is in C++).

Nader Elshehabi15-Aug-06 2:07

Nader Elshehabi

15-Aug-06 2:07

Hello

The best practice I can think of is to inherit a class from Windows.Form, and handle its drawing yourself

Otherwise putting a control outside the client area at runtime -though I think it's not impossible- would be extremely difficult

Regards Rose | [Rose]