SqlCommand之select、update

来源：互联网发布：分销平台系统源码编辑：程序博客网时间：2024/06/11 06:31

前台代码：

<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();        }    }}

0 0