// <snippet3> public bool Delete() { if (ID.Equals(DBNull.Value)) { // The Employee object is not persisted. return(true); } else { // The Employee object is persisted. // Use the SqlDataSource control as a convenient wrapper for // the ADO.NET code needed to delete a record from the database. ConnectionStringSettings cts = ConfigurationManager.ConnectionStrings["NorthwindConnection"]; SqlDataSource sds = new SqlDataSource(); try { sds.ConnectionString = cts.ConnectionString; sds.DeleteParameters.Add(new Parameter("empID", TypeCode.Int32, this.ID.ToString())); sds.DeleteCommand = "DELETE FROM [Order Details] " + "WHERE OrderID IN (SELECT OrderID FROM Orders WHERE EmployeeID=@empID)"; sds.Delete(); sds.DeleteCommand = "DELETE FROM Orders WHERE EmployeeID=@empID"; sds.Delete(); sds.DeleteCommand = "DELETE FROM EmployeeTerritories WHERE EmployeeID=@empID"; sds.Delete(); sds.DeleteCommand = "DELETE FROM Employees WHERE EmployeeID=@empID"; sds.Delete(); return(true); } finally { // Clean up resources. sds.Dispose(); } } }
protected void Button1_Click(object sender, EventArgs e) { SqlDataSource sqldatasource2 = new SqlDataSource(); sqldatasource2.ConnectionString = WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString.ToString(); sqldatasource2.UpdateParameters.Add("Order_date", TextBox1.Text); sqldatasource2.UpdateParameters.Add("Assign_numbers", TextBox2.Text); sqldatasource2.UpdateParameters.Add("Account_numbers", DropDownList1.Text); sqldatasource2.UpdateParameters.Add("Account_abstract", TextBox3.Text); sqldatasource2.UpdateParameters.Add("Income", TextBox4.Text); sqldatasource2.UpdateParameters.Add("Spend", TextBox5.Text); sqldatasource2.UpdateCommand = "Update [Account_Order_M] set Order_date=@Order_date, Account_numbers=@Account_numbers, Assign_numbers=@Assign_numbers, Account_abstract=@Account_abstract, Income=@Income, Spend=@Spend where Id="+Request["Id"]; int affraw_update = sqldatasource2.Update(); if (affraw_update == 0) { Label1.Text = "error"; } else { Label1.Text = "ok"; Button1.Visible = false; } sqldatasource2.Dispose(); }
// Returns a collection of NorthwindEmployee objects. public static ICollection GetAllEmployees() { ArrayList al = new ArrayList(); // Use the SqlDataSource class to wrap the // ADO.NET code required to query the database. ConnectionStringSettings cts = ConfigurationManager.ConnectionStrings["NorthwindConnection"]; SqlDataSource sds = new SqlDataSource(cts.ConnectionString, "SELECT EmployeeID FROM Employees"); try { IEnumerable IDs = sds.Select(DataSourceSelectArguments.Empty); // Iterate through the Enumeration and create a // NorthwindEmployee object for each ID. IEnumerator enumerator = IDs.GetEnumerator(); while (enumerator.MoveNext()) { // The IEnumerable contains DataRowView objects. DataRowView row = enumerator.Current as DataRowView; int id = (int)row["EmployeeID"]; NorthwindEmployee nwe = new NorthwindEmployee(id); // Add the NorthwindEmployee object to the collection. al.Add(nwe); } } finally { // If anything strange happens, clean up. sds.Dispose(); } return(al); }
// <snippet3> public bool Delete() { if (ID.Equals(DBNull.Value)) { // The Employee object is not persisted. return(true); } else { // The Employee object is persisted. // Use the SqlDataSource control as a convenient wrapper for // the ADO.NET code needed to delete a record from the database. ConnectionStringSettings cts = ConfigurationManager.ConnectionStrings["NorthwindConnection"]; SqlDataSource sds = new SqlDataSource(); try { sds.ConnectionString = cts.ConnectionString; sds.DeleteCommand = "DELETE FROM Employees WHERE EmployeeID=@empID;"; sds.DeleteParameters.Add(new Parameter("empID", TypeCode.Int32, this.ID.ToString())); /* To make this sample fully functional, uncomment these lines * int retval = sds.Delete(); * if (retval == 1) { return true; } * return false; */ return(true); } finally { sds.Dispose(); } } }
protected void Button1_Click(object sender, EventArgs e) { SqlDataSource SqlDataSource2 = new SqlDataSource(); SqlDataSource2.ConnectionString = WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; try { SqlDataSource2.DeleteCommand = "delete [Account_Order_M] where id=" + Request["Id"]; int affraw = SqlDataSource2.Delete(); if (affraw == 0) { Label8.Text = "error"; Button1.Visible = false; } else { Label8.Text = "ok"; Button1.Visible = false; } } catch (Exception ex2) { Response.Write(ex2.ToString()); } finally { SqlDataSource2.Dispose(); } }
protected void LinkButton1_Click(object sender, EventArgs e) { if (Session["AdminName"] == null && Session["AId"] == null) { Response.Redirect("~/admin/default.aspx"); } string admin_id = Session["AId"].ToString(); if (string.IsNullOrEmpty(admin_id)) { Response.Redirect("~/admin/default.aspx"); } SqlDataSource SqlDataSource1 = new SqlDataSource(); SqlDataSource1.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlDataSource1.UpdateCommand = @"UPDATE [Admin] SET [admin_name] = @admin_name, [admin_email] = @admin_email, [admin_pass] = @admin_pass WHERE [admin_id] = @admin_id"; SqlDataSource1.UpdateParameters.Add("admin_name", aname_ip.Text.Trim().ToString()); SqlDataSource1.UpdateParameters.Add("admin_email", email_ip.Text.Trim().ToString()); SqlDataSource1.UpdateParameters.Add("admin_pass", pass_ip.Text.Trim().ToString()); SqlDataSource1.UpdateParameters.Add("admin_id", Session["AId"].ToString()); SqlDataSource1.Update(); SqlDataSource1.Dispose(); //Label1.Text = "Update Successful....!!!"; html1.InnerHtml += "<div class=alertBox alertBox--success>"; html1.InnerHtml += "<div class=alertBox-column alertBox-icon>"; html1.InnerHtml += "<icon glyph=ic-success class=icon aria-hidden=true>"; html1.InnerHtml += "<svg xmlns=http://www.w3.org/2000/svg width=24 height=24 viewBox=0 0 24 24>"; html1.InnerHtml += "<path d=M12 2C6.48 2 2 6.48 2 12s4.48 10 10 10 10-4.48 10-10S17.52 2 12 2zm1 15h-2v-2h2v2zm0-4h-2V7h2v6z>"; html1.InnerHtml += "</path>"; html1.InnerHtml += "</svg>"; html1.InnerHtml += "</icon>"; html1.InnerHtml += "</div>"; html1.InnerHtml += "<p class=alertBox-column alertBox-message>"; html1.InnerHtml += "<span>"; html1.InnerHtml += "Your account details have been updated."; html1.InnerHtml += "</span>"; html1.InnerHtml += "</p>"; html1.InnerHtml += "</div>"; }
public SqlDataSource bindGrid(string query, string dsID) { SqlDataSource sql = new SqlDataSource(System.Configuration.ConfigurationManager.ConnectionStrings["SQLConnstr"].ConnectionString, query); sql.ID = dsID; sql.DataBind(); sql.Dispose(); return(sql); }
protected void ButtonOpasnost_Click(object sender, EventArgs e) { // ID ИСПДн string IspdnID = DetailsViewISPDnOpasn.Rows[0].Cells[1].Text; string conn = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString; SqlDataSource sdsDelMnogieOpasn = new SqlDataSource(); sdsDelMnogieOpasn.ConnectionString = conn; sdsDelMnogieOpasn.DeleteCommand = "DELETE FROM MnogieOpasnUgrozIS WHERE (ISPDnOperatorID = @ParamISPDnID)"; sdsDelMnogieOpasn.DeleteParameters.Add(new Parameter("ParamISPDnID", TypeCode.Int32, IspdnID)); sdsDelMnogieOpasn.Delete(); sdsDelMnogieOpasn.InsertCommand = "INSERT INTO MnogieOpasnUgrozIS (NazvanieUgrozID, ISPDnOperatorID, OpasnostUgrozID) VALUES (@ParamUgrozaID,@ParamISPDnID,@ParamOpasnID)"; sdsDelMnogieOpasn.InsertParameters.Add(new Parameter("ParamUgrozaID", TypeCode.Int32)); sdsDelMnogieOpasn.InsertParameters.Add(new Parameter("ParamISPDnID", TypeCode.Int32)); sdsDelMnogieOpasn.InsertParameters.Add(new Parameter("ParamOpasnID", TypeCode.Int32)); // незабыть диспозе для дата сорсе int ugroza; //ugroza = 0; for (int i = 0; i < GridViewUgrozaOpasn.Rows.Count - 1; i++) { RadioButton radioVer1 = (RadioButton)GridViewUgrozaOpasn.Rows[i].FindControl("RadioButton1"); RadioButton radioVer2 = (RadioButton)GridViewUgrozaOpasn.Rows[i].FindControl("RadioButton2"); RadioButton radioVer3 = (RadioButton)GridViewUgrozaOpasn.Rows[i].FindControl("RadioButton3"); // если первая радио кнопка отмечена то маловероятная угроза if (radioVer1.Checked == true) { ugroza = 1; sdsDelMnogieOpasn.InsertParameters["ParamUgrozaID"].DefaultValue = (i + 1).ToString(); sdsDelMnogieOpasn.InsertParameters["ParamISPDnID"].DefaultValue = IspdnID; sdsDelMnogieOpasn.InsertParameters["ParamOpasnID"].DefaultValue = ugroza.ToString(); sdsDelMnogieOpasn.Insert(); } else if (radioVer2.Checked == true) { ugroza = 2; sdsDelMnogieOpasn.InsertParameters["ParamUgrozaID"].DefaultValue = (i + 1).ToString(); sdsDelMnogieOpasn.InsertParameters["ParamISPDnID"].DefaultValue = IspdnID; sdsDelMnogieOpasn.InsertParameters["ParamOpasnID"].DefaultValue = ugroza.ToString(); sdsDelMnogieOpasn.Insert(); } else if (radioVer3.Checked == true) { ugroza = 3; sdsDelMnogieOpasn.InsertParameters["ParamUgrozaID"].DefaultValue = (i + 1).ToString(); sdsDelMnogieOpasn.InsertParameters["ParamISPDnID"].DefaultValue = IspdnID; sdsDelMnogieOpasn.InsertParameters["ParamOpasnID"].DefaultValue = ugroza.ToString(); sdsDelMnogieOpasn.Insert(); } } sdsDelMnogieOpasn.Dispose(); }
public void refreshdata() { SqlDataSource da1 = new SqlDataSource(); da1.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["constr"].ConnectionString; da1.SelectCommand = @"SELECT Batch.batch_id,Batch.batch_sdate,Batch.batch_edate,Course.course_name FROM Course INNER JOIN Batch ON Batch.course_id = Course.course_id"; da1.DataBind(); Batch.DataSource = da1; Batch.DataBind(); da1.Dispose(); }
public void refreshdata() { SqlDataSource da1 = new SqlDataSource(); da1.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["constr"].ConnectionString; da1.SelectCommand = @"SELECT Product.product_id,Product.product_name,Product.product_cdate,Category.category_name FROM Category INNER JOIN Product ON Category.category_id = Product.category_id"; da1.DataBind(); Products.DataSource = da1; Products.DataBind(); da1.Dispose(); }
private void GVBind(int page) { using (SqlDataSource Conn = new SqlDataSource()) { Conn.ConnectionString = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["EIPAConnectionString"].ConnectionString; StringBuilder sb = new StringBuilder(); string user = this.UserName.Text; string dept = this.Dept.SelectedValue.Trim(); sb.Append(" select u.id,d.dept_nm ,u.name ,u.email,u.logonid from eipa.dbo.dguser u "); sb.Append(" left join eipa.dbo.lea_hm1emp10 e on e.emp_no = u.empid"); sb.Append(" left join eipa.dbo.lea_hm1dept10 d on d.dept_no = e.dept_no "); sb.Append(" left join eipa.dbo.dglevel l on u.levid = l.lnid "); sb.Append(" where ustatus='57DADAB8-44CF-4BAA-A40C-324F9F4533A9'"); sb.Append(" and comid='MAT' and d.dept_no is not null "); if (_group.ToUpper() == "MAIL") { sb.Append(" and u.email is not null "); } sb.AppendFormat(" and u.logonid not in (select logonid from eipe.dbo.IPQC_Mail where u_group='{0}' ) ", _group); if (!string.IsNullOrEmpty(user)) { sb.Append(string.Format(" and u.name like '%{0}%' ", user)); } if (!string.IsNullOrEmpty(dept)) { sb.Append(string.Format(" and d.dept_no='{0}' ", dept)); } sb.Append(" order by d.dept_no ,l.lshort desc "); Conn.SelectCommand = sb.ToString(); Conn.DataSourceMode = SqlDataSourceMode.DataSet; DataSourceSelectArguments args = new DataSourceSelectArguments(); DataView dv = (DataView)Conn.Select(args); GridView1.PageIndex = page; GridView1.DataSource = dv; GridView1.DataBind(); Session["Page"] = page; Conn.Dispose(); } }
public void getdata() { SqlDataSource da1 = new SqlDataSource(); da1.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["constr"].ConnectionString; da1.SelectCommand = @"SELECT Student.stud_code,Student.stud_name,Student.batch_id,Course.course_name FROM Course INNER JOIN Student ON Student.course_id = Course.course_id"; da1.DataBind(); Student.DataSource = da1; Student.DataBind(); da1.Dispose(); }
protected void Page_Init(object sender, EventArgs e) { if (Session["Id"] == null) { Response.Redirect("login.aspx"); } string user_id = Session["Id"].ToString(); if (string.IsNullOrEmpty(user_id)) { Response.Redirect("login.aspx"); } SqlDataSource SqlDataSource1 = new SqlDataSource(); SqlDataSource1.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlDataSource1.SelectCommand = @"SELECT [user_fname], [user_lname], [user_email], [user_ph_num], [user_addr1], [user_addr2], [user_city], [user_state], [user_country], [user_zip] FROM [UserInfo] WHERE [user_id] = @user_id"; SqlDataSource1.SelectParameters.Add("user_id", user_id); DataSourceSelectArguments args = new DataSourceSelectArguments(); DataView dv = SqlDataSource1.Select(args) as DataView; fname_ip.Text = dv.Table.Rows[0]["user_fname"].ToString(); lname_ip.Text = dv.Table.Rows[0]["user_lname"].ToString(); email_ip.Text = dv.Table.Rows[0]["user_email"].ToString(); phnum_ip.Text = dv.Table.Rows[0]["user_ph_num"].ToString(); addr1_ip.Text = dv.Table.Rows[0]["user_addr1"].ToString(); addr2_ip.Text = dv.Table.Rows[0]["user_addr2"].ToString(); city_ip.Text = dv.Table.Rows[0]["user_city"].ToString(); state_ip.Text = dv.Table.Rows[0]["user_state"].ToString(); countrylist.Text = dv.Table.Rows[0]["user_country"].ToString(); zip_ip.Text = dv.Table.Rows[0]["user_zip"].ToString(); /*fname_ip.Text = dv.Table.Rows[0][1].ToString(); * lname_ip.Text = dv.Table.Rows[0][2].ToString(); * email_ip.Text = dv.Table.Rows[0][3].ToString(); * phnum_ip.Text = dv.Table.Rows[0][5].ToString(); * addr1_ip.Text = dv.Table.Rows[0][6].ToString(); * addr2_ip.Text = dv.Table.Rows[0][7].ToString(); * city_ip.Text = dv.Table.Rows[0][10].ToString(); * state_ip.Text = dv.Table.Rows[0][9].ToString(); * countrylist.Text = dv.Table.Rows[0][8].ToString(); * zip_ip.Text = dv.Table.Rows[0][11].ToString(); */ SqlDataSource1.Dispose(); }
public void getdata() { SqlDataSource da1 = new SqlDataSource(); da1.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["constr"].ConnectionString; da1.SelectCommand = @"SELECT Category.category_id, Category.category_name, Product.product_name, Product.product_desc, Product.product_video, Product.product_image, Product.category_id AS cat_id, Product.product_id FROM Product INNER JOIN Category ON Product.product_id = @product_id"; da1.SelectParameters.Add("product_id", pro_id); da1.DataBind(); formview1.DataSource = da1; formview1.DataBind(); da1.Dispose(); }
/// <summary> /// Executes the query reader. /// </summary> /// <param name="query">The query.</param> /// <param name="execType">Type of the execute.</param> /// <param name="command">The command.</param> /// <returns></returns> public System.Data.SqlClient.SqlDataReader executeQueryReader(string query, byte execType = 0, System.Data.SqlClient.SqlCommand command = null) { query = query ?? queryOverride; if (string.IsNullOrEmpty(query) && string.IsNullOrEmpty(queryOverride)) { return(null); } if (Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["check4"] ?? "0") == 3) { setLogAppEntry(query); } Consultas asd = new Consultas(); var sqlInstruction = query; sqlInstruction = string.Format(sqlInstruction); sqlInstruction = indeedFormatted != 0? commandFormat(sqlInstruction):sqlInstruction; SqlDataSource sqlDs = new SqlDataSource() { ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString, SelectCommand = execType == 0 ? sqlInstruction : string.Empty, SelectCommandType = command == null ? SqlDataSourceCommandType.Text : SqlDataSourceCommandType.StoredProcedure, InsertCommand = execType == 1 ? sqlInstruction : string.Empty, InsertCommandType = command == null ? SqlDataSourceCommandType.Text : SqlDataSourceCommandType.StoredProcedure, UpdateCommand = execType == 2 ? sqlInstruction : string.Empty, UpdateCommandType = command == null ? SqlDataSourceCommandType.Text : SqlDataSourceCommandType.StoredProcedure, DeleteCommand = execType == 3?sqlInstruction:string.Empty, DeleteCommandType = command == null?SqlDataSourceCommandType.Text:SqlDataSourceCommandType.StoredProcedure, DataSourceMode = execType == 0? SqlDataSourceMode.DataReader: SqlDataSourceMode.DataSet, ConflictDetection = System.Web.UI.ConflictOptions.OverwriteChanges }; SqlDataReader reader = null; try { switch (execType) { case 0: { reader = ((SqlDataReader)sqlDs.Select(new System.Web.UI.DataSourceSelectArguments())); break; } case 1: { rwSnd = sqlDs.Insert(); break; } case 2: { rwSnd = sqlDs.Update(); break; } case 3: { rwSnd = sqlDs.Delete(); break; } default: { break; } } } catch (Exception xcpt) { setLogAppEntry(xcpt.Message + '\n' + xcpt.StackTrace + '\n' + xcpt.InnerException != null?xcpt.Source :xcpt.InnerException.Message); } sqlDs.Dispose(); return(reader); }
protected void Page_Load(object sender, EventArgs e) { SqlDataSource SqlDataSource1 = new SqlDataSource(); SqlDataSource1.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlDataSource1.SelectCommand = @"SELECT user_id, user_fname, user_lname, user_email, user_ph_num, user_addr1, user_addr2, user_city, user_state, user_country, user_zip FROM UserInfo"; SqlDataSource1.DataBind(); GridView1.DataSource = SqlDataSource1; GridView1.DataBind(); SqlDataSource1.Dispose(); }
protected void Page_Load(object sender, EventArgs e) { SqlDataSource SqlDataSource1 = new SqlDataSource(); SqlDataSource1.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlDataSource1.SelectCommand = @"SELECT Product.product_id, Product.product_name, Product.product_desc, Product.product_price, Product.product_stock, Product.product_cdate, Category.category_name FROM Category INNER JOIN Product ON Category.category_id = Product.category_id"; SqlDataSource1.DataBind(); GridView1.DataSource = SqlDataSource1; GridView1.DataBind(); SqlDataSource1.Dispose(); }
public void NewCountry(string CountryName) { SqlDataSource sqlDataSource = new SqlDataSource(); sqlDataSource.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"].ToString(); Parameter p = new Parameter("@Name", System.Data.DbType.String, CountryName); sqlDataSource.InsertParameters.Add(p); sqlDataSource.InsertCommandType = SqlDataSourceCommandType.StoredProcedure; sqlDataSource.InsertCommand = "SP_NewCountry"; sqlDataSource.Insert(); sqlDataSource.Dispose(); }
public void view() { BatchStudent.Visible = true; SqlDataSource da1 = new SqlDataSource(); da1.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["constr"].ConnectionString; da1.SelectCommand = @"SELECT Student.stud_code,Student.stud_name,Student.batch_id,Course.course_name FROM Course INNER JOIN Student ON Student.course_id = Course.course_id where Student.batch_id=@batch_id"; da1.SelectParameters.Add("batch_id", batch); da1.DataBind(); BatchStudent.DataSource = da1; BatchStudent.DataBind(); da1.Dispose(); }
public void bindGrid(string query, string dsID, GridView g, Page p) { SqlDataSource sql = new SqlDataSource(System.Configuration.ConfigurationManager.ConnectionStrings["SQLConnstr"].ConnectionString, query); sql.ID = dsID; sql.DataBind(); sql.Dispose(); p.Controls.Add(sql); g.DataSourceID = dsID; g.AllowPaging = true; g.AllowSorting = true; g.DataBind(); }
private void GetTotalPayment() { SqlDataSource SqlDataSource1 = new SqlDataSource(); SqlDataSource1.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlDataSource1.SelectCommand = "SELECT SUM(cart_subTotal) AS TotalPayment FROM Cart WHERE [cart_transid] = @cart_transid"; SqlDataSource1.SelectParameters.Add("cart_transid", Session["Tid"].ToString()); FormView1.DataSource = SqlDataSource1; FormView1.DataBind(); SqlDataSource1.Dispose(); }
protected void Page_Load(object sender, EventArgs e) { SqlDataSource SqlDataSource1 = new SqlDataSource(); SqlDataSource1.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlDataSource1.SelectCommand = @"SELECT order_id, cart_transid, order_customerName, order_total, order_payment, user_id FROM [Order]"; //SqlDataSource1.DataBind(); GridView1.DataSource = SqlDataSource1; GridView1.DataBind(); SqlDataSource1.Dispose(); }
private void BindGrid() { SqlDataSource SqlDataSource1 = new SqlDataSource(); SqlDataSource1.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlDataSource1.SelectCommand = "SELECT [cart_id], [product_id], [cart_quantity], [cart_product_name], [cart_productSubPrice], [cart_subTotal], [cart_cdate], [cart_transid] FROM [Cart] WHERE [cart_transid] = @cart_transid"; SqlDataSource1.SelectParameters.Add("cart_transid", Session["Tid"].ToString()); GridView1.DataSource = SqlDataSource1; GridView1.DataBind(); SqlDataSource1.Dispose(); }
/// <summary> /// Crea nueva acta /// </summary> /// <param name="CodConvocatoria">id convocatoria.</param> /// <param name="CodDocumentoFormato">id formato del documento.</param> /// <param name="Comentario">comentario.</param> /// <param name="Fecha">fecha.</param> /// <param name="FechaActa">fecha del acta.</param> /// <param name="Icono">icono.</param> /// <param name="Id_Acta"> id del acta.</param> /// <param name="NomActa">The nom acta.</param> /// <param name="NomDocumentoFormato">nombre documento.</param> /// <param name="NumActa">numero del acta.</param> /// <param name="URL">URL.</param> public void NewActa(string CodConvocatoria, string CodDocumentoFormato, string Comentario, string Fecha, string FechaActa, string Icono, string Id_Acta, string NomActa, string NomDocumentoFormato, string NumActa, string URL) { if (contextProc) { return; } var jyf = new Datos.MD_ActasFormatoResult() { CodConvocatoria = int.Parse(CodConvocatoria), CodDocumentoFormato = byte.Parse(CodDocumentoFormato ?? "0"), Comentario = Comentario, Fecha = DateTime.Parse(Fecha), FechaActa = DateTime.Parse(FechaActa), Icono = Icono ?? "0", Id_Acta = int.Parse(Id_Acta ?? "0"), NomActa = NomActa, NomDocumentoFormato = NomDocumentoFormato ?? "0", NumActa = NumActa, URL = URL }; Consultas asd = new Consultas(); asd.Db.MD_ActasFormato(0).ToList().Add(jyf); asd.Db.SubmitChanges(); var IdContacto = HttpContext.Current.Request.ServerVariables["cod"] ?? "0"; CodDocumentoFormato = HttpContext.Current.Session["Adjuntos"] != null?((HttpPostedFile[])HttpContext.Current.Session["Adjuntos"]).FirstOrDefault().FileName.Split('.')[1].Insert(0, "."):"5"; var _CodDocumentoFormato = (int)asd.Db.DocumentoFormatos.Where(u => u.Extension == CodDocumentoFormato).Select(h => h.Id_DocumentoFormato).FirstOrDefault(); _CodDocumentoFormato = _CodDocumentoFormato > 0 ? _CodDocumentoFormato : 5; CodDocumentoFormato = _CodDocumentoFormato.ToString(); var sqlInsert = "INSERT INTO [dbo].[ConvocatoriaActa] ([NumActa] ,[NomActa] ,[FechaActa] ,[Fecha] ,[URL] ,[CodConvocatoria]" + ",[CodDocumentoFormato],[CodContacto],[Comentario],[Borrado]) " + "VALUES ({0} ,ƒ{1}ƒ ,CONVERT(DATETIME, ƒ{2}ƒ, 103) ,CONVERT(DATETIME, ƒ{3}ƒ, 103) ,ƒ{4}ƒ ,{5} ,{6} ,{7} ,ƒ{8}ƒ ,{9})"; sqlInsert = string.Format(sqlInsert, jyf.NumActa, jyf.NomActa, jyf.FechaActa.ToShortDateString(), jyf.Fecha.ToShortDateString(), jyf.URL, jyf.CodConvocatoria, CodDocumentoFormato, IdContacto, jyf.Comentario, new byte()); sqlInsert = commandFormat(sqlInsert); SqlDataSource sqlDs = new SqlDataSource() { ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString, InsertCommand = sqlInsert, UpdateCommandType = SqlDataSourceCommandType.Text, DataSourceMode = SqlDataSourceMode.DataReader }; sqlDs.Insert(); sqlDs.Dispose(); contextProc = true; }
// Кнопка добавления отмеченных ПД protected void ButtonChekOtdelPD_Click(object sender, EventArgs e) { //*** Методы добавления основных персональных данных в связную таблицу МногиеИСПДнПД string conn = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString; SqlDataSource sds = new SqlDataSource(); sds.ConnectionString = conn; sds.DeleteCommand = "DELETE FROM MnogieKategoryPdOtdel WHERE (OtdelOrgID = @ParamOtdelID)"; sds.DeleteParameters.Add(new Parameter("ParamOtdelID", TypeCode.Int32, DetailsViewOtdel.Rows[0].Cells[1].Text)); sds.Delete(); sds.InsertCommand = "INSERT INTO MnogieKategoryPdOtdel(OtdelOrgID, KategoryPdID) VALUES (@ParamOtdelID, @ParamPdID)"; sds.InsertParameters.Add(new Parameter("ParamOtdelID", TypeCode.Int32)); sds.InsertParameters.Add(new Parameter("ParamPdID", TypeCode.Int32)); for (int i = 0; i < CheckBoxListOtdelOsnova.Items.Count; i++) { if (CheckBoxListOtdelOsnova.Items[i].Selected == true) { sds.InsertParameters["ParamOtdelID"].DefaultValue = DetailsViewOtdel.Rows[0].Cells[1].Text; sds.InsertParameters["ParamPdID"].DefaultValue = (i + 1).ToString(); sds.Insert(); } } sds.Dispose(); //*** Методы добавления специальных персональных данных в связную таблицу МногиеИСПДнСпецПД SqlDataSource sdsspecPD = new SqlDataSource(); sdsspecPD.ConnectionString = conn; sdsspecPD.DeleteCommand = "DELETE FROM MnogieKategoriSpecOtdel WHERE (OtdelOrgID = @ParamOtdelID)"; sdsspecPD.DeleteParameters.Add(new Parameter("ParamOtdelID", TypeCode.Int32, DetailsViewOtdel.Rows[0].Cells[1].Text)); sdsspecPD.Delete(); sdsspecPD.InsertCommand = "INSERT INTO MnogieKategoriSpecOtdel(OtdelOrgID, KategoryPdSpecID) VALUES (@ParamOtdelID, @ParamPdID)"; sdsspecPD.InsertParameters.Add(new Parameter("ParamOtdelID", TypeCode.Int32)); sdsspecPD.InsertParameters.Add(new Parameter("ParamPdID", TypeCode.Int32)); for (int i = 0; i < CheckBoxListOtdelSpecPD.Items.Count; i++) { if (CheckBoxListOtdelSpecPD.Items[i].Selected == true) { sdsspecPD.InsertParameters["ParamOtdelID"].DefaultValue = DetailsViewOtdel.Rows[0].Cells[1].Text; sdsspecPD.InsertParameters["ParamPdID"].DefaultValue = (i + 1).ToString(); sdsspecPD.Insert(); } } sdsspecPD.Dispose(); }
protected void SubscribeButton_Click(object sender, EventArgs e) { SqlDataSource SqlData1 = new SqlDataSource(); SqlData1.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ToString(); SqlData1.InsertCommand = "INSERT INTO [Subscriber] ([subscriber_email]) VALUES (@subscriber_email)"; SqlData1.InsertParameters.Add("subscriber_email", newsletter_email_ip.Text.Trim().ToString()); SqlData1.Insert(); SqlData1.Dispose(); Response.Redirect("subscribe.aspx"); }
protected void Button1_Click(object sender, EventArgs e) { SqlDataSource SqlDataSource2 = new SqlDataSource(); SqlDataSource2.ConnectionString=WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; try { //update //SqlDataSource2.UpdateParameters.Add("Order_date", TextBox1.Text); //SqlDataSource2.UpdateParameters.Add("Assign_numbers", TextBox2.Text); //SqlDataSource2.UpdateParameters.Add("Account_numbers", DropDownList1.Text); //SqlDataSource2.UpdateParameters.Add("Account_abstract", TextBox3.Text); //SqlDataSource2.UpdateParameters.Add("Income", TextBox4.Text); //SqlDataSource2.UpdateParameters.Add("Spend", TextBox5.Text); //SqlDataSource2.UpdateCommand = "Update [Joural_Order_M] set Order_date=@Order_date, Assign_numbers=@Assign_numbers, Account_numbers=@Account_numbers, Account_abstract=@Account_abstract, Income=@Income, Spend=@Spend where Id=" + Request["Id"]; //update SqlDataSource2.DeleteCommand = "delete [Account_Order_M] where Id=" + Request["Id"]; //delete table Joural_Order_M content //SqlDataSource2.DeleteParameters.Add("Order_date", Label1.Text); //SqlDataSource2.DeleteParameters.Add("Assign_numbers", Label2.Text); //SqlDataSource2.DeleteParameters.Add("Account_numbers", Label3.Text); //SqlDataSource2.DeleteParameters.Add("Account_abstract", TextBox3.Text); //SqlDataSource2.DeleteParameters.Add("Income", TextBox4.Text); //SqlDataSource2.DeleteParameters.Add("Spend", TextBox5.Text); //delete table Joural_Order_M content int affraw = SqlDataSource2.Delete(); if (affraw == 0) { Label1.Text = "Error"; } else { Label1.Text = "Delete OK"; Button1.Visible = false; } } catch (Exception ex2) { Response.Write("error" + ex2.ToString()); } finally { SqlDataSource2.Dispose(); } }
protected void Page_Init(object sender, EventArgs e) { if (Session["AId"] == null) { Response.Redirect("~/default.aspx"); } pro_id = Request.QueryString.Get("pid").ToString(); if (pro_id == String.Empty) { Response.Redirect("products.aspx"); } SqlDataSource SqlDataSource1 = new SqlDataSource(); SqlDataSource1.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlDataSource1.SelectCommand = @"SELECT [product_id], [product_name], [product_desc], [product_price], [product_stock], [product_cdate], [product_image1], [product_image2], [product_image3], [category_id] FROM [Product] WHERE [product_id] = @product_id"; SqlDataSource1.SelectParameters.Add("product_id", pro_id); DataSourceSelectArguments args = new DataSourceSelectArguments(); DataView dv = SqlDataSource1.Select(args) as DataView; string cat_id = dv.Table.Rows[0][9].ToString(); txtProductName.Text = dv.Table.Rows[0][1].ToString(); txtProductDesc.Text = dv.Table.Rows[0][2].ToString(); txtProductPrice.Text = dv.Table.Rows[0][3].ToString(); txtProductQty.Text = dv.Table.Rows[0][4].ToString(); dv.Dispose(); SqlDataSource1.SelectCommand = @"SELECT [category_id],[category_name] FROM Category"; //SqlDataSource1.SelectParameters.Add("cat_id", cat_id); ProductPageList.DataSource = SqlDataSource1; ProductPageList.DataTextField = "category_name"; ProductPageList.DataValueField = "category_id"; ProductPageList.SelectedIndex = Convert.ToInt32(cat_id) - 1; ProductPageList.DataBind(); SqlDataSource1.Dispose(); }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { string cart_id = GridView1.DataKeys[e.RowIndex].Value.ToString(); SqlDataSource SqlDataSource1 = new SqlDataSource(); SqlDataSource1.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlDataSource1.DeleteCommand = "DELETE FROM [Cart] WHERE [cart_id] = @cart_id AND [cart_transid] = @cart_transid "; SqlDataSource1.DeleteParameters.Add("cart_id", cart_id); SqlDataSource1.DeleteParameters.Add("cart_transid", Session["Tid"].ToString()); SqlDataSource1.Delete(); SqlDataSource1.Dispose(); GridView1.EditIndex = -1; BindGrid(); GetTotalPayment(); }
protected void Page_Init(object sender, EventArgs e) { if (Session["AId"] == null) { Response.Redirect("~/default.aspx"); } SqlDataSource SqlDataSource1 = new SqlDataSource(); SqlDataSource1.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlDataSource1.SelectCommand = "SELECT [category_id], [category_name] FROM [Category]"; CategoryList.DataSource = SqlDataSource1; CategoryList.DataTextField = "category_name"; CategoryList.DataValueField = "category_id"; CategoryList.DataBind(); SqlDataSource1.Dispose(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["AId"] == null) { Response.Redirect("~/default.aspx"); } SqlDataSource SqlDataSource1 = new SqlDataSource(); SqlDataSource1.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlDataSource1.SelectCommand = "SELECT [cart_id], [product_id], [cart_quantity], [cart_product_name], [cart_productSubPrice], [cart_subTotal], [cart_cdate], [cart_transid], [cart_status], [user_id] FROM [Cart] WHERE [cart_status] = @cart_status"; SqlDataSource1.SelectParameters.Add("cart_status", "Pending"); GridView1.DataSource = SqlDataSource1; GridView1.DataBind(); SqlDataSource1.Dispose(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["AId"] == null) { Response.Redirect("~/admin/default.aspx"); } SqlDataSource SqlDataSource1 = new SqlDataSource(); SqlDataSource1.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlDataSource1.SelectCommand = "SELECT [category_id], [category_name] FROM [Category]"; SqlDataSource1.DataBind(); GridView1.DataSource = SqlDataSource1; GridView1.DataBind(); SqlDataSource1.Dispose(); }
protected void Page_Init(object sender, EventArgs e) { pro_id = Request.QueryString.Get("pid").ToString(); if (string.IsNullOrEmpty(pro_id)) { Response.Redirect("Default.aspx"); } SqlDataSource SqlDataSource1 = new SqlDataSource(); SqlDataSource1.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlDataSource1.SelectCommand = @"SELECT [product_id], [product_name], [product_desc], [product_price], [product_stock], [product_cdate], [product_image1], [product_image2], [product_image3], [category_id] FROM [Product] WHERE [product_id] = @product_id"; SqlDataSource1.SelectParameters.Add("product_id", pro_id); DataSourceSelectArguments args = new DataSourceSelectArguments(); DataView dv = SqlDataSource1.Select(args) as DataView; cat_id = dv.Table.Rows[0][9].ToString(); pid = Convert.ToInt32(pro_id); productName = dv.Table.Rows[0][1].ToString(); price_per_unit = dv.Table.Rows[0][3].ToString(); Image1.ImageUrl = dv.Table.Rows[0]["product_image1"].ToString(); Image2.ImageUrl = dv.Table.Rows[0]["product_image2"].ToString(); Image3.ImageUrl = dv.Table.Rows[0]["product_image3"].ToString(); Image4.ImageUrl = dv.Table.Rows[0]["product_image1"].ToString(); Image5.ImageUrl = dv.Table.Rows[0]["product_image2"].ToString(); Image6.ImageUrl = dv.Table.Rows[0]["product_image3"].ToString(); product_nameLabel.Text = dv.Table.Rows[0]["product_name"].ToString(); product_priceLabel.Text = dv.Table.Rows[0]["product_price"].ToString(); product_descLabel.Text = dv.Table.Rows[0]["product_desc"].ToString(); dv.Dispose(); productQ.Text = "1"; SqlDataSource1.Dispose(); }
protected void Button1_Click(object sender, EventArgs e) { SqlDataSource sqldatasource2 = new SqlDataSource(); sqldatasource2.ConnectionString = WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString.ToString(); sqldatasource2.UpdateParameters.Add("Lottery", DropDownList1.Text); sqldatasource2.UpdateCommand = "Update [Account_Order_M] set Lottery=@Lottery where Id=" + Request["Id"]; int affraw_update = sqldatasource2.Update(); if (affraw_update == 0) { Label8.Text = "error"; } else { Label8.Text = "ok"; Button1.Visible = false; } sqldatasource2.Dispose(); }
protected void Button1_Click(object sender, EventArgs e) { SqlDataSource SqlDataSource1 = new SqlDataSource(); SqlDataSource1.ConnectionString = WebConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; SqlDataSource1.InsertParameters.Add("Order_date", TextBox1.Text); SqlDataSource1.InsertParameters.Add("Assign_numbers", TextBox2.Text); SqlDataSource1.InsertParameters.Add("Account_numbers", DropDownList1.Text); SqlDataSource1.InsertParameters.Add("Account_abstract", TextBox3.Text); SqlDataSource1.InsertParameters.Add("Income", TextBox4.Text); SqlDataSource1.InsertParameters.Add("Spend", TextBox5.Text); SqlDataSource1.InsertCommand = "Insert into Account_Order_M(Order_date,Assign_numbers,Account_numbers,Account_abstract,Income,Spend) values(@Order_date,@Assign_numbers,@Account_numbers,@Account_abstract,@Income,@Spend)"; int affraw = SqlDataSource1.Insert(); if (affraw == 0) { Label1.Text = "Error"; } else { Label1.Text = "OK"; Button1.Visible = false; } SqlDataSource1.Dispose(); }