dim Sqlserver as string = "server=localhost;uid=用户名;pwd='密码';database=company_data"
Dim conn AS SqlConnection
Dim Sql AS String
Sql = "Select * from ......"
conn = New SqlConnection(Sqlserver)
Dim dbComm AS SqlDataAdapter
dbComm = New SqlDataAdapter(Sql,conn)
dbComm.Fill(ds,"tb_employee")
dg.DataSource = ds.Tables("tb_employee").DefaultView
dg.DataBind()this can connect ,and bind data ,
define id of dagagrid as dg then you can show data on page .
ok ?......
Dim conn AS SqlConnection
Dim Sql AS String
Sql = "Select * from ......"
conn = New SqlConnection(Sqlserver)
Dim dbComm AS SqlDataAdapter
dbComm = New SqlDataAdapter(Sql,conn)
dbComm.Fill(ds,"tb_employee")
dg.DataSource = ds.Tables("tb_employee").DefaultView
dg.DataBind()this can connect ,and bind data ,
define id of dagagrid as dg then you can show data on page .
ok ?......
解决方案 »
- 如何在客户端判断上传文件大小~不要网上搜的。。求高人~!
- 各位大侠,请问我这样写有什么错吗?
- 回车无法触发submit按钮脚本的问题
- 一个页面怎么去修改另一个页面上的内容
- 请问Microsoft Visual Studio.NET 2005与Microsoft Visual Studio 2005的区别
- |M| 一个HTML在线编辑器 怎么在服务器获取他的值 http://www.kindsoft.net/
- ICollection,IList,IDictionary 有什么区别?
- 一个新手问题,希望大家帮下忙
- asp.net在VS上可以访问数据库,但是在IIS上却访问不了数据库
- string strNumber= e.Item.Cells[1].Text;数据库更新数据无效???
- 小小问题,也有小小的分,不成敬意。
- .Net下用哪种连接比较好,是oledb还是oracleclient?
OleDbConnection myConnection = new OleDbConnection( connDB );
myConnection.Open();
string strSql = "Select id, u_name from yh";
OleDbCommand myCommand = new OleDbCommand( strSql, myConnection );
OleDbDataReader myReader = myCommand.ExecuteReader();
ConSet是你的数据库连接参数
string strcon = "server=yourname;database=company_data;id=sa,pwd=";
string sql = "SELECT FirstName, LastName, Country FROM Employees";
SqlConnection con = new SqlConnection(strcon);
SqlDataAdapter com = new SqlDataAdapter(sql);
con.Open();
DataSet ds = new DataSet();
com.Fill(ds,"Tab");
DataGrid1.Datasource = ds.Table["Tab"].DefaultView;
DataGrid1.DataBind();
con.Close();