TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Ron
NA
14
0
Selection from datbound combo box to choose binary image in windows form
Jan 2 2010 9:10 AM
Hello, I am trying to create a windows form that a user will use a databound selection from combo box to choose an image to be displayed in a picture box or datagrid. The selection is base on categories and one selection may have multiple images associated with it.
I use a class to populate my combo box.
public
class
AddValue
{
private
string
m_Display;
private
long
m_Value;
public
AddValue(
string
Display,
long
Value)
{
m_Display = Display;
m_Value = Value;
}
public
string
Display
{
get
{
return
m_Display; }
}
public
long
Value
{
get
{
return
m_Value; }
}
and my combo box is populated in this manner
SqlConnection
roy =
new
SqlConnection
(
@"server=CAPTSISKO-PC\SQLEXPRESS;Initial Catalog=cable;Integrated Security=True"
);
string
roySetup1 =
@"Select * from GuideFeatures"
;
SqlCommand
sqlCommand1 =
new
SqlCommand
(roySetup1, roy);
roy.Open();
SqlDataReader
rbList1 = sqlCommand1.ExecuteReader();
ArrayList
setup1 =
new
ArrayList
();
while
(rbList1.Read())
{
setup1.Add(
new
AddValue
(rbList1.GetString(1), rbList1.GetInt32(0)));
}
rbList1.Close();
roy.Close();
comboBox1.DataSource = setup1;
comboBox1.DisplayMember =
"Display"
;
comboBox1.ValueMember =
"Value"
;
comboBox1.SelectedIndex = 4;
The problem I am running into is when I try to pull the information from the combox box selection into datagrid is
The mult-part identifier "PicForm.Form1" could not be bound. Invalid column name AddValue.
Here is my code for the datagrid
string
instrPic = comboBox1.SelectedItem.ToString();
SqlConnection
roy1 =
new
SqlConnection
(
@"server=CAPTSISKO-PC\SQLEXPRESS;Initial Catalog=cable;Integrated Security=True"
);
roy1.Open();
string
newPic =
"Select Pic from guidePic WHERE picTitle = "
+ instrPic +
""
;
DataSet
ds =
new
DataSet
();
SqlDataAdapter
da =
new
SqlDataAdapter
(newPic, roy1);
da.Fill(ds,
"newPic"
);
dataGridView1.DataSource = ds;
dataGridView1.DataMember =
"newPic"
;
roy1.Close();
when I look at the process in debug mode the combobox.selecteditem.tostring() has the selection in it but it displays {picform.form1.AddValue}, is there a way i can pull the display answer out of this, it is there I just don't know how to get it to display instead of the AddValue.
Oh is it easier to put the image in a picture box instead of datagrid also, not sure how to do that
Thanks
Reply
Answers (
1
)
how to restrict usercontrol event in windows form application
how to add usercontrol to datagriview in windows forms.