本文整理汇总了C#中DataClassesDataContext.SubmitChanges方法的典型用法代码示例。如果您正苦于以下问题:C# DataClassesDataContext.SubmitChanges方法的具体用法?C# DataClassesDataContext.SubmitChanges怎么用?C# DataClassesDataContext.SubmitChanges使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类DataClassesDataContext
的用法示例。
在下文中一共展示了DataClassesDataContext.SubmitChanges方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Button1_Click
protected void Button1_Click(object sender, EventArgs e)
{
DataClassesDataContext da = new DataClassesDataContext();
var result1 = from n in da.user
where n.user_name == TextBox3.Text
select n.major;
var result2 = from m in da.project
where m.project_num == DropDownList1.Text
select m.major;
foreach (var n in result1)
{
foreach (var m in result2)
{
if (n != m)
{
ClientScriptManager client = this.ClientScript;
client.RegisterStartupScript(this.GetType(), "55", "<script>alert('专业不符!');history.back()</script>");
return;
}
}
}
proposal p = new proposal();
p.proposal1 = TextBox1.Text;
p.project_num = DropDownList1.Text;
p.teacher_name = DropDownList2.Text;
p.user_name = TextBox3.Text;
p.proposal_num = TextBox2.Text;
da.proposal.InsertOnSubmit(p);
da.SubmitChanges();
GridView1.DataBind();
}
示例2: PrzydzielZadanieButton_Click
protected void PrzydzielZadanieButton_Click(object sender, EventArgs e)
{
List<int> idGrupList = new List<int>();
for (int i = 0; i < EnableGroupsListView.Items.Count; i++)
{
CheckBox chk = EnableGroupsListView.Items[i].FindControl("NazwaCheckBox") as CheckBox;
if (chk != null && chk.Checked)
{
idGrupList.Add((int)EnableGroupsListView.DataKeys[i].Value);
}
}
DataClassesDataContext db = new DataClassesDataContext();
Zadania zadanie = db.Zadanias.FirstOrDefault(g => g.IdZadania == (int)((DataKey)Session["IdZadania"]).Value);
foreach (int id in idGrupList)
{
ZadaniawGrupach zadaniawGrupach = new ZadaniawGrupach
{
Zadania = zadanie,
IdGrupy = id,
DataDodania = DateTime.Now
};
db.ZadaniawGrupaches.InsertOnSubmit(zadaniawGrupach);
}
db.SubmitChanges();
WczytajListeGrup(db);
SuccesLabel.Text = "Dodano zadanie do grup/y";
SuccesLabel.ForeColor = System.Drawing.Color.Green;
}
示例3: SubmitButton_Click
protected void SubmitButton_Click(object sender, EventArgs e)
{
TextBox commentCtrl = (TextBox)CommentsLoginView.FindControl("CommentTextBox");
if (commentCtrl != null && commentCtrl.Text.Length > 0)
{
using (DataClassesDataContext dtx = new DataClassesDataContext())
{
int aid = 0;
MembershipUser mu = Membership.GetUser(HttpContext.Current.User.Identity.Name);
if (int.TryParse(Context.Request["aid"], out aid))
{
var comment = new Comment()
{
ArticleId = aid,
UserId = (Guid)mu.ProviderUserKey,
Body = commentCtrl.Text,
Created = System.DateTime.Now
};
dtx.Comments.InsertOnSubmit(comment);
dtx.SubmitChanges();
CommentService c = new CommentService();
CommentsDataList.DataSource = c.GetComments(aid);
CommentsDataList.DataBind();
}
commentCtrl.Text = "";
}
}
}
示例4: button1_Click
protected void button1_Click(object sender, EventArgs e)
{
if (textbox1.Text.Equals(String.Empty) || textbox2.Text.Equals(String.Empty))
{
Label1.Text = "评论内容与验证码不能为空";
return;
}
try
{
if (!Request.Cookies["ValiCode"].Value.ToString().Equals(textbox2.Text))
{
Label1.Text = "验证码错误";
return;
}
Table_DocumentComment comment = new Table_DocumentComment();
comment.AccountName = Session["name"].ToString();
comment.AccountType = Session["type"].ToString();
comment.Comment = textbox1.Text;
comment.Date = DateTime.Now;
comment.DocumentId = (Int32)Session["document"];
DataClassesDataContext data = new DataClassesDataContext();
data.Table_DocumentComment.InsertOnSubmit(comment);
data.SubmitChanges();
comments.Add(comment);
textbox1.Text = String.Empty;
textbox2.Text = String.Empty;
Label1.Text = String.Empty;
}
catch (Exception) { }
}
示例5: Insert
public static void Insert(Student_Registration_Form studentToAdd)
//used by that add student form to add a new record to the db
{
var db = new DataClassesDataContext();
db.Student_Registration_Forms.InsertOnSubmit(studentToAdd);
db.SubmitChanges();
}
示例6: DeletePerson
public void DeletePerson(string personId)
{
WebOperationContext ctx = WebOperationContext.Current;
try
{
using (var dataContext = new DataClassesDataContext())
{
Person person = dataContext.Persons.SingleOrDefault(p => p.PersonId == Convert.ToInt32(personId));
if (person == null)
{
ctx.OutgoingResponse.StatusCode = System.Net.HttpStatusCode.NotFound;
return;
}
dataContext.Persons.DeleteOnSubmit(person);
dataContext.SubmitChanges();
ctx.OutgoingResponse.StatusCode = System.Net.HttpStatusCode.OK;
return;
}
}
catch
{
ctx.OutgoingResponse.StatusCode = System.Net.HttpStatusCode.BadRequest;
return;
}
}
示例7: AddAnswer
//��Ӵ�
public bool AddAnswer(List<Answer> answer)
{
DataClassesDataContext da = new DataClassesDataContext();
da.Answer.InsertAllOnSubmit(answer);
da.SubmitChanges();
return true;
}
示例8: Index
public ActionResult Index(string username, string password)
{
DataClassesDataContext db = new DataClassesDataContext();
if (string.IsNullOrWhiteSpace(username) || string.IsNullOrWhiteSpace(password))
{
return View();
}
if (db.Users.Where(u => u.nick == username).Count() < 1)
{
db.Users.InsertOnSubmit(new User { nick = username, password = password });
db.SubmitChanges();
}
if (db.Users.Where(u => u.nick == username && u.password == password).Count() > 0)
{
Session["login"] = true;
Session["nick"] = username;
Session["userid"] = db.Users.Where(u => u.nick == username).First().id;
Session["type"] = db.Users.Where(u => u.nick == username).First().type;
return RedirectToAction("Index", "Chat");
}
else
{
ViewBag.ErrorMessage = "Nicket er ikke tilgjengelig!";
return View();
}
}
示例9: btn_Solicitar_Click
//***************************** MÉTODO INSERTAR ******************************
protected void btn_Solicitar_Click(object sender, EventArgs e)
{
DataClassesDataContext scc = new DataClassesDataContext();
solicitud obj_Solicitud = new solicitud();
try
{
//Validacion
cleanMsgTxt();
if (validaForm() == 0)
{
obj_Solicitud.idCliente = Convert.ToInt32(idCliente);
obj_Solicitud.cSolicitada = Convert.ToInt32(txt_cSolicitada.Text.Trim());
obj_Solicitud.idModalidad = Convert.ToByte(txt_modalidad.SelectedValue);
//obj_Cliente.fechaNac = txt_fn.SelectedDate.ToShortDateString(
obj_Solicitud.fechaInicio = txt_fInicio.SelectedDate.ToShortDateString();
obj_Solicitud.fechaFin = txt_fFin.SelectedDate.ToShortDateString();
obj_Solicitud.ingresoMensual = Convert.ToDecimal(txt_ingresoMe.Text.Trim());
obj_Solicitud.gastoMensual = Convert.ToDecimal(txt_gastoMens.Text.Trim());
obj_Solicitud.descripcionCredito = txt_desc.Text.Trim();
obj_Solicitud.descripcionGarantias = txt_garantias.Text.Trim();
obj_Solicitud.montoValuado = Convert.ToDecimal(txt_montoVa.Text.Trim());
if (Convert.ToDecimal(txt_ingresoMe.Text.Trim()) > Convert.ToDecimal(txt_gastoMens.Text.Trim())
& Convert.ToDecimal(txt_montoVa.Text.Trim()) / 3 >= Convert.ToInt32(txt_cSolicitada.Text.Trim()))
{
decimal monto=0;
monto=Convert.ToDecimal(txt_montoVa.Text.Trim()) /3;
obj_Solicitud.creditoMaximo = monto;
obj_Solicitud.estatus = "Aceptado";
}
else {
decimal monto = 0;
monto = Convert.ToDecimal(txt_montoVa.Text.Trim()) / 3;
obj_Solicitud.creditoMaximo = monto;
obj_Solicitud.estatus = "Rechazado";
}
scc.solicitud.InsertOnSubmit(obj_Solicitud); //uso del metodo
scc.SubmitChanges(); //cambioss
lbl_Mensaje.Text = "Su solicitud ha sido registrada";
}
}
catch (Exception ex)
{
lbl_Mensaje.Text = "ERROR - " + ex.Message.ToString();
}
}
示例10: create
public bool create(Assignment thisAssignment)
{
// ������ҵ
DataClassesDataContext da = new DataClassesDataContext();
da.Assignment.InsertOnSubmit(thisAssignment);
da.SubmitChanges();
return true;
}
示例11: Button1_Click
protected void Button1_Click(object sender, EventArgs e)
{
DataClassesDataContext db = new DataClassesDataContext();
Product product = db.Products.SingleOrDefault(p => p.ProductID == 16);
product.UnitPrice = product.UnitPrice + 2;
product.UnitsInStock = 70;
db.SubmitChanges();
DisplayData();
}
示例12: btnDelete_Click
protected void btnDelete_Click(object sender, EventArgs e)
{
using (var obj = new DataClassesDataContext())
{
var tbl = obj.tblLinqSamples.Single(a => a.Id == Convert.ToInt64(txtId.Text));
obj.tblLinqSamples.DeleteOnSubmit(tbl);
obj.SubmitChanges();
}
}
示例13: Button2_Click
protected void Button2_Click(object sender, EventArgs e)
{
DataClassesDataContext data = new DataClassesDataContext();
var q = from s in data.Table_Document
where s.Id == (Int32)Session["document"]
select s;
data.Table_Document.DeleteAllOnSubmit(q);
data.SubmitChanges();
Response.Redirect("Document.aspx");
}
示例14: SetRead
public void SetRead(bool state)
{
DataClassesDataContext dbo = new DataClassesDataContext();
var temp = dbo.Messages.Single(m => m.ID == this.ID);
temp.Read = true;
dbo.SubmitChanges();
}
示例15: Button1_Click
protected void Button1_Click(object sender, EventArgs e)
{
DataClassesDataContext context = new DataClassesDataContext();
dynamic b = new dynamic();
var query = (from p in context.dynamics where p.name == DropDownList1.SelectedValue select p).Single();
query.description = FreeTextBox1.Text;
context.SubmitChanges();
}