Click here to Skip to main content
15,888,351 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hello everybody ;
I am an Asp.net new beginner, and I need somebody to help me ..
actually I work on an instance of fullCalender This one !
My question is about how to populate the draggable events area from a sqlserver database using ado.net and how to save events into a database ...
I hope that my question is clear enough for you ..
THANK YOU VERY MUCH :-)
Posted
Updated 10-Jan-12 11:41am
v2

I'm not familiar with the control, but to communicate with SQL Server:
- define a SqlCOnnection[^]
- use proper connection string, refer to http://www.connectionstrings.com/[^]
- define a SqlCommand[^] to fetch or update/insert the data
- use for example a SqlDataAdapter to fill a datatable[^]
- show the fetched event list from the database
- and when you want to save, again: open connection, define a command, define and set the parameters and their values, call command's ExecuteNonQUery
- also use SqlParameter[^] in your queries

And when the database operations are done properly (as they should be done) wrap the command executions inside a SqlTransaction[^]
 
Share this answer
 
Is nobody knows !!
thanks Mika Wendelius but that's not what i mean , i know how to fill from date base and how to make connection my problem is how to interact my code using vb and source code of fullcalendar !
and thank you so much !
 
Share this answer
 
Comments
Mehdi Gholam 11-Jan-12 2:10am    
Use the comments if you need further assistance, do not post solutions.
You are lucky! You have the solution with you. Your sample -
http://arshaw.com/js/fullcalendar-1.5.2/demos/external-dragging.html- source, "View Source", has the solution. This uses (as I already guessed!) jQuery UI plugin.

One thing is sure - you have to do some good amount of client side coding using javascript(jQuery or someother framework).

For retrieving/saving event data to server you may have to use ajax. jQuery has a fine set of ajax commands to use.

I'm sure you can do the job. First start with small sample using jQuery- drag & drop a <div> html control. Then go for a bigger fish!

Good luck my friend!
 
Share this answer
 
v3

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900