SqlConnection,SqlCommand,SqlDataAdaper的用法总结
来源:互联网 发布:小强呼死你软件免费版 编辑:程序博客网 时间:2024/05/16 06:35
SqlConnection,SqlCommand,SqldataReader的用法总结:
希望对新手有所帮助!!!
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//--------------------------------SqlConnection,SqlCommand,SqlDataAdaper的用法------------//
//下面的3种形式等价,如果你的数据库是Windows连接方法,直接把连接字符串改成"server=.;database=northwind;integrated security=true;"
//如果你的数据库是某个实例名,直接把"server=."改成"server=你的计算机名实例名"就可以了
//SqlConnection con = new SqlConnection("server=.;database=northwind;uid=sa;pwd=;");
//con.Open();
//SqlDataAdapter sda = new SqlDataAdapter("select * from customers", con);
//DataSet ds = new DataSet();
//sda.Fill(ds, "customers");
////下面这5个语句等价
////this.GridView1.DataSource = ds;
////this.GridView1.DataSource = ds.Tables[0];
////this.GridView1.DataSource = ds.Tables["customers"];
////this.GridView1.DataSource = ds.Tables[0].DefaultView;
//this.GridView1.DataSource = ds.Tables["customers"].DefaultView;
//this.GridView1.DataBind();
//con.Close();
//SqlConnection con = new SqlConnection("server=.;database=northwind;uid=sa;pwd=;");
//con.Open();
//SqlCommand cmd = new SqlCommand("select * from customers", con);
//SqlDataAdapter sda = new SqlDataAdapter();
//sda.SelectCommand = cmd;
//DataSet ds = new DataSet();
//sda.Fill(ds, "customers");
//this.GridView1.DataSource = ds.Tables["customers"].DefaultView;
//this.GridView1.DataBind();
//con.Close();
//SqlConnection con = new SqlConnection("server=.;database=northwind;uid=sa;pwd=;");
//con.Open();
//SqlDataAdapter sda = new SqlDataAdapter();
//sda.SelectCommand = new SqlCommand("select * from customers", con);
//DataSet ds = new DataSet();
//sda.Fill(ds, "customers");
//this.GridView1.DataSource = ds.Tables["customers"].DefaultView;
//this.GridView1.DataBind();
//con.Close();
}
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
//--------------------------------SqlConnection,SqlCommand,SqlDataAdaper的用法------------//
//下面的3种形式等价,如果你的数据库是Windows连接方法,直接把连接字符串改成"server=.;database=northwind;integrated security=true;"
//如果你的数据库是某个实例名,直接把"server=."改成"server=你的计算机名实例名"就可以了
//SqlConnection con = new SqlConnection("server=.;database=northwind;uid=sa;pwd=;");
//con.Open();
//SqlDataAdapter sda = new SqlDataAdapter("select * from customers", con);
//DataSet ds = new DataSet();
//sda.Fill(ds, "customers");
////下面这5个语句等价
////this.GridView1.DataSource = ds;
////this.GridView1.DataSource = ds.Tables[0];
////this.GridView1.DataSource = ds.Tables["customers"];
////this.GridView1.DataSource = ds.Tables[0].DefaultView;
//this.GridView1.DataSource = ds.Tables["customers"].DefaultView;
//this.GridView1.DataBind();
//con.Close();
//SqlConnection con = new SqlConnection("server=.;database=northwind;uid=sa;pwd=;");
//con.Open();
//SqlCommand cmd = new SqlCommand("select * from customers", con);
//SqlDataAdapter sda = new SqlDataAdapter();
//sda.SelectCommand = cmd;
//DataSet ds = new DataSet();
//sda.Fill(ds, "customers");
//this.GridView1.DataSource = ds.Tables["customers"].DefaultView;
//this.GridView1.DataBind();
//con.Close();
//SqlConnection con = new SqlConnection("server=.;database=northwind;uid=sa;pwd=;");
//con.Open();
//SqlDataAdapter sda = new SqlDataAdapter();
//sda.SelectCommand = new SqlCommand("select * from customers", con);
//DataSet ds = new DataSet();
//sda.Fill(ds, "customers");
//this.GridView1.DataSource = ds.Tables["customers"].DefaultView;
//this.GridView1.DataBind();
//con.Close();
}
以上四种方法都可以把数据库中的数据读出来,绑定到GridView控件!!!
- SqlConnection,SqlCommand,SqlDataAdaper的用法总结
- SqlConnection,SqlCommand,SqlReader,SqlDataAdaper的用法总结!!
- SqlConnection,SqlCommand,SqlReader,SqlDataAdaper的用法总结!!
- SqlConnection,SqlCommand,SqlDataAdaper的用法总结
- SqlConnection,SqlCommand,SqldataReader的用法总结
- SqlConnection,SqlCommand,SqldataReader的用法总结:
- SqlConnection,SqlCommand,SqldataReader的用法总结:
- [转载]SqlConnection,SqlCommand,SqldataReader的用法总结:
- SqlConnection,SqlCommand,SqldataReader的用法总结:
- (转)SqlConnection,SqlCommand,SqldataReader的用法总结:
- sqlconnection,sqldataadapter,sqlcommand的区别
- 理解SqlConnection,SqlCommand,SqldataReader
- SqlConnection,SqlCommand,SqldataReader
- SqlConnection,SqlDataAdapter,SqlCommand,SqlParameter
- SqlCommand.CommandTimeout 和 SqlConnection.ConnectionTimeout 这两个的区别
- Sqlconnection,sqlcommand,和List和Arraylist的区别
- sqlconnection, sqlcommand, sqltransaction,SqlParameter连接数据库的几个对象使用
- sqlconnection,sqlcommand,sqldataadapter,sqldatareader,dataset的关系详解
- 最新流氓网站8749病毒专杀工具下载
- sql 语句group by
- SqlConnection,SqlCommand,SqldataReader的用法总结
- 网站做测试自动化
- 什么时候,我们要设计Copy构造函数
- SqlConnection,SqlCommand,SqlDataAdaper的用法总结
- 初学MySql5 所应了解的知识和常见问题
- 一些自己常用的封装的代码
- mysql在linux中安装与使用
- ListCtrl显示不同类型文件图标
- [收藏][杂谈]Google 广告收入计算公式猜想
- 加班(续)
- asp.net 2.0 中的 三层
- Symbian DBMS中的检索