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();
}
