Intersoft Community - ISDataSource

ISDataSource - Stored Procedure with Input Parameters

cvgierloff — Fri, 15 Aug 2014 11:36:53 GMT

I created an ISDataSource (version 1.0.1500) on a web form in order to populate a webgrid (version 8). The The schema type for the ISDataSource is a dataset that calls a stored procedure with 2 input paramaters. The Select method is set to pull the parameter values from text boxes on the web form. This is being done to allow the end user to control the amount of data returned to the grid. Due to the large volume of data available we want to display a smaller amount in the grid initially and allow the end user to add more by changing the values in the text boxes and refreshing.

The program is ignoring the values entered into the textboxes. Would it be possible to obtain a sample of how to use an ISDataSource with a stored procedure and input parameters that are on a web form? I reviewed the documentation extensively but there isn't much detail on parameters and ISDataSource.

FilterExpression

siemiatkowski@softwarestudio.com.pl — Tue, 14 May 2013 02:59:17 GMT

I try to use

ISDataSource1.Tables.GetNamedItem("Events").FilterExpression = "subject='02'";

for ISWebScheduler

<ISWebScheduler:WebScheduler ID="WebScheduler1" runat="server" Height="100%"

Width="100%" DefaultStyleMode="Win7" Culture="Polish (Poland)"

CategoriesDataMember="Categories" DataSourceID="ISDataSource1"

EventsDataMember="Events" ResourcesDataMember="Resources" EnableFastJsonSerialization="True" >

<EventsBinding AllDayEventField="AllDayEvent" CategoryIDField="CategoryID"

DescriptionField="Description" EndTimeField="EndTime" EventIDField="ID"

LocationField="Location" ModeField="Mode" ReminderTimeSpanField="Reminder"

ResourceIDField="ResourceID" StartTimeField="StartTime"

SubjectField="Subject" />

I have not any error, but I have in my WebScheduler all data from table "events", the filter expression does not work ?

When I write wrong expression

ISDataSource1.Tables.GetNamedItem("Events").FilterExpression = "subjectx='02'";

I have an error, because the column subjectx absent

I try run with parametrs, but still the same,

ISDataSource1.Tables.GetNamedItem("Events").FilterExpression = " subject='{0}'";

ISDataSource1.Tables.GetNamedItem("Events").FilterParameters.Add("subject", "02");

any idea ?

My ISDataSource:ISDataSource

<ISDataSource:ISDataSource ID="ISDataSource1" runat="server" SchemaName="StudioSystem.App_Code.kalendarz" >

<ISDataSource:ISDataSourceTable SelectMethod="GetData" OldValuesParameterFormatString="Original_{0}"

TableName="Events" TypeName="StudioSystem.App_Code.kalendarzTableAdapters.EventsTableAdapter" DeleteMethod="Delete" InsertMethod="Insert" UpdateMethod="Update">

<asp:Parameter Name="Original_ID" Type="Int32" />

</DeleteParameters>

<asp:Parameter Name="CategoryID" Type="String" />

<asp:Parameter Name="ResourceID" Type="Int32" />

<asp:Parameter Name="Mode" Type="Int32" />

<asp:Parameter Name="Subject" Type="String" />

<asp:Parameter Name="Description" Type="String" />

<asp:Parameter Name="Location" Type="String" />

<asp:Parameter Name="AllDayEvent" Type="Boolean" />

<asp:Parameter Name="StartTime" Type="DateTime" />

<asp:Parameter Name="EndTime" Type="DateTime" />

<asp:Parameter Name="Reminder" Type="Int32" />

<asp:Parameter Name="ReminderTimeSpan" Type="Int32" />

</InsertParameters>

<asp:Parameter Name="CategoryID" Type="String" />

<asp:Parameter Name="ResourceID" Type="Int32" />

<asp:Parameter Name="Mode" Type="Int32" />

<asp:Parameter Name="Subject" Type="String" />

<asp:Parameter Name="Description" Type="String" />

<asp:Parameter Name="Location" Type="String" />

<asp:Parameter Name="AllDayEvent" Type="Boolean" />

<asp:Parameter Name="StartTime" Type="DateTime" />

<asp:Parameter Name="EndTime" Type="DateTime" />

<asp:Parameter Name="Reminder" Type="Int32" />

<asp:Parameter Name="ReminderTimeSpan" Type="Int32" />

<asp:Parameter Name="Original_ID" Type="Int32" />

</UpdateParameters>

</ISDataSource:ISDataSourceTable>

Adam

Work with parameters

fernando.pablo@kcc.com — Tue, 18 Dec 2012 10:29:19 GMT

Anyboy know how can to pass 3 parameters to my ISDatasource, and another question, its possible to get some examples to wok with Chidtables, please?

Thanks in advance.

Regards

Connecting with ISDataSource at runtime using dynamic dataset,

throstur62 — Fri, 31 Aug 2012 14:09:18 GMT

Hi,
In my app. I have a datastructure that has dynamic number of columns (and rows). It is a report. I retrieve data from the database and build a DataSet runtime to hold the data. I define the tables, columns in eahc table, etc. Actualy there is only one table, but as I say the number of columns is dynamic. Then I bind this DataSet to a WebGrid. All works fine untill the number of rows x columns increases, building the WebGrid is very time consuming on the web server (typicaly when rows x columns > 168 x 8.

So I thought the solution would be to bind the WebGrid with a ISDataSource in code. But how can I create a ISDataSource in code when there is no schema name. There is no need for a GetData method ad the DataSet table is already populated, when I want to bind the WebGrid to the ISDataSource in the InitializeDataSource event.

Is there any solution to this?

Can anyone point me in the right direction for SCRIPT5007 Error in I.E?

usejwat — Thu, 22 Mar 2012 19:47:33 GMT

I have the same problem but on my development machine. I just took over a project that uses several Intersoft controls. I get the error:

SCRIPT5007: The value of the property 'InitWebPaneManager' is null or undefined, not a Function object
Default.aspx, line 423 character 1

SCRIPT5007: The value of the property 'OnWebPMRSC' is null or undefined, not a Function object
Default.aspx, line 422 character 1

SCRIPT5009: 'IS' is undefined
Default.aspx, line 439 character 1

SCRIPT5007: The value of the property 'OnWebPMRSC' is null or undefined, not a Function object
Default.aspx, line 422 character 1

As well as several others when trying to run my app.

It actually looks like some script is not getting written when the page is rendered on the client. I have tried it using Crome, I.E. 9 and FireFox all with the same error.

As I said, I just took over the project so I had to unregister the licenses on the former developers machine and then reregistered them on my own after tech support said they had me setup.

Any help in this scenario?

ISDataSourceControl Trial version can only be used in localhost.

pwbriggs23 — Tue, 28 Feb 2012 14:50:52 GMT

I have a valid license for the WebScheduler product and everything is running great on a temporary server. I am trying to get my current application working on a production server but I keep getting the following error:ISDataSourceControl Trial version can only be used in localhost. To use ISDataSourceControl in production server, please obtain licensed version. Visit http://www.intersoftpt.com for more information.

I have tried everything...reinstall, license manager, etc. and I cannot get this working. Do I need to buy a license for the ISDataSourceControl too? If so why does my temp server work great?

Please help!

Search problem with paging operation when using ISDataSource

gavin — Tue, 30 Aug 2011 10:48:31 GMT

Hi ,

I meet a problem of paging operation when I use ISDataSource . The data of webgrid is displayed through paging operation . When I want to search some information , I pass parameters with ControlParameter of ISDataSource . The data of first page is displayed normally , however , the data of second page is not sifted according to the parameters .

When I debug my code , I find the parameters I passed is normal when the data of first page is displayed . But the parameters I passed is null after I click the icon of next page in the footer of webgrid , and the data of webgrid is showed without sifting .

I want to know why . Anyone can help me ? Thanks a lot .

Update problem when using ISDataSource

gavin — Sat, 20 Aug 2011 03:11:08 GMT

Hi ,

I am tring to update the data in the webgrid , then there will be a alert said "update failure etc" . But in fact , the data in the webgrid is change and the data in the database is also change . It mean update success .

<ISDataSource:ISDataSource runat="server" ID="IDS1" SchemaName="Bizlogic.DB_Frame_CustomPageSetting">
      <Tables>
           <ISDataSource:ISDataSourceTable SelectMethod="Select" TypeName="Bizlogic.DB_Frame_CustomPageSetting"
 TableName="DB_Frame_CustomPageSetting" EnablePaging="true" SelectCountMethod="SelectCount">
                 <SelectParameters>
                     <asp:QueryStringParameter Name="categoryNum" DbType="String" QueryStringField="ParentCategoryNum" />
                 </SelectParameters>
            </ISDataSource:ISDataSourceTable>
       </Tables>
</ISDataSource:ISDataSource>

The code above I used is to bind to webgrid , and the update method I used is OnBatchUpdate . The image in the attach file is that alert .

Anyone can help me ? Thanks a lot !

insert Problem using isdatasource

schau — Tue, 28 Jun 2011 16:03:13 GMT

Hi,

I'm trying to do an insert into a table (t_log_entry) and I got this error that says "column dtopened does not allow null". I have a date value in that field and it still gives me that error. I'm using isdatasource. Please see image provided. thanks for your help.

Urgent ! Issue when referencing ISNET.Data.Linq and ISDatasource in 2011 release

pchanez — Thu, 26 May 2011 06:27:35 GMT

Hi,

We have a serious issue using WebUI Studio 2011. When we referenced and use ISNET.Data.Linq and ISDatasource together, we get a System.OutOfMemory (see the attached pictures).

The zip file contains a mini projet to reproduce the issue, including all the intersoft dll we are using.

Thanks for your help ... this is completly blocking our project at the moment

-patrick-