Use PivotGrid with view of sql entity
6 Replies
Hi Guadalupe,
Thanks for contacting Syncfusion support.
You can render PivotGrid with DataTable as datasource. Please follow the below steps.
Step 1:
Add the following class into the WebAPI controller file.
Code Snippet:[c#]
|
public class DbaseQuery
{
public dynamic GetSQLResult(dynamic clientParam)
{
string conSTR = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=" + AppDomain.CurrentDomain.BaseDirectory + @"App_Data\Database1.mdf;Integrated Security=True";//SQL database connection string
string xquery = "SELECT * FROM table1";
SqlConnection sqlConn = new SqlConnection(conSTR);
sqlConn.Open();
SqlCommand cmd = new SqlCommand(xquery, sqlConn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
for (var i = 0; i < dt.Rows.Count; i++)
{
for (var j = 0; j < dt.Rows[i].ItemArray.Length; j++)
{
dt.Rows[i].ItemArray[j] = dt.Rows[i].ItemArray[j].ToString().Trim();
}
}//datasource
return dt;
}} |
Step 2:
Call the GetSQLResult method in each method of PivotGrid WebAPI controller to feed datasource to the control.(Like, InitializeGrid, fetchMembers..etc.)
Code Snippet:[C#]
|
public Dictionary<string, object> InitializeGrid(Dictionary<string, object> jsonResult)
{
htmlHelper.PivotReport = BindDefaultData();
dict = htmlHelper.GetJsonData(jsonResult["action"].ToString(), dbquery.GetSQLResult(null));
return dict;
} |
Please let us know if you need any further assistance.
Arulraj A
Hello
I cant view the example with VisualStudio.
SIGN IN To post a reply.
