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();
// 关闭连接
}
}
}