SqlDataReader Read()
DataView 用索引,DataRowView
DataView 用索引,DataRowView
解决方案 »
- 正则匹配超链接问题
- 我想做一个可以播放rm格式视频的网页,object里的classid怎么设置,谢谢
- asp.net 框架网页怎样间传递cookies?
- gridview分页转到第几页RowCommand命令无效
- GridView 分页老是提示错误!(vb)
- 未包含对textbox的定义
- 新手问下框架的问题?
- 怎末在服务器端Button控件的click 事件里响应Html button的click事件
- 入门问题,解释下段代码含义,越详细越好,这段代码怎么出来的?
- 关于TabStrip和multipage这两个控件的问题?
- 图片输入流的获取问题?
- 如何在一个页面里分割,上面显示aspx的页面,下面显示html的页面?
用foreach循环foreach(DataRow row in DataSet1.Table[0].Rows)
{
//...单条记录操作
}
dstgrid.Tables["webgrid"].DefaultView.RowFilter="cwhcode= '"+this.txtbh.Text+"'";
dstgrid.Tables["webgrid"].DefaultView.Sort="cvouchtype";
if(dstgrid.Tables["webgrid"].DefaultView.Count>0 )
{
Object []dd=new Object[1];
dd[0]=this.txtcode.Text;
int i=dstgrid.Tables["webgrid"].DefaultView.Find(dd);
if(i+1<dstgrid.Tables["webgrid"].DefaultView.Count)
{
this.txtcode.Text=dstgrid.Tables["webgrid"].DefaultView[i+1]["cvouchtype"].ToString();
bind(this.txtcode.Text);//绑定到文本框中显示
return true;
}
else
return false;
}
else
return false;
'函数名:DeleteJJUser
'函数功能:删除参与竞价的会员出价
'入口参数:
'返回值:
'################################################################################################
Public Function DeleteJJUser() As Boolean
' On Error GoTo err
DeleteJJUser = False
Dim DeleteTop As String
Dim MyConnection As New SqlConnection(ShareFunction.GetDBConnectionString())
MyConnection.Open()
Dim SQL As String = "SELECT top 2 * FROM V_JJBack where SaleProductID='" & SaleProductID & "' order by BackID desc"
Dim SQLReader As SqlDataReader
Dim MyCommand As New SqlCommand
MyCommand.Connection = MyConnection
MyCommand.CommandText = SQL
SQLReader = MyCommand.ExecuteReader
If SQLReader.Read() Then
If CStr(SQLReader.Item("BackID")) = CStr("BackID") Then
DeleteTop = 1
End If
If Not SQLReader.Read() Then
NowPrice = 0
Else
NowPrice = SQLReader.Item("NowPrice")
End If
If DeleteTop = 1 Then
UpdateJJNowTopPrice(SaleProductID, NowPrice)
End If
End If
SQLReader.Close()
MyConnection.Close()
MyConnection = Nothing
SQL = Nothing
DeleteJJBackAndUpdateBackNum("BackID")
DeleteJJUser = True
Exit Function
err:
DeleteJJUser = False
End Function
看看我这样写对不?
先建个datareader 然后用一下read(),就到下一条了,
NowPrice = 0
Else
NowPrice = SQLReader.Item("NowPrice")
End If
那我用这条不是可以实现吗?