怎样调用Access的查询?(C#+ASP.NET) 如题。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 类似于SQL Server里面的视图吧。你直接把它当作一个表名,进行查询就可以了。和你对表进行查询一样。 如:SqlConnection objCon=new SqlConnection(strDB);SqlCommand objCmd=new SqlCommand("yourQueryName",objCon);....上面的yourQueryName为你在ACCESS中的查询名. to: pingnt回答問題也不思考Access使用Sqlconnection嗎? to: pingnt回答問題也不思考Access使用Sqlconnection嗎? 呵呵另外不知道 private OleDbCommand m_AccessCmd = null;m_AccessCmd = new OleDbCommand(commandText);m_AccessCmd.CommandType = CommandType.StoredProcedure;m_AccessCmd.CommandTimeout = 180;DataSet dsRetVal = null;using(OleDbConnection con = new OleDbConnection(m_connStr)){con.Open();m_AccessCmd.Connection = con;dsRetVal = new DataSet();OleDbDataAdapter adapter = new OleDbDataAdapter(m_AccessCmd);adapter.Fill(dsRetVal);adapter.Dispose();} private OleDbCommand m_AccessCmd = null;m_AccessCmd = new OleDbCommand(commandText);m_AccessCmd.CommandType = CommandType.StoredProcedure;m_AccessCmd.CommandTimeout = 180;DataSet dsRetVal = null;using(OleDbConnection con = new OleDbConnection(m_connStr)){con.Open();m_AccessCmd.Connection = con;dsRetVal = new DataSet();OleDbDataAdapter adapter = new OleDbDataAdapter(m_AccessCmd);adapter.Fill(dsRetVal);adapter.Dispose();} 有人做过类似在线客服的吗 asp.net发布网站问题 Asp.Net 中 怎样获取上一页的Request 对象 ASP.NET2.0中如何实现网站动态换肤? gridview 追加自定义列问题 一个郁闷的问题 在js里如何的到页面所传的值,用session 解决立即给分! 对数据库的读和更新,这个问题如何实现? 用存储过程存储text型字段的问题? 如何把一个页面的DataGrid或DataTable中选择的一行或多行数据传递给另一页面显示? 立即结帐!!在asp.net中如何上传图片代码如何实现?? 急,在asp.net中,我想弹出一个对话框,
SqlConnection objCon=new SqlConnection(strDB);
SqlCommand objCmd=new SqlCommand("yourQueryName",objCon);
....
上面的yourQueryName为你在ACCESS中的查询名.
Access使用Sqlconnection嗎?
Access使用Sqlconnection嗎?
呵呵
另外不知道
m_AccessCmd = new OleDbCommand(commandText);
m_AccessCmd.CommandType = CommandType.StoredProcedure;
m_AccessCmd.CommandTimeout = 180;
DataSet dsRetVal = null;
using(OleDbConnection con = new OleDbConnection(m_connStr))
{
con.Open();
m_AccessCmd.Connection = con;
dsRetVal = new DataSet();
OleDbDataAdapter adapter = new OleDbDataAdapter(m_AccessCmd);
adapter.Fill(dsRetVal);
adapter.Dispose();
}
m_AccessCmd = new OleDbCommand(commandText);
m_AccessCmd.CommandType = CommandType.StoredProcedure;
m_AccessCmd.CommandTimeout = 180;
DataSet dsRetVal = null;
using(OleDbConnection con = new OleDbConnection(m_connStr))
{
con.Open();
m_AccessCmd.Connection = con;
dsRetVal = new DataSet();
OleDbDataAdapter adapter = new OleDbDataAdapter(m_AccessCmd);
adapter.Fill(dsRetVal);
adapter.Dispose();
}