这个函数错在哪啊 ？？？谢谢赐教

Question

    protected void SetDate(DropDownList ddTist)
    {
        SqlConnection connTmp;
        DataSet dsTmp;
        SqlDataAdapter daTmp;
        try
        {
            connTmp = new SqlConnection();            connTmp.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
            dsTmp = new DataSet();
            connTmp.Open();
            daTmp = new SqlDataAdapter("select distinct(sheng) from [地名表]", conn);
            
            daTmp.Fill(dsTmp, "sheng");
            ddTist.Items.Clear();
            ddTist.DataTextField = "sheng";
            ddTist.DataValueField = "sheng";
            ddTist.DataSource = dsTmp.Tables["sheng"];
            ddTist.DataBind();
        }
        finally
        {
            daTmp.Dispose();
            dsTmp.Dispose();
            connTmp.Close();
            
            connTmp.Dispose();
        }
    }
这个函数错在哪啊 ？？？谢谢赐教

Answer 1

using(SqlConnection connTmp= new SqlConnection(""))
{}
SqlDataAdapter("select distinct(sheng) as sheng   from [地名表]", conn);

Answer 2

硬是看不清，就catch(Exception e)
{
Console.WriteLine("message: "+e.message); }

Answer 3

connTmp.Open();        connTmp.Close();
这两句是非必要的. SqlDataAdapter是非持续连接,它自动打开关闭数据库.看不出来有撒错

Answer 4

设个断点看一下
感觉是这句出错了
daTmp = new SqlDataAdapter("select distinct(sheng) from [地名表]", conn);

Answer 5

daTmp = new SqlDataAdapter("select distinct(sheng) from [地名表]", conn);这里是不是应该是connTmp???

Answer 6

select distinct sheng from [地名表]
试试、

Answer 7

try
{}
catch
{}

Answer 8

daTmp = new SqlDataAdapter("select distinct(sheng) from [地名表]", conn);
conn应该是connTmp