?? altergoods.ascx.cs
字號:
?using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class control_altergoods : System.Web.UI.UserControl
{
protected void Page_Load(object sender, EventArgs e)
{
// if (Convert.ToString(Session["username"]) == "")
//{
// Response.Write("<script language=javascript>alert('請登錄');location='../login.aspx'</script>");
// return;
//}
if (!IsPostBack)
{
this.bindtogridview();
//SqlConnection strcon = DB.createConnection();
//strcon.Open();
//SqlCommand cmd = new SqlCommand("select * from client ", strcon);
//SqlDataReader sdr = cmd.ExecuteReader();
//this.ddlgoodclient.DataSource = sdr;
//this.ddlgoodclient.DataValueField = "客戶編號";
//this.ddlgoodclient.DataTextField = "客戶名稱";
//this.ddlgoodclient.DataBind();
}
}
//protected void Button1_Click(object sender, EventArgs e)
//{
// //string txtgoodsnum = this.txtgoodsnum .Text.ToString();
// string txtgoodsname = this.txtgoodsname.Text.ToString();
// string txtgoodsunit = this.txtgoodsunit.Text.ToString();
// string txtgoodsspecs = this.txtgoodsspecs.Text.ToString();
// string txtgoodsprice = this.txtgoodsprice.Text.ToString();
// string txtgoodsnumber = this.txtgoodsnumber.Text.ToString();
// string ddlgoodclient = this.ddlgoodclient.Text.ToString();
// //string Remark = this.Remark.Text.ToString();
// //string Username = Convert.ToString(Session["username"]);
// //string AddTime = Convert.ToString(DateTime.Now);
// SqlConnection strcon = DB.createConnection();
// //new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["strcon"]);
// strcon.Open();
// SqlCommand scd = new SqlCommand("update stock set 商品名稱='" + txtgoodsname + "',單位='" + txtgoodsunit + "' ,規格型號='" + txtgoodsspecs + "',單價='" + txtgoodsprice + "',數量='" + txtgoodsnumber + "', 供貨商='" + ddlgoodclient + "'where 商品編號='"+txtgoodsnum+"'", strcon);
// scd.ExecuteNonQuery();
// strcon.Close();
// Response.Write("<script language=javascript>alert('您已經成功修改該商品!');location='altergoods.aspx'</script>");
//}
private void bindtogridview()
{
SqlConnection con = DB.createConnection();
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = new SqlCommand("select * from stock", con);
DataSet ds = new DataSet();
sda.Fill(ds, "stock");
this.GridView1.DataKeyNames = new string[] { "商品編號" };
this.GridView1.DataSource = ds.Tables["stock"];
this.GridView1.DataBind();
}
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -