请参阅.net企业级范例duwamish的相关代码,duwamish的安装程序在.net安装目录下可以找到
解决方案 »
- 如何去除所有符号?
- 很傻很天真的问题!!!
- 请教c#调用C++类库中的函数问题。
- devexpress的VGridControl控件中EditValueChanged事件的获取被包装的RepositoryItem
- axwebbrowser里有_Navigated事件吗
- 我在sql server中改了列的數據類型,為什麼在我的form表單的dataGridView中還是沒有改變
- 如何為ListView排序時設定Colunn的索引?
- 请问如何设定精度(小数点后面的位数)?
- 无刷新技术.......................................?
- RIBBON 菜单如何实现MDI窗口的菜单合并功能
- 请问一组radioButton怎样与一个值实现绑定?
- 请问一个关于将word文档或者图片存入数据库是否还能导出成文件的问题
Dim oraDataAdapter As OracleDataAdapter
Dim oraComm As OracleCommand
Dim ret As Integer
Try
ret = 0
oraComm = oraConn.CreateCommand()
oraComm.CommandText = strSql
If Not oraTrans Is Nothing Then
oraComm.Transaction = oraTrans
End If
oraDataAdapter = New OracleDataAdapter(oraComm)
oraDataTable = New DataTable
oraDataAdapter.Fill(oraDataTable)
If oraDataTable.Rows.Count <= 0 Then
ret = -9
End If
oraDataAdapter.Dispose()
Catch ex As Exception
m_OraException = ex
ret = -1
End Try
Return ret
End Function
class DbOperator
{
private SqlConnection conn_;
private SqlCommand sqlCommand_;
private SqlDataReader reader_;
public DbOperator(string ConnStr)
{
conn_ = new SqlConnection(ConnStr);
conn_.Open();
sqlCommand_ = conn_.CreateCommand();
}
public SqlDataReader execQueryReader(string sql)
{
sqlCommand_.CommandText = sql;
try
{
reader_ = sqlCommand_.ExecuteReader();
}
catch(SqlException D)
{
StreamWriter file = new StreamWriter(Perty["ErrorFile"].ToString(),true);
file.WriteLine(D.Message.ToString());
file.Flush();
file.Close();
}
return reader_;
}
public void execNoQuery(string sql)
{
sqlCommand_.CommandText = sql;
try
{
sqlCommand_.ExecuteNonQuery();
}
catch(SqlException D)
{
StreamWriter file = new StreamWriter(Perty["ErrorFile"].ToString(),true);
file.WriteLine(D.Message.ToString());
file.Flush();
file.Close();
}
}
public void closeReader()
{
if (reader_ != null)
{
reader_.Close();
}
}
public void dbclose()
{
conn_.Close();
}
}调用方式
DbOperator db = new DbOperator(ConnStr);db.execNoQuery("sql语句");//不需要返回结果的操作SqlDataReader reader = db.execQueryReader("sql语句");//需要返回结果的操作