救救我吧，实在搞不定，这方法哪错了？

[crazynet2011]

   var tb = SQLHelper.GetTable("select * from bjx_zt");

    /// <summary>
    /// 返回指定Sql语句的DataTable
    /// </summary>
    /// <param name="strSql">传入的Sql语句</param>
    /// <returns>DataTable</returns>
    public static DataTable GetTable(string strSql)
    {
        SqlDataAdapter da = new SqlDataAdapter();
        DataTable datatable = new DataTable();
        try
        {
            using (SqlConnection connection = new SqlConnection(StrConn))
            {

                using (SqlCommand cmd = new SqlCommand(strSql, connection))
                {
                    try
                    {
                        connection.Open();
                        cmd.CommandType = CommandType.Text;
                        da.SelectCommand = cmd;
                        da.Fill(datatable);
                    }
                    catch
                    {
                        connection.Close();
                    }
                }
            }
        }
        catch { }
        return datatable;
    }

这怎么老返回空呢，
我表里有内容， 数据库链接也没错，求救大牛....

[cs_esharp]

/// <summary>
/// 返回指定Sql语句的DataTable
/// </summary>
/// <param name="strSql">传入的Sql语句</param>
/// <returns>DataTable</returns>
public static DataTable GetTable(string strSql)
{
DataTable datatable = new DataTable();
try
{
using (SqlDataAdapter adapter = new SqlDataAdapter(strSql,StrConn))
{
DataSet ds = new DataSet();
adapter.Fill(ds);
datatable = ds.Tables[0];
}
}
catch { }
return ds;
}

[crazynet2011]

da.SelectCommand = cmd;

这这句话有问题，还是少写什么了...

[堆代码的爱因斯坦]

SqlConnection conn = new SqlConnection(sqlConnectionString);

conn.Open();

SqlCommand cmd = new SqlCommand();

cmd.Connection = conn;

cmd.CommandType = CommandType.Text;

cmd.CommandText = commandText;

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataSet ds = new DataSet();

try

{

da.Fill(ds);

}

[pz25925]

貌似没错，看下是否是数据库的原因？

[crazynet2011]

[Quote=引用 3 楼 pz25925 的回复:]

貌似没错，看下是否是数据库的原因？
[/Quote]
数据库没错，我自己写添加就没问题，用这个方法就不行，我可以用别的方法实现，不过我就是郁闷，这个方法为什么不行，哪里有问题

[波仔]

using (SqlConnection connection = new SqlConnection(StrConn))
{

try
{
da=new SqlDataAdapter(strSql, connection);
da.Fill(datatable);
}
catch
{
connection.Close();
}

}

[波仔]

不好意思,搞错了

try
{
da=new SqlDataAdapter(strSql, StrConn);
da.Fill(datatable);
}
catch
{
connection.Close();
}

[shenloveeveryone]

肯定不是数据库问题，要不然就报错了

[代码小天王]

既然用了using了 还用try catch 多此一举

[暖枫无敌]

    /// <summary>
    /// 返回指定Sql语句的DataTable
    /// </summary>
    /// <param name="strSql">传入的Sql语句</param>
    /// <returns>DataTable</returns>
    public static DataTable GetTable(string strSql)
    {
        DataTable datatable = new DataTable();
        try
        {
            using (SqlConnection connection = new SqlConnection(StrConn))
            {
                  SqlDataAdapter adapter = new SqlDataAdapter(strSql,connection);
                  DataSet ds = new DataSet();
                  adapter.Fill(ds);
                  datatable  = ds.Tables[0];
            }
        }
        catch { }
        return ds;
    }