|
What a mess
matjame wrote: con.ConnectionString = str;
what is str, and why is a member variable named so badly ?
matjame wrote: String str1 = "Select * from Filter";
You never use this anywhere, so it's irrelevant to the rest of the code.
What is con, cm and dtr ? Why do you have badly named member variables like this, that probably could be local, and are not named in a way that means anything ?
matjame wrote: cboExtension.Text = (dtr["FilterKey"]).ToString();<<*****Problem****
What's the problem ? Does it not compile ? Does it blow up ? What's the error message ?
This is also not going to do more than add one value into the combo box. That's what the Text property will do. To add items, make a collection the datasource, and if it's not a collection of strings, set the DisplayMember property.
All of this looks to me like you're making it up as you go and hoping it will work. Intellisense is no substitute for reading MSDN or buying a good book as a reference.
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 )
|
|
|
|
|
|
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...
|
|
|
|
|
sujithkumarsl wrote: status = ExecuteNonQuery_SP("Select * from Filter");//getting the value
cmbStatus.DataSource =status ;
 
|
|
|
|
|
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...
|
|
|
|
|
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.
|
|
|
|
|
Im using MS Access not SQL
kagiso
|
|
|
|
|
 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());
}
|
|
|
|
|
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
|
|
|
|
|
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...
|
|
|
|
|
I want to filter by FilterKey
kagiso
|
|
|
|
|
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();
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
This should do it.I will keep you posted, jus have to configure my database
kagiso
|
|
|
|
|
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.
|
|
|
|
|
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 )
|
|
|
|
|
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.
|
|
|
|
|
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.
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 )
|
|
|
|
|
Hi, does anyone know how to get kerning pairs from a font in WPF?
Thanks.
|
|
|
|
|
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
|
|
|
|
|
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.
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 )
|
|
|
|
|
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
|
|
|
|
|
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! 
All the best,
Martin
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
