Implimenting SQL in C#

We are doing a group project that requires access to a database with C#, but the google does nothing for helping us; how does I shot SQL commands in C#?  That is, how can I go about using SELECT * FROM DATABASE and such commands through .NET code?  We have all the software we need, but we don't know how to us it.

Eat shit and die

ADO.NET

Try something like this,


SqlConnection con = new SqlConnection();
con.ConnectionString = "Data Source="+Server+";Database="+Database+";Integrated Security=True";
con.Open();
SqlCommand cmd = new SqlCommand("select * from faggots", con);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
    doSomethingWithTheData(dr[0], dr[1]);
}
dr.Close();
con.Close();

LOL, he uses /b/ memes.

>>1
Go fuck yourself.

new SqlCommand
Lol OO

C# fails hard for not having any means for metaprogramming.  I can't help you, sorry.

>>7
Explain yourself.

Database server in C   or an enterprise   SOLUTION must offer.

11 Name: Anonymous 2011-02-17 20:28

check 'em dubz

Don't change these.

Name:		Email:
Entire Thread Thread List

All trademarks and copyrights on this site are owned by their respective parties. All comments and posts are the responsibility of their own posters.
- Tinychan + 2ch Mode -