CYQ.Data componentsCYQ.Data support multi-database application [Txt,Xml,Access, MSSQL, Oracle,SQLite,MySql], help easily and quickly to develop your project |
CYQ.Data 数据框架 应用示例 JSON通讯篇
Guide |
|
|
| #TopicOwner |
前言: 好久没写教程类的文章,版本升级的是很快,由于所有版本都是向下兼容的,所以原先教程也适用, 有时间再适度的人为的更新一下。 暂时有一些新功能用法,都散落在各在发布版本的文章中,所以大伙有空也不要放过各版本的发布文章。 今天,特意精心写了一个示例,来演示 CYQ.Data 数据框架中一项未被大伙重视的:JSON应用篇。 下面就来看示例了: 一:功能清单介绍 1:发布一个WebService,提供两个方法: a:查询表数据:public string GetUsersInfo() b:数据更新[带插入]:public bool UpdateUserInfo(string json) 2:本地Aspx页面: a:直接调用WebService的GetUsersInfo,绑定到列表控件中。 b:用Jquery读取WebService,循环输出数据。 c:用Jquery调用UpdateUserInfo,提交数据。 3:解决方案: 为了这次示例,把 秋色园QBlog 数据库也用上了。 二:项目实施步骤 1:到 下载中心下载V4.3版本,并配置好数据库链接--略过 2:引用CYQ.Data 数据框架--略过 3:添加WebService,并新增以下两个方法: 4:添加WebService的引用 5:界面调用: a:html <asp:GridView ID="gvUsers" runat="server"></asp:GridView>
b:Default.aspx protected void Page_Load(object sender, EventArgs e) 6:F5结果1: 7:与Jquery调用交互一:查询数据: a:html <div id="jsonBody" title="显示用的Div一个"> </div> 同时body增加onload="loadData()",引发事件的脚本如下: b:调用结果: 8:与Jquery调用交互二:提交数据: a:html:1个输入框,一个提交按钮 <input id="txtJson" type="text" value="" style="width: 300px" />
<input type="button" value="提交更新" onclick="updateData()" /> b:jquery调用提交数据: c:界面输入数据,并准备提交数据: d:提交后的数据结果已更新如下: 三:总结与示例打包下载: 本能过篇的介绍,能掌握 CYQ.Data 数据框架在网络通讯JSON的应用。 从本节的示例代码中看,应用起来是相当的简洁方便的: 可以非常方便的从表格转化成JSON,同时能方便的从JSON还原为表格,表格还可以转化为List<T>的实体形式。
即使是基于WCF,Silverlight的通讯应用,也是非常方便的,大伙赶紧激情体验下。 最后是:示例打包下载地址:http://cyqdata.com/download/article-detail-28683 |
swhhcf2011/6/22 15:09:53 | #3 | |
已经按照你说的做了,但还是不能更新 我用的是 .net4 附文本框输入的文本: {"ID":"20","UserName":"abcde"} reply: 你可以根据以下步骤进行调试: 1:断点,看是否执行了action.Update()方法。 2:在执行完action.Update之后,通过action.DebugInfo看执行的SQL语句是什么。 |
swhhcf2011/6/20 22:13:50 | #2 | |
我下载了代码,显示数据正常,但不能更新,怎么回事? reply: access数据库目录没有写权限应该,给App_data添加everyone的写权限。 |
방문자가 [회원 가입][59.175.233.*]2011/3/30 23:55:05 | #1 | |
jjjjjjjjjjjjj reply: smail jj? |
Post Comment
Bulletin
Article Search
Categories
- Platform for dynamic (20)
- Feedback (9)
- Guide (33)
- Principles (19)
- Project-Case (8)
- Business & Buy (2)
- Technology exchange (45)
New Article
- CYQ.Data Components Getting Started Guide [Part 5]-[MProc Execute Stored Procedures or SQL]
- CYQ.Data Components Getting Started Guide [Part 4]-[MAction Insert Delete Update]
- CYQ.Data Components Getting Started Guide [Part 3]-[MAction Get And Set Value]
- CYQ.Data Components Getting Started Guide [Part 2]-[MAction Data Query- Fill And Select]
- CYQ.Data Components Getting Started Guide [Part 1]
New Comment
- When some one searches for his necessary thing, therefore he/she wishes to be available that in detail, so that thing is maintained over here.
- This is my first time pay a quick visit at here and i am in fact happy to read everthing at alone place.
- I truly appreciate this blog article.Really thank you! Cool.
- please pay a visit to the web sites we follow, like this one particular, as it represents our picks in the web
- Really enjoyed this post.Really thank you!
- Really enjoyed this article.Really looking forward to read more. Great.
- poker bonuses What are the norms of copyright of web content? How as it different from Patent?
- Wow! Thank you! I permanently needed to write on my blog something like that. Can I implement a fragment of your post to my site?
- This website was how do I say it? Relevant!! Finally I ave found something that helped me. Cheers!
- I was reading through some of your content on this internet site and I believe this web site is very informative ! Continue posting.