Form1.cs
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.ServiceModel;
using System.ServiceModel.Web;
namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
StudentDBDataContext studentdb = new StudentDBDataContext();
private void button1_Click(object sender, EventArgs e)
{
dataGridView1.DataSource = studentdb.Students; //Show all
//dataGridView1.DataSource = studentdb.Students.Where(
// g => g.studentid == “001″);
}
private void button2_Click(object sender, EventArgs e) //insert
{
Student newstudent = new Student();
newstudent.studentid = textBox1.Text;
newstudent.firstname = textBox2.Text;
newstudent.lastname = textBox3.Text;
newstudent.level = Int32.Parse(textBox4.Text);
studentdb.Students.InsertOnSubmit(newstudent);
studentdb.SubmitChanges();
}
Student std;
private void button3_Click(object sender, EventArgs e) //find
{
std = studentdb.Students.Where(
s => s.studentid==textBox1.Text).SingleOrDefault();
if (studentdb != null)
{
textBox2.Text = std.firstname;
textBox3.Text = std.lastname;
textBox4.Text = std.level.ToString();
}
}
private void button4_Click(object sender, EventArgs e) //Update
{
std.firstname = textBox2.Text;
std.lastname = textBox3.Text;
std.level = Int32.Parse(textBox4.Text);
studentdb.SubmitChanges();
}
private void button5_Click(object sender, EventArgs e) //Delete
{
studentdb.Students.DeleteOnSubmit(std);
studentdb.SubmitChanges();
}
private void Form1_Load(object sender, EventArgs e) {
WebServiceHost ws = new WebServiceHost(
typeof(StudentSerive),
new Uri(”http://172.16.28.61:8888″));
ws.AddServiceEndpoint(typeof(iStudent),
new BasicHttpBinding(),”students”);
ws.Open();
}
[ServiceContract]
public interface iStudent {
[OperationContract,
WebGet(ResponseFormat = WebMessageFormat.Json)]
List<Student> getAllStudents();
}
public class StudentSerive : iStudent {
StudentDBDataContext studentdb = new StudentDBDataContext();
public List<Student> getAllStudents()
{
return studentdb.Students.ToList();
}
}
}
}
วิธี set
Result after Run
จากการฝึกอบรม Android วิทยากร อ.โชคชัย จันทร์เชย