联接SQL
using System.Data.SqlClient;
... ...
DataSet ds=new DataSet("XMLProducts");
//连接SQL Server数据库
SqlConnection conn=new SqlConnection(@"server=glf;uid=sa;pwd=;database=northwind");
SqlDataAdapter da=new SqlDataAdapter("SELECT * FROM products",conn);
//绑定DataGrid控件
da.Fill(ds,"products");联接MySQL
1.安装Microsoft ODBC.net。
2.安装MySQL的ODBC驱动程序。
2.解决方案管理中添加引用Microsoft.Data.Odbc.dll(1.0.3300)
3.代码中增加引用
using Microsoft.Data.Odbc;
4.编写代码
string MyConString = "DRIVER={MySQL ODBC 3.51 Driver};" +
"SERVER=localhost;" +
"DATABASE=samp_db;" +
"UID=root;" +
"PASSWORD=;" +
"OPTION=3";
//Connect to MySQL using Connector/ODBC
OdbcConnection MyConnection = new OdbcConnection(MyConString);
MyConnection.Open();
Console.WriteLine("\n !!! success, connected successfully !!!\n");
MyConnection.Close();联接Access
OleDbConnection myConn=new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Application.StartupPath+"\\First.mdb;");
myConn.Open();
using System.Data.SqlClient;
... ...
DataSet ds=new DataSet("XMLProducts");
//连接SQL Server数据库
SqlConnection conn=new SqlConnection(@"server=glf;uid=sa;pwd=;database=northwind");
SqlDataAdapter da=new SqlDataAdapter("SELECT * FROM products",conn);
//绑定DataGrid控件
da.Fill(ds,"products");联接MySQL
1.安装Microsoft ODBC.net。
2.安装MySQL的ODBC驱动程序。
2.解决方案管理中添加引用Microsoft.Data.Odbc.dll(1.0.3300)
3.代码中增加引用
using Microsoft.Data.Odbc;
4.编写代码
string MyConString = "DRIVER={MySQL ODBC 3.51 Driver};" +
"SERVER=localhost;" +
"DATABASE=samp_db;" +
"UID=root;" +
"PASSWORD=;" +
"OPTION=3";
//Connect to MySQL using Connector/ODBC
OdbcConnection MyConnection = new OdbcConnection(MyConString);
MyConnection.Open();
Console.WriteLine("\n !!! success, connected successfully !!!\n");
MyConnection.Close();联接Access
OleDbConnection myConn=new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Application.StartupPath+"\\First.mdb;");
myConn.Open();
找本介绍ado.net的书,上面都有
using System.Data.SqlClient;string sConn = "Data Source=(local);Initial Catalog=NCMT;User ID=sa;Password=;Persist Security Info=False;";
SqlConnection conn = new SqlConnection(sConn);
string sSql = "Select * From T_UserTechData";
SqlDataAdapter apt = new SqlDataAdapter(sSql,conn);
DataSet ds = new DataSet();
try
{
//填充数据集
apt.Fill(ds,"dtTechData"); //创建数据表和数据视图
DataTable dtTechData = ds.Tables[0];
DataView dv = dtTechData.DefaultView;
//按指定的字段排序
dv.Sort = sSortView;
lblCount.Text = dv.Count.ToString(); //绑定数据
dgTechData.DataSource = dv;
dgTechData.DataBind();
}
catch(Exception ex)
{
Response.Write(ex.Message);
}Access 数据库的连接与此类似,不过的导入名称空间:
using System.Data.OldDb;
http://www.asp.net/Default.aspx?tabindex=0&tabid=1
找个例子看看
SqlConnection con1;
SqlCommand scmd1;
SqlCommand scmd2;
SqlDataAdapter adap1;
DataSet dset1;
protected System.Web.UI.WebControls.DataGrid dg1;
con1=new SqlConnection(@"data source=pp\pp;user id=s03;password=s03;database=s03");
con1.Open();
scmd1=new SqlCommand("select * from ClassTable",con1);
adap1=new SqlDataAdapter();
adap1.SelectCommand=scmd1;
dset1=new DataSet();
adap1.Fill(dset1);
dg1.DataSource =dset1.Tables[0];
dg1.DataBind();
先找到控制面板上的管理工具中的数据源ODBC,打开后,先切换到“系统DSN”选项,单击添加,就看到“创建新数据源”对话框,选择MICROSOFT ACCESS DRIVER(*.MDB)驱动程序之后,单击“完成”,在随后的对话框中在“数据源名”中输入WEBDATABASE,并在“说明”中输入“ASP。NET网页数据库”,在单击“选择”按钮,在随后的选择数据库对话框中,将目录切换到ACCESS数据库文件的目录,并选择创建的数据库名称,再按“确定”即可,回到前一个画面,也按“确定”,就可了。
在程序中也需要声明:
<%@ Import NameSpace="System.Data" %>
<%@ Import NameSpace="System.Data.Oledb" %>
<% Response.Expires=0 %>
<html>
<head>
<Script Language="vb" runat="server">
sub page_load(obj as object,e as eventargs)
dim dsn as string,tsql as string
'设置使用联机字符串
dsn="provider=microsoft.jet.oledb.4.0;data source=" & server.mappath("数据库的路径") & ";"
’设置SQL语句
tsql="select * from 表名"
后面就由你自己决定要做什么了,包括上面的SQL语句