sqldatasource能这样使用么，select方法报错

houyichong 2011-03-26 02:53:05

protected void btn_ok_Click(object sender, EventArgs e)
{
string strDate1 = "";
string strDate2 = "";
string htbh = "";
string nkxh = "";
string strSQL="select top 100 xdrq,htbh,khbh,khmc,khdm,jhrqt,sjrqt,pcrq,fhrq,nkxh,ph,gd,htsl,dw,jgdj,nklb,bz,bz2,bzyq" +
" from t_LDWC_CXB where 1=1";
strDate1 = txt_date1.Text.Trim();
strDate2 = txt_date2.Text.Trim();
htbh = txt_htbh.Text.Trim();
nkxh = txt_nkxh.Text.Trim();
if (strDate1 != "")
strSQL = strSQL + " and pcrq>='" + strDate1 + "' and pcrq<='" + strDate2 + "'";
if (htbh != "")
strSQL = strSQL + " and htbh like '" + htbh + "%'";
if (nkxh != "")
strSQL = strSQL + " and nkxh like '" + nkxh + "%'";
sds_cx.SelectCommand = strSQL;
sds_cx.Select;---------------------------------------------------------------------------------

}

...全文

335 9 打赏收藏转发到动态举报

写回复

用AI写文章

9 条回复

切换为时间正序

请发表友善的回复…

发表回复

houyichong 2011-03-28

打赏
举报

你们在使用gridview,sqldatasource在界面操作使用的时候配置数据源的时候，直接写入sql语句就可以生成结果集，于是我就想呀，我把sql拼出来，然后赋予sqldatasource的selectcommand，然后调用方法跑一下就很快得到结果集了，楼上的方法我知道

子夜__ 2011-03-26

打赏
举报

[Quote=引用 6 楼 houyichong 的回复:]

怎么用select 这个方法啊
[/Quote]
把你的SQL传入里就行了

/// <summary>

        /// 执行有参的查询 返回DataTable

        /// </summary>

        /// <returns>返回DataTable</returns>

        public static DataTable ReturnDataTable(string cmdtext)

        {

            SqlConnection cn = new SqlConnection();

            cn.ConnectionString = "数据库连接字符串";

            DataTable dt = new DataTable();

            SqlCommand cmd = new SqlCommand();

            cmd = new SqlCommand(cmdtext, cn);

            cmd.CommandType = CommandType.Text; ;

            SqlDataReader dr = null;

            using (dr = cmd.ExecuteReader(CommandBehavior.CloseConnection))

            {

                dt.Load(dr);

            }

            return dt;

           

        }