Visual Basic

Re: bind data from database to datagridview combobox

6-Jul-09 1:25

Hello Experts!!

I am using following code to bind data from db to datagridview column having type combobox. but i dont know how to show data into combobox.

Dim o As New designpant
       Dim i As Integer
       rssearch = New ADODB.Recordset
       rssearch.Open("select srno from designpant", con, ADODB.CursorTypeEnum.adOpenDynamic, ADODB.LockTypeEnum.adLockPessimistic)
       While Not rssearch.EOF
           o = New designpant
           o.dsrno = rssearch.Fields("srno").Value

           Dim row1() As String = {o.dsrno}
           Dim rows() As Object = {row1}
           Dim rowArray As String()
           For Each rowArray In rows
                  Dim no As Integer = rowArray(0)
               'ComboBox1.Items.Add(no)
               dgvsherwanibottom.Columns  //like combobox1 i want to show rowArray contents into gridview combobox              Next rowArray

dan!sh 6-Jul-09 2:04

dan!sh

6-Jul-09 2:04

1. DataGridViewComboBoxColumn
2. DataGridViewComboBoxColumn.DataSource
3. DataGridViewComboBoxColumn.DisplayMember
4. DataGridViewComboBoxColumn.ValueMember

Re: bind data from database to datagridview combobox

KIDYA6-Jul-09 2:57

Adding a Unbound Image Column to Datagrid

6-Jul-09 2:57

In my code it shows only DataGridViewComboBoxColumn.Equals and DataGridViewComboBoxColumn.reference properties

Does i made any mistake?

Where i have to write this??

i am trying it in form load.

Concerning XSDs....

LostMonkey6-Jul-09 0:50

LostMonkey

6-Jul-09 0:50

All,

This may be a silly question, but what is the accepted "norm" when using XSD files in a project?

For me I see 2 ways to use them...either make a huge one that is a schema of your database and define all the relationships etc within it.

OR

Define lots of little ones that perform certain tasks, for example you may create an XSD that might contain just the schema, relations etc for a Customer/Order/Order Line/Product scenario.

I can see the big all in one file being a bit slow when creating objects from it but easier to maintain, but I can see the smaller one being more task focused but a bugger to maintain...or is that the trade-off?

So, generally, what is the "best" usage for a given scenario or what is the accepted "norm" when dealing with these files??

Thanks,

Monkey

Re: Concerning XSDs....

Rozis7-Jul-09 6:54

Rozis

7-Jul-09 6:54

If you use XSD's as a definition of your datamodel i would surely choose for one definition. Otherwise you will get the same problems as 2 apps each having a seperate database that must communicate with eachother (how do you maintain integrity then?)

Rozis

Member 44205345-Jul-09 22:24

Member 4420534

5-Jul-09 22:24

Hi there, hope someone can assist me on this.

Ive got a datatable that gets Data from SQL.
Now what I want to do is add a unbound Image datacolumn to this datatable.

But the image must be a linkbutton.
When its gets click it should redirect to a page carrying over the other datagrid Colums as parameters.For instanse

-------------------------------------------
Col1 | Col2| Col3| Col4 | NewImageColumn
--------------------------------------------
Row1 Row1 Row1 Row1 Row1
Row2 Row2 ROw2 Row2 Row2
Row3 Row3 Row3 Row3 Row3

Lets assume the DataTable has 3 rows
When clicking on the NewImageColumn on lets say row 2
it should Redirect(pgSomepage.aspx? Row2.Col1 & Row2.Col2 & Row2.Col3 & Row2.Col4

Re: Adding a Unbound Image Column to Datagrid

Tom Deketelaere5-Jul-09 22:38

Tom Deketelaere

5-Jul-09 22:38

Member 4420534 wrote:
redirect to a page carrying over the other datagrid Colums as parameters.

Sounds like this is a web application?

Try the ASP.NET[^] forum.

Re: Adding a Unbound Image Column to Datagrid

Member 44205345-Jul-09 22:46

Member 4420534

5-Jul-09 22:46

Yes indeed

Write field Value

vijay24825-Jul-09 21:41

vijay2482

5-Jul-09 21:41

Hi all,

modified 28-Nov-12 8:02am.

Re: Write field Value

helelark1236-Jul-09 19:48

how to take images path into an array

6-Jul-09 19:48

You should minimized and focus your question, although to give an example of what you need because few persons will try to understand what you need

Shay Noy

AjitMourya5-Jul-09 20:51

AjitMourya

5-Jul-09 20:51

Hello experts!!

I have to move picture box on to form,for static image it works but for multiimages in same picture box dont know how to handle.

if i take all images path into an array then i must show it in picturebox.but dont know how to take path into an array?

Can anybody tell me how to do it???
for any idea always welcome!!

0x3c05-Jul-09 20:57

0x3c0

5-Jul-09 20:57

As you've discovered, a PictureBox only shows one picture at a time. If you want to show multiple pictures, then you need to either have an collection of PictureBoxes, or draw the images onto the PictureBox's Image manually. Look up the System.Drawing namespace for details, or search Google

Between the idea
And the reality
Between the motion
And the act
Falls the Shadow

helelark1235-Jul-09 21:08

5-Jul-09 21:08

I am not sure about what you are asking for, but following snippet code demonstrating how to work with PictureBox and array:

Public Class Form1
Private arrImages() As String
Const PicNumber As Integer = 3

Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
ReDim arrImages(PicNumber - 1)

arrImages(0) = "C:\Documents and Settings\All Users\Documents\My Pictures\Sample Pictures\Blue hills.jpg" '"Path1"
arrImages(1) = "C:\Documents and Settings\All Users\Documents\My Pictures\Sample Pictures\Sunset.jpg" '"Path2"
arrImages(2) = "C:\Documents and Settings\All Users\Documents\My Pictures\Sample Pictures\Water lilies.jpg" '"Path3"

End Sub

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Static ind As Integer

ind = ind Mod (PicNumber)

PictureBox1.SizeMode = PictureBoxSizeMode.StretchImage
PictureBox1.Image = Image.FromFile(arrImages(ind))

ind += 1
End Sub

End Class

Instead of Button1, you can put a timer that will display your pictures like presentation (you may have to add Application.Doevents in the timer event)

Shay Noy

AjitMourya5-Jul-09 21:42

AjitMourya

5-Jul-09 21:42

thanx,it worked... Big Grin | :-D

...do you know how to add images into array from folder?

Pasan1486-Jul-09 0:55

Pasan148

6-Jul-09 0:55

Declare array with 'Image' type
dim Picarray (1) as Image
Picarray(0) = System.Drawing.Image.Fromfile(ImagePath)
Picarray(1) = System.Drawing.Image.Fromfile(ImagePath)

helelark1236-Jul-09 19:18

6-Jul-09 19:18

You know the questions you are asking are very simple for beeing found in google. You only have to work a little and enter in google something like that: "load images from folder to array + vb.net" OR "updload inages from folder" etc...

The snippet code should be something like that: (I didn't compile or run it, but this is the concept)

private sub f()
dim fld as new IO.directoryinfo(YourFolderPath)
dim arrImages() as string 'or images as you need
dim ind as integer =0

for each fil as IO.fileInfo in fld.getFiles("*.your extension")
redim preserve arrImages(ind)
arrImages(ind)=... 'like the first answer I gave you
ind+=1
next

fld=nothing
end sub

Shay Noy

KIDYA7-Jul-09 0:08

7-Jul-09 0:08

Your posted code helped me also but i have one more query -How to take images dynamically means i dont know images name.If i replace all images from same folder then what to do??
So i want code for that in which image name is not fix....

helelark1237-Jul-09 1:44

7-Jul-09 1:44

If I understood your question, you do not have to know image name. When you loop into the folder that contains all the images, the name property of the fil (as IO.FIleInfo) variable handle the name of the image file.

Shay Noy

KIDYA7-Jul-09 2:34

7-Jul-09 2:34

ok,i got it but can you please tel me code at following line posted earlier by you which solve my problem and confusion...

arrImages(ind)=... 'like the first answer I gave you

In first reply you wrote there path of file...thats why i am confuse..

Kidya

helelark1237-Jul-09 10:05

7-Jul-09 10:05

Option Explicit On
Imports System.IO

Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim fld As New DirectoryInfo("C:\MyPictures\")
Dim arrImages() As String, ind As Integer = 0

For Each fil As FileInfo In fld.GetFiles("*.jpg")
ReDim Preserve arrImages(ind)

arrImages(ind) = fil.FullName
ind += 1
Next
End Sub
End Class

hope it helps you

Shay Noy

KIDYA7-Jul-09 22:54