DataTbale中的参数方法怎么写？

Question

public DataTable GetTable(string sql, params SqlParameter[] values)
        {
            DataTable dt = new DataTable();
            try
            {
                Open();
                SqlCommand cmd = new SqlCommand(sql, conn);
                cmd.Parameters.AddRange(values); 
                SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);
                
                adapter.Fill(dt);
                Close();
            }
            catch (Exception e)
            {
                message = e.Message;
            }
            return dt;
        }
帮我修改一下

Answer 1

你写的有问题，，
 cmd.Parameters.AddRange(values.ToArray());
 SqlDataAdapter adapter = new SqlDataAdapter(sql, conn);改成SqlDataAdapter adapter = new SqlDataAdapter();
adapter.selectCommand = cmd;就oK了
你去试试应该OK

Answer 2

SqlDataAdapter adapter = new SqlDataAdapter();
 adapter.selectCommand = cmd;

Answer 3

[code=csharp]public static int ExecNonQuery(string sqlString, SQLiteParameter[] param)
        {
           Adapter.SelectCommand = new SqlCommand(SqlString, connection);
           Adapter.SelectCommand.Parameters.Add(values);        
           Adapter.Fill(Table);[code]

Answer 4

Adapter.SelectCommand = new SqlCommand(SqlString, connection);
            Adapter.SelectCommand.Parameters.Add(values);        
            Adapter.Fill(Table);