先搞个读写类,还要添加MySQL.data应用
再创建一个web窗体
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title></title>
<style type="text/css">
.auto-style1 {
height: 24px;
}
</style>
</head>
<body>
<form id="form2" runat="server">
<div>
<table style="width: 100%;">
<tr>
<td>
<table style="width:100%;">
<tr>
<td colspan="4" class="auto-style1">
input
</td>
</tr>
<tr>
<td>
Id</td>
<td>
<asp:TextBox ID="Id" runat="server"></asp:TextBox>
</td>
<td>
产品编号</td>
<td>
<asp:TextBox ID="产品编号" runat="server"></asp:TextBox>
</td>
<td>
产品名称</td>
<td>
<asp:DropDownList ID="产品名称" runat="server" Height="19px" Width="127px" AutoPostBack="True" OnSelectedIndexChanged="产品名称_SelectedIndexChanged">
<asp:ListItem>电脑</asp:ListItem>
<asp:ListItem>手机</asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<td>
入库人</td>
<td>
<asp:TextBox ID="入库人" runat="server"></asp:TextBox>
</td>
<td>
入库数量</td>
<td>
<asp:TextBox ID="入库数量" runat="server"></asp:TextBox>
<asp:TextBox ID="原来的值" runat="server" Visible="False" Width="44px"></asp:TextBox>
</td>
</tr>
<tr>
<td>
产品规格</td>
<td>
<asp:TextBox ID="产品规格" runat="server"></asp:TextBox>
</td>
<td>
入库时间</td>
<td>
<asp:TextBox ID="入库时间" runat="server"></asp:TextBox>
</td>
<td>
库存数量
</td>
<td>
<asp:TextBox ID="库存数量" runat="server"></asp:TextBox>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table style="width:100%;">
<tr>
<td>
<asp:Button ID="Button_read" runat="server" Text="read" OnClick="Button_read_Click" />
</td>
<td>
<asp:Button ID="Button_write" runat="server" Text="write" OnClick="Button_write_Click" />
</td>
<td>
<asp:Button ID="Button_modify" runat="server" Text="modify" OnClick="Button_modify_Click" />
</td>
<td>
<asp:Button ID="Button_delete" runat="server" Text="delete" OnClick="Button_delete_Click" />
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<asp:GridView ID="GridView1" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None" Width="100%" OnRowCommand="GridView1_RowCommand">
<AlternatingRowStyle BackColor="White" />
<Columns>
<asp:ButtonField CommandName="select" HeaderText="选择" Text="按钮" />
</Columns>
<EditRowStyle BackColor="#7C6F57" />
<FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="#E3EAEB" HorizontalAlign="Center" />
<SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
<SortedAscendingCellStyle BackColor="#F8FAFA" />
<SortedAscendingHeaderStyle BackColor="#246B61" />
<SortedDescendingCellStyle BackColor="#D4DFE1" />
<SortedDescendingHeaderStyle BackColor="#15524A" />
</asp:GridView>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
读取数据库
string strsql = "select * from input";//读取数据的SQL语句
GridView1.DataSource = me.getTable(strsql);//调用读数据的函数进行读,并把读取的表返回,并绑定到数据控件上。
GridView1.DataBind();
添加入库信息
string strsql = "insert into input(产品名称,产品编号,入库数量,入库时间,入库人,产品规格) values('" + 产品名称.Text + "'";
strsql = strsql + ",'" + 产品编号.Text + "'";
strsql = strsql + ",'" + 入库数量.Text + "'";
strsql = strsql + ",'" + 入库时间.Text + "'";
strsql = strsql + ",'" + 入库人.Text + "'";
strsql = strsql + ",'" + 产品规格.Text + "'";
strsql = strsql + ")";
me.execSql(strsql);
strsql = "update product set 库存数量=库存数量+" + 入库数量.Text + " where 产品名称='" + 产品名称.Text + "'";
me.execSql(strsql);
Button_read_Click(sender, e);
更新信息
string strsql = "update input set Id='" + Id.Text + "'";
strsql = strsql + ",产品编号='" + 产品编号.Text + "'";
strsql = strsql + ",产品名称='" + 产品名称.Text + "'";
strsql = strsql + ",入库数量='" + 入库数量.Text + "'";
strsql = strsql + ",入库人='" + 入库人.Text + "'";
strsql = strsql + ",入库时间='" + 入库时间.Text + "'";
strsql = strsql + ",产品规格='" + 产品规格.Text + "'";
strsql = strsql + " where Id='" + Id.Text + "'";
me.execSql(strsql);
strsql = "update product set 库存数量=库存数量+" + 入库数量.Text + "-" + 原来的值.Text + " where 产品名称='" + 产品名称.Text + "'";
me.execSql(strsql);
Button_read_Click(sender, e);
删除信息
string strsql = "update product set 库存数量=库存数量-" + 入库数量.Text + " where 产品名称='" + 产品名称.Text + "'";
me.execSql(strsql);
string strsql2 = "delete from input where Id ='" + Id.Text + "'";
me.execSql(strsql2);
Button_read_Click(sender, e);
自定义按钮引发的事件
int index = Convert.ToInt32(e.CommandArgument);
if (e.CommandName == "select")
{
GridViewRow row = GridView1.Rows[index];
产品名称.Text = row.Cells[2].Text;
产品编号.Text = row.Cells[3].Text;
入库数量.Text = row.Cells[4].Text;
入库人.Text = row.Cells[6].Text;
入库时间.Text = row.Cells[5].Text;
产品规格.Text = row.Cells[7].Text;
Id.Text = row.Cells[1].Text;
}
原来的值.Text = 入库数量.Text;
出库类似上面的