C# displaying query

Question

I want to display my record from the SQL Server db can some help me with the function I need?

I am using C#, SQL Server 2005, the table is created with name and address etc.... etc, I insert it successfully is connected now I want to get the record from the table

Please clarify display. Would that be in a data grid? In a console window? Somewhere else entirely? — Frédéric Hamidi
– Frédéric Hamidi, Commented Nov 20, 2010 at 12:21
You have provided very little information, not enough for anyone to be able to help. How are you accessing the database (what technology)? What is/are the table/s name/s? What data do you need to display? — Oded
– Oded, Commented Nov 20, 2010 at 12:23
@marc: its not issue put any name and any columns use the display query to display result in windows form not console.. display it in any thing i want jusy the basic method — salman
– salman, Commented Nov 20, 2010 at 12:38

Mohamad Alhamoud · Accepted Answer · 2010-11-20 12:33:51Z

4

Your question is unclear but I think you need something like this. and here how to connect a data grid view to a DB.

answered Nov 20, 2010 at 12:33

Mohamad Alhamoud

4,94910 gold badges35 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

marc_s · Accepted Answer · 2010-11-20 15:08:48Z

0

You have lots of options:

straight ADO.NET - use SqlConnection and SqlCommand to grab e.g. DataSets, or data readers, to handle your data
use some kind of an ORM, like Linq-to-SQL, Entity Framework, NHibernate or something else, to turn your database rows and columns into .NET objects
custom code - roll your own ORM or do something else to your liking

Due this vast array of options, it's really hard to know what you're looking for - which options are you interested in?? ADO.NET ? ORM (which one?) ??

answered Nov 20, 2010 at 15:08

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

Collectives™ on Stack Overflow

C# displaying query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related