您好,登錄后才能下訂單哦!
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Text;
- using System.Configuration;
- using System.Data;
- using System.Data.SqlClient;
- namespace 數(shù)據(jù)綁定
- {
- class SqlHelper
- {
- private static string strconn= ConfigurationManager.ConnectionStrings["dbstrConn"].ConnectionString;
- public static int ExecuteNonQuery(string sql)
- {
- using (SqlConnection conn = new SqlConnection(strconn))
- {
- conn.Open();
- using (SqlCommand cmd = conn.CreateCommand())
- {
- cmd.CommandText = sql;
- return cmd.ExecuteNonQuery();
- }
- }
- }
- public static object ExecuteScalar(string sql)
- {
- using (SqlConnection conn = new SqlConnection(strconn))
- {
- conn.Open();
- using (SqlCommand cmd = conn.CreateCommand())
- {
- cmd.CommandText = sql;
- return cmd.ExecuteScalar();
- }
- }
- }
- //查詢少量數(shù)據(jù)
- public static DataTable ExecuteTable(string sql)
- {
- using (SqlConnection conn = new SqlConnection(strconn))
- {
- conn.Open();
- using (SqlCommand cmd = conn.CreateCommand())
- {
- cmd.CommandText = sql;
- SqlDataAdapter adapter = new SqlDataAdapter(cmd);
- DataSet dataset = new DataSet();
- adapter.Fill(dataset);
- return dataset.Tables[0];
- }
- }
- }
- }
- }
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點不代表本網(wǎng)站立場,如果涉及侵權(quán)請聯(lián)系站長郵箱:is@yisu.com進(jìn)行舉報,并提供相關(guān)證據(jù),一經(jīng)查實,將立刻刪除涉嫌侵權(quán)內(nèi)容。