get data from database with out query

Question

Is there any way to retrive data from Database with out writing any sql query . I mean i want to read data into my label fileds with out writing any query in sqlcommand.Please anyone help me or tell me how can i do this in c# or vb.net

Update

 protected void Page_Load(object sender, System.EventArgs e)
    {
        string connectionString = @"Data Source=Data Source=.\SQLEXPRESS;AttachDbFilename=E:\Test\Database.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True";
         SqlConnection con = new SqlConnection(connectionString);        
        con.Open();
        SqlCommand cmd = new SqlCommand("Select * from Test", con);
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds, "Test");
        GridView1.DataSource = ds;
        GridView1.DataBind();        
        con.Close();
    }

using LINQ is also similar to querying the database. To get the data from database we need to send the request. and that request is your select statement which will give you results as per the query. — Murtaza
– Murtaza, Commented Feb 24, 2012 at 13:01

Community · Accepted Answer · 2017-05-23 12:20:03Z

3

If you don't want to write direct SQL queries, then another option is ORMs like:

Here's a related post: https://stackoverflow.com/questions/3505/what-are-your-favorite-net-object-relational-mappers-orm

Depending on how much database interactions you need, you may find the few lines to execute a SQL command query directly easier. If you need to do quite a bit of DB interactions with objects then an ORM may be more productive for you.

Code samples are outside the scope of a question because you need to setup mappings etc... but here's a getting started with tutorial: http://msdn.microsoft.com/en-us/library/bb386876.aspx

edited May 23, 2017 at 12:20

CommunityBot

11 silver badge

answered Feb 24, 2012 at 12:31

bryanmac

39.3k10 gold badges93 silver badges99 bronze badges

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

Comments

alundy · Accepted Answer · 2012-02-24 12:34:00Z

2

You might want to find an ORM.

Linq to Sql and Entity Framework are a couple you can use out of the box in .Net.

answered Feb 24, 2012 at 12:34

alundy

8578 silver badges22 bronze badges

2 Comments

alundy Over a year ago

You'll need to create a datasource in your .Net project to use either, then objects based on your SQL tables/views will be generated for you to use in your code. There are many examples for both Linq 2 Sql and EF on the web.

alundy Over a year ago

Linq to SQL tutorial: weblogs.asp.net/scottgu/archive/2007/05/19/…

Arion · Accepted Answer · 2012-02-24 12:37:52Z

1

You can use linq to sql. Here is a some examples

answered Feb 24, 2012 at 12:37

Arion

31.3k10 gold badges75 silver badges89 bronze badges

Comments

Virus · Accepted Answer · 2012-02-24 12:33:11Z

0

Sorry I am not sure I understand your question, but I do not think there is a way to get 'any' data from DATABASE without querying. You may have to use a simple select query to return the data from a table or a stored procedure.

answered Feb 24, 2012 at 12:33

Virus

3,4558 gold badges31 silver badges47 bronze badges

Comments

Virus · Accepted Answer · 2012-02-24 12:49:15Z

0

Framework 2.0 doesn't support LINQ! U can't use entity framework or LINQ in framework 2.0. Try framewerk 4.0. If not u have to write a query.

answered Feb 24, 2012 at 12:49

Virus

3,4558 gold badges31 silver badges47 bronze badges

Comments

Kishore Kumar · Accepted Answer · 2012-03-19 10:51:00Z

0

You can use Strongly Typed DataSet File and then return data into your label

answered Mar 19, 2012 at 10:51

Kishore Kumar

12.9k27 gold badges99 silver badges158 bronze badges

Collectives™ on Stack Overflow

get data from database with out query

6 Answers 6

Comments

2 Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

Comments

2 Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related