我们如何在sqlcommand中填充数据表。 [英] How can we fill data table in sqlcommand.

问题描述

我们如何在sqlcommand中填充数据表。

How can we fill data table in sqlcommand.

推荐答案

尝试：

Try:

using (SqlConnection con = new SqlConnection(strConnect))
    {
    con.Open();
    using (SqlDataAdapter da = new SqlDataAdapter("SELECT MyColumn1, MyColumn2 FROM myTable", con))
        {
        DataTable dt = new DataTable();
        da.Fill(dt);
        ...
        }
    }

这是填充sql数据表的通用代码命令为：

Here is the generic code to fill data table for sql command as:

public static DataTable GetDataTable(SqlCommand cmd)
{
    try
    {
        SqlDataAdapter dataAdapt = new SqlDataAdapter();
        dataAdapt.SelectCommand = cmd;
        DataTable dataTable = new DataTable();
        dataAdapt.Fill(dataTable);
        return dataTable;
        
    }
    catch (SqlException ex)
    {
        MessageBox.Show(ex.Message);
    }
    catch (Exception ex)
    {
        MessageBox.Show(ex.Message);
    }
}

what about this one ?

string constr = @"Data Source=.;Initial Catalog=test;Integrated Security=True";
SqlConnection con = new SqlConnection(constr);
con.Open();
SqlDataAdapter adpt = new SqlDataAdapter("select * from  Items",con);
DataTable dt = new DataTable();
adpt.Fill(dt);

这篇关于我们如何在sqlcommand中填充数据表。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！