经常忘记的东西！DataTable mytab = this.Get_Dt(sql)...

private void xmlBind(string sortid,string sType)
  {
   string mystr = "";
   string sql = "";
   string gc;
   if(sType == "1")
   {
    gc=sortid.Substring(0,2);
    sql ="SELECT DISTINCT 行政区代码 as id,名称1 as sname FROM 行政编码 WHERE (名称1 IS NOT NULL) AND (名称2 IS NULL) AND (行政区代码 like '" + gc +"%')";
   }
   else
   {
    gc=sortid.Substring(0,4);
    SqlDataReader dr=this.quhao(gc);
    dr.Read();
    TextBox5.Text=dr["区号"].ToString();
    dr.Close();    
    sql = "SELECT DISTINCT 行政区代码 as id,名称2 as sname FROM 行政编码 WHERE (名称2 IS NOT NULL) AND (行政区代码 like '" + gc+"%')";
   }
   

   DataTable mytab = this.Get_Dt(sql);

   //将取到的值形成: ID|名称,ID|名称...这样的形式
   if(mytab.Rows.Count != 0)
   {
    for(int i=0;i<mytab.Rows.Count;i++)
    {
     mystr += "," + mytab.Rows[i]["id"].ToString() + "|" + mytab.Rows[i]["sname"].ToString();
    }
    mystr = mystr.Substring(1);
   }
   //输出页面
   this.Response.Write(mystr); 
   this.Response.End();
  }

private DataTable Get_Dt(string sql)
  {
   SqlConnection conn=new SqlConnection();
   //数据库连接串,本数据库为ACCESS数据库,当前在本目录的根目录下
   string connString = "Server=192.168.0.7;User id=sa;pwd=longwang;database=word";
   conn = new SqlConnection(connString);
   //打开数据库
   conn.Open();
   
   SqlDataAdapter myAdp = new SqlDataAdapter(sql,conn);
   DataTable myDt = new DataTable();
   
   try
   {
    //填充数据
    myAdp.Fill(myDt);
    //返回数据集
    return(myDt);
   }
   catch(SqlException ex)
   {
    //显示错误信息
    throw ex;
   }
   finally
   {
    //关闭数据库连接
    conn.Close();
   }
  }

private SqlDataReader quhao(string gg)
  {
   SqlConnection conn=db.cn();
   conn.Open();
   SqlCommand cmd=new SqlCommand();
   cmd.Connection=conn;
   cmd.CommandText="SELECT * FROM 行政编码 WHERE 行政区代码 LIKE '"+gg+"%'";
   SqlDataReader dr=cmd.ExecuteReader();   
   return dr;
  }

转载于:https://www.cnblogs.com/wzhxj/archive/2005/12/22/302702.html