sqldata.cs

C#环境下

using System;
using System.Data;
using System.Configuration;
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;

/// <summary>
/// sqlData 的摘要说明
/// </summary>
public class SqlData
{
    string connsql1 = System.Configuration.ConfigurationManager.AppSettings["connstring"];
    SqlConnection conn=new SqlConnection();
    public SqlData()
	{
		//
		// TODO: 在此处添加构造函数逻辑
		//
	}
    public string ReturnOnesValue(string strsql,string selectedstr)  //适用于select出一条记录的SQL语句,返回一个数
    {
        string ReturnValue="";
        conn = new SqlConnection();
        conn.ConnectionString = "Data Source=SZMT-37;Initial Catalog=shiyong;Persist Security Info=True;User ID=sa;Password=123456";
        conn.Open();
        SqlCommand cmd = new SqlCommand(strsql, conn);
        SqlDataReader sqlreader = cmd.ExecuteReader();
        while (sqlreader.Read())
        {
            ReturnValue = sqlreader[selectedstr].ToString() ;
        }
        conn.Close();
        return ReturnValue;
    }
    public string InsertValue(string strsqlTQ)  //适用于insert一条记录
    {
        conn = new SqlConnection(connsql1);
        conn.ConnectionString = "Data Source=SZMT-37;Initial Catalog=shiyong;Persist Security Info=True;User ID=sa;Password=123456";
        conn.Open();
        SqlCommand sqlcmd1 = new SqlCommand(strsqlTQ, conn);
        int iResult = sqlcmd1.ExecuteNonQuery();
        conn.Close();
        return strsqlTQ;
    }
    public string UpdateValue(string strsqlUp)  //适用于update一条记录
    {
        conn = new SqlConnection(connsql1);
        conn.ConnectionString = "Data Source=SZMT-37;Initial Catalog=shiyong;Persist Security Info=True;User ID=sa;Password=123456";
        conn.Open();
        SqlCommand sqlcmd2 = new SqlCommand(strsqlUp, conn);
        int iResult = sqlcmd2.ExecuteNonQuery();
        conn.Close();            
        return strsqlUp;
    }
}