DataGridView ComboBox Column

Question

5.00/5 (1 vote)

See more:

Hi,

I am creating a VB.Net Application. I have a datagridview in form and bind using datasource.

After bind suppose the datagridview structure like -

column1 | column2 | column3 | column4 | column15
-----------------------------------------------------
value 1 | value 2 | value 3 | value 4 | value 5
value 1 | value 9 | value 3 | value 4 | value 5

You can see only column2 has different values. Now i want instead on adding 2nd row (duplicate) both the value (value 2 and value9 ) show in combobox of row 1

Posted 2-Jan-13 20:35pm

kals84

Updated 2-Jan-13 20:49pm

Aarti Meswania

v2

Add a Solution

Comments

Abhishek Pant 3-Jan-13 2:54am

genrate the combobox at runtime

[no name] 3-Jan-13 20:06pm

Copy your data selection and data binding code here.

You need to bind your combobox at datagridview DataBound level.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

kals84 · Answer 1 · 2013-01-03T17:53:00

This is basically a book store application. Suppose any customer wants the books of particular class, all the books with detail load in datagridview. 1 book can have multiple edition. I want those books have multiple edition show in single row with option of choose edition (can be combobox).

I have bind the datagridview but failed to produced above describe structure

VB

Dim conn As SqlConnection = New SqlConnection(connectionString)
conn.Open()

Dim command As SqlCommand

command = New SqlCommand("invoice_sales_board_class_all", conn)
command.CommandType = CommandType.StoredProcedure
command.Parameters.Add("@board", SqlDbType.NVarChar).Value = board_name
command.Parameters.Add("@class", SqlDbType.NVarChar).Value = class_name
command.Parameters.Add("@storeid", SqlDbType.Int).Value = public_store_id

Dim adapter As SqlDataAdapter = New SqlDataAdapter(command)
adapter.Fill(ds)

DataGridView1.AutoGenerateColumns = False
DataGridView1.DataSource = ds.Tables(0)
conn.Close()