上传数据库到AspSpider空间后,通过连接字符串连接放在空间的数据库
Data Source=.\SQLExpress;Persist Security Info=True;Integrated Security=SSPI;Initial Catalog=lanjackg2003_web
其中红色字表示我上传到服务器后的数据库,该格式为 用户名_原数据库名字
参考代码
SqlConnection sqlcnt;//打开的数据库
SqlCommand sqlcmd;//操作数据
string strconn = @"Data Source=.\SQLExpress;Persist Security Info=True;Integrated Security=SSPI;Initial Catalog=<span style="color:#FF0000;">lanjackg2003_web</span>";//AspSpider服务器数据库
string sql = string.Format("select count(*) from Info");//返回表的总数
string strRes = "";
try
{
sqlcnt = new SqlConnection(strconn);
sqlcnt.Open();
sqlcmd = new SqlCommand(sql, sqlcnt);
Int32 count = (Int32) sqlcmd.ExecuteScalar();
sqlcmd.CommandText = String.Format("select * from Info where code = '{0}'", Request.QueryString["code"].ToString());
SqlDataReader reader = sqlcmd.ExecuteReader();
while (reader.Read())
{
strRes += reader[0] + " " + reader[1] + " " + reader[2];
}
sqlcnt.Close();
}
catch (Exception)
{
Response.ContentType = "application/json"; //返回给前台是JSON数据
Response.Write("Error");
Response.End();
}