Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
2
Reply
Select query for retrieve data from temporary DataTable?
Mani Kandan
Jul 5 2016 4:59 AM
257
Reply
Sir,
How can I write this inline sql (That is,
cmdstr
) query to datarow c#?
string cmdstr = "select top 5 First_name, COUNT(Department) [Department] from Employee group by First_name";
DataTable dt = new DataTable("Employee");
dt.Columns.Add(new DataColumn("Id", typeof(int)));
dt.Columns.Add(new DataColumn("First_name", typeof(string)));
dt.Columns.Add(new DataColumn("Department", typeof(int)));
dt.Rows.Add(1, "Jerry", 1);
dt.Rows.Add(2, "Mudassar", 1);
dt.Rows.Add(3, "Mathews", 1);
dt.Rows.Add(4, "Robert", 1);
dt.Rows.Add(5, "John", 1);
DataRow[]
result
=?
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
prime numbers in 1 to 100
ContexmenuStrip