Re: is the order of parameters addition to a command for update command realy required? - C# Discussion Boards

First Prev Next

Re: Form inside another form [modified]

Martin#10-Oct-07 23:37

Martin#

10-Oct-07 23:37

Hello,

Yes, it is possible;

By setting the 'TopLevel' property of the SubForm to 'false'.
Then you can Add the SubForm to the MainForm.Controls.

//Inside MainForm
Form SubForm = new Form();
SubForm.TopLevel = false;
this.Controls.Add(SubForm );
SubForm.Show();

By setting the TopLevel property to false, it is no more possible to call the form modal with ShowDialog.

Hope it helps!

-- modified at 5:48 Thursday 11th October, 2007

A second possibility is the IsMdiContainer

//Inside MainForm
this.IsMdiContainer = true;
SubForm.MdiParent = this;
this.Controls.Add(SubForm);
SubForm.Show();

All the best,

Martin

Re: Form inside another form

Spunky Coder10-Oct-07 23:46

Spunky Coder

10-Oct-07 23:46

wow ...it's great i never knew that it can be shown in that way ...

Koushik

Re: Form inside another form

half-life10-Oct-07 23:48

half-life

10-Oct-07 23:48

YEAH MAN
THNKS A lot Smile | :)

it works GREAT Smile | :)

kobkob

Re: Form inside another form

Martin#10-Oct-07 23:50

Martin#

10-Oct-07 23:50

You are wellcome!

All the best,

Martin

is the order of parameters addition to a command for update command realy required?

nicolus10-Oct-07 23:10

nicolus

10-Oct-07 23:10

i am using an oledbcommand object to perform both insert and update based on the command text supplied and i am adding the parameters for update also in the order of insert. So incase of update though, its not giving any error/exception but database is not getting updated.

Can any body pls tell me how to resolve this or any other way to implement both the functionalities using single method.

Thanks in advance.

Re: is the order of parameters addition to a command for update command realy required?

Christian Graus10-Oct-07 23:28

Christian Graus

10-Oct-07 23:28

You need to specify either the parameters by name ( in any order ), or pass them in the order that a stored proc you're calling requires them ( although I suspect you're using the nasty 'dynamic SQL in the presentation layer' stuff here )

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: is the order of parameters addition to a command for update command realy required?

nicolus10-Oct-07 23:52

nicolus

10-Oct-07 23:52

thanks now its working (yes order mattered).

Re: is the order of parameters addition to a command for update command realy required?

Dave Kreskowiak11-Oct-07 4:09

Dave Kreskowiak

11-Oct-07 4:09

OleDb doesn't support named parameters. You have to specifiy them in the exact order they appear in the SQL statement. Well, you can give them names all you want, they won't do anything...

Yet another reason why I never use Access anymore.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

Re: is the order of parameters addition to a command for update command realy required?

PIEBALDconsult11-Oct-07 5:37

PIEBALDconsult

11-Oct-07 5:37

I've found that naming them allows the use of a parameter value multiple times in the statement.

And is it an OleDb thing or a Jet Engine thing?

Re: is the order of parameters addition to a command for update command realy required?

Dave Kreskowiak11-Oct-07 12:07

Dave Kreskowiak

11-Oct-07 12:07

I never bothered to figure that one out. I'm guessing that since you can't do it in VA code in Access either that the "problem" would be tied to Jet, but I could be wrong.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007

picturebox image

NewToAspDotNet10-Oct-07 23:07

NewToAspDotNet

10-Oct-07 23:07

hi everyone,
i have a picture box and i set pic's from database to it...bud the size of my images are bigger then the size of my picturebox...how can i fix this? what should i do to make the images programmaticaly smaller that they fix in the picturebox? thanx

Re: picturebox image

half-life10-Oct-07 23:24

half-life

10-Oct-07 23:24

Use The SizeMode Propertie

kobkob

Property Grid

Lucian.Palcu10-Oct-07 23:05

Lucian.Palcu

10-Oct-07 23:05

Hi!

I have a property grid and I set to its SelectedObject an instance of a class. This class has some properties which I don't want to be displayed in the property grid. Is there an attribute to set before those properties to make PropertyGrid to ignore them?

Thanks,

Lukas

Re: Property Grid

TJoe11-Oct-07 2:22

TJoe

11-Oct-07 2:22

Check this[^] out.

Take care,
Tom

-----------------------------------------------
Check out my blog at http://tjoe.wordpress.com

Re: Property Grid

visualhint11-Oct-07 9:11

visualhint

11-Oct-07 9:11

and if this is not enough (for example if you have no access to the source code of your target instance), you can define a Type descriptor that will filter the unwanted properties. See this article[^].

Best regards,

Nicolas Cadilhac @ VisualHint
Smart PropertyGrid.Net
Microsoft PropertyGrid Resource List
Free PropertyGrid for MFC
Smart FieldPackEditor.Net / DateTimePicker

Treeveiw(add nodes)

chanzeb10-Oct-07 22:53

chanzeb

10-Oct-07 22:53

con.Open();
object[] objArrRestrict;
//select just TABLE in the Object array of restrictions.
//Remove TABLE and insert Null to see tables, views, and other objects.
objArrRestrict = new object[] {null, null, null, "TABLE"};
DataTable schemaTbl;
schemaTbl = con.GetOleDbSchemaTable(OleDbSchemaGuid.Tables,objArrRestrict);
// Display the table name from each row in the schema
foreach (DataRow row in schemaTbl.Rows)
{
listBox.Items.Add(row["TABLE_NAME"]);

}

instead of using list box,i want to add tables to tree veiw
what can i do???????????/

chanzeb chaudhary

Re: Treeveiw(add nodes)

Spunky Coder10-Oct-07 22:57

Spunky Coder

10-Oct-07 22:57

use treeview1.nodes[0].add()....but a treeview can have child nodes recursively so how do you want to show the obtained rows in treeview ?

Koushik

Re: Treeveiw(add nodes)

chanzeb10-Oct-07 23:03

chanzeb

10-Oct-07 23:03

int i = 0;
foreach (DataRow row in tbs.Rows)
{
treeVu1.Nodes[i].Add(row["TABLE_NAME"]);
i = i + 1;
}

But it does not work.
ERROR Message "Cannot apply indexing with [] to an expression of type 'method group"

Re: Treeveiw(add nodes)

Spunky Coder10-Oct-07 23:15

Spunky Coder

10-Oct-07 23:15

hey use the following...

foreach (DataRow row in tbs.Rows)
{
treeVu1.Nodes.Add(row["TABLE_NAME"].ToString());

}

Koushik

Re: Treeveiw(add nodes)

chanzeb10-Oct-07 23:43

chanzeb

10-Oct-07 23:43

thank u

File being used

-spy-10-Oct-07 22:33

-spy-

10-Oct-07 22:33

hey guyz..im having a problem about my application, it has a profile form, with picture, this picture is being converted to bytes and save it to database, when the form loads, it will create a temporary file..and display the picture.. but the problem here is that, whenever i changed the picture of a certain profile, it will still displays the previous one, because the "file is being used". I can't see the effect, unless i stop the application and run it again.. i hope you can help me with this..tnx in advance

some codes:

strfn = AppDomain.CurrentDomain.BaseDirectory + "profile_pic\\" + dgProfile[dgProfile.CurrentRowIndex,0].ToString();
FileStream fs = new FileStream(strfn,FileMode.Create,FileAccess.Write);
fs.Write(imageByte,0,imageByte.Length);
fs.Flush();
fs.Close();
picBoxProfile.Image = Image.FromFile(strfn);

Re: File being used

Christian Graus10-Oct-07 22:34

Christian Graus

10-Oct-07 22:34

How do you read the bitmap ? If you pass the path to the constructor, this is what's holding the file open.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Re: File being used

Luc Pattyn10-Oct-07 22:35

Luc Pattyn

10-Oct-07 22:35

Hi,

Image.FromFile() is known to lock the file for as long as the image is alive;
I suggest you try and use Image.FromStream() instead. The stream you use can be
a FileStream, but it can also be a MemoryStream, so maybe you don't need a file at all.

Smile | :)

Luc Pattyn [Forum Guidelines] [My Articles]

this months tips:
- use PRE tags to preserve formatting when showing multi-line code snippets
- before you ask a question here, search CodeProject, then Google

C# Dictionary: From item to key?

Extrakun10-Oct-07 22:27

Extrakun

10-Oct-07 22:27

Hi all,

Is there any way, given an item in a dictionary D, to find its key(s), besides iterating through it? Would using another data structure helps if so which? (I seem to recall a solution for C++, but I can't definitely remember it and not sure if it applies to C#)

Thanks in advance!

Re: C# Dictionary: From item to key?

Christian Graus10-Oct-07 22:33

Christian Graus

10-Oct-07 22:33

You basically build two dictionaries, one in each direction. I think there are C++ classes that do a bidirectional hash table.

Christian Graus - Microsoft MVP - C++

"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )

Last Visit: 31-Dec-99 18:00 Last Update: 17-Jun-24 14:48

Refresh

ᐊ Prev 1...8362 8363 8364 836583668367 8368 8369 8370 8371 Next ᐅ

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