Sorry !! I didnt know it has been posted twice. the first time I posted it didnt appear on the forum board and gave me a message saying the website is installing some updates.:confused:

Hi people, I want to have a print button in my GUI to print the contents of a panel (control drawn using Graphics class) perhaps to take a screenshot of the panel and print it out as an image. Does anyone have any idea how I can do this? Cheers :)

During runtime when I execute shiftInsertNewRow() method I get a Format exception at this line: command.ExecuteNonQuery() that says input string was not in a correct format.

it threw the same format exception again.

well I tried to assign a DateTime object to Value but it didnt work either command.Parameters[1].Value = DateTime.Now; command.Parameters[2].Value = DateTime.Now;

Hi people, I have the a form in my application where the user can enter a data and time and then save it to a Mysql database. but I get a FormatExeption saying "Input string was not in a correct format" How can I convert from .net datatime datatype to Mysql database type ? Heres my method for inserting a row that contains a datetime datatype private void shiftInsertNewRow() { conn = new MySqlConnection ("datasource=localhost;username=admin;password=student;database=hospital"); conn.Open(); MySqlCommand command = new MySqlCommand ("insert into shifts(ShiftID, Starttime, Endtime, WardID, NurseID) select ?ShiftID, ?Starttime, ?Endtime, ?WardID, ?NurseID", conn); command.Parameters.Add(new MySqlParameter("?ShiftID", MySqlDbType.Int32)); command.Parameters.Add(new MySqlParameter("?Starttime", MySqlDbType.Datetime)); command.Parameters.Add(new MySqlParameter("?Endtime", MySqlDbType.Datetime)); command.Parameters.Add(new MySqlParameter("?WardID", MySqlDbType.Int32)); command.Parameters.Add(new MySqlParameter("?NurseID", MySqlDbType.Int32)); command.Parameters[0].Value = shiftidTextBox.Text; command.Parameters[1].Value = startTimeTextBox.Text; command.Parameters[2].Value = endTimTextBox.Text; command.Parameters[3].Value = wardShiftidTextBox.Text; command.Parameters[4].Value = wardNameTextBox.Text; command.ExecuteNonQuery(); conn.Close(); } any help would be greatly appreciated :)

what do you mean by third party control? something like Google calendar API Cheers

Thanks for the reply, Rob. this is not what i im looking for though. i want to draw a calendar for a schedule and to have the days of the week displayed vertically and the time horizontally (similar to school timetable format) and then to populate this with shifts created in the program.

Hi im trying to implement a calendar interface in my C# application but im not sure what the best way to draw the calendar is - i had a look at the form controls in visual C# 2005 and thought the datagridview might be a good start then populate it with events from an Xml file Another possible solution would be google calender but i couldnt find any help with drawing google calender in C# application and thier tutorial was about adding and manipultaing events using .NET cliet libraries. Does anyone have any ideas for this? i would appreciate any help Cheers