Unlock 30% off on Manual Testing Annual Plans this Holiday Season.

Copied to Clipboard!

How to use ReadQueryFromSharedDataSet method of NBi.Core.Report.DatabaseReportingParser class

Best NBi code snippet using NBi.Core.Report.DatabaseReportingParser.ReadQueryFromSharedDataSet

DatabaseReportingParser.cs

Source:DatabaseReportingParser.cs

...26                    , request.ReportName27                    , request.DataSetName28                    , ref otherDataSets);29                if (!string.IsNullOrEmpty(reference))30                    query = ReadQueryFromSharedDataSet(request.Source, request.Path, reference);31            }32            if (query != null)33                return query;34            if (otherDataSets.Count() == 0)35                throw new ArgumentException(string.Format("No report found on path '{0}' with name '{1}'", request.Path, request.ReportName));36            else if (otherDataSets.Count() == 1)37                throw new ArgumentException(string.Format("The requested dataset ('{2}') wasn't found for the report on path '{0}' with name '{1}'. The dataset for this report is {3}", request.Path, request.ReportName, request.DataSetName, otherDataSets[0]));38            else39                throw new ArgumentException(string.Format("The requested dataset ('{2}') wasn't found for the report on path '{0}' with name '{1}'. The datasets for this report are {3}", request.Path, request.ReportName, request.DataSetName, String.Join(", ", otherDataSets.ToArray())));40        }41        public ReportingCommand ExtractCommand(SharedDatasetRequest request)42        {43            var query = ReadQueryFromSharedDataSet(request.Source, request.Path, request.SharedDatasetName);44            if (query != null)45                return query;46            throw new ArgumentException(string.Format("The requested shared dataset ('{1}') wasn't found on path '{0}'.", request.Path, request.SharedDatasetName));47        }48        private ReportingCommand SearchDataSet(string source, string reportPath, string reportName, string dataSetName, ref List<string> otherDataSets)49        {50            using (var conn = new SqlConnection())51            {52                //create connection and define sql query53                conn.ConnectionString = source;54                var cmd = new SqlCommand();55                cmd.Connection = conn;56                cmd.CommandText = ReadQueryFromContent("ListDataSet");57                //create the three parameters for the sql query58                var paramReportPath = new SqlParameter("ReportPath", System.Data.SqlDbType.NVarChar, 425);59                paramReportPath.Value = reportPath;60                cmd.Parameters.Add(paramReportPath);61                var paramReportName = new SqlParameter("ReportName", System.Data.SqlDbType.NVarChar, 425);62                paramReportName.Value = reportName;63                cmd.Parameters.Add(paramReportName);64                //execute the command65                conn.Open();66                var dr = cmd.ExecuteReader();67                68                while (dr.Read())69                    if (dr.GetString(2) == dataSetName)70                    {71                        var command = new ReportingCommand();72                        command.CommandType = (CommandType)Enum.Parse(typeof(CommandType), dr.GetString(4)); //CommandType73                        command.Text = dr.GetString(5); //CommandText74                        return command;75                    }76                    else77                        otherDataSets.Add(dr.GetString(2));78            }79            return null;80        }81        private string SearchSharedDataSet(string source, string reportPath, string reportName, string dataSetName, ref List<string> otherDataSets)82        {83            using (var conn = new SqlConnection())84            {85                //create connection and define sql query86                conn.ConnectionString = source;87                var cmd = new SqlCommand();88                cmd.Connection = conn;89                cmd.CommandText = ReadQueryFromContent("ListSharedDataSet");90                //create the three parameters for the sql query91                var paramReportPath = new SqlParameter("ReportPath", System.Data.SqlDbType.NVarChar, 425);92                paramReportPath.Value = reportPath;93                cmd.Parameters.Add(paramReportPath);94                var paramReportName = new SqlParameter("ReportName", System.Data.SqlDbType.NVarChar, 425);95                paramReportName.Value = reportName;96                cmd.Parameters.Add(paramReportName);97                //execute the command98                conn.Open();99                var dr = cmd.ExecuteReader();100                while (dr.Read())101                    if (dr.GetString(2) == dataSetName)102                        return dr.GetString(3);103                    else104                        otherDataSets.Add(dr.GetString(2));105            }106            return null;107        }108        private ReportingCommand ReadQueryFromSharedDataSet(string source, string path, string reference)109        {110            using (var conn = new SqlConnection())111            {112                //create connection and define sql query113                conn.ConnectionString = source;114                var cmd = new SqlCommand();115                cmd.Connection = conn;116                cmd.CommandText = ReadQueryFromContent("QueryFromSharedDataSet");117                //create the two parameters for the sql query118                var paramPath = new SqlParameter("SharedDataSetPath", System.Data.SqlDbType.NVarChar, 425);119                paramPath.Value = path;120                cmd.Parameters.Add(paramPath);121                var paramReference = new SqlParameter("SharedDataSetName", System.Data.SqlDbType.NVarChar, 425);122                paramReference.Value = reference;...

ReadQueryFromSharedDataSet

Using AI Code Generation

1using System;2using System.Collections.Generic;3using System.Linq;4using System.Text;5using System.Threading.Tasks;6using NBi.Core.Report;7{8    {9        static void Main(string[] args)10        {11            DatabaseReportingParser parser = new DatabaseReportingParser();12            var query = parser.ReadQueryFromSharedDataSet(@"C:\Users\user\Documents\Visual Studio 2015\Projects\3\3\bin\Debug\3.sds", "Query1");13            Console.WriteLine(query);14            Console.ReadLine();15        }16    }17}18        <ConnectString>Integrated Security=True;Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=3</ConnectString>

ReadQueryFromSharedDataSet

Using AI Code Generation

1using System;2using System.Collections.Generic;3using System.Linq;4using System.Text;5using System.Threading.Tasks;6using NBi.Core.Report;7{8    {9        static void Main(string[] args)10        {11            var parser = new DatabaseReportingParser();12            var query = parser.ReadQueryFromSharedDataSet(@"C:\Users\user\Desktop\NBi\NBi-master\NBi.Testing\NBi.Testing.Integration\Report\3.rdl", "DataSet1");13            Console.WriteLine(query);14            Console.ReadLine();15        }16    }17}

ReadQueryFromSharedDataSet

Using AI Code Generation

1using System;2using System.Collections.Generic;3using System.Linq;4using System.Text;5using System.Threading.Tasks;6using NBi.Core.Report;7{8    {9        static void Main(string[] args)10        {11            DatabaseReportingParser parser = new DatabaseReportingParser();12            string query = parser.ReadQueryFromSharedDataSet(@"C:\Users\mohamed\Desktop\3.rdl");13        }14    }15}

ReadQueryFromSharedDataSet

Using AI Code Generation

1using System;2using System.Collections.Generic;3using System.Linq;4using System.Text;5using System.Threading.Tasks;6using NBi.Core.Report;7{8    {9        static void Main(string[] args)10        {11            var parser = new DatabaseReportingParser();12            var query = parser.ReadQueryFromSharedDataSet(@"C:\Users\ssarraf\Desktop\3.rdl", "DataSet1");13            Console.WriteLine(query);14            Console.ReadLine();15        }16    }17}

ReadQueryFromSharedDataSet

Using AI Code Generation

1using System;2using System.IO;3using System.Data;4using System.Data.SqlClient;5using System.Collections.Generic;6using NBi.Core.Report;7using NBi.Core.Query;8using NBi.Core.Query.Command;9using NBi.Core.Query.Resolver;10using NBi.Core.Query.Resolver.Csv;11using NBi.Core.Query.Resolver.Variables;12using NBi.Core.Query.Resolver.Folder;13using NBi.Core.Query.Resolver.File;14using NBi.Core.Query.Resolver.Command;15using NBi.Core.Query.Resolver.Profile;16using NBi.Core.Query.Resolver.DbCommand;17using NBi.Core.Query.Resolver.Ado;18using NBi.Core.Query.Resolver.Factory;19using NBi.Core.Query.Resolver.Lookup;20using NBi.Core.Query.Resolver.Variables;21using NBi.Core.Query.Resolver.Variables.Csv;22using NBi.Core.Query.Resolver.Variables.Csv.Rows;23using NBi.Core.Query.Resolver.Variables.Csv.Columns;24using NBi.Core.Query.Resolver.Variables.NCalc;25using NBi.Core.Query.Resolver.Variables.NCalc.Columns;

ReadQueryFromSharedDataSet

Using AI Code Generation

1using NBi.Core.Report;2using System.Data;3using System.Data.SqlClient;4using System.IO;5using System.Xml;6using System.Xml.Serialization;7{8    {9        static void Main(string[] args)10        {11            DatabaseReportingParser parser = new DatabaseReportingParser();12            string reportPath = @"C:\Users\Public\Documents\NBi\Reports\";13            string reportName = "Report1.rdl";14            string connectionString = "Data Source=.;Initial Catalog=AdventureWorks2012;Integrated Security=True";15            string query = parser.ReadQueryFromSharedDataSet(reportPath, reportName, connectionString);16            Console.WriteLine(query);17        }18    }19}

ReadQueryFromSharedDataSet

Using AI Code Generation

1using System;2using System.Data;3using System.IO;4using NBi.Core.Report;5using NBi.Core.Report.Delimited;6using NBi.Core.Report.Html;7using NBi.Core.Report.Xml;8using NBi.Core.Report.Excel;9using NBi.Core.Report.Pivot;10using NBi.Core.Report.Olap;11using NBi.Core.Report.PowerBI;12using NBi.Core.Report.Rdl;13using NBi.Core.Report.Rs;14using NBi.Core.Report.Rs2010;15using NBi.Core.Report.Rs2016;16using NBi.Core.Report.Rs2017;17using NBi.Core.Report.Rs2019;18using NBi.Core.Report.Rs2019R2;19using NBi.Core.Report.Rs2020;20using NBi.Core.Report.Rs2022;21using NBi.Core.Report.Ssrs;22using NBi.Core.Report.Ssrs2010;23using NBi.Core.Report.Ssrs2016;24using NBi.Core.Report.Ssrs2017;25using NBi.Core.Report.Ssrs2019;26using NBi.Core.Report.Ssrs2019R2;27using NBi.Core.Report.Ssrs2020;28using NBi.Core.Report.Ssrs2022;29using NBi.Core.Report.Ssrs2012;30using NBi.Core.Report.Ssrs2014;31using NBi.Core.Report.Ssrs2018;32using NBi.Core.Report.Ssrs2018R2;33using NBi.Core.Report.Ssrs2021;34using NBi.Core.Report.Ssrs2021R2;35using NBi.Core.Report.Ssrs2022R2;36using NBi.Core.Report.Ssrs2012R2;37using NBi.Core.Report.Ssrs2013;38using NBi.Core.Report.Ssrs2013R2;39using NBi.Core.Report.Ssrs2015;40using NBi.Core.Report.Ssrs2015R2;41using NBi.Core.Report.Ssrs2015R3;42using NBi.Core.Report.Ssrs2015R4;43using NBi.Core.Report.Ssrs2015R5;44using NBi.Core.Report.Ssrs2015R6;45using NBi.Core.Report.Ssrs2015R7;46using NBi.Core.Report.Ssrs2015R8;47using NBi.Core.Report.Ssrs2015R9;48using NBi.Core.Report.Ssrs2015R10;

ReadQueryFromSharedDataSet

Using AI Code Generation

1using System;2using System.Collections.Generic;3using System.Linq;4using System.Text;5using System.Threading.Tasks;6using NBi.Core.Report;7using NBi.Core.Report.Dataset;8using NBi.Core.Report.Dataset.Xml;9using NBi.Core.Report.Dataset.Helper;10{11    {12        static void Main(string[] args)13        {14            DatabaseReportingParser parser = new DatabaseReportingParser();15            SharedDatasetHelper helper = new SharedDatasetHelper();16            XmlSharedDatasetParser xmlParser = new XmlSharedDatasetParser();17            SharedDataset dataset = new SharedDataset();18            SharedDataset dataset2 = new SharedDataset();19            SharedDataset dataset3 = new SharedDataset();20            SharedDataset dataset4 = new SharedDataset();21            SharedDataset dataset5 = new SharedDataset();22            SharedDataset dataset6 = new SharedDataset();23            SharedDataset dataset7 = new SharedDataset();24            SharedDataset dataset8 = new SharedDataset();25            SharedDataset dataset9 = new SharedDataset();26            SharedDataset dataset10 = new SharedDataset();27            SharedDataset dataset11 = new SharedDataset();28            SharedDataset dataset12 = new SharedDataset();29            SharedDataset dataset13 = new SharedDataset();30            SharedDataset dataset14 = new SharedDataset();31            SharedDataset dataset15 = new SharedDataset();32            SharedDataset dataset16 = new SharedDataset();33            SharedDataset dataset17 = new SharedDataset();

ReadQueryFromSharedDataSet

Using AI Code Generation

1var parser = new DatabaseReportingParser();2var resultSet = parser.ReadQueryFromSharedDataSet(@"C:\Users\user\Documents\Visual Studio 2017\Projects\NBiTest\NBiTest\bin\Debug\3.rdl");3foreach (var row in resultSet.Rows)4{5    foreach (var item in row)6    {7        Console.Write(item + "\t");8    }9    Console.WriteLine();10}11        <ConnectString>Server=(localdb)\MSSQLLocalDB;Database=master;Trusted_Connection=True;</ConnectString>

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.