执行一条计算查询结果语句，返回查询结果代码,CSharp代码库,德仔网

代码语言
代码分类
【CSharp】执行一条计算查询结果语句，返回查询结果
作者:Dezai.CN / 发布于2011/7/8/ 426
<div>
/// <summary></div>
<div></div>
<div></div>
<div> /// 执行一条计算查询结果语句，返回查询结果（object）。</div>
<div></div>
<div></div>
<div> /// </summary></div>
<div></div>
<div></div>
<div> /// <param name="SQLString">计算查询结果语句</param></div>
<div></div>
<div></div>
<div> /// <returns>查询结果（object）</returns></div>
<div></div>
<div></div>
<div> public static object GetSingle(string SQLString)</div>
<div></div>
<div></div>
<div> {</div>
<div></div>
<div></div>
<div> using (SqlConnection connection = new SqlConnection(connectionString))</div>
<div></div>
<div></div>
<div> {</div>
<div></div>
<div></div>
<div> using (SqlCommand cmd = new SqlCommand(SQLString, connection))</div>
<div></div>
<div></div>
<div> {</div>
<div></div>
<div></div>
<div> try</div>
<div></div>
<div></div>
<div> {</div>
<div></div>
<div></div>
<div> connection.Open();</div>
<div></div>
<div></div>
<div> object obj = cmd.ExecuteScalar();</div>
<div></div>
<div></div>
<div> if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))</div>
<div></div>
<div></div>
<div> {</div>
<div></div>
<div></div>
<div> return null;</div>
<div></div>
<div></div>
<div> }
<div></div>
<div></div>
<div> else</div>
<div></div>
<div></div>
<div> {</div>
<div></div>
<div></div>
<div> return obj;</div>
<div></div>
<div></div>
<div> }
<div></div>
<div></div>
<div> }
<div></div>
<div></div>
<div> catch (System.Data.SqlClient.SqlException e)</div>
<div></div>
<div></div>
<div> {</div>
<div></div>
<div></div>
<div> connection.Close();</div>
<div></div>
<div></div>
<div> throw e;</div>
<div></div>
<div></div>
<div> }
<div></div>
<div></div>
<div> }
<div></div>
<div></div>
<div> }
<div></div>
<div></div>
<div> }
<div></div>
<div></div>
<div> public static object GetSingle(string SQLString, int Times)</div>
<div></div>
<div></div>
<div> {</div>
<div></div>
<div></div>
<div> using (SqlConnection connection = new SqlConnection(connectionString))</div>
<div></div>
<div></div>
<div> {</div>
<div></div>
<div></div>
<div> using (SqlCommand cmd = new SqlCommand(SQLString, connection))</div>
<div></div>
<div></div>
<div> {</div>
<div></div>
<div></div>
<div> try</div>
<div></div>
<div></div>
<div> {</div>
<div></div>
<div></div>
<div> connection.Open();</div>
<div></div>
<div></div>
<div> cmd.CommandTimeout = Times;</div>
<div></div>
<div></div>
<div> object obj = cmd.ExecuteScalar();</div>
<div></div>
<div></div>
<div> if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))</div>
<div></div>
<div></div>
<div> {</div>
<div></div>
<div></div>
<div> return null;</div>
<div></div>
<div></div>
<div> }
<div></div>
<div></div>
<div> else</div>
<div></div>
<div></div>
<div> {</div>
<div></div>
<div></div>
<div> return obj;</div>
<div></div>
<div></div>
<div> }
<div></div>
<div></div>
<div> }
<div></div>
<div></div>
<div> catch (System.Data.SqlClient.SqlException e)</div>
<div></div>
<div></div>
<div> {</div>
<div></div>
<div></div>
<div> connection.Close();</div>
<div></div>
<div></div>
<div> throw e;</div>
<div></div>
<div></div>
<div> }
<div></div>
<div></div>
<div> }
<div></div>
<div></div>
<div> }
<div></div>
<div></div>
<div> }
</div>
试试其它关键字
同语言下
可能有用的
Dezai.CN贡献的其它代码(4037)