Hey there! any question in your mind? Ask It Now!.

Popular Categories





How to get data from android through web services and update database?

0 votes
447 views
asked in Programming by monika (2,040 points)

i am using this code to get database and convert it into JSON and display in android through web services.

public string Method()
{
        DataTable dt = new DataTable();
        using (SqlConnection con = new SqlConnection(@"Connection_string"))
        {
            using (SqlCommand cmd = new SqlCommand("_query_", con))
            {
  con.Open();
  SqlDataAdapter da = new SqlDataAdapter(cmd);
  da.Fill(dt);
  System.Web.Script.Serialization.JavaScriptSerializer serializer 
            = new System.Web.Script.Serialization.JavaScriptSerializer();
   List<Dictionary<string, object>> rows = new List<Dictionary<string, object>>();
                Dictionary<string, object> row;
                foreach (DataRow dr in dt.Rows)
                {
                    row = new Dictionary<string, object>();
                    foreach (DataColumn col in dt.Columns)
                    {
                        row.Add(col.ColumnName, dr[col]);
                    }
                    rows.Add(row);
                }
                return serializer.Serialize(rows);
            }
        }
}

In the same way if an android app gives a data then how would I be able to get that data and insert it into database?

Please log in or register to answer this question.

Related Questions

+7 votes
7 answers 1,280 views
+8 votes
2 answers 126 views
+1 vote
1 answer 211 views
+8 votes
1 answer 98 views
+2 votes
1 answer 1,316 views
+1 vote
2 answers 204 views
+1 vote
1 answer 1,011 views
0 votes
0 answers 257 views

Not a Member yet?

Ask to Folks Login

My Account
678 Folks are online
0 members and 678 guest online
Your feedback is highly appreciated