---

.

---

---

Metode dan Algoritma | Web Service Database dengan C#.NET . Anda bisa melakukan konsultasi tentang Web Service Database dengan C#.NET melalui form di samping kanan !!!

---

Web Service - C#.NET 

Buat WebService dengan cara klik File - New - Web Site. Pilih ASP.NET Web Service. Pilih Language : Visual C#.

Kemudian masukkan database, misalnya db.mdb ke direktori App_Data.

Tuliskan kode program berikut ini pada file App_Code/Service.cs :

using System;

using System.Linq;

using System.Web;

using System.Web.Services;

using System.Web.Services.Protocols;

using System.Xml.Linq;

using System.Data;

using System.Data.OleDb;



[WebService(Namespace = "http://tempuri.org/")]

[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]

// 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

{

public Service () {



//Uncomment the following line if using designed components

//InitializeComponent();

}



//[WebMethod]

//public string HelloWorld() {

// return "Hello World";

//}



[WebMethod]

public DataSet getTb() {

OleDbConnection cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("~\\App_Data") + "\\db.mdb");

cn.Open();

OleDbCommand cm = new OleDbCommand("SELECT * FROM tb", cn);

OleDbDataReader rd = cm.ExecuteReader();

DataSet ds = new DataSet();

ds.Tables.Add(new DataTable("tb"));

ds.Load(rd, LoadOption.Upsert, ds.Tables["tb"]);

return ds;

}



[WebMethod]

public String insertTb(String id, String nm, String dsc, String dt, String prc) {

OleDbConnection cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("~\\App_Data") + "\\db.mdb");

cn.Open();

OleDbCommand cm = new OleDbCommand("INSERT INTO tb (id, nm, dsc, dt, prc) VALUES ('" + id + "', '" + nm + "', '" + dsc + "', #" + dt + "#, " + prc + ")", cn);

cm.ExecuteNonQuery();

return "Succeed";

}



[WebMethod]

public String updateTb(String id, String nm, String dsc, String dt, String prc) {

OleDbConnection cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("~\\App_Data") + "\\db.mdb");

cn.Open();

OleDbCommand cm = new OleDbCommand("UPDATE tb SET nm = '" + nm + "', dsc = '" + dsc + "', dt = #" + dt + "#, prc = " + prc + " WHERE id = '" + id + "'", cn);

cm.ExecuteNonQuery();

return "Succeed";

}



[WebMethod]

public String deleteTb(String id) {

OleDbConnection cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath("~\\App_Data") + "\\db.mdb");

cn.Open();

OleDbCommand cm = new OleDbCommand("DELETE FROM tb WHERE id = '" + id + "'", cn);

cm.ExecuteNonQuery();

return "Succeed";

}



}

Hasilnya dapat dilihat dengan cara klik Debug - Start Debugging (Run - F5)

---

ActionScript AS3 ASP.NET AJAX C / C++ C# Clipper COBOL ColdFusion DataFlex Delphi Emacs Lisp Fortran FoxPro Java J2ME JavaScript JScript Lingo MATLAB Perl PHP PostScript Python SQL VBScript Visual Basic 6.0 Visual Basic .NET Flash MySQL Oracle Android

---

Related Post :

---

Judul: Web Service Database dengan C#.NET
Rating: 100% based on 99998 ratings. 5 user reviews.
Ditulis Oleh hank2

Anda sedang membaca artikel tentang Web Service Database dengan C#.NET, Semoga artikel tentang Web Service Database dengan C#.NET ini sangat bermanfaat bagi teman-teman semua, jangan lupa untuk mengunjungi lagi melalui link Web Service Database dengan C#.NET.

---