Solved

How do I read my SQL dataset and update the Dotnetbar Schedule control ?

Posted on 2010-11-09
8
1,439 Views
Last Modified: 2012-05-10
Hi I can read in an xml file and update Devcomponents schedule control with below code., but how can I do the same with my SQL Dataset as it does not seem to work.

XML code

Try
            If File.Exists(Application.StartupPath & "\Appointments.xml") Then
                Dim xml As New Xml.Reader(Application.StartupPath & "\Appointments.xml")
                For Each node As Xml.Node In xml.Root.Nodes
                    Dim appointment As New Appointment()

                    appointment.OwnerKey = node.Attributes("owner").Value
                    appointment.StartTime = node.Attributes("start").ValueDateTime
                    appointment.EndTime = node.Attributes("end").ValueDateTime
                    appointment.Tag = node.Attributes("preremind").ValueInt
                    appointment.Subject = node.Attributes("subject").Value
                    appointment.Description = node.Attributes("description").Value
                    appointment.Tooltip = appointment.Description
                    appointment.CategoryColor = node.Attributes("color").Value
                    appointment.TimeMarkedAs = node.Attributes("timemarker").Value
                    Me.CalendarView1.CalendarModel.Appointments.Add(appointment)
                Next

SQL CODE THAT IS NOT WORKING.

 Private Sub ButtonItem2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ButtonItem2.Click
        'Me.ScheduleTableAdapter.Fill(Me.Inspections_Schedule_DataSet.Schedule)
        Me.ScheduleTableAdapter.Fill(Inspections_Schedule_DataSet.Schedule)
        For Each dr As DataRow In Inspections_Schedule_DataSet.Schedule.Rows

            Dim appointment As New Appointment()

            appointment.StartTime = dr("starttime")
            appointment.EndTime = dr("endtime")
            appointment.OwnerKey = dr("owner")
            appointment.Tag = dr("tag")
            appointment.Subject = dr("subject")
            appointment.Description = dr("description")
            appointment.CategoryColor = dr("categorycolor")
            appointment.Tooltip = appointment.Description

            Me.CalendarView1.CalendarModel.Appointments.Add(appointment)



        Next


        MessageBox.Show("data import finished!")
    End Sub

The control is availible for trial download from here  http://www.devcomponents.com/dotnetbar/download.aspx
 
0
Comment
Question by:rhill52
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
8 Comments
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 34100291
Are all the values same in SQL and XML? You have missed one line in SQL code which may make a difference

appointment.TimeMarkedAs = node.Attributes("timemarker").Value
0
 

Author Comment

by:rhill52
ID: 34100385
Hi Code Cruiser, looking at the data in the xml file created it does not seem to matter if the timemarker value is there or not. am I looping through the rows correctly ?
0
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 34100428
Yes loop seems fine. Step through the code to see whether its executing or not (The dataset may be empty!).
0
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

Author Comment

by:rhill52
ID: 34100786
all seems fine when steping through the code, the dataset is loaded and the results change as expected,  I suspect it is this line that is causing the issue but I am not sure why.
Me.CalendarView1.CalendarModel.Appointments.Add(appointment)

0
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 34100961
Enclose it in try catch block and see if you get any errors.
0
 

Author Comment

by:rhill52
ID: 34101054
still do not see any problems, think it might be best to try the sample and see if you can reproduce ?
0
 

Accepted Solution

by:
rhill52 earned 0 total points
ID: 34145066
The issue was down to extra spaces when trying to read appointment.OwnerKey = dr("owner")
from the dataset.

0
 

Author Closing Comment

by:rhill52
ID: 34182374
Found the issue myself
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question