DataGrid-利用imagebutton实现更新操作

说明:
本例中实现单击更新修改图标(imagebutton)时取得相应行的数据并填充到下面的panel容器中,这时panel的Visible为true,修改相应数据单击更新后隐藏下面的panel容器.
更新操作如下图所示:


步骤如下:
1.创建panel如图所示,具体就不用说了吧,需要在Page_Load事件中添加如下代码
ContractedBlock.gif ExpandedBlockStart.gif 设置panel的可见性为false
None.gifprivate void Page_Load(object sender, System.EventArgs e)
ExpandedBlockStart.gifContractedBlock.gif        
dot.gif{
InBlock.gif            
// 在此处放置用户代码以初始化页面
InBlock.gif
            if(!IsPostBack)
ExpandedSubBlockStart.gifContractedSubBlock.gif            
dot.gif{
InBlock.gif                BindDG();
InBlock.gif                
this.Panel1.Visible=false;
ExpandedSubBlockEnd.gif            }

ExpandedBlockEnd.gif        }
2.在datagrid中创建模板列
3.在模板列中加入imagebutton并为其指定
ImageUrlCommandName,代码如下:
ContractedBlock.gif ExpandedBlockStart.gif 更新.aspx
None.gif<asp:TemplateColumn>
None.gif                                    
<ItemTemplate>
None.gif                                        
<asp:ImageButton id="Imagebutton2" runat="server" CommandName="UpDt" ImageUrl="../Pic/edit2.gif"></asp:ImageButton>
None.gif                                    
</ItemTemplate>
None.gif                                
</asp:TemplateColumn>
4.在datagrid的 ItemCommand事件中添加如下代码
ContractedBlock.gif ExpandedBlockStart.gif 单击修改图标时触发
None.gif private void DG_userinfo_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
None.gif        {
None.gif            if(e.CommandName=="Del")
None.gif            {
None.gif                string uid = e.Item.Cells[0].Text.ToString();
None.gif                string [] values = {uid};
None.gif                OperateXmlByDataSet.DeleteXmlRows(ViewState["filename"].ToString(),"userid",values);
None.gif                BindDG();
None.gif
None.gif            }
None.gif            if(e.CommandName=="UpDt")
None.gif            {
None.gif                string userid = e.Item.Cells[0].Text.ToString();
None.gif                ViewState["uid"] = userid;
None.gif                this.Txt_id.Text = userid;
None.gif                this.Txt_name.Text = e.Item.Cells[1].Text.ToString();
None.gif                this.Txt_pass.Text = e.Item.Cells[2].Text.ToString();
None.gif                this.Txt_mail.Text = e.Item.Cells[3].Text.ToString();
None.gif                this.Txt_site.Text = e.Item.Cells[4].Text.ToString();
None.gif                this.Txt_msn.Text = e.Item.Cells[5].Text.ToString();
None.gif                this.Panel1.Visible=true;            
None.gif            }
None.gif        }

5."更新"按钮事件,我是用xml存储数据的,由于涉及代码较多,这里只给出部分源码,有想要的请留言
ContractedBlock.gif ExpandedBlockStart.gif 更新事件
None.gif void Xml_UpDt(string userid)
None.gif        {
None.gif            string username = this.Txt_name.Text;
None.gif            string userpass = this.Txt_pass.Text;
None.gif            string usermail = this.Txt_mail.Text;
None.gif            string usersite = this.Txt_site.Text;
None.gif            string usermsn = this.Txt_msn.Text;
None.gif
None.gif            string [] Columns = {"username","userpass","usermail","usersite","usermsn"};
None.gif            string [] ColumnsValues = {username,userpass,usermail,usersite,usermsn};
None.gif            OperateXmlByDataSet.UpdateXmlRow(ViewState["filename"].ToString(),Columns,ColumnsValues,"userid",userid);
None.gif        }
None.gif
None.gif        private void Btn_update_Click(object sender, System.EventArgs e)
None.gif        {
None.gif            Xml_UpDt(ViewState["uid"].ToString());
None.gif            BindDG();
None.gif            this.Panel1.Visible=false;
None.gif        }


转载于:https://www.cnblogs.com/tenghoo/archive/2006/10/11/525875.html

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
<div style=";text-align:center;;height:auto;" class="datagrid-cell datagrid-cell-c1-checkId">已通过</div></td><td field="button"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-button"><a href="#" style="color: red" onclick="fileManager(0)">图片管理</a></div></td><td field="truckNo"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-truckNo">辽PD6885</div></td><td field="truckCardColor"><div style=";text-align:center;;height:auto;" class="datagrid-cell datagrid-cell-c1-truckCardColor">黄牌</div></td><td field="vtNam"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-vtNam">秦皇岛九福物流有限公司</div></td><td field="driverNam"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-driverNam">叶红建</div></td><td field="linkTel"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-linkTel">13842929049</div></td><td field="workCompanyCod"><div style=";text-align:center;;height:auto;" class="datagrid-cell datagrid-cell-c1-workCompanyCod">金海粮油</div></td><td field="cargoNam" style="display:none;"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-cargoNam"></div></td><td field="consignCod" style="display:none;"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-consignCod"></div></td><td field="planDte"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-planDte">2023-05-01</div></td><td field="validTyp"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-validTyp">当天有效</div></td><td field="ifEnd"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-ifEnd">x</div></td><td field="individualId" style="display:none;"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-individualId">0</div></td><td field="rejectReason"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-rejectReason"></div></td><td field="checkNam"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-checkNam">jhly</div></td><td field="checkTim"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-checkTim">2023-04-29 21:09</div></td>以上代码为网页源码,帮我写一段python程序从以上代码中找出drivernam和checkTim并保存数据库中
06-13
可以使用BeautifulSoup和pymysql库来实现该功能。以下是示例代码: ``` python from bs4 import BeautifulSoup import pymysql # 解析网页源码 html = """ <div style=";text-align:center;;height:auto;" class="datagrid-cell datagrid-cell-c1-checkId">已通过</div></td><td field="button"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-button"><a href="#" style="color: red" onclick="fileManager(0)">图片管理</a></div></td><td field="truckNo"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-truckNo">辽PD6885</div></td><td field="truckCardColor"><div style=";text-align:center;;height:auto;" class="datagrid-cell datagrid-cell-c1-truckCardColor">黄牌</div></td><td field="vtNam"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-vtNam">秦皇岛九福物流有限公司</div></td><td field="driverNam"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-driverNam">叶红建</div></td><td field="linkTel"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-linkTel">13842929049</div></td><td field="workCompanyCod"><div style=";text-align:center;;height:auto;" class="datagrid-cell datagrid-cell-c1-workCompanyCod">金海粮油</div></td><td field="cargoNam" style="display:none;"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-cargoNam"></div></td><td field="consignCod" style="display:none;"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-consignCod"></div></td><td field="planDte"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-planDte">2023-05-01</div></td><td field="validTyp"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-validTyp">当天有效</div></td><td field="ifEnd"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-ifEnd">x</div></td><td field="individualId" style="display:none;"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-individualId">0</div></td><td field="rejectReason"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-rejectReason"></div></td><td field="checkNam"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-checkNam">jhly</div></td><td field="checkTim"><div style=";height:auto;" class="datagrid-cell datagrid-cell-c1-checkTim">2023-04-29 21:09</div></td> """ soup = BeautifulSoup(html, 'html.parser') # 获取driverNam和checkTim的值 driverNam = soup.find('td', {'field': 'driverNam'}).text.strip() checkTim = soup.find('td', {'field': 'checkTim'}).text.strip() # 将数据保存到数据库中 conn = pymysql.connect(host='localhost', user='root', password='password', database='test') cur = conn.cursor() sql = "INSERT INTO table_name (driverNam, checkTim) VALUES (%s, %s)" values = (driverNam, checkTim) cur.execute(sql, values) conn.commit() cur.close() conn.close() ``` 需要将代码中的`table_name`替换为实际表名,以及修改数据库连接参数。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值