sql.cs
using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace WindowsApplication1
{
class sql
{
private static SqlConnection conn = new SqlConnection("workstation id=localhost;Integrated Security=SSPI;database=test");
private static SqlCommand cmd = new SqlCommand();
private static SqlDataAdapter da = new SqlDataAdapter();
public static DataTable getdata(string cmdtext)
{
da.SelectCommand = cmd;
da.SelectCommand.Connection = conn;
da.SelectCommand.CommandText = cmdtext;
conn.Open();
da.SelectCommand.ExecuteNonQuery();
conn.Close();
DataSet ds = new DataSet();
da.Fill(ds);
return ds.Tables[0];
}
public static int exec(string cmdtext)
{
cmd.CommandText = cmdtext;
cmd.Connection = conn;
conn.Open();
int i = cmd.ExecuteNonQuery();
conn.Close();
return i;
}
}
}
SQL间断式连接
最新推荐文章于 2024-09-21 10:25:52 发布