Dbsource

title

dbsource is a connection between CMS and database. In a simple words no matter what kind of database you use (SQL, MySQl, Oracle, access,…) you can call similar results from database on CMS. To reach this, You just need to create Store-procedures with execute permission in your demanded database.


Syntax
< basis core="db" name="m1" >
< member type=["your type"] name= "m1"/>
.
.
< member type=["your type"] name= "mn"/>
< /basis>
table 1=(n.m1)
.
.
table n=(n.mn)
sample1
USE [exhibitor]
GO
CREATE TYPE [dbo].[name_value]
AS TABLE (
[name] [nvarchar](4000) NULL
[value] [nvarchar](max) NULL
(
GO
sample2
USE [exhibitor]
GO
DECLARE @return_value int , @params name_value
EXEC [dbo].[DBSource_genic]
@command= N'<basis core="dbsource" source="genic" mid="43" name="acconting" lid="1" mainid="1208656" >
<member name="data" type="list" format="all" propertyid="1197,1198" /> </basis>'
@dmnid =12
@params=@params
We create a very huge database to present how these functions work. You can see these procedures here.