public void SaveUser(string Nombre, string Email) { DataRow drUsuario = new dsNorthwind().Tables["Usuarios"].NewRow(); UsuarioBus usr = new UsuarioBus(); Messages q = new Messages(); drUsuario["Nombre"] = Nombre; drUsuario["Email"] = Email; try { q.value = usr.UsuarioInsert(drUsuario); if (q.value == 1) { q.message = "Los datos se grabaron correctamente."; } else { q.message = "Los datos no han sido guardados."; } } catch (Exception ex) { q.value = -1; q.message = ex.Message; } Context.Response.ContentType = "application/json;charset=utf-8"; Context.Response.Write(Context.Request["callback"] + "(" + new JavaScriptSerializer().Serialize(q) + ")"); }
protected void btnRead_Click(object sender, EventArgs e) { //實體化強型別DataSet dsNorthwind myDs = new dsNorthwind(); //透過EmployeesTableAdapter將資料載入myDs.Employees的DataTable中 dsNorthwindTableAdapters.EmployeesTableAdapter adapter = new dsNorthwindTableAdapters.EmployeesTableAdapter(); adapter.Fill(myDs.Employees); //以LINQ查詢員工基本資料 var Emps = from p in myDs.Employees where p.EmployeeID < 10 select new { p.EmployeeID, p.LastName, p.FirstName, p.City, p.Address }; GridView1.DataSource = Emps; GridView1.DataBind(); }