mycommand.Parameters("@project_id").Value="Request.QueryString("id")"语句问题,Request.QueryString("id")该如何转换?

Question

mycommand.Parameters("@project_id").Value="Request.QueryString("id")"语句问题,Request.QueryString("id")直接用数字代替就行了!请问Request.QueryString("id")该如何转换?

Answer 1

System.Convert.ToInt32(Request.QueryString("id"))

Answer 2

mycommand.Parameters("@project_id").Value=Request.QueryString("id")
上面这不行吗？那这样：
mycommand.Parameters("@project_id").Value=Int32.Parse(Request.QueryString("id"))

Answer 3

代码如下:
Dim mycommand As New SqlCommand("get_project_statuslist",conn)
mycommand.CommandType = CommandType.StoredProceduremycommand.Parameters.Add(New SqlParameter("@project_id",SqlDbType.int,4))
mycommand.Parameters("@project_id").Value=Convert.ToInt32(Request.QueryString("id"))
sqladapter=New SqlDataAdapter(mycommand)
  mydataset=New DataSet
sqladapter.fill(mydataset,"statuslist")提示错误:sqladapter.fill(mydataset,"statuslist")   ","附近有语法错误
请问是什么问题?

Answer 4

mycommand.Parameters("@project_id").Value=Convert.ToInt32(Request.QueryString["id"]);

Answer 5

int i=int.Parse(Request.QueryString("id"));
如果多就用
Int32.Parse(Request.QueryString("id"));