请教一个问题关最大值的问题!!

[great388]

麻烦各位高人帮我看下这写的语句行不行咯?
谢谢了!
SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["ConnectionString"]);
string mySelectQuery1 = "SELECT max(id) FROM[UpLoad]";
SqlCommand myCommand1 = new SqlCommand(mySelectQuery1, conn);
conn.Open();
SqlDataReader myReader1 = myCommand1.ExecuteReader();
myReader1.Close();
conn.Close();
int Filename=mySelectQuery1++;

[great388]

出现一个这样的错!
编译错误
说明: 在编译向该请求提供服务所需资源的过程中出现错误。请检查下列特定错误详细信息并适当地修改源代码。

编译器错误信息: CS0029: 无法将类型“string”隐式转换为“int”

源错误:



行 53: myReader1.Close();
行 54: conn.Close();
行 55: int Filename=mySelectQuery1;
行 56: if (fileName != "")

[great388]

请问应怎样改才行咯!

麻烦了!

[fencole]

int Filename=mySelectQuery1++;
你的mySelectQuery1是字符串。
改为int Filename=(int.parse(mySelectQuery1))++;

[sunchaohuang]

string mySelectQuery1 ＝ "SELECT max(id) FROM[UpLoad]";

怎么能mySelectQuery1 ++呢？

[myminimouse]

int Filename=(Convert.ToInt32(mySelectQuery1))++;

[shoutor]

类型转换错误嘛

int 怎么能跟 string　类型直接操作呢

[shoutor]

int Filename=mySelectQuery1++;

mySelectQuery1是一段sql语句，执行sql语句后，并没有赋值

[luqinghua]

SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["ConnectionString"]);
string mySelectQuery1 = "SELECT max(id) FROM[UpLoad]";
SqlCommand myCommand1 = new SqlCommand(mySelectQuery1, conn);
conn.Open();
SqlDataReader myReader1 = myCommand1.ExecuteReader();
if(myReader1.Read())
{
int Filename=int.Parse(myReader1.GetValue(0).ToString());
}
myReader1.Close();
conn.Close();