小弟用VS2005,ASP2.0和VB.NET进行编写.
现在碰到个问题,我查询代码自己写的,显示在GRIDVIEW里面,然后在GRIDVIEW里面添加编辑按钮,然后联接到另外一个页面把选中的内容详细的列出来进行编辑,求方法.
我的代码是:
查询:
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim myConnectionString As String
myConnectionString = "server=localhost;database=NBDC;uid=****;pwd=****;"
Dim myConnection As New SqlConnection(myConnectionString)
Dim mySelect As String = "SELECT * FROM Repository WHERE Name LIKE '%" + TextBox3.Text + "%' AND Operator LIKE '%" + DropDownList1.Text + "%' AND Type LIKE '%" + DropDownList2.Text + "%' AND Server LIKE '%" + DropDownList3.Text + "%' AND Detail LIKE '%" + TextBox4.Text + "%' AND Keyword LIKE '%" + TextBox6.Text + "%'"
Dim myCommand As New SqlCommand(mySelect)
Dim adapter As SqlDataAdapter = New SqlDataAdapter(mySelect, myConnection)
myCommand.Connection = myConnection
myConnection.Open()
Dim ds As New DataSet
adapter.Fill(ds)
GridView1.DataSource = ds
GridView1.DataBind()
myCommand.Connection.Close()
End Sub
显示:
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" Width="780px" Font-Size="Small" ForeColor="Black" AutoGenerateColumns="False" DataKeyNames="RepositoryID" AutoGenerateDeleteButton="True" AutoGenerateEditButton="True" EnableSortingAndPagingCallbacks="True" PageSize="8">
<Columns>
<asp:BoundField DataField="Name" HeaderText="名称"></asp:BoundField>
<asp:BoundField DataField="Operator" HeaderText="操作者"></asp:BoundField>
<asp:BoundField DataField="Type" HeaderText="类型"></asp:BoundField>
<asp:BoundField DataField="Datetime" HeaderText="时间"></asp:BoundField>
<asp:BoundField DataField="Detail" HeaderText="描述"></asp:BoundField>
<asp:BoundField DataField="Picture" HeaderText="图片"></asp:BoundField>
<asp:BoundField DataField="Keyword" HeaderText="关键字"></asp:BoundField>
<asp:BoundField DataField="Server" HeaderText="服务器"></asp:BoundField>
<asp:HyperLinkField HeaderText="编辑" Text="编辑" DataNavigateUrlFormatString="SearchEdit.aspx?RepositoryID={0}" DataNavigateUrlFields="RepositoryID"></asp:HyperLinkField>
<asp:CommandField ShowEditButton="True" />
</Columns>
</asp:GridView>
后面我的思路是:点编辑以后,联接到SearchEdit.aspx页面,然后把相应的数据详细的显示在页面上,然后用UPDATING 命令进行更新,求每个环节,特别是把选中的行的信息怎么关联到下一个页面的代码.先谢谢了.
现在碰到个问题,我查询代码自己写的,显示在GRIDVIEW里面,然后在GRIDVIEW里面添加编辑按钮,然后联接到另外一个页面把选中的内容详细的列出来进行编辑,求方法.
我的代码是:
查询:
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim myConnectionString As String
myConnectionString = "server=localhost;database=NBDC;uid=****;pwd=****;"
Dim myConnection As New SqlConnection(myConnectionString)
Dim mySelect As String = "SELECT * FROM Repository WHERE Name LIKE '%" + TextBox3.Text + "%' AND Operator LIKE '%" + DropDownList1.Text + "%' AND Type LIKE '%" + DropDownList2.Text + "%' AND Server LIKE '%" + DropDownList3.Text + "%' AND Detail LIKE '%" + TextBox4.Text + "%' AND Keyword LIKE '%" + TextBox6.Text + "%'"
Dim myCommand As New SqlCommand(mySelect)
Dim adapter As SqlDataAdapter = New SqlDataAdapter(mySelect, myConnection)
myCommand.Connection = myConnection
myConnection.Open()
Dim ds As New DataSet
adapter.Fill(ds)
GridView1.DataSource = ds
GridView1.DataBind()
myCommand.Connection.Close()
End Sub
显示:
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" Width="780px" Font-Size="Small" ForeColor="Black" AutoGenerateColumns="False" DataKeyNames="RepositoryID" AutoGenerateDeleteButton="True" AutoGenerateEditButton="True" EnableSortingAndPagingCallbacks="True" PageSize="8">
<Columns>
<asp:BoundField DataField="Name" HeaderText="名称"></asp:BoundField>
<asp:BoundField DataField="Operator" HeaderText="操作者"></asp:BoundField>
<asp:BoundField DataField="Type" HeaderText="类型"></asp:BoundField>
<asp:BoundField DataField="Datetime" HeaderText="时间"></asp:BoundField>
<asp:BoundField DataField="Detail" HeaderText="描述"></asp:BoundField>
<asp:BoundField DataField="Picture" HeaderText="图片"></asp:BoundField>
<asp:BoundField DataField="Keyword" HeaderText="关键字"></asp:BoundField>
<asp:BoundField DataField="Server" HeaderText="服务器"></asp:BoundField>
<asp:HyperLinkField HeaderText="编辑" Text="编辑" DataNavigateUrlFormatString="SearchEdit.aspx?RepositoryID={0}" DataNavigateUrlFields="RepositoryID"></asp:HyperLinkField>
<asp:CommandField ShowEditButton="True" />
</Columns>
</asp:GridView>
后面我的思路是:点编辑以后,联接到SearchEdit.aspx页面,然后把相应的数据详细的显示在页面上,然后用UPDATING 命令进行更新,求每个环节,特别是把选中的行的信息怎么关联到下一个页面的代码.先谢谢了.
解决方案 »
- Commoditys.comm_picture,Commoditys.comm_name,Advertisers.adv_amount,Advertisers.
- excel数据导入 数据库 菜鸟求指导
- 求助!!关于线程控制随机数的问题
- Response.Expires!!
- 高手都来看下,请教!
- c#.net 上传图片问题!~
- asp.net快速入门中的示例程序在查看其源代码是出错,请各位帮助,在线等 谢谢
- 请问:ActiveReport怎样才能同时邦定一个DateSet的两张表中的数据(急)
- [放分]在WebForm中,将ArrayList绑定到DataGrid
- 请教如何实现事务
- ASP.NET 2.0 页面计时
- PETSHOPS数据库问题
这些信息,显示在TextBox里面,更新的时候执行UPdate语句就可以了撒
VB里是这样传的rs("ProdNum")
我这里是这样:DataNavigateUrlFormatString="SearchEdit.aspx?RepositoryID={0}"
然后怎么传啊.
你有QQ吗?具体聊下.
我在<asp:GridView ID="GridView1" runat="server" AllowPaging="True" Width="780px" Font-Size="Small" ForeColor="Black" AutoGenerateColumns="False" DataKeyNames="RepositoryID" AutoGenerateDeleteButton="True" AutoGenerateEditButton="True" EnableSortingAndPagingCallbacks="True" PageSize="8">
<Columns>
<asp:BoundField DataField="Name" HeaderText="名称"></asp:BoundField>
<asp:BoundField DataField="Operator" HeaderText="操作者"></asp:BoundField>
<asp:BoundField DataField="Type" HeaderText="类型"></asp:BoundField>
<asp:BoundField DataField="Datetime" HeaderText="时间"></asp:BoundField>
<asp:BoundField DataField="Detail" HeaderText="描述"></asp:BoundField>
<asp:BoundField DataField="Picture" HeaderText="图片"></asp:BoundField>
<asp:BoundField DataField="Keyword" HeaderText="关键字"></asp:BoundField>
<asp:BoundField DataField="Server" HeaderText="服务器"></asp:BoundField>
<asp:HyperLinkField HeaderText="编辑" Text="编辑" DataNavigateUrlFormatString="SearchEdit.aspx?RepositoryID={0}" DataNavigateUrlFields="RepositoryID"></asp:HyperLinkField>
<asp:CommandField ShowEditButton="True" />
</Columns>
</asp:GridView>定义了连接,该在什么时候取值呢?
http://www.developerfusion.co.uk/utilities/convertvbtocsharp.aspx
然后
[C#]
DataKey key = this.GridView1.DataKeys[e.RowIndex];
String var=key[0].ToString();
取得这个值,就可以实现想要的update操作了.