C# (CSharp) JSON.TableData Examples

Example #1

File: JsonController.cs Project: ststeiger/AnySqlDataFeed

        //
        // GET: /Json/
        public ContentResult Index()
        {
            string table_name = "T_Benutzer";
            AnySqlDataFeed.JSON.TableData tableData = new JSON.TableData();
            tableData.metadata = "http://*****:*****@"
            SELECT
             table_name AS name
            ,table_name AS url
            FROM INFORMATION_SCHEMA.TABLES
            WHERE TABLE_TYPE = 'BASE TABLE'
            AND table_name LIKE 'T\_%' ESCAPE '\'
            ORDER BY table_name
            ";

            AnySqlDataFeed.JSON.TableList tableList = new JSON.TableList();
            tableList.metadata = "http://localhost:5570/Virt_X/ExcelDataFeed.svc/$metadata";
            tableList.data = SQL.GetDataTable(strSQL);

            return Content(Newtonsoft.Json.JsonConvert.SerializeObject(tableList));
        }

Example #2

        //
        // GET: /Json/

        public ContentResult Index()
        {
            string table_name = "T_Benutzer";

            AnySqlDataFeed.JSON.TableData tableData = new JSON.TableData();
            tableData.metadata = "http://*****:*****@"
SELECT 
	 table_name AS name 
	,table_name AS url 
FROM INFORMATION_SCHEMA.TABLES 
WHERE TABLE_TYPE = 'BASE TABLE' 
AND table_name LIKE 'T\_%' ESCAPE '\' 
ORDER BY table_name 
";

            AnySqlDataFeed.JSON.TableList tableList = new JSON.TableList();
            tableList.metadata = "http://localhost:5570/Virt_X/ExcelDataFeed.svc/$metadata";
            tableList.data     = SQL.GetDataTable(strSQL);


            return(Content(Newtonsoft.Json.JsonConvert.SerializeObject(tableList)));
        }