Android Question How to Bind Sql Data in Grid

[junaidahmed]

Please provide me sample code for tableview for below RDC URL

Dim job As HttpJob
Dim StrURLPath as String
Dim Query as String

StrURLPath = "http://103.76.188.138:85/"
Query = "Select DeptName Dept,celltype Sections,empname,total from Mis.Dbo.Vw_StaffSalary Order by DeptName,CellType,EmpCode "

job.Initialize("Job1", Me)
job.PostString(StrURLPath & "Android/FrmRemoteSQL.aspx",Query)

 

[Erel]

Please use [code]code here...[/code] tags when posting code.

 

[junaidahmed]

Sorry Erel,Forgot...Please chek it now..

Dim job As HttpJob
Dim StrURLPath as String
Dim Query as String

StrURLPath = "http://103.76.188.138:85/"
Query = "Select DeptName Dept,celltype Sections,empname,total from Mis.Dbo.Vw_StaffSalary Order by DeptName,CellType,EmpCode "

job.Initialize("Job1", Me)
job.PostString(StrURLPath & "Android/FrmRemoteSQL.aspx",Query)

 

[Erel]

It doesn't look like you are using RDC at all. What is FrmRemoteSQL?

 

[junaidahmed]

FrmRemoteSQL is an ".aspx file",Please check below code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Web.Script.Serialization;
using System.IO;
using System.Text;
using System;

namespace Android
{
    public partial class FrmRemoteSQL : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            using (SqlConnection cn = new SqlConnection("Server=Arindsql;Database=Mis; User Id=sa; password=Pass@123")) //change as needed
            {
                using (StreamReader sr = new StreamReader(Request.InputStream, Encoding.UTF8))
                {
                    Response.ContentType = "text/plain";
                    string c;
                    c = Request.QueryString["query"]; //for debugging with the browser
                   
                    //you can set the query by adding the query parameter  For ex: http://127.0.0.1/test.aspx?query=select * from table1
                    if (c == null)
                        c = sr.ReadToEnd();
                    try
                    {
                        SqlCommand cmd = new SqlCommand(c, cn);
                        cn.Open();
                        SqlDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
                        List<Dictionary<string, object>> list = new List<Dictionary<string, object>>();
                        while (rdr.Read())
                        {
                            Dictionary<string, object> d = new Dictionary<string, object>(rdr.FieldCount);
                            for (int i = 0; i < rdr.FieldCount; i++)
                            {
                                d[rdr.GetName(i)] = rdr.GetValue(i);
                            }
                            list.Add(d);
                        }
                        JavaScriptSerializer j = new JavaScriptSerializer();
                        Response.Write(j.Serialize(list.ToArray()));

                    }
                    catch (Exception E)
                    {
                        Response.TrySkipIisCustomErrors = true;
                        Response.StatusCode = 500;
                        Response.Write("Error occurred. Query=" + c + "\n");
                        Response.Write(e.ToString());

                    }
                    Response.End();
                }
            }
        }
    }
}

 

[Erel]

Your question is not related to RDC. You are using the code from this tutorial: https://www.b4x.com/android/forum/threads/connect-android-to-ms-sql-server-tutorial.13166/#content

You need to handle JobDone as explained in that tutorial.

 

[junaidahmed]

Thanks Erel

Sorry for confusion...

I have gone though above link,its working fine as per my requirement but I need to Load Data in Grid (Tableview) from Json Result.....

Hope its clear..........

 

[Erel]

Each item in the rows list is a map. You need to convert each map to an array of strings:

For Each m As Map in rows
 Dim row(m.Size) As String
 row(0) = m.Get("DeptName")
 row(1) = m.Get(...)
 TableView.AddRow(row)
Next

 

[junaidahmed]

Thanks Erel...

Actually I am new for Basic4Android.Can you Please provide me example code with Grid Header and Data's from above code ...??

 

[Erel]

Start with this tutorial: https://www.b4x.com/android/forum/threads/class-tableview-supports-tables-of-any-size.19254/#content