slamat sore,
saya memakai APS.net web service
code pada web service :
SPBU spbu;
[WebMethod]
public DataTable TampilSPBU()
{
spbu = new SPBU();
return spbu.SelectAllData();
}
_________________________
class SPBU :
public class SPBU
{
private SqlConnection conn;
private SqlCommand cmd;
private DataSet ds;
private SqlDataAdapter da;
//private DataTable dt;
public void setKoneksi()
{
string strConn = @"Data Source=.\SQLEXPRESS;Initial Catalog=spbu_database;Integrated Security=True;";
conn = new SqlConnection(strConn);
}
public DataTable SelectAllData()
{
setKoneksi();
string strCmd = @"SELECT * FROM daftar_spbu";
cmd = new SqlCommand(strCmd, conn);
da = new SqlDataAdapter();
da.SelectCommand = cmd;
ds = new DataSet();
da.Fill(ds, "daftar_spbu");
da.Dispose();
cmd.Dispose();
conn.Close();
return ds.Tables["daftar_spbu"];
}
saya jalankan di web brower, jalan dan hasil dari database dapat dilihat.
lalu saya add service reference dan saya isi localhost webservice saya.
coding di WP7 :
private void button1_Click(object sender, RoutedEventArgs e)
{
loadData();
}
public void loadData()
{
ServiceReference1.Service1SoapClient aa = new Service1SoapClient();
aa.TampilSPBUAsync();
aa.TampilSPBUCompleted += new EventHandler<TampilSPBUCompletedEventArgs>(proxy_tampilSPBU);
}
void proxy_tampilSPBU(object sender, TampilSPBUCompletedEventArgs e)
{
listBox1.ItemsSource = e.Result;
}
terdapat error pada result, dan pesan errornya :
Error 1 Cannot implicitly convert type 'Coba.ServiceReference1.TampilSPBUResponseTampilSPBUResult' to 'System.Collections.IEnumerable'. An explicit conversion exists (are you missing a cast?) D:\belajar
WP7\SPBUWebService\Coba\MainPage.xaml.cs 41 36 Coba
