命名空间相同和不相同的做法分别是怎样?
解决方案 »
- WinForm的结构出现问题
- 高分求助:后台创建html控件组问题
- dataGridView选中一行为起点,另外在选中一行为终点,怎么获取起点到终点的所有数据 ?(winform))
- 关于在对象间交换数据的问题
- LISTVIEW.ColumnClick.排序300分给分绪贴2
- 初学C#,关于菜单绘制的问题。在线……
- bitmap的颜色画的太差。
- 帮我看看这段代码为什么不能在鼠标按下处加载指定的位图?
- 怎样截取字符串(像ASP的RIGHT函数一样)
- 请问如何利用反射的PropertyInfo.GetVaule()和SetValue()方法对数组型的属性进行操作?
- 请教dataGrid问题??
- 有人做过俄罗斯人机对战吗??有问题请教!!!
<appSettings>
<add key="SQL_CONNECT" value="server=;uid=;pwd=;database=abc"/>
</appSettings>然后自建一个类Imports System.Data
Imports System.Data.SqlClient
Imports System.Configuration.ConfigurationSettings
Namespace Flow_Foun Public Class Db_Handle '// Execute Sql Command
Public SqlConn As SqlConnection
Function DbOpen() As Boolean
Dim chaDbConnStr As String = AppSettings("SQL_CONNECT")
SqlConn = New SqlConnection(chaDbConnStr)
Try
SqlConn.Open()
Catch ex As Exception
Return False
End Try
End Function Function DbClose() As Boolean
Try
SqlConn.Close()
SqlConn = Nothing
Catch ex As Exception
Return False
End Try
End Function Function DbExecuteCmd(ByVal I_chaSql As String)
On Error Resume Next
Dim chaSql As String = I_chaSql
Dim SqlCmd As New SqlCommand(chaSql, SqlConn)
SqlCmd.ExecuteNonQuery()
SqlCmd = Nothing
End Function ' // Create Data Reader Object Function DbCreateDataReader(ByVal I_chaSql As String) As SqlDataReader
On Error GoTo err
Dim chaSql As String = I_chaSql
Dim sqlreader As SqlDataReader
DbClose()
DbOpen()
Dim SqlCmd As New SqlCommand(chaSql, SqlConn)
'Dim SqlDr As SqlDataReader()
' DbCreateDataReader = SqlCmd.ExecuteReader()
sqlreader = SqlCmd.ExecuteReader(CommandBehavior.CloseConnection)
SqlCmd = Nothing
Return sqlreadererr:
End Function ' // Create Data Table Object
Function DbCreateDataTable(ByVal I_chaSql As String, ByVal I_TableName As String) As DataTable
On Error GoTo err
Dim chaSql As String = I_chaSql
Dim chaTableName As String = I_TableName
Dim SqlDs As DataSet = New DataSet
Dim SqlAdp As New SqlDataAdapter(chaSql, SqlConn)
SqlAdp.Fill(SqlDs, chaTableName)
Return SqlDs.Tables(chaTableName)err:
End Function ' // Create Data Set Object
Function DbCreateDataSet(ByVal I_chaSql As String, ByVal I_DataSetName As String) As DataSet
On Error GoTo err
Dim chaSql As String = I_chaSql
Dim chaTableSet As String = I_DataSetName
Dim SqlDs As DataSet = New DataSet
Dim SqlAdp As New SqlDataAdapter(chaSql, SqlConn) SqlAdp.Fill(SqlDs, chaTableSet)
Return SqlDs
err: End Function '//Create Data Reader Object
Function DbReturnString(ByVal I_chaSql As String, ByVal colname As String) As String
On Error GoTo err
Dim chaSql As String = I_chaSql
Dim str As String
Dim sqlreader As SqlDataReader
DbClose()
DbOpen()
Dim SqlCmd As New SqlCommand(chaSql, SqlConn)
sqlreader = SqlCmd.ExecuteReader(CommandBehavior.CloseConnection)
If sqlreader.Read Then
str = sqlreader.Item(colname)
Else
str = ""
End If
Return str
err:
str = "ERROR"
End Function End ClassEnd Namespace
在每个页面中加入
Imports 项目名.Flow_Foun