C# Discussion Boards - CodeProject

Re: Populate combobox

matjame29-May-07 23:21

matjame

29-May-07 23:21

Im not a c# code, so Im learning.

dtr is a datareader.
cm is a command
cn is a connection Sigh | :sigh:

kagiso

Re: Populate combobox

sujithkumarsl29-May-07 23:15

sujithkumarsl

29-May-07 23:15

DataTable status = new DataTable();
status = ExecuteNonQuery_SP("Select * from Filter");//getting the value
cmbStatus.DataSource =status ;
cmbStatus.DisplayMember = "Status_Name";
cmbStatus.ValueMember = "Status_Id";

give the displaymember and valuemember to the combobox'x object
here cmbStatus is the combobox

My small attempt...

Re: Populate combobox

J4amieC29-May-07 23:42

J4amieC

29-May-07 23:42

sujithkumarsl wrote:
status = ExecuteNonQuery_SP("Select * from Filter");//getting the value
cmbStatus.DataSource =status ;

---

How to get answers to your questions[^]

Re: Populate combobox

sujithkumarsl29-May-07 23:58

sujithkumarsl

29-May-07 23:58

status = ExecuteNonQuery_SP("Select * from Filter");//getting the value
cmbStatus.DataSource =status ;

actually ExecuteNonQuery_SP("Select * from Filter"); is a method which takes quaery as parameter and returns the datatable.
i used this code in my proj and its working

My small attempt...

Re: Populate combobox

J4amieC30-May-07 0:58

J4amieC

30-May-07 0:58

sujithkumarsl wrote:
actually ExecuteNonQuery_SP("Select * from Filter"); is a method which takes quaery as parameter and returns the datatable.
i used this code in my proj and its working

Two things:

1) There is no method named ExecuteNonQuery_SP in the framework, and therefore using it in an example to a newer programmer is just going to confuse them more! This method is most likely defined in your own project, or is part of a data access framework that you use.

2) The name of the method would imply that it executes IDbConnection.ExecuteNonQuery which does not "return a table". If your method really does take a SQL clause as a parameter and return a table it should be named ExecuteDataTable_SP

Please take the time to consider the usefulness of the code and the target audience before posting a (useless) code snippet.

---

How to get answers to your questions[^]

Re: Populate combobox

matjame30-May-07 0:48

matjame

30-May-07 0:48

Im using MS Access not SQL

kagiso

Re: Populate combobox

Shivaprasad D Atthigode29-May-07 23:38

Shivaprasad D Atthigode

29-May-07 23:38

what a mess is this!!

"cbo.extension.text" will never populate items in to combobox control, this only displays the specified text
if it is already there in combobox items collection.

to populate the items u should specifie
{
combobox.items.add(dtr["filterKey"].tostring());
}

Re: Populate combobox

matjame29-May-07 23:50

matjame

29-May-07 23:50

cboExtension.items.add(dtr["filterKey"].tostring());

items gives this error

"System.Web.UI.WebControl.DropdownList doesnt contain definition for items."

Then to .tostring()

"object doesnt contain a definition for string

Can you generate a code that would work.
NB. The Items in the database are jus A.B.C til Z
So, it suppose to load A
B
C
Till Z
Thank you for your help.A nice code would be nice.Im an amature in this

kagiso

Re: Populate combobox

sujithkumarsl30-May-07 0:00

sujithkumarsl

30-May-07 0:00

please try the exable which i gave to you. that will work
which field from db, you want to add in combobox?

My small attempt...

Re: Populate combobox

matjame30-May-07 0:23

matjame

30-May-07 0:23

I want to filter by FilterKey

kagiso

Re: Populate combobox

Shivaprasad D Atthigode30-May-07 0:15

Shivaprasad D Atthigode

30-May-07 0:15

using sytem.oledb;
using system.windows.forms;

oledbconnection connect=new oledbconnection;
oledbcommand command=new oledbbcommand("Select 'field_name' from 'tabel' where 'condition'", connect);
oledbreader reader=command.executeReader();
reader.read();
{
combobox1.items.add(reader[0].tostring());
}
reader.close();
connect.close();

Re: Populate combobox

matjame30-May-07 0:27

matjame

30-May-07 0:27

using sytem.oledb;
using system.windows.forms;

oledbconnection connect=new oledbconnection;
oledbcommand command=new oledbbcommand("Select 'field_name' from 'tabel'

***There are only two fields. ID & FilterKey and Im using FilterKey
so no need for where *****
where 'condition'", connect);
oledbreader reader=command.executeReader();
reader.read();
{
combobox1.items.add(reader[0].tostring());
}
reader.close();
connect.close();

kagiso

Re: Populate combobox

matjame30-May-07 0:51

matjame

30-May-07 0:51

Ok, its not taking the using system.Windows.forms;

and the combobox1.items.add(reader[0].tostring()); says its doesnot have a definition for Add.

Everything else was what I did before

kagiso

Re: Populate combobox

Shivaprasad D Atthigode30-May-07 1:24

Shivaprasad D Atthigode

30-May-07 1:24

hi if its a web application, it wont take windows.forms, and u wont get combobox control also....

in such case, use
" using system.web.ui.webcontrols; "
{
dropdownlist1.items.add(reader[0].tostring());
}
this will defenetely work Smile | :)

Re: Populate combobox

matjame30-May-07 1:37

matjame

30-May-07 1:37

This should do it.I will keep you posted, jus have to configure my database

kagiso

PictureBox's and the Graphics Class

MarkB77729-May-07 22:58

MarkB777

29-May-07 22:58

Does anyone know why if i draw something using the Graphics class in a picturebox, and then shrink the screen, it disappears when i bring the form up again?

Mark.

Re: PictureBox's and the Graphics Class

Christian Graus29-May-07 23:02

Christian Graus

29-May-07 23:02

Probably because you used the CreateGraphics method ( which is bad ) instead of catching a paint event ( which is good ). Once you're doing more than showing a pciture, the picturebox is useless, you should just put a panel on the screen for sizing, and handle it's paint event, draw the image yourself.

Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"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 )

Queries about coding standards

MarkB77729-May-07 22:56

MarkB777

29-May-07 22:56

Hi,

I'm a self taught programmer and wondered if any commercial programming (or equiv experienced) could enlighten me to standards as far as the naming of variables/methods and program layout go.

I'm aware of the "methods start with capital letters (eg.MethodOne) and variables start with lower case (eg.variableOne).

I've been seeing alot of m_iXDimension though (just as example)... whats with the m_i bit? or is it just coincidence ive seen it in 3 programs ive looked at?

Any info on this or anything else helpful would be appreciated.

Mark.

Re: Queries about coding standards

Christian Graus29-May-07 23:01

Christian Graus

29-May-07 23:01

The i is Hungarian notation, it means that it's an integer ( although n was more commonly used ). Microsoft stopped supporting it when the Hungarian it was named after ( Charles Simoni or something ? ) stopped working for them. The m means it's a member variable. In C#, it's more common to do the _ for a member variable, without the m.

The main thing is, what matters is that if you work with a team, you ask what *their* standard is. It matters not one jot if your member variables start with m or not, what does matter is that your code base is consistent.

How to get kerning pair values from a Typeface/GlyphTypeface

Dmitri Nеstеruk29-May-07 22:55

Dmitri Nеstеruk

29-May-07 22:55

Hi, does anyone know how to get kerning pairs from a font in WPF?

Thanks.

How to add text in table control

EEmaan29-May-07 22:42

EEmaan

29-May-07 22:42

Hi!
i want to use table control in windows application but i couldnot find it, so i searched for it i found its dll from below link

http://www.codeproject.com/cs/miscctrl/TableControl.asp

i added it in my project ,now problem is that i can add row control and column control and then i can add any control in my table using table and column control but i couldnot add text directly in column control to be displayed in table
can anybody help me plz
thanx

Re: How to add text in table control

Christian Graus29-May-07 22:55

Christian Graus

29-May-07 22:55

You probably wanted to use a datagrid or a gridview.

If you're going to use a control from an article, ask about it in the forum under the article itself.

Want to display a hidden form

devesh_code29-May-07 22:25

devesh_code

29-May-07 22:25

Hello

There are two form i.e form1 and form2. There is a send button on the form1. when i click on send, it'll send a message that i m displaying on from2. form2 displays on the another system and form1 is on another system. Application is running on both the system. At form2, there is a reply button. Now i want to show form1 which is in system tray on both the system, when i click on reply.

Thanks

Devesh Mishra

Hello???? This can not be true!

Martin#29-May-07 22:41

Martin#

29-May-07 22:41

You are posting same question again after <3h.
A question which was missunderstood from nearely everybody (including me), ecxept Christian Graus, because it is malformed!
Christian gave you a good advice whcih you ignored!

Again, I can't believe this is happening!
Stop beeing rude! Mad | :mad:

All the best,

Martin

Re: Want to display a hidden form

Christian Graus29-May-07 22:59

Christian Graus

29-May-07 22:59

OK, as someone else said, I told you what you needed to do, and you ignored me and just reposted the question. http://www.codeproject.com/info/search.asp?cats=3&cats=6&searchkw=chat&Submit1=Search&author=&sd=15+Nov+1999&ed=30+May+2007[^]

Took me 2 minutes, and I see at least three articles on what you want to do.

I recommend if you want to become a developer, that you abandon this project, and instead learn some basic skills, both in C#, and in terms of being able to use google. On the other hand, if you want to impress people by showing them code you copied off the web and don't understand, just keep doing what you're doing.

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