调用代码:
----------------------------------------------------------
Sub DelItem(ByVal Sender As Object, ByVal e As DataGridCommandEventArgs)
If e.CommandSource.commandname = "Del" Then
Dim sDel As New Chg_information.SqlOperate("Localhost", "Mysite", "sa", "lsy123") sDel.GetManagerDel(e.Item.ItemIndex, "SoftWare", "list")
End If
End Sub
----------------------------------------------------------类代码:
----------------------------------------------------------
Public Class SqlOperate
' Private strConn As String
Private ObjConn As SqlClient.SqlConnection
Private objCommand As SqlClient.SqlCommand
Private sOleDbDa As SqlClient.SqlDataAdapter
Private sDataSet As New DataSet
'
Sub New(ByVal _strServer As String, ByVal _strDB As String, ByVal _strUid As String, ByVal _strPwd As String)
strConn = "Server=" & _strServer & ";Database=" & _strDB & ";User id=" & _strUid & ";password=" & _strPwd
ObjConn = New SqlClient.SqlConnection(strConn)
objCommand = New SqlClient.SqlCommand
sDataSet = New DataSet
End Sub'
Function GetManagerDel(ByVal sid As Integer, ByVal DelTable As String, _
ByVal DsTableName As String)
Dim DelSql As String
DelSql = sDataSet.Tables(DsTableName).Rows(sid).Item("LS_ID") '错在这行
Dim Sql = "Delete From " & DelTable & " Where LS_ID='" & DelSql & "'"
sOleDbDa = New SqlClient.SqlDataAdapter(Sql, ObjConn)
sOleDbDa.Fill(sDataSet, DsTableName)
sDataSet.Clear()
End Function
End Class
----------------------------------------------------------提示错误:异常详细信息: System.NullReferenceException: 未将对象引用设置到对象的实例。错在这行:
-----------------------------------------------------------
DelSql = sDataSet.Tables(DsTableName).Rows(sid).Item("LS_ID")
-----------------------------------------------------------
----------------------------------------------------------
Sub DelItem(ByVal Sender As Object, ByVal e As DataGridCommandEventArgs)
If e.CommandSource.commandname = "Del" Then
Dim sDel As New Chg_information.SqlOperate("Localhost", "Mysite", "sa", "lsy123") sDel.GetManagerDel(e.Item.ItemIndex, "SoftWare", "list")
End If
End Sub
----------------------------------------------------------类代码:
----------------------------------------------------------
Public Class SqlOperate
' Private strConn As String
Private ObjConn As SqlClient.SqlConnection
Private objCommand As SqlClient.SqlCommand
Private sOleDbDa As SqlClient.SqlDataAdapter
Private sDataSet As New DataSet
'
Sub New(ByVal _strServer As String, ByVal _strDB As String, ByVal _strUid As String, ByVal _strPwd As String)
strConn = "Server=" & _strServer & ";Database=" & _strDB & ";User id=" & _strUid & ";password=" & _strPwd
ObjConn = New SqlClient.SqlConnection(strConn)
objCommand = New SqlClient.SqlCommand
sDataSet = New DataSet
End Sub'
Function GetManagerDel(ByVal sid As Integer, ByVal DelTable As String, _
ByVal DsTableName As String)
Dim DelSql As String
DelSql = sDataSet.Tables(DsTableName).Rows(sid).Item("LS_ID") '错在这行
Dim Sql = "Delete From " & DelTable & " Where LS_ID='" & DelSql & "'"
sOleDbDa = New SqlClient.SqlDataAdapter(Sql, ObjConn)
sOleDbDa.Fill(sDataSet, DsTableName)
sDataSet.Clear()
End Function
End Class
----------------------------------------------------------提示错误:异常详细信息: System.NullReferenceException: 未将对象引用设置到对象的实例。错在这行:
-----------------------------------------------------------
DelSql = sDataSet.Tables(DsTableName).Rows(sid).Item("LS_ID")
-----------------------------------------------------------
解决方案 »
- 我想取一个页面的返回值,保存到一个string变量里怎么弄
- 内容页后台代码如何调用自定义JS?
- 关于使用RSS
- |M| 江湖救争 WebClient问题 WebClient更一个网站页面的时候Session在那个页面无效 急
- WebControl.Events.Clear()
- c#简单的问题
- File.Delete 能使用通配符吗?
- 自定义控件如何加控件验证,上次已经发过但还是没人能解决,高手请进!!!!!!!!
- ASP.NET身份验证是干什么用的!!!!!!
- 高手,给一个自定义web控件添加自定义事件的例子!
- asp.net如何实现程序与美工分离
- 读入HTTP_REFERER时返回值始终为空
LS_ID是不是字段?
是的话 DelSql = sDataSet.Tables(DsTableName).Rows(sid)("LS_ID")
不是很懂vb,反正c#就这样写 DelSql = sDataSet.Tables(DsTableName).Rows(sid)["LS_ID"];
DataSet.Table[0].Select 行不?
vb的我不会
内的
---------------------------------------------------------------------
Function GetData(ByVal sSelect As String, ByVal DsTableName As String, ByVal SqlTable As Object, _
ByVal strGrid As DataGrid)
Dim Sql = "select " & sSelect & " from " & SqlTable
sOleDbDa = New SqlClient.SqlDataAdapter(Sql, ObjConn)
sOleDbDa.Fill(sDataSet, DsTableName)
sDataView = sDataSet.Tables(DsTableName).DefaultView
strGrid.DataSource = sDataView
strGrid.DataBind()
End Function
-----------------------------------------------------------------
ByVal DsTableName As String)sOleDbDa = new SqlClient.SqlDataAdapter("select * from " + DelTable, objConn)
sDataSet = New DataSet
sOleDbDa.Fill(sDataSet,DsTableName)
Dim DelSql As String
DelSql = sDataSet.Tables(DsTableName).Rows(sid).Item("LS_ID")
Dim Sql = "Delete From " & DelTable & " Where LS_ID='" & DelSql & "'"
sOleDbDa = New SqlClient.SqlDataAdapter(Sql, ObjConn)
sOleDbDa.Fill(sDataSet, DsTableName)
sDataSet.Clear()
End Function
End Class