62,046
社区成员
发帖
与我相关
我的任务
分享
public int ReturnE1(string id)//返回e1
{
SqlConnection conn = new SqlConnection();
string css = ConfigurationManager.ConnectionStrings["asp"].ConnectionString;
conn.ConnectionString = css;
id = DropDownList1.SelectedValue.ToString();
string sq = "select e1 from testt where id='" + id + "'";
conn.Open();
SqlDataAdapter sda = new SqlDataAdapter(sq, conn);
DataSet ds = new DataSet();
sda.Fill(ds);
if (ds.Tables.Count == 1 && ds.Tables[0].Rows.Count == 0) return -1;//kong
else return 1;
ds.Clear();
conn.Close();
conn.Dispose();
}