SqlDataAdapter用法

来源:互联网 发布:淘宝神笔加自定义模块 编辑:程序博客网 时间:2024/03/29 14:23
DataSet <br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />作用:DataSet,DataAdapter读取数据。 <br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />问:什么是DataAdapter?<br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />答:DataAdapter对象在DataSet与数据之间起桥梁作用<br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" /><br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />string strConn="uid=账号;pwd=密码;database=数据库;server=服务器";//SQL Server链接字符串<br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />SqlConnection ConnSql=new SqlConnection (strConn); //Sql链接类的<a target=_blank target="_blank" class="inner-link decor-none" href="http://zhidao.baidu.com/search?word=%E5%AE%9E%E4%BE%8B%E5%8C%96&fr=qb_search_exp&ie=utf8" rel="nofollow" style="text-decoration: none; color: rgb(202, 0, 0); transition: color 0s ease-out; -webkit-transition: color 0s ease-out; font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;">实例化</a><br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />ConnSql.Open ();//打开数据库<br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />string strSQL="SELECT * FROM 表名1 "; //要执行的SQL语句 <br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />SqlDataAdapter da=new SqlDataAdapter(strSQL,ConnSql); //创建DataAdapter数据适配器实例<br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />DataSet ds=new DataSet();//创建DataSet实例<br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />da.Fill(ds,"自定义虚拟表名");//使用DataAdapter的Fill方法(填充),调用SELECT命令<br style="font-family: 'Microsoft Yahei', 'Microsoft Yahei' !important; text-shadow: rgb(153, 153, 153) 0.01em 0.01em 0.01em !important;" />ConnSql.Close ();//关闭数据库
更多0
0 0
原创粉丝点击