I wanted to share this more than anything, it took me most of the morning searching and finding various post on various sites but I got it figured out and working. It might be better coded, but it is a start for some one trying to understand how linq and ASP.Net things work.
What I have is a database table with a datetime in string format and a stored procedure which returns all the data.
What I want to do is load a dropdown list with MonthName and Year for a selection choice on generating monthly report.
The stored procedure is in a Linq to SQL class dbml and the connection string is dynamic, i.e., made througha call to another class.
here is the code. Enjoy understanding how it works.
// Miscellaneous Details are filled in for helping you get the big picture.
// Some of the using statements are for other things in the code behind,
// but I left it in so don't get confused,
public partial class TheReportPage : System.Web.UI.Page
protected void Page_Load(object sender, EventArgs e)
View Complete Post