请问一下用vb中查询sqlsever语句怎么写,谢谢

[courm]

rt

[bing0804]

//c# code

//定义一个连接
System.Data.SqlClient.SqlConnection sqlcon = new System.Data.SqlClient.SqlConnection("server=;database=;uid=;pass=");

//定义查询命令
System.Data.SqlClient.SqlCommand sqlcommand = new System.Data.SqlClient.SqlCommand(sqlcon,"select * from tablename");
//定义数据适配器
System.Data.SqlClient.SqlDataAdapter sqladapter = new System.Data.SqlClient.SqlDataAdapter(sqlcommand);
//填充表
DataTable dt = new DataTable();
sqladapter.Fill(dt);

[yjl1393422]

dim rst as new adodb.recordset
dim cn as new adodb.connection
建立连接
rst.open"select * from 表名 where 条件",cn,打开方式