ListView Control Displaying Records through a SQL Query

Question

0.00/5 (No votes)

See more:

ListView Control should display records of a SQL Table depending on a Query.
It should have the Column headings and when we press the down arrow it should select all the columns of the rows.

please tell to what will be code to get the value of a particular cell using static Column no. and dynamic rows no. at run time.

thanks in advance.

Posted 21-Dec-11 6:51am

Sourav Sarkar-SS

Add a Solution

2 solutions

Solution 1

SQL

select column_name from information_schema.columns
where table_name = 'MenuItems'
order by ordinal_position

Above query will retrun the column names belong to specific table

http://doitdotnet.wordpress.com/2011/12/21/how-to-get-all-field-names-in-a-table-using-sql-query/[^]

You can get the column names using the above query by passing the table as a parameter. then in the selected index changed you can pass the column name paramter to a query which will return all the values of that column in table rows

Posted 21-Dec-11 7:09am

doit4dotnet

Comments

[no name] 21-Dec-11 14:04pm

Thanks for your Reply.
Query is executing perfectly.
but values are creating problem for me.
what I want is to Fill the listView in a way that it will look like a DataGridView Control.
Thanks again.

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)

Wendelius · Accepted Answer · 2011-12-21T08:57:00

Solution 2

If you're having problems in filling the listview, perhaps this would help: http://www.akadia.com/services/dotnet_listview_sort_dataset.html[^]

About the selection, you can use ListView.SelectedItems Property [^]. Then you can either get the value from the proper subitem or perhaps it would be better to get it from the datatable.

Posted 21-Dec-11 8:57am

Wendelius

Comments

[no name] 21-Dec-11 15:04pm

Thanks for the reply mika.
I will try the process.

Wendelius 21-Dec-11 15:09pm

You're welcome :) Hopefully it helps.