如何在ASP.NET C＃中从SQL Server到GridView中选择数据

凯恩·史密斯

我如何选择要显示在带有按钮的gridview中的数据对不起，我真的很困惑寻求帮助T> T

private void button1_Click(object sender, EventArgs e)
{
    SqlConnection objConn = new SqlConnection();
    SqlCommand objCmd = new SqlCommand();
    string strConnString = null;
    string strSQL = null;

    strConnString = "Server=localhost;UID=sa;PASSWORD=1234;Database=Machining;Max Pool Size=400;Connect Timeout=600;";
    objConn.ConnectionString = strConnString;
    objConn.Open();

    //    int intNumRows = 0;
    strSQL = "SELECT * FROM ADMS_Machining = ";
    SqlDataAdapter sda = new SqlDataAdapter(strSQL);
    DataSet ds = new DataSet();
    sda.Fill(ds);

    GridView1.DataSource = ds;
    GridView1.DataBind();

    sda.ExecuteNonQuery();
    objConn.Close();
}

和web.config：

<connectionStrings>
    <add name="ApplicationServices"
         connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnetdb.mdf;User Instance=true"
         providerName="System.Data.SqlClient" />
</connectionStrings>

苏拉杰·什雷斯塔（Suraj Shrestha）

private void button1_Click(object sender, EventArgs e)
{

    string strConnString = ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString;
    SqlConnection objConn = new SqlConnection(strConnString);

    string strSQL = "SELECT * FROM ADMS_Machining ";
    SqlDataAdapter sda = new SqlDataAdapter(strSQL, objConn);
    DataSet ds = new DataSet();
    sda.Fill(ds);

    GridView1.DataSource = ds;
    GridView1.DataBind();

}

本文收集自互联网，转载请注明来源。

如有侵权，请联系 [email protected] 删除。