c#与数据库

最新推荐文章于 2024-06-20 09:39:00 发布

liushuang7342

最新推荐文章于 2024-06-20 09:39:00 发布

阅读量474

点赞数

分类专栏：数据库文章标签： c# textbox object string insert cmm

本文链接：https://blog.csdn.net/liushuang7342/article/details/7621085

版权

数据库专栏收录该内容

2 篇文章 0 订阅

订阅专栏

using System.Data;
using System.Data.SqlClient;
using System.Configuration;

public partial class Default3 : System.Web.UI.Page
{
    string ConnectionString = ConfigurationManager.ConnectionStrings["DB1ConnectionString"].ConnectionString;
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void Button1_Click(object sender, EventArgs e)
    {


        using (SqlConnection con = new SqlConnection(ConnectionString))
        {
            con.Open();
            string insertString = "insert into login (username,password) values (@username,@password)";
            SqlCommand cmm = con.CreateCommand();
            cmm.CommandText = insertString;

            //cmm.Parameters.Add("@username", SqlDbType.VarChar, 50);
            //cmm.Parameters.Add("@password", SqlDbType.VarChar, 50);

            //cmm.Parameters["@username"].Value = TextBox1.Text;
            //cmm.Parameters["@password"].Value = TextBox2.Text;

            //cmm.ExecuteNonQuery();

            cmm.Parameters.AddWithValue("@username", TextBox1.Text);

            cmm.Parameters.AddWithValue("@password", TextBox2.Text);

            cmm.ExecuteNonQuery();

        }


    }
}