SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MessageConnectionString"].ToString());
SqlConnection conMeg = new SqlConnection(ConfigurationManager.ConnectionStrings["MegConnectionString"].ToString());
conMeg.Open();
string ip = GetIP().ToString();
SqlCommand cmdMeg = new SqlCommand();
cmdMeg.Connection = conMeg;
cmdMeg.CommandText = "select * from GetIP where username='" + userName + "' and ipaddress='" + ip + "'";
SqlDataAdapter sdaMeg = new SqlDataAdapter();
sdaMeg.SelectCommand = cmdMeg;
cmdMeg.ExecuteNonQuery();
DataSet dsMeg = new DataSet();
sdaMeg.Fill(dsMeg, "GetIP");
conMeg.Close();
这样运行之后dsMeg中的记录数为0,但实际数据库里是有数据的