[WebMethod] public void readOneModelImage(string id) { try { String strJson; SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["myCS"].ConnectionString); string strSQL = "select * from PosData2018New.dbo.Client_Define where client_no = '" + id + "'"; conn.Open(); SqlCommand cmd = new SqlCommand(strSQL, conn);
DataTable dt = new DataTable();
dt.Load(cmd.ExecuteReader());
conn.Close();
OneModelImage[] m = new OneModelImage[dt.Rows.Count];
int counter = 0;
foreach (DataRow row in dt.Rows)
{
m[counter] = new OneModelImage();
m[counter].MoNo = row.Field<string>("mod_no");
m[counter].Mona = row.Field<string>("mod_name");
m[counter].ImageUrl = row.Field<string>("ModelImage");
counter++;
}
strJson = serializer.Serialize(m);
Context.Response.ContentType = "application/json";
Context.Response.ContentEncoding = Encoding.UTF8;
Context.Response.Write(strJson);
}
catch (Exception ex)
{
}
}
Aucun commentaire:
Enregistrer un commentaire