前台代码:
<span style="font-size:14px;"><%@ Page Language="C#" AutoEventWireup="true" CodeFile="test2.aspx.cs" Inherits="ykw_test_test2" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:TextBox ID="Number_TB" runat="server"></asp:TextBox>
<asp:Button ID="Button2" runat="server" Text="查找" OnClick="Button2_Click" />
<asp:Button ID="Button1" runat="server" Text="提交" OnClick="Button1_Click" />
<br />
<asp:Label ID="Label1" runat="server" Text="Inum"></asp:Label>
</div>
</form>
</body>
</html>
</span>
<span style="font-size:14px;">
</span>
<span style="font-size:14px;">后台代码:</span>
<span style="font-size:14px;">
</span>
<span style="font-size:14px;"></span><pre name="code" class="csharp">using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
public partial class ykw_test_test2 : System.Web.UI.Page
{
//private SqlConnection connstr = new SqlConnection("Data Source=KW_PC;Initial Catalog=wlwzbgl;User ID=sa;Password=admin2014");
private String connStr = "Data Source=KW-PC;Initial Catalog=wlwzbgl;User ID=sa;Password=admin2014";
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
string SQL = "update t_dyz_test set sname=@sname where sid='1'";
SqlConnection conn = new SqlConnection(connStr);
SqlCommand cmd = new SqlCommand();
try
{
cmd.CommandText = SQL;
cmd.Connection = conn;
cmd.Parameters.Clear();
cmd.Parameters.Add("@sname", SqlDbType.VarChar).Value = Number_TB.Text.ToString();
conn.Open();
cmd.ExecuteNonQuery();
}
catch
{
this.ClientScript.RegisterStartupScript(this.GetType(), "messages", "<script>alert('更新异常!')</script>");
}
finally
{
conn.Close();
}
}
protected void Button2_Click(object sender, EventArgs e)
{
double amount = 0d;
string SQL = "select inum from t_dyz_test where sid=@sid";
SqlConnection conn = new SqlConnection(connStr);
SqlCommand cmd = new SqlCommand();
try
{
cmd.CommandText = SQL;
cmd.Connection = conn;
cmd.Parameters.Clear();
cmd.Parameters.Add("@sid", SqlDbType.VarChar).Value = Number_TB.Text.ToString();
conn.Open();
amount = Convert.ToDouble(cmd.ExecuteScalar());
Label1.Text = amount.ToString();
}
catch
{
this.ClientScript.RegisterStartupScript(this.GetType(), "messages", "<script>alert('查找异常!')</script>");
}
finally
{
conn.Close();
}
}
}