From your question, I assume that you asking how to query a database using c#? String connString = ConfigurationManager.ConnectionStrings["NorthwindConnectionString"].ToString(); String sSQL = "select * from dbo.Categories "; using (SqlConnection conn = new SqlConnection(connString)) { using (SqlCommand cmd = new SqlCommand()) { conn.Open(); cmd.CommandText = sSQL; cmd.Connection = conn; using (SqlDataReader dr = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection)) { using (DataSet result = new DataSet()) { result.Load(dr); } } } }

Answer

I need help with embedded sql and c#. How does C# implement embedded sql?

Jijgee Jamsran

12y

2.3k

Embedded sql?

Answers (1)

Next Recommended Forum

from the database value to be fetched and placed in tothe another page

How do i get property of object

Forum Statistics

Please welcome our newest member Erin Jose.
3,090,647 users have contributed to 147,405 threads and 483,576
In the past 24 hours, we have 5 new threads, 15 new posts, and 91 new users.
In last week, the most popular thread is 'Will LOV111VOL replace SharePoint worldwide?'.

Upcoming Events

View all

Advancing into the Future with IT
Live Discussion on Startups, AI, and Career Growth
Prompt Engineering Live Show