C# Discussion Boards - CodeProject

How to invoke SQL Function through SqlCommand class

El'Cachubrey9-Jan-08 4:06

9-Jan-08 4:06

Hi all! How i can to invoke SQL Function through SqlCommand class,
what syntax i should use in CommandText and what value i should define in CommandType

THANK

Re: How to invoke SQL Function through SqlCommand class

led mike9-Jan-08 4:31

led mike

9-Jan-08 4:31

Are you using an Article or tutorial? If not you should, there are many Database related articles here on Code Project. Use the Site Menu on the left side of the page to find them.

Re: How to invoke SQL Function through SqlCommand class

andyharman9-Jan-08 4:44

andyharman

9-Jan-08 4:44

For scalar UDFs (which return a single value) use:
select dbo.MyUdfName()

For table-valued UDFs (that return a resultset) use:
select * from dbo.MyUdfName()

Regards
Andy

How to catch the event of thowing an exception in Visual Studio

manustone9-Jan-08 3:51

manustone

9-Jan-08 3:51

Hi all
I would like to trigger a function (writing a time stamp)
when Visual Studio is running in Debug Mode and an exception is thrown by the code.
I am basically interested in the event OnExceptionRaised in Visual Studio.
I saw that there is some DebuggerEventClass but it is something internal that cannot be used.
Is there any way to do that? I noticed that VIsualStudioIDE supportsa COM component model
but I think that this is not also supported.
Kind Regards
ManuStone

set child form height

arkiboys9-Jan-08 2:29

arkiboys

9-Jan-08 2:29

Hi,
I have an mdi parent form (frmMain) and a child form (frmChild)
Using c#, How is it possible to set the height of the child form as long as that in the frmMain i.e. the parent form.
At present the frmChild appears in the middle of frmMain but there is room for the frmChild's height to be increased.

Tried frmChild.height but .height does not appear in the intellisense.

Thanks

Re: set child form height

Stu Richardson9-Jan-08 2:40

Stu Richardson

9-Jan-08 2:40

A form has a Size property.

ChildForm child = new childForm();
child.MdiParent = this;
child.Size = new Size(this.Width, this.Height);
child.Show();

This will set the height and width of the child form to be the same as its parent form.

Re: set child form height

arkiboys9-Jan-08 2:49

arkiboys

9-Jan-08 2:49

I get a scrollbar on the parent form because the child form seems to be too long.
Any thoughts please?
This is what I have

Form frmNew = new frmChild();
frmNew.MdiParent = this;

frmNew.Size = new Size(frmNew.Width, this.Height);

frmNew.Show();

Re: set child form height

DaveyM699-Jan-08 3:08

DaveyM69

9-Jan-08 3:08

frmNew.Size = new Size(frmNew.Width, this.ClientSize.Height);

Re: set child form height

arkiboys9-Jan-08 3:13

arkiboys

9-Jan-08 3:13

That still gives a scrollbar.

Re: set child form height

DaveyM699-Jan-08 3:24

DaveyM69

9-Jan-08 3:24

Wierd, I'm sure that's how I've done it before!

This way works if you want width and height:

In your child form's load event put...
this.Dock = DockStyle.Fill;

Re: set child form height

Stu Richardson9-Jan-08 3:27

Stu Richardson

9-Jan-08 3:27

It depends how you will use your child form. I cant seem to get the child form to appear within the client rectangle without scroll bars apart from hacking it. So here is a couple of options you could have a look at.

1. You can set the child forms Dock = Fill.
2. You can set the child forms WindowState = FormWindowState.Maximized.
3. You can set the childs size to parentForm.ClientRectangle - x. (hack i know)

Sorry I am all out of ideas after that. The scroll bars seem to appear no matter if i set the hscroll etc props.

Re: set child form height

arkiboys9-Jan-08 3:27

arkiboys

9-Jan-08 3:27

Solved it by doing this:
frmNew.Size = new Size(frmNew.Width, this.Height - 80);

Thanks

Re: set child form height

Dave Kreskowiak9-Jan-08 4:59

Dave Kreskowiak

9-Jan-08 4:59

You may want to check the value of this.Height before you run this line of code. Setting the size to a negative number could be detrimental to the execution of your application.

A guide to posting questions on CodeProject[^]

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

Re: set child form height

DaveyM6910-Jan-08 1:12

DaveyM69

10-Jan-08 1:12

Ok, I've checked the code that I used in a previous project and this works fine:

this.Height = this.Parent.ClientSize.Height;

Using this.MdiParent.ClientSize.Height doesn't however - strange! Confused | :confused:

Get GUID of Network Card

Kamal.Afridi9-Jan-08 1:48

Kamal.Afridi

9-Jan-08 1:48

Is there any code in C# to get GUID of network card.

Thanks.

The great pleasure in life is doing what people say you cannot do.

Re: Get GUID of Network Card

Pete O'Hanlon9-Jan-08 2:07

Pete O'Hanlon

9-Jan-08 2:07

GUID of network card? Do you mean the Mac Address? If so, you can use WMI to retrieve it:

public string GetMACAddress() 
{ 
  ManagementClass mc = new ManagementClass("Win32_NetworkAdapterConfiguration"); 
  ManagementObjectCollection moc = mc.GetInstances(); 
  string address = string.Empty; 
  foreach (ManagementObject mo in moc) 
  { 
    if (MACAddress == string.Empty)
    {
      if ((bool)mo["IPEnabled"] == true) 
        address = mo["MacAddress"].ToString(); 
    } 
    mo.Dispose(); 
  } 
  address = address.Replace(":", string.Empty); 
  return address; 
}

Deja View - the feeling that you've seen this post before.

My blog | My articles

Re: Get GUID of Network Card

Kamal.Afridi9-Jan-08 20:01

Kamal.Afridi

9-Jan-08 20:01

Thanks Pete O'Hanlon for your reply, but i need GUID which also called UUID.

Any Idea please.

The great pleasure in life is doing what people say you cannot do.

EXE To display within a Form

ziwez09-Jan-08 0:53

ziwez0

9-Jan-08 0:53

Hi,
I have recently got a test server running so the employees can input test data without needing worry about if they mess up.
So I written a small c# windows app that the user runs and it has two buttons "test server" or "live server".
The problem is I want to indicate to the user what system they are in, but I cant mod the exe so can I execute the exe within a windows form app, so the exe is contained inside the windows form and I can place some text on the Form like "You are in the Test Server",

how can I get the exe to load within a form?

Re: EXE To display within a Form

Thomas Stockwell10-Jan-08 6:16

Thomas Stockwell

10-Jan-08 6:16

What you would have to do is set the form so that it is MDI and then use WinAPI to get the handle of the main form for the application you want to embed and set its parent (done through API) to the .NET application that you are developing.

Regards,
Thomas Stockwell

Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.

Visit my homepage Oracle Studios[^]

DATAGRIDVIEW

usyra429-Jan-08 0:52

usyra42

9-Jan-08 0:52

How can i add drop down list to datagridview for one column.

usharani

Re: DATAGRIDVIEW

led mike9-Jan-08 4:35

led mike

9-Jan-08 4:35

Do you mean without using the DataGridViewComboBoxColumn[^]?

Re: DATAGRIDVIEW

DotNetXenon9-Jan-08 4:35

DotNetXenon

9-Jan-08 4:35

Get this[^]

------------------------------------------------------------
"The only true wisdom is in knowing you know nothing." --Socrates

webClient.Headers.Add(string key, string value) behaves strange if 'key' has a square bracket in it? ([])

mightyCoCo9-Jan-08 0:04

mightyCoCo

9-Jan-08 0:04

Hi there,

I came across this strange thing, i don't know how to handle it. Maybe a pretty stupid question or a case of RTFM - but i couldn't find any refference...

Following code works just fine:

<br />
    WebClient webClient = new WebClient();<br />
    webClient.Headers.Add("Content-Type","application/x-www-form-urlencoded");<br />
    webClient.Headers.Add("abc", "123");<br />
    byte[] postArray = Encoding.UTF8.GetBytes("submitting some data here...");<br />
    byte[] responseArray = webClient.UploadData("MyServer", postArray);<br />
    Console.WriteLine("Response received was : " + Encoding.ASCII.GetString(responseArray));<br />
    Console.Read();<br />

BUT if i change the HTTP Header to something like
webClient.Headers.Add("abc[OBJECT_ID]", "123");
i get an error in the next line (byte[] postArray...) saying:
An unhandled exception of type 'System.ArgumentException' occurred in system.dll

So it's the square brackets causing the issue. Do i need to escape them in any way???

thanks in advance,
- ajs

how to add Item to binded comboBox ?

hdv2128-Jan-08 23:53

hdv212

8-Jan-08 23:53

hi i have a comboBox that binded to a field in database, and i want to add new item to my binded comboBox dynamically, how to do that ?
thanks

Re: how to add Item to binded comboBox ?

pmarfleet9-Jan-08 1:21

pmarfleet

9-Jan-08 1:21

Add the item in code. Something like:

mycombo.Items.Add(mytext)

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

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