Visual Basic

Problems binding datarelations to a listbox

13-Sep-07 4:10

RX Maverick wrote:
imageBmp = New Bitmap(imageBmp, New Size(imageWidth, imageHeight))
To me that feels sloppy

No, that's what you have to do.

RX Maverick wrote:
and so far I can't figure out a nice way to make a single like way to crop,

I think you're asking if there is a "single LINE" way to crop an image. No, there isn't. You have to create a new bitmap the size you want the cropped image to be, then copy the bits from the old bitmap to the new one.

RX Maverick wrote:
Would it be better for me to do both at once (resize and crop) by making a second image and using DrawImage like in the code below (currently it just crops)?

You could do it in one operation, but I wouldn't for right now. Get your app to work the way you want first, without worrying about wasting a ton of resources. If you're not constantly resizing and cropping an image, then this code should work just fine. It's one image operation. You're not really taxing the processor at all doing this.

A guide to posting questions on CodeProject[^]

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

Mr Oizo12-Sep-07 9:31

12-Sep-07 9:31

Hi. I need to bind alistbox control to my table named genre. genre has a one-to-many relaionship with a table called song. What is happening is that I have bound my datagrid to table song. Table "song" has a column named genrename(foreign key) which also exists in the parent table "Genre" as a primary fey. I need my listbox to be able to select a genre for a specifc song(selected in the datagrid) and update the song tables genrename field for that song. If a user selects a genre all songs for a specific genre wil be listed then. please help

Mr Oizo

Dave Kreskowiak13-Sep-07 4:01

13-Sep-07 4:01

From your description, if I understand it, you're looking at two different situations.

The first is updating the Genre of a selected Song or multiple Songs. All you need to do is retrieve the Genre table's PK and Name columns and bind a ComboBox to that table. When the user selects something, the Combo's SelectedItem will fire, where you'll update the FK Genre column in the Songs table.

The second is if a ComboBox selection is made, all the Songs from the selected Genre should be returned.

This is two different operations, so I'd probably use two different ComboBox's to do this. One for searching and one for updating.

A guide to posting questions on CodeProject[^]

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

Mr Oizo13-Sep-07 11:26

13-Sep-07 11:26

I have a datagridview on the same form. If I select a genre from the combobox it is meant to update the datgridview and the datagrid view then saves to the database. For some reason the value that it displays is "system.Data.datagridview" instead of the selected genre. I currently have set the datamember property to the dataset itself and the displaymember property to "genrename" the actual primary key and only field within the genre table(genre names need to be unique).Is this how to bind it or do i need to bind it somewhere else. Please help??? Mr Kreskowiak or anybody

Mr Oizo

Dave Kreskowiak13-Sep-07 12:38

13-Sep-07 12:38

Mr Oizo wrote:
For some reason the value that it displays is "system.Data.datagridview" instead of the selected genre

And the code you're using that gets the value from the Combo would be ...??? Basically, what's causing that string to show up is that, somehow, your code is calling the ToString method on a DataGridView, instead of what you intended.

I get the feeling you're using all the designer generated stuff and not writing much, or any code, to do what you want?? I simply don't see that working.

Mr Oizo wrote:
datamember property to the dataset itself and the displaymember property to "genrename"

I hope you really set the DataSource property to a DataTable, not a DataSet. A DataSet is a collection of DataTable objects and any DataRelations between those tables.

A guide to posting questions on CodeProject[^]

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

Mr Oizo15-Sep-07 0:36

15-Sep-07 0:36

i use:

For i = 0 To dgSongProperties.Rows.Count - 1
If dgSongProperties.Rows(i).Selected = True Then
index = i

Call ShowCurrentSong(index)
End If

Next

Public sub showCurrentSong(index as integer)

' Other code for the various fields

' this code is to set the displayed values for a particular datgrid row in the various textboxes and combo boxes on the form (cmbGenre is the combo box)

If (dgSongProperties.Rows(index).Cells("Genre").Value) Is DBNull.Value Then
cmbGenre.SelectedText = ""
Else
cmbGenre.SelectedValue = CStr(dgSongProperties.Rows(index).Cells("Genre").Value.ToString)
End If

End sub

" i then have a sub called update datgird which works for allt he fields except genre at the moment(it displays system.data.dataviewrow instead of the selcted genre)

the code for the genre update for the datagrid is:

dgSongProperties.Rows(index).Cells("Genre").Value = cmbGenre.SelectedItem

(I have also tried cmbGenre.selectedvalue and also called the toString method.....None work)
The datasource for the combobox is dsLibrary.Genre
and for display member : dsLibrary.Genre.GenreName

What am I doing wrong here???????
I thought these tools were made to make life easy. Vb2003 seems easy compared to this. Please help

Mr Oizo

Dave Kreskowiak15-Sep-07 2:11

15-Sep-07 2:11

Mr Oizo wrote:
dgSongProperties.Rows(index).Cells("Genre").Value = cmbGenre.SelectedItem

Take a look at the cmbGenre.SelectedItem part. What you think SelectedItem returns?? You're trying to use SelectedItem and SelectedValue interchangably. I can assure you they have very different purposes. Change SelectedItem to SelectedValue.

A guide to posting questions on CodeProject[^]

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

Mr Oizo16-Sep-07 2:13

16-Sep-07 2:13

I changed it from selectedItem to selectedValue and it still doesn't work. Still displays "system.data.dataviewrow"

in this code i get an error message saying "Cannot set the SelectedValue in a ListControl with an empty ValueMember."

If (dgSongProperties.Rows(index).Cells("Genre").Value) Is DBNull.Value Or (dgSongProperties.Rows(index).Cells("Genre").Value) Is Nothing Then
cmbGenre.SelectedValue = ""
Else

"The error happens for the code below. "
cmbGenre.SelectedValue = CStr(dgSongProperties.Rows(index).Cells("Genre").Value)
End If

I have tried puttin genres in the song table in MS ACCESS so there is a value in dgSongproperties.Rows(index).cells("Genre").value but that still gives the error message.I want the value in the datagridview selected row genre to be the selected one in the genre combo box??? Confused | :confused:

Mr Oizo

Dave Kreskowiak16-Sep-07 4:46

16-Sep-07 4:46

OK, this is really messed up.

Mr Oizo wrote:
dgSongProperties.Rows(index).Cells("Genre").Value

You're getting the value out of the datagrid by an index?? Where's the index coming from?

Your posting single lines of code, but nothing around it, or what events these lines are in, so it's really difficult to get a hnadle on what your doing. We can go round and round with little bits of your code all month and still not get it fixed because it would take a code review to see what you did where and why. That simply isn't going to happen in a forum environment. (Don't even think of posting the entire project somewhere. I don have my own job to do and I have a life.)

A guide to posting questions on CodeProject[^]

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

Mr Oizo16-Sep-07 5:25

16-Sep-07 5:25

Hi. The index was from a for loop that returns the index of the selected row in the datagridview. All I need is for the selected rows genre column value to be the value that is dislayed in the combobox. I am aware that you must be a busy man. Very sorry for bugging you but I'm just stuck with such a small thing Sigh | :sigh:

Mr Oizo

Dave Kreskowiak16-Sep-07 5:52

16-Sep-07 5:52

Mr Oizo wrote:
The index was from a for loop that returns the index of the selected row in the datagridview.

Why the loop? What does the code look like???

A guide to posting questions on CodeProject[^]

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

Mr Oizo16-Sep-07 7:52

Re: solution config file ?

16-Sep-07 7:52

Well im using a loop so i can select that row index for updating(wasn't sure if there was another way, still a dumb student D'Oh! | :doh:

)

the loop is as follows:

For i = 0 To dgSongProperties.Rows.Count - 1
If dgSongProperties.Rows(i).Selected = True Then
index = i

Call ShowCurrentSong(index)
End If

Public sub ShowCurrentCong(index as integer)

'other code for the various fields (which works fine)

If (dgSongProperties.Rows(index).Cells("Genre").Value) Is DBNull.Value Or (dgSongProperties.Rows(index).Cells("Genre").Value) Is Nothing Then
cmbGenre.SelectedValue = ""
Else

'this is the problem code
cmbGenre.SelectedValue = CStr(dgSongProperties.Rows(index).Cells("Genre").Value)
End If

End sub

If you want me to stop asking you questions i will. I understand Smile | :)

Mr Oizo

solution config file ?

ttilque12-Sep-07 8:38

ttilque

12-Sep-07 8:38

We are developing a windows application that has several projects under one solution.
The problem we have run into is that we have connectionstrings in app.config files for each project.
We would like to have just one config file that all of the projects in the solution use.
Is there a way to do this or are there other ways that people normally handle this.

Naji El Kotob12-Sep-07 9:57

Naji El Kotob

12-Sep-07 9:57

Hi,

Dim cfgMap As New ExeConfigurationFileMap
cfgMap.ExeConfigFilename = "MyConfigFile.exe.config"
cfg = ConfigurationManager.OpenMappedExeConfiguration(cfgMap, ConfigurationUserLevel.None)

For i As Integer = 0 To cfg.ConnectionStrings.ConnectionStrings.Count - 1
MsgBox(cfg.ConnectionStrings.ConnectionStrings(i).ConnectionString)
Next

Note: The type of extra applications in your solution is dll or exe?

Hope this helps Smile | :)

NajiCo http://www.InsideVB.NET[^]

It's nice 2b important, but it's more important 2b nice...

Re: solution config file ?

ttilque13-Sep-07 1:10

ttilque

13-Sep-07 1:10

Pardon my ingorance but what should cfg be declared as ?

Thanks in advance...

Re: solution config file ?

Dave Kreskowiak13-Sep-07 3:54

13-Sep-07 3:54

You can find that out by looking at the return type of the ConfigurationManager.OpenMappedExeConfiguration method, which is Configuration out of the System.Configuration namespace.

A guide to posting questions on CodeProject[^]

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

Automatic Namespaces

Mark0612-Sep-07 6:19

Mark06

12-Sep-07 6:19

Hi,
By default, when adding a folder to a C# project, it will affect the namespace of new classes contained there.
EG: Add a folder called dummy. then a class below, the IDE automatically inserts "namespace classlibrary1.dummy" into the class.

Is there anyway to turn this on in VB.Net?

Re: Automatic Namespaces

Dave Kreskowiak13-Sep-07 3:52