sqlserver數(shù)據(jù)庫鏈接1

using System;

創(chuàng)新互聯(lián)長期為1000+客戶提供的網(wǎng)站建設服務，團隊從業(yè)經(jīng)驗10年，關注不同地域、不同群體，并針對不同對象提供差異化的產品和服務；打造開放共贏平臺，與合作伙伴共同營造健康的互聯(lián)網(wǎng)生態(tài)環(huán)境。為臨川企業(yè)提供專業(yè)的網(wǎng)站設計制作、成都網(wǎng)站建設，臨川網(wǎng)站改版等技術服務。擁有10多年豐富建站經(jīng)驗和眾多成功案例,為您定制開發(fā)。

using System.Data;

using System.Xml;

using System.Data.SqlClient;

using System.Collections;

namespace DataBase.Data.SqlClient

{

public sealed class SqlHelper

{

#region private utility methods constructors

private SqlHelper() { }

private static void AttachParameters(SqlCommand command, SqlParameter[] commandParameters)

{

foreach (SqlParameter p in commandParameters)

{

if ((p.Direction == ParameterDirection.InputOutput) (p.Value == null))

{

p.Value = DBNull.Value;

}

command.Parameters.Add(p);

}

}

private static void AssignParameterValues(SqlParameter[] commandParameters, object[] parameterValues)

{

if ((commandParameters == null) || (parameterValues == null))

{

return;

}

if (commandParameters.Length != parameterValues.Length)

{

throw new ArgumentException("Parameter count does not match Parameter Value count.");

}

for (int i = 0, j = commandParameters.Length; i j; i++)

{

commandParameters[i].Value = parameterValues[i];

}

}

private static void PrepareCommand(SqlCommand command, SqlConnection connection, SqlTransaction transaction, CommandType commandType, string commandText, SqlParameter[] commandParameters)

{

if (connection.State != ConnectionState.Open)

{

connection.Open();

}

command.Connection = connection;

command.CommandText = commandText;

command.CommandTimeout = 20;

if (transaction != null)

{

command.Transaction = transaction;

}

command.CommandType = commandType;

if (commandParameters != null)

{

AttachParameters(command, commandParameters);

}

return;

}

#endregion private utility methods constructors

#region ExecuteNonQuery

public static int ExecuteNonQuery(string connectionString, CommandType commandType, string commandText)

{

return ExecuteNonQuery(connectionString, commandType, commandText, (SqlParameter[])null);

}

public static int ExecuteNonQuery(string connectionString, CommandType commandType, string commandText, params SqlParameter[] commandParameters)

{

using (SqlConnection cn = new SqlConnection(connectionString))

{

cn.Open();

return ExecuteNonQuery(cn, commandType, commandText, commandParameters);

}

}

public static int ExecuteNonQuery(string connectionString, string spName, params object[] parameterValues)

{

if ((parameterValues != null) (parameterValues.Length 0))

{

SqlParameter[] commandParameters = SqlHelperParameterCache.GetSpParameterSet(connectionString, spName);

AssignParameterValues(commandParameters, parameterValues);

return ExecuteNonQuery(connectionString, CommandType.StoredProcedure, spName, commandParameters);

}

else

{

return ExecuteNonQuery(connectionString, CommandType.StoredProcedure, spName);

}

}

public static int ExecuteNonQuery(SqlConnection connection, CommandType commandType, string commandText)

{

return ExecuteNonQuery(connection, commandType, commandText, (SqlParameter[])null);

}

public static int ExecuteNonQuery(SqlConnection connection, CommandType commandType, string commandText, params SqlParameter[] commandParameters)

{

SqlCommand cmd = new SqlCommand();

PrepareCommand(cmd, connection, (SqlTransaction)null, commandType, commandText, commandParameters);

int retval = cmd.ExecuteNonQuery();

cmd.Parameters.Clear();

return retval;

}

public static int ExecuteNonQuery(SqlConnection connection, string spName, params object[] parameterValues)

{

if ((parameterValues != null) (parameterValues.Length 0))

{

SqlParameter[] commandParameters = SqlHelperParameterCache.GetSpParameterSet(connection.ConnectionString, spName);

AssignParameterValues(commandParameters, parameterValues);

return ExecuteNonQuery(connection, CommandType.StoredProcedure, spName, commandParameters);

}

else

{

return ExecuteNonQuery(connection, CommandType.StoredProcedure, spName);

}

}

public static int ExecuteNonQuery(SqlTransaction transaction, CommandType commandType, string commandText)

{

return ExecuteNonQuery(transaction, commandType, commandText, (SqlParameter[])null);

}

public static int ExecuteNonQuery(SqlTransaction transaction, CommandType commandType, string commandText, params SqlParameter[] commandParameters)

{

SqlCommand cmd = new SqlCommand();

PrepareCommand(cmd, transaction.Connection, transaction, commandType, commandText, commandParameters);

int retval = cmd.ExecuteNonQuery();

cmd.Parameters.Clear();

return retval;

}

public static int ExecuteNonQuery(SqlTransaction transaction, string spName, params object[] parameterValues)

{

if ((parameterValues != null) (parameterValues.Length 0))

{

SqlParameter[] commandParameters = SqlHelperParameterCache.GetSpParameterSet(transaction.Connection.ConnectionString, spName);

AssignParameterValues(commandParameters, parameterValues);

return ExecuteNonQuery(transaction, CommandType.StoredProcedure, spName, commandParameters);

}

else

{

return ExecuteNonQuery(transaction, CommandType.StoredProcedure, spName);

}

}

#endregion ExecuteNonQuery

#region ExecuteDataSet

public static DataSet ExecuteDataset(string connectionString, CommandType commandType, string commandText)

{

return ExecuteDataset(connectionString, commandType, commandText, (SqlParameter[])null);

}

public static DataSet ExecuteDataset(string connectionString, CommandType commandType, string commandText, params SqlParameter[] commandParameters)

{

using (SqlConnection cn = new SqlConnection(connectionString))

{

cn.Open();

return ExecuteDataset(cn, commandType, commandText, commandParameters);

}

}

public static DataSet ExecuteDataset(string connectionString, string spName, params object[] parameterValues)

{

if ((parameterValues != null) (parameterValues.Length 0))

{

SqlParameter[] commandParameters = SqlHelperParameterCache.GetSpParameterSet(connectionString, spName);

AssignParameterValues(commandParameters, parameterValues);

return ExecuteDataset(connectionString, CommandType.StoredProcedure, spName, commandParameters);

}

else

{

return ExecuteDataset(connectionString, CommandType.StoredProcedure, spName);

}

}

public static DataSet ExecuteDataset(SqlConnection connection, CommandType commandType, string commandText)

{

return ExecuteDataset(connection, commandType, commandText, (SqlParameter[])null);

}

public static DataSet ExecuteDataset(SqlConnection connection, CommandType commandType, string commandText, params SqlParameter[] commandParameters)

{

SqlCommand cmd = new SqlCommand();

PrepareCommand(cmd, connection, (SqlTransaction)null, commandType, commandText, commandParameters);

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

da.Fill(ds);

cmd.Parameters.Clear();

return ds;

}

public static DataSet ExecuteDataset(SqlConnection connection, string spName, params object[] parameterValues)

{

if ((parameterValues != null) (parameterValues.Length 0))

{

SqlParameter[] commandParameters = SqlHelperParameterCache.GetSpParameterSet(connection.ConnectionString, spName);

AssignParameterValues(commandParameters, parameterValues);

return ExecuteDataset(connection, CommandType.StoredProcedure, spName, commandParameters);

}

else

{

return ExecuteDataset(connection, CommandType.StoredProcedure, spName);

}

}

public static DataSet ExecuteDataset(SqlTransaction transaction, CommandType commandType, string commandText)

{

return ExecuteDataset(transaction, commandType, commandText, (SqlParameter[])null);

}

public static DataSet ExecuteDataset(SqlTransaction transaction, CommandType commandType, string commandText, params SqlParameter[] commandParameters)

{

SqlCommand cmd = new SqlCommand();

PrepareCommand(cmd, transaction.Connection, transaction, commandType, commandText, commandParameters);

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

da.Fill(ds);

cmd.Parameters.Clear();

return ds;

}

public static DataSet ExecuteDataset(SqlTransaction transaction, string spName, params object[] parameterValues)

{

if ((parameterValues != null) (parameterValues.Length 0))

{

SqlParameter[] commandParameters = SqlHelperParameterCache.GetSpParameterSet(transaction.Connection.ConnectionString, spName);

AssignParameterValues(commandParameters, parameterValues);

return ExecuteDataset(transaction, CommandType.StoredProcedure, spName, commandParameters);

}

else

{

return ExecuteDataset(transaction, CommandType.StoredProcedure, spName);

}

}

#endregion ExecuteDataSet

#region ExecuteDatatable

public static DataTable ExecuteDatatable(string connectionString, CommandType commandType, string commandText)

{

return ExecuteDatatable(connectionString, commandType, commandText, (SqlParameter[])null);

}

public static DataTable ExecuteDatatable(string connectionString, CommandType commandType, string commandText, params SqlParameter[] commandParameters)

{

using (SqlConnection cn = new SqlConnection(connectionString))

{

cn.Open();

return ExecuteDatatable(cn, commandType, commandText, commandParameters);

}

}

public static DataTable ExecuteDatatable(string connectionString, string spName, params object[] parameterValues)

{

if ((parameterValues != null) (parameterValues.Length 0))

{

SqlParameter[] commandParameters = SqlHelperParameterCache.GetSpParameterSet(connectionString, spName);

AssignParameterValues(commandParameters, parameterValues);

return ExecuteDatatable(connectionString, CommandType.StoredProcedure, spName, commandParameters);

}

else

{

return ExecuteDatatable(connectionString, CommandType.StoredProcedure, spName);

}

}

public static DataTable ExecuteDatatable(SqlConnection connection, CommandType commandType, string commandText)

{

return ExecuteDatatable(connection, commandType, commandText, (SqlParameter[])null);

}

public static DataTable ExecuteDatatable(SqlConnection connection, CommandType commandType, string commandText, params SqlParameter[] commandParameters)

{

SqlCommand cmd = new SqlCommand();

PrepareCommand(cmd, connection, (SqlTransaction)null, commandType, commandText, commandParameters);

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataTable dt = new DataTable();

da.Fill(dt);

cmd.Parameters.Clear();

return dt;

}

public static DataTable ExecuteDatatable(SqlConnection connection, string spName, params object[] parameterValues)

{

if ((parameterValues != null) (parameterValues.Length 0))

{

SqlParameter[] commandParameters = SqlHelperParameterCache.GetSpParameterSet(connection.ConnectionString, spName);

AssignParameterValues(commandParameters, parameterValues);

return ExecuteDatatable(connection, CommandType.StoredProcedure, spName, commandParameters);

}

else

{

return ExecuteDatatable(connection, CommandType.StoredProcedure, spName);

}

}

public static DataTable ExecuteDatatable(SqlTransaction transaction, CommandType commandType, string commandText)

{

return ExecuteDatatable(transaction, commandType, commandText, (SqlParameter[])null);

}

public static DataTable ExecuteDatatable(SqlTransaction transaction, CommandType commandType, string commandText, params SqlParameter[] commandParameters)

{

SqlCommand cmd = new SqlCommand();

PrepareCommand(cmd, transaction.Connection, transaction, commandType, commandText, commandParameters);

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataTable dt = new DataTable();

da.Fill(dt);

cmd.Parameters.Clear();

return dt;

}

public static DataTable ExecuteDatatable(SqlTransaction transaction, string spName, params object[] parameterValues)

{

if ((parameterValues != null) (parameterValues.Length 0))

{

SqlParameter[] commandParameters = SqlHelperParameterCache.GetSpParameterSet(transaction.Connection.ConnectionString, spName);

AssignParameterValues(commandParameters, parameterValues);

return ExecuteDatatable(transaction, CommandType.StoredProcedure, spName, commandParameters);

}

else

{

return ExecuteDatatable(transaction, CommandType.StoredProcedure, spName);

}

}

sqlserver一對一關系怎么建立

你好， 非常高興為你解答

現(xiàn)在你建了兩個表主鍵都是xuehao， 也就是說學好是1001的在這兩個表里都只能存在一條

這就是一對一的關系， 不用再有什么約束，不知道你還想要什么結果， 如果有能舉個例子嗎

《SQLServer》1. 怎樣結束事物?

事務分顯示事務和隱式事務,

隱式事務 在SQLServer 語句執(zhí)行完成就自動結束；

顯示事務語法：

BEGIN TRAN/TRANSACTION

--這里寫事務內容

callback TRAN/TRANSACTION --回滾事務

commit TRAN/TRANSACTION --提交事務

callback 和commit 都是結束事務的語句，不通之處在于，callback是回滾使用，即事務中所有執(zhí)行語句都無效化(在事務中某處有錯誤時使用)； commit 是提交事務，即完成所有事務內容。