樱之花

叶散的时候,你明白欢聚;花谢的时候,你明白青春.

日志

关于我

yinzhihua2008

分类中“我的实验室”是我在日常工作中的一些知识总结,有些写的比较匆忙,可能大家在阅读时会产生困扰,后期有时间我会重新整理编辑,谢谢大家的到访,您们的支持是我前进的动力！

文章分类

PDA上让DataGrid单元格可编辑

2007-07-26 10:26:50| 分类： Windows Mobile | 标签： |举报 |字号大中小订阅

下载LOFTER 我的照片书 |

在PDA设备上不能直接对DataGrid的单元格进行编辑，那么，如何实现单元格可编辑呢？我们可以用TextBox来模拟单元格，让这个TextBox一开始隐藏起来，当点击DataGrid的单元格的时候，在当前单元格的位置显示TextBox.因此我们必须要先获得当前单元格的坐标，然后显示TextBox在该坐标，并且将当前单元格的内容赋给TextBox，当用户修改了TextBox的内容并且离开该单元格时，TextBox将再次被隐藏，同时，单元格的内容被赋为TextBox的最新内容。按照以上的思路我们可以写如下代码：

Imports System.Data
Imports System.Data.SqlClient
Imports System.Data.SqlServerCe

Public Class Form5
    Public conn As New SqlCeConnection("DataSource=\test.sdf")
    Public cmd As SqlCeCommand
    Public adapter As New SqlCeDataAdapter
    Public LineType As Integer
    Private Sql As String
    Private isEditMode As Boolean = False '是否处于编辑模式
    Private isUpdateMode As Boolean = False '是否处于更新模式
    Private editCell As New DataGridCell '编辑的单元格子
    Private cellPos As New Rectangle '单元格的位置

    Private Sub DataGrid1_CurrentCellChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DataGrid1.CurrentCellChanged
        If isUpdateMode = False Then
            '更新模式
            If isEditMode = True And DataGrid1.CurrentCell.Equals(editCell) = False Then
                '保存当前所在单元格子，因为设置item时候焦点会移出
                isUpdateMode = True
                DataGrid1.Visible = False
                Dim currentcell As New DataGridCell
                currentcell = DataGrid1.CurrentCell

                DataGrid1.Item(editCell.RowNumber, editCell.ColumnNumber) = TextBox1.Text
                DataGrid1.CurrentCell = currentcell
                DataGrid1.Visible = True
                '开始保存编辑结果到数据库中
                '(...)代码略
                '结束保存
                TextBox1.Visible = False
                isUpdateMode = False
                isEditMode = False
            End If

            '编辑模式
            editCell = DataGrid1.CurrentCell
            cellPos = DataGrid1.GetCellBounds(editCell.RowNumber, editCell.ColumnNumber)
            TextBox1.Left = cellPos.Left - 1
            TextBox1.Top = cellPos.Top + DataGrid1.Top - 1
            TextBox1.Width = cellPos.Width + 2
            TextBox1.Height = cellPos.Height + 2
            TextBox1.Visible = True
            TextBox1.Text = DataGrid1.Item(editCell.RowNumber, editCell.ColumnNumber)
            isEditMode = True
        End If

End Sub

Private Sub Form5_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

        Try
            Cursor.Current = Cursors.Default
            conn.Open()
            Sql = "select plandate,linename,planweekday from t_plan where userid=1 order by plandate asc"
            cmd = New SqlCeCommand(Sql)
            cmd.Connection = conn
            adapter.SelectCommand = cmd
            Dim dataset As New DataSet()
            adapter.Fill(dataset, "plan")
            dataset.Tables(0).Columns(0).ColumnName = "日期"
            dataset.Tables(0).Columns(1).ColumnName = "描述"
            dataset.Tables(0).Columns(2).ColumnName = "星期"

            Dim tableStyle As DataGridTableStyle
            tableStyle = New DataGridTableStyle
            tableStyle.MappingName = "plan"
            DataGrid1.TableStyles.Clear()
            DataGrid1.TableStyles.Add(tableStyle)

            DataGrid1.DataSource = dataset.Tables(0)
            DataGrid1.TableStyles("plan").GridColumnStyles(0).Width = 80
            DataGrid1.TableStyles("plan").GridColumnStyles(1).Width = 70
            DataGrid1.TableStyles("plan").GridColumnStyles(2).Width = 54
            conn.Close()

        Catch ex As Exception
            MessageBox.Show(ex.ToString)
        End Try
    End Sub

Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click

End Sub
End Class

效果演示：

同理，我们可以用DataTimePicker来模拟单元格达到日期编辑的效果，效果图如下：

评论这张

转发至微博

阅读(1946)| 评论(0)

历史上的今天

this.p={  m:2,
              b:2,
              loftPermalink:'',
              id:'fks_094075092094082068083095074068093082082067082081',
              blogTitle:'PDA上让DataGrid单元格可编辑',
              blogAbstract:'<P\>在PDA设备上不能直接对DataGrid的单元格进行编辑，那么，如何实现单元格可编辑呢？我们可以用TextBox来模拟单元格，让这个TextBox一开始隐藏起来，当点击DataGrid的单元格的时候，在当前单元格的位置显示TextBox.因此我们必须要先获得当前单元格的坐标，然后显示TextBox在该坐标，并且将当前单元格的内容赋给TextBox，当用户修改了TextBox的内容并且离开该单元格时，TextBox将再次被隐藏，同时，单元格的内容被赋为TextBox的最新内容。按照以上的思路我们可以写如下代码：</P\>\r\n<P\>Imports System.Data<BR\>Imports System.Data.SqlClient<BR\>Imports System.Data.SqlServerCe</P\>\r\n<P\>Public Class Form5<BR\>  </P\>',
              blogTag:'',
              blogUrl:'blog/static/79430672007626102650785',
              isPublished:1,
              istop:false,
              type:2,
              modifyTime:1185418531593,
              publishTime:1185416810785,
              permalink:'blog/static/79430672007626102650785',
              commentCount:0,
              mainCommentCount:0,
              recommendCount:0,
              bsrk:-100,
              publisherId:0,
              recomBlogHome:false,
              currentRecomBlog:false,
              attachmentsFileIds:[],
              vote:{},
              groupInfo:{},
              friendstatus:'none',
              followstatus:'unFollow',
              pubSucc:'',
              visitorProvince:'',
              visitorCity:'',
              visitorNewUser:false,
              postAddInfo:{},
              mset:'000',
              mcon:'',
              srk:-100,
              remindgoodnightblog:false,
              isBlackVisitor:false,
              isShowYodaoAd:true,
              hostIntro:'分类中“我的实验室”是我在日常工作中的一些知识总结,有些写的比较匆忙,可能大家在阅读时会产生困扰,后期有时间我会重新整理编辑,谢谢大家的到访,您们的支持是我前进的动力！',
              hmcon:'1',
              selfRecomBlogCount:'0',
              lofter_single:'<iframe width="140" height="560" style="overflow:hidden;" src="http://www.lofter.com/mailEntry.do?blogad=1&blog" frameBorder="0"></iframe>'
            }

{list a as x}
    {if !!x}
    <div class="iblock nbw-fce nbw-f40">
      <a class="fc03 noul" target="_blank" hidefocus="true" href="http://blog.163.com/${x.visitorName}/">
      {if x.visitorName==visitor.userName}
      <img alt="${x.visitorNickname|escape}" onerror="this.src=location.f40" class="cwd bdwa bdc0" src="${fn1(x.visitorName)}&r=${visitor.imageUpdateTime}"/>
      {else}
      <img alt="${x.visitorNickname|escape}" onerror="this.src=location.f40" class="cwd bdwa bdc0" src="${fn1(x.visitorName)}"/>
      {/if}
      </a>
      <div class="cwd vname thide">
        {if x.moveFrom=='wap'}
          <a class="noul pnt" target="_blank" href="http://blog.163.com/services/wapblog.html?frompersonalbloghome"><span title="来自网易手机博客" class="iblock wapIcon"> </span></a>
        {elseif x.moveFrom=='iphone'}
          <a class="noul pnt" target="_blank"><span title="来自iPhone客户端" class="iblock iphoneIcon"> </span></a>
        {elseif x.moveFrom=='android'}
          <a class="noul pnt" target="_blank"><span title="来自Android客户端" class="iblock androidIcon"> </span></a>
        {elseif x.moveFrom=='mobile'}
          <a class="noul pnt" target="_blank" href="http://blog.163.com/services/emsblog.html?frompersonalbloghome"><span title="来自网易短信写博" class="iblock wapIcon"> </span></a>
        {/if}
        <a class="fc03 m2a"  target="_blank" hidefocus="true" href="http://blog.163.com/${x.visitorName}/">
          ${fn(x.visitorNickname,8)|escape}
        </a>
      </div>
    </div>
    {/if}
    {/list}

<#--最新日志，群博日志--> <#--推荐日志-->

<p class="fc06">推荐过这篇日志的人：</p>
    <div>
      {list a as x}
      {if !!x}
      <div class="iblock nbw-fce nbw-f40">
        <a class="fc03 noul" target="_blank" hidefocus="true" href="http://blog.163.com/${x.recommenderName}/">
        <img alt="${x.recommenderNickname|escape}" onerror="this.src=location.f40" class="cwd bdwa bdc0" src="${fn1(x.recommenderName)}"/>
        </a>
        <div class="cwd thide">
          <a class="fc03 m2a" target="_blank" hidefocus="true" href="http://blog.163.com/${x.recommenderName}/">
            ${fn(x.recommenderNickname,6)|escape}
          </a>
        </div>
      </div>
      {/if}
      {/list}
    </div>
    {if !!b&&b.length>0}
    <p  class="fc06">他们还推荐了：</p>
    <ul>
    {list b as y}
      {if !!y}
        <li class="rrb"><span class="iblock">·</span><a class="fc03 m2a" target="_blank" href="http://blog.163.com/${y.recommendBlogPermalink}/?from=blog/static/79430672007626102650785">${y.recommendBlogTitle|escape}</a></li>
      {/if}
    {/list}
    </ul>
    {/if}

<#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇，下一篇--> <#-- 热度 -->

{list a as x}
    {if !!x}
    <div class="hotItem iblock nbw-fce nbw-f40">
      <a class="fc03 noul" target="_blank" hidefocus="true" href="http://blog.163.com/${x.publisherUsername}/">
      {if x.publisherUsername==visitor.userName}
      <img alt="${x.publisherNickname|escape}" onerror="this.src=location.f40" class="cwd bdwa bdc0" src="${fn1(x.publisherUsername)}&r=${visitor.imageUpdateTime}"/>
      {else}
      <img alt="${x.publisherNickname|escape}" onerror="this.src=location.f40" class="cwd bdwa bdc0" src="${fn1(x.publisherUsername)}"/>
      {/if}
      </a>
      <div class="cwd vname thide">
        <a class="fc03 m2a"  target="_blank" hidefocus="true" href="http://blog.163.com/${x.publisherUsername}/">
          ${fn(x.publisherNickname,8)|escape}
        </a>
      </div>
      <a class="f-myLikeIcons hottype {if x.type==1} js-liketype{elseif x.type==2} js-reblogtype{elseif x.type==3} js-sharetype{else}{/if}" target="_blank" hidefocus="true" href="http://blog.163.com/${x.publisherUsername}/"> </a>
    </div>
    {/if}
    {/list}

<#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->

页脚

我的照片书 - 手机博客 - 下载LOFTER APP - 订阅此博客

樱之花

导航

日志

PDA上让DataGrid单元格可编辑

历史上的今天

最近读者

热度

评论

页脚