dataop.cs

来自「一个土地管理系统」· CS 代码 · 共 59 行

using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
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;
/// <summary>
/// Summary description for DataOp
/// </summary>
public class DataOp
{
	public DataOp()
	{
		//
		// TODO: Add constructor logic here
		//
	}
    public static string getConnStr()
    {
        return System.Configuration.ConfigurationManager.ConnectionStrings["LocalSqlServer"].ToString();
    }
    public static SqlConnection getConn()
    {
        SqlConnection conn = new SqlConnection(getConnStr());
        return conn;
    }
    public static void updateData(string [] sql)
    {
        foreach (string s in sql)
        {
            updateData(s);
        }
    }
    public static void updateData(string sql)
    {
        SqlConnection conn = getConn();
        SqlCommand cmd = new SqlCommand();
        cmd.CommandText = sql;
        cmd.Connection = conn;
        conn.Open();
        cmd.ExecuteNonQuery();
        conn.Close();
    }
    public static DataTable getData(string sql)
    {
        DataTable table = new DataTable();
        SqlConnection conn = getConn();
        SqlDataAdapter adp = new SqlDataAdapter(sql,conn);
        adp.Fill(table);
        return table;
    }
}