读书人

关于Access:ASP可将视图当存储过程用

发布时间: 2012-01-10 21:26:51 作者: rapoo

关于Access:ASP可将视图当存储过程用,ASP.NET怎么写法?
如题
谢谢!

[解决办法]
OleDbConnection conn = new OleDbConnection(conntionstring);
OleDbCommand cmd = conn.CreateCommand();
cmd.CommandText = "select * from table where ID=@id ";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add( "@id ", OleDbType.Integer).Value = 100;
conn.Open();
........
[解决办法]
不好意思,发错了.
OleDbConnection conn = new OleDbConnection(conntionstring);
OleDbCommand cmd = conn.CreateCommand();
cmd.CommandText = "查询名 ";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add( "@id ", OleDbType.Integer).Value = 100;
conn.Open();
........

读书人网 >asp.net

热点推荐