string rt=null;
SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["zLSz_MySql"]);
SqlDataAdapter Sda = new SqlDataAdapter("SELECT Max(SCID) FROM StairClass",conn);
DataTable dt = new DataTable();
Sda.Fill(dt);
if(rt!="")
{
string strOne = rt.Substring(0,3);
string strTwo = rt.Substring(3,2);
int i = Convert.ToInt32(strTwo)+1;
string ID = "0"+i;
string IDOne = ID.Substring(ID.Length-2);
rt = strOne+IDOne;
}
else
{
rt = "SC_01";
}
return rt;错误提示:对象”StairClass“ 无效 为什么?
我在查询分析器里面执行可以
SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["zLSz_MySql"]);
SqlDataAdapter Sda = new SqlDataAdapter("SELECT Max(SCID) FROM StairClass",conn);
DataTable dt = new DataTable();
Sda.Fill(dt);
if(rt!="")
{
string strOne = rt.Substring(0,3);
string strTwo = rt.Substring(3,2);
int i = Convert.ToInt32(strTwo)+1;
string ID = "0"+i;
string IDOne = ID.Substring(ID.Length-2);
rt = strOne+IDOne;
}
else
{
rt = "SC_01";
}
return rt;错误提示:对象”StairClass“ 无效 为什么?
我在查询分析器里面执行可以
<add key="zLSz_MySql" value="Server=DESIGN6;DataBase=SunAdorn;uID=sa;Pwd=" />
</appSettings>
<add key="connectionStrings" value="server=(local);uid=sa;pwd=;database=pubs"/>
</appSettings>----------------------------------------------------------------------------------------
string connString = System.Configuration.ConfigurationManager.AppSettings["connectionStrings"].ToString();
string cmdText = "select * from titles ";
SqlConnection conn = new SqlConnection(connString);
SqlDataAdapter adp = new SqlDataAdapter(cmdText, conn);
DataSet ds = new DataSet();
adp.Fill(ds);