教程中国
PHOTOSHOP CS9.0中文版 MAYA 8.5 FOR WINDOWS Corel Painter v9.0 Flash MX2004 中文版 Illustrator cs2 中文版
VC++6.0含sp6 中英文版 VB6.0 +sp6 简体中文版 Borland Delphi 7汉化版 MSDN for vb6.0中文版 Visual Studio 2005简体
教程中国下属 文件存储共享专家BIBIDU.COM 提供大型软件,教材,源码,电影,音乐,图书等下载 更多精品请点此进入
  您目前所在位置: 教程中国 >> .NET类 >> ASP.NET >> beta2中的SqlConnection和SqlCommand RSS订阅
beta2中的SqlConnection和SqlCommand
教程(视频,书籍)下载:  ASP.NET AutoCAD 数据库 C# ASP java photoshop 网页设计 delphi 3dmax Flash C++ VB 张孝祥 实例   更多请进入BIBIDU搜索
IT搜索引擎   
After a long struggle, I was able to install .NET Beta 2 but this is not the end of problems. As per as MSDN documentation, It is clearly mentioned that ASP.NET is supported on Win NT but dear Bill Gates fans just check out this letter from Scott and you will find that ASP.NET is not supported on NT for some technical reasons. And that's what I experienced with lot of efforts. Anyway, that's the past. Now, I'm up with Win 2000 and on top of that I successfully installed 123 Mb of .NET and Mobile Internet Toolkit. As per as your expectations, I won't disappoint you. Although, In this particular article, I  won't discuss my mobile series. In this article, I'll discuss something new which I noticed when I start testing my first Beta 1 based application. There are many changes in Beta2 and first of them I noticed was ADO.NET area.

In this article, you'll see how to use SqlConnection and SqlCommand ADO.NET objects. First thing is, namespaces. There is no namespace called System.Data.SQL any more. IT has been changed with System.Data.SqlClient. See http://www.c-sharpcorner.com/Beta%202/adonet1.ASP for more details.

If you had program in Beta 1, your code would look like this -
如果你用beta1编过程序,你的代码会看起来象下面的样子
<%@ Import Namespace="System.Data.SQL" %>
SQLDataReader myReader;
SQLConnection myConnection = new SQLConnection("server=localhost;uid=sa;pwd=sa;database=Shivani");
SQLCommand myCommand = new SQLCommand("Select * from ShivaniArea, myConnection);

try
{
myConnection.Open();
myCommand.Execute(out myReader);

while (myReader.Read())
{

// Retrieve the fields  
}
  



and now new version of Beta 2 looks like this -
现在新版本的Beta2中看起来这样
  
<%@ Import Namespace="System.Data.SqlClient"%>
SqlDataReader myReader;

SqlConnection myConnection = new SqlConnection("server=localhost;uid=sa;pwd=sa;database=Shivani");
SqlCommand myCommand = new SqlCommand("Select * from ShivaniArea", myConnection);
try
{
      myConnection.Open();
      myReader = myCommand.ExecuteReader;

while(myReader.Read())
{
    //Retrieve the fields
}
}  

During the testing of my mobile applications, I noticed more problems working with Beta 1 code. I was having problem working with the TagPrefix. Any way .. I'll be coming with more articles on this matter soon and keep updating you on Beta 2. In my next article, I will discuss how to deal with the problem of losing the DocumentNavigator Class in XML and take the real use of XMLDocument Class.



来源:upschool.com.cn
作者:
关键字:beta2中
发表日期:2005-12-23

网页显示有限 阅读全文请下载本文完整版WORD文档

上一篇:Dataview绑定实例(初学者可以看,很简单,但很实用的)   下一篇:Working with Relational Data in ADO.Net(东方蜘蛛快来看!!)


2008-12-4 6:44:32
本文的相类似文章
  • Word 2007 beta2中又挖出两个彩蛋
  • Word 2007 beta2中又挖出两个彩蛋
  • BETA2中操作SQL数据库
  • 贴篇文章,BETA2中ACCESS操作数据库
  • 在学习中进步 在进步中成长 教程中国相随您的成长之路
    华腾联合科技股份有限公司版权所有
    广告联系:Rosibo@163.com