ASP.net Events Calendar using SQL
I would love it if someone would take the tutorial Joel Martinez did on Using the ASP.NET Calendar Control and expand upon it ecspecially expand upon the Outputting the data int he calander. He did this tutorial to work with Access but i would love it to be wrote for the very many of us using SQL.
Here is a link to his tutorial http://www.macromedia.com/devnet/mx/dreamweaver/articles/aspnet_calendar.html
Really love to see this one or make an extension for it.
I would love it if someone would take the tutorial Joel Martinez did on Using the ASP.NET Calendar Control and expand upon it ecspecially expand upon the Outputting the data int he calander. He did this tutorial to work with Access but i would love it to be wrote for the very many of us using SQL.
Here is a link to his tutorial http://www.macromedia.com/devnet/mx/dreamweaver/articles/aspnet_calendar.html
Really love to see this one or make an extension for it.
Comments
SQL Connection
I really enjoyed this tutorial and also wanted to use a SQL database.
I imported his Access database and then changed the connection string from:
string connectionstring = "Provider=Microsoft.Jet.OLEDB.4.0;Data source="+ Server.MapPath("aspnet_calendar.mdb") +";";
to:
string connectionstring = "Driver={SQL Server}; provider="SQLOLEDB;" server="YOURSERVERNAME;" database="PDC;" uid="YOURUSERNAME;" pwd="YOURPASSWORD"";
Don't forget to give your user permissions to use the new database table. Replace the UPPERCASE items with your SQL server data. Look at one of your other SQL connection strings for other databases you use in Dreamweaver.
Now I am off to try and adapt it to one of my current databases.
This is my first post to try and help out so I hope it helps!
Thanks,
Carl
You must me logged in to write a comment.