Comments by Sandip Paul 491984 (Top 49 by date)

actually this code worked for some php so i just convert the link to .asmx.I am new to android.My aim is to store data from ms sql server to sqlite and vice versa by using web service.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Data;
using System.Data.SqlClient;
using System.Web.Configuration;
using System.Runtime.Serialization.Json;
using System.Web.Script.Services;
using System.Web.Script.Serialization;
using System.ComponentModel;

[WebService(Namespace = "http://surveyservices.sanraysinfotech.com/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
[ToolboxItem(false)]
//[ScriptService]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
[System.Web.Script.Services.ScriptService]

public class Service : System.Web.Services.WebService
{
List<wilaya> Wilayalist = new List<wilaya>();
List<moughata> Moughataalist = new List<moughata>();
List<commune> Communelist = new List<commune>();

[WebMethod]
public string HelloWorld() {
return "Hello World";
}

[WebMethod]
[ScriptMethod(ResponseFormat = ResponseFormat.Json)]
public String GetWilaya()
{
string conStr = WebConfigurationManager.ConnectionStrings["SQLDbConnection"].ConnectionString;
DataTable dt = new DataTable();
SqlDataReader dr = null;
using (SqlConnection conn = new SqlConnection(conStr))
{
string sql = string.Format(@"Select * from [WilayaMast]");
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
conn.Open();

dr = cmd.ExecuteReader();
dt.Load(dr);
conn.Close();
cmd = null;
}

int countRow = dt.Rows.Count;

foreach (DataRow drEmp in dt.Rows)
{
Wilaya objwilaya = new Wilaya();
objwilaya.WCode = Convert.ToInt32(drEmp["Wcode"].ToString());
objwilaya.WName = drEmp["WName"].ToString();
objwilaya.WID = drEmp["WID"].ToString();
Wilayalist.Add(objwilaya);
}
return new JavaScriptSerializer().Serialize(Wilayalist);

}

[WebMethod]
[ScriptMethod(ResponseFormat = ResponseFormat.Json)]
public String GetCommune()
{
// getting connection string

string conStr = WebConfigurationManager.ConnectionStrings["SQLDbConnection"].ConnectionString;
DataTable dt = new DataTable();
SqlDataReader dr = null;
// Creating Sql Connection
using (SqlConnection conn = new SqlConnection(conStr))
{
// Creating insert statement
string sql = string.Format(@"Select * from [CommuneMast]");
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
conn.Open();

dr = cmd.ExecuteReader();
dt.Load(dr);
conn.Close();
cmd = null;
}

int countRow = dt.Rows.Count;

foreach (DataRow drcommune in dt.Rows)
{
Commune objcommune = new Commune();
objcommune.CCode = Convert.ToInt32(drcommune["CCode"].ToString());
objcommune.CName = drcommune["CName"].ToString();
objcommune.CID = drcommune["CID"].ToString();
objcommune.MCode = Convert.ToInt32(drcommune["MCode"]);
Communelist.Add(objcommune);
}
return new JavaScriptSerializer().Serialize(Communelist);
}

[WebMethod]
[ScriptMethod(ResponseFormat = ResponseFormat.Json)]
//public List<moughata> GetMoughata()
public String GetMoughata()
{
// getting connection string

string conStr = WebConfigurationManager.ConnectionStrings["

i just want to build my package with visual studio installer.In which i want to add some custom action which prevents the uninstall process when the application is running.can anyone help me how to do this