Intersoft Community - ISDataSource - ISDataSource with MS SQL

ISDataSource with MS SQL

wayhang@elutions.com.my — Wed, 24 Feb 2010 02:05:46 GMT

ok that solves the problem.

Thanks!

ISDataSource with MS SQL

Glayaar — Mon, 22 Feb 2010 23:38:01 GMT

WebScheduler will override any onload client side event handler in order to facilitate WebScheduler internal process. You could try using the WebScheduler OnInitialize client side event handler for similar life cycle with the OnLoad event handler. In your case, the OnInitialize event handler would be:

function wsSchedule_OnInitialize(controlId) {
    var wsSchedule = ISGetObject(controlId);

    setTimeout(function() {
        RefreshScheduler()
    }, 50);
    
    return true;
}

The setTimeout is required to achieve the scenario you wanted.

You are using WebButton to post back the page and by default the PostBackMode of the WebButton is FlyPostBack. In order to refresh the scheduler during button click please use the InvokeScript function in the WebButton ClientAction property. Here is the snippet:

    Private Sub wbInsert_Clicked(ByVal sender As Object, ByVal e As ISNet.WebUI.WebDesktop.WebButtonClickedEventArgs) Handles wbInsert.Clicked
        Dim strSQL As String

        Dim dsStaffInfo As DataSet
        Dim dsRecurrenceInfo As DataSet

        strSQL = "INSERT INTO ttResources (StaffCode, StaffName, ResourceColor) VALUES ('SC02', 'Staff 02', '#00FF')"
        conn.ExecuteCommand(strSQL)

        strSQL = "SELECT ID, StaffCode, StaffName FROM ttResources"
        dsStaffInfo = conn.ExecuteSelect(strSQL)

        strSQL = "INSERT INTO ttEvents (StaffID, ActivityCode, ActivityName, RoomID, Location, StartTime, EndTime, ScheduleID, Description) " _
                    & "VALUES ('" + dsStaffInfo.Tables(0).Rows(0).Item("ID").ToString + "', 'INWKA', 'INWKA', 1, 'BC01-F01-LR02', '2010-02-22 08:00:00.000', '2010-02-22 09:00:00.000', 1, 'Resources - Staff 02 (Staff 02) Activity -  (INWKA) Venue - BC01-F01-LR02')"
        conn.ExecuteCommand(strSQL)

        strSQL = "INSERT INTO ttRecurrenceInfo (StartDate, EndDate, TotalRecurrence, WeekDay, ScheduleID, Mode, RangeMode) " _
                    & "VALUES('2010-01-04 00:00:00.000', '2010-03-31 00:00:00.000', '10', '1', '1', '2', '0')"
        conn.ExecuteCommand(strSQL)

        strSQL = "SELECT ID FROM ttResources"
        dsRecurrenceInfo = conn.ExecuteSelect(strSQL)

        strSQL = "INSERT INTO ttRecurringEvents (RecurrenceID, StaffID, ActivityCode, ActivityName, RoomID, Location, StartTime, EndTime, ScheduleID, " _
                    & "Description) " _
                    & "VALUES('" + dsRecurrenceInfo.Tables(0).Rows(0).Item("ID").ToString + "', '" + dsStaffInfo.Tables(0).Rows(0).Item("ID").ToString + "', 'ICSALab1', 'ICSALab1', 2, 'BC01-F01-CL02', '2010-01-04 08:00:00.000', '2010-01-04 09:00:00.000', 1, 'Resources - Staff 02 (Staff 02) Activity - Introduction to Computer Science (L) (ICSALab1) Venue - BC01-F01-CL02') "
        conn.ExecuteCommand(strSQL)

        wbInsert.ClientAction.InvokeScript("RefreshScheduler()")

    End Sub

ISDataSource with MS SQL

wayhang@elutions.com.my — Mon, 22 Feb 2010 01:54:01 GMT

Attached is the sample to reproduce the issue. Inside the folder, there's CreateTable.sql to create the needed tables.

There are 2 issues here:

1) The function is not called during onLoad when there's WebScheduler in the aspx. If the WebScheduler is removed, then the function is called without problem during onLoad.

2) I'm not able to refresh the WebSchduler after page post back.

Pls advise.

ISDataSource with MS SQL

Glayaar — Thu, 04 Feb 2010 03:56:48 GMT

In the snippet you provided, you are trying to use a client side function to handle a server side event. As I mentioned before, WebScheduler RefreshAll is a client side function so it should be invoked in the client side event such as the events defined under ClientSideEvents property.

In the previous post you mention:

On the same page, i have button to insert record into Events and RecurringEvents table. When i click the button and insert record and the page is post back, the content in WebScheduler is not updated accordingly, the WebScheduler still show calendar only without any event. I need to refresh the page manually in order for the WebScheduler to "refresh".

If the issue occurs after full postback, you could try to invoke the RefreshScheduler function during HTML body OnLoad client side event handler.

If the suggestion does not solve the issue please send us a sample of the page so we could help you determine the issue.

ISDataSource with MS SQL

wayhang@elutions.com.my — Wed, 03 Feb 2010 21:16:37 GMT

How should i called the function?

I have 2 functions defined as below, wtvActivity_OnNodeCheckedChanged is called without problem but not RefreshScheduler:

a[i] = checkedNodes[i].Name;

if (hidden1.value == "")

{ hidden1.value = a[i]; }

else { hidden1.value = hidden1.value + "," + a[i]; }

}

return true;

}

function RefreshScheduler() {var sched = ISGetObject("wsSchedule");

sched.RefreshAll();

}

</script>

Below is the code how i called the function:

<ISWebScheduler:WebScheduler ID="wsSchedule" runat="server" CategoriesDataMember="ttCategories" DataSourceID="ISDSSchedule"

EventsDataMember="ttEvents" Height="600px" RecurrenceDataMember="ttRecurrenceInfo" RecurringEventsDataMember="ttRecurringEvents" ResourcesDataMember="ttResources" Width="800px" OnDataBinding="RefreshScheduler">

I tested with all other client side events OnDataBinding / OnDataBound / OnInit / OnInsert / OnLoad / OnPreInitialize / OnPreRender / OnUpdate.

and i get error:

BC30456: 'RefreshScheduler' is not a member of 'ASP.schstaffplanner_aspx'.

Pls advise.

ISDataSource with MS SQL

Glayaar — Wed, 03 Feb 2010 20:25:37 GMT

As I mentioned before, the RefreshAll is a client side function (Javascript function) so it should be invoke in the client side.

I have already provided a snippet of the RefreshAll function in my previous post. You will need the WebScheduler object reference and call the RefreshAll function.

ISDataSource with MS SQL

wayhang@elutions.com.my — Wed, 03 Feb 2010 03:08:07 GMT

The code should be placed in client/server site?

Can u provide a sample?

Thanks!

ISDataSource with MS SQL

Glayaar — Wed, 03 Feb 2010 02:34:44 GMT

Since the original question of this thread has been solved, next time please create a new thread if you have a new question.

WebScheduler have a method to refresh the data programatically using the RefreshAll client side function. Here is the snippet:

function RefreshScheduler() {
    var sched = ISGetObject("WebScheduler1");

    sched.RefreshAll();
}

ISDataSource with MS SQL

wayhang@elutions.com.my — Tue, 02 Feb 2010 23:01:10 GMT

Hi Glenn,

Now my WebScheduler can connect to different database dynamically during run time, but there's another issue.

Initially there's no record in Events and RecurringEvents table. So when my system load the page with WebScheduler, the WebScheduler will show calendar only as there's no event yet.

On the same page, i have button to insert record into Events and RecurringEvents table. When i click the button and insert record and the page is post back, the content in WebScheduler is not updated accordingly, the WebScheduler still show calendar only without any event. I need to refresh the page manually in order for the WebScheduler to "refresh".

How can i make the WebScheduler to "refresh" during post back after the button is clicked?

Pls advise

ISDataSource with MS SQL

wayhang@elutions.com.my — Tue, 02 Feb 2010 01:05:40 GMT

ok, it works now!

Thanks!

ISDataSource with MS SQL

wayhang@elutions.com.my — Mon, 04 Jan 2010 04:10:47 GMT

i have my application server installed in 192.168.1.1 and my database server (ms sql) in 192.168.1.2.

From my application, how can ISDataSource connect to database in my database server?

Thanks!