怎么向数据库中存数据

来源：互联网发布：知乎运动员书编辑：程序博客网时间：2024/04/25 22:48

using System;

using System.Collections.Generic;

using System.Linq;
using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SqlClient;

using System.IO;

public partial class _Default : System.Web.UI.Page
{

protected void Page_Load(object sender, EventArgs e)

{

}



protected void btnClick(object sender, EventArgs e)
{

if (Password2.Value==Password3.Value)

{
string name = Text1.Value;

string password = Password2.Value;

string sex="";

if (Radio1.Checked)



{
sex = "男";
}

else


{
sex = "女";
}


//if(Radio2.Checked)

//{

// sex = "女";

//}



//string strPath = Server.MapPath("0.jpg");


//System.Drawing.Image image = System.Drawing.Image.FromFile(strPath);
//以上代码为装载图像

//MemoryStream stream = new MemoryStream();
//创建内存流
//image.Save(stream, System.Drawing.Imaging.ImageFormat.Jpeg);
//把图像存入内存流

//byte[] buffer = stream.ToArray();
//生成字节数组


//1.建立数据库连接

SqlConnection con = new SqlConnection();

con.ConnectionString = @"server=LENOVO-PC\SQLEXPRESS;

Integrated Security=true;

Initial Catalog=business";

con.Open();

//打开数据库

SqlCommand cmd = con.CreateCommand();

//创建一个数据库命令行 cmd.CommandText="insert into RegiserLogin(UserName,Password,Sex)

values('"+name+"','"+password+"','"+sex+"')";


//cmd.CommandText = "insert into RegiserLogin(UserName,Password,Sex) values

(@un,@pw,@se)";



//cmd.Parameters.AddWithValue("un", name);

// 将name 赋值给命令行的 "un”


//cmd.Parameters.AddWithValue("pw", password);

// 将Password 赋值给命令行的 "pw”


//cmd.Parameters.AddWithValue("se", sex);



//cmd.Parameters.AddWithValue("im", buffer);


cmd.ExecuteNonQuery();
// 执行数据库命令

接收受影响行数


Response.Write("恭喜您，注册成功！");


cmd.Dispose();

// 丢弃命令


con.Close();

// 关闭连接

}

}

}