如何在ASPX页面中编写SQL命令代码 [英] How to write sql commands code in aspx page

问题描述

大家好，

我有aspx页面，我需要在aspx页面中编写sql命令，任何人都可以答复我如何在aspx页面中编写sql命令.

Hi all,

I have aspx page ,I need to write the sql commands in aspx page can any one reply me how can I write sql commands in aspx page

推荐答案

将它们放在背后的代码:
试试:

Put them in the code behind:
Try:

using (SqlConnection con = new SqlConnection(strConnect))
    {
    con.Open();
    using (SqlCommand com = new SqlCommand("SELECT iD, description FROM myTable", con))
        {
        using (SqlDataReader reader = com.ExecuteReader())
            {
            while (reader.Read())
                {
                int id = (int) reader["iD"];
                string desc = (string) reader["description"];
                ...
                }
            }
        }
    }

using (SqlConnection con = new SqlConnection(strConnect))
    {
    con.Open();
    using (SqlCommand com = new SqlCommand("INSERT INTO myTable (myColumn1, myColumn2) VALUES (@C1, @C2)", con))
        {
        com.Parameters.AddWithValue("@C1", myValueForColumn1);
        com.Parameters.AddWithValue("@C2", myValueForColumn2);
        com.ExecuteNonQuery();
        }
    }

这篇关于如何在ASPX页面中编写SQL命令代码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！