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 ?......
解决方案 »
- validate.js select验证
- 我是新手问一个关于DropDownList得问题
- 如果取消JS报错
- 水晶报表10出现了“无效的类别字符串”错误
- 急急!!如何用datagrid显示树刑的数据,无限分级的!!
- 实现一个自己在网站上面已经注册了,有一个邀请好友注册连接加积分,不能邀请自己在去注册加积分。
- 在asp.net中如何用动态数据使用TreeView,vb.net语言。快帮忙!
- 请问怎样实现象php、asp一样的自定义表格,而不用datagrid
- window 2003 服务器配置 asp.net的问题
- 急急急,求助大神,利用AutoMapper将DataReader转换成List失败
- 小小问题,也有小小的分,不成敬意。
- .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();