bind data from database to datagridview combobox - Visual Basic Discussion Boards

Re: Edit and Delete option with gridview

Mycroft Holmes6-Jul-09 19:48

6-Jul-09 19:48

You are working with a completly different control. The DataGridView does not have the concept of the Template column. Google working with DataGridView, there are plenty of examples out there.

Never underestimate the power of human stupidity
RAH

Re: Edit and Delete option with gridview

helelark1236-Jul-09 19:56

helelark123

6-Jul-09 19:56

You need to work with datagridview and add 2 additional columns, for example DataGridViewLinkColumn. For each one of those columns add events, for example:
AddHandler DataGridView1.CellContentClick, AddressOf Lnk_CellContentClick

Private Sub Lnk_CellContentClick(ByVal sender As Object, ByVal e As DataGridViewCellEventArgs)
Select Case e.ColumnIndex
End Select
End Sub

Shay Noy

Infopath: help with implementing code

corbetlp6-Jul-09 4:55

corbetlp

6-Jul-09 4:55

I have been provided these two code sources:

http://www.outlookcode.com/codedetail.aspx?id=88

and

http://www.outlookcode.com/codedetail.aspx?id=83

to generate a new meeting request in Outlook. My goal, is to use code (i've been told these will do what I need) to be able to send a new meeting request via an infopath form. The reason I want this done in Infopath is so that I can generate a print view form for users to have a custom brochure. I would like for users to fill out the form in infopath and upon clicking the submit button, have the meeting request send in outlook. I am not very familiar with coding, so if someone could walk me through the steps to implement this (or another) code to make this happen, I'd greatly appreciate it.

Thank you.

Re: Infopath: help with implementing code

Eddy Vluggen7-Jul-09 3:48

Eddy Vluggen

7-Jul-09 3:48

Programming is somewhat more complicated then browsing for code-snippets and mixing them. You might consider outsourcing your project if you have no practical experience.

My apologies, I know that this isn't the answer you had hoped for.

I are troll Smile | :)

bios date/time

vishal lele6-Jul-09 1:27

vishal lele

6-Jul-09 1:27

hi i want to use bios date in my application ,i want use this date in my
application expipry coding which developed in vb.net.Please tell me how i can get the bios date in my application.

Re: bios date/time

dan!sh 6-Jul-09 1:57

dan!sh

6-Jul-09 1:57

DateTime.Now should work since whenever you change Windows clock BIOS time changes as well.

Re: bios date/time

Henry Minute6-Jul-09 11:57

Henry Minute

6-Jul-09 11:57

You should not post the same question in more than one forum. It is rude.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

bind data from database to datagridview combobox

KIDYA6-Jul-09 1:25

KIDYA

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

Re: bind data from database to datagridview combobox

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

KIDYA

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

Adding a Unbound Image Column to Datagrid

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

helelark123

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

how to take images path into an array

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!!

Re: how to take images path into an array

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

Re: how to take images path into an array

helelark1235-Jul-09 21:08

helelark123

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

Re: how to take images path into an array

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?

Re: how to take images path into an array

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)

Re: how to take images path into an array

helelark1236-Jul-09 19:18

helelark123

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

Re: how to take images path into an array

KIDYA7-Jul-09 0:08

KIDYA

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....

Re: how to take images path into an array

helelark1237-Jul-09 1:44

helelark123

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

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