ADO.NET

Question

用sql语句从数据库查询的数据执行的时候怎么能返回datatableADO.NET数据库SQL

Answer 1

refer:
 public DataTable ExecuteQuery(string sql)
        {
            using (SqlConnection sqlConnection = new SqlConnection())
            {
                sqlConnection.ConnectionString = "server=.;database=test;uid=sa;pwd=123456;";
                sqlConnection.Open();                SqlCommand sqlCommand = new SqlCommand(sql, sqlConnection);
                SqlDataAdapter sda = new SqlDataAdapter(sqlCommand);
                DataSet ds = new DataSet();
                sda.Fill(ds);
                return ds.Tables[0];
            }
        }

Answer 2

https://www.google.com.hk/search?q=ado.net+%E5%A2%9E%E5%88%A0%E6%94%B9%E6%9F%A5&oq=ado.net+%E5%A2%9E%E5%88%A0%E6%94%B9%E6%9F%A5&aqs=chrome.0.69i57j69i60j69i61l2j0l2.206j0&sourceid=chrome&ie=UTF-8