)
log on
(
name=_1102studb_log,
filename=d: 8203\_1102studb_data.ldf,
size=4mb,
filegrowth=5%
)
go
use _1102studb
go
create table student
(
stuid int identity(1001,1) primary key,
stuname nvarchar(20) not null,
sex char(2),
birthday datetime,
stuno varchar(20),
remark text
)
go
insert into student values(韩愈,男,2011-1-1,20112033,计算机)
insert into student values(李小婉,女,2011-3-3,20112034,法学)
insert into student values(韩三,男,2011-5-5,20112035,生科)
insert into student values(无何,女,2011-5-3,20112036,计算机)
insert into student values(海风,男,2011-9-9,20112037,计算机)
select * from student
c#---------------------------
--Button
string s1=textBox1.text;
string s2=textBox2.text;
int i1,i2;
if(int.TryParse(s1,out i1)==false)
{
MessageBox.Show("输入的不是数字");
}
if(int.TryParse(s2,out s2==false))
{
MessageBox.Show("输入的不是整数");
}
int i3=i1+i2;
textBox3.Text=Convert.ToString(i3);
emain分析
String email=textBox1.Text;
Sring[] strs=email.Split(@);
if(strs.Length!=2)
{
MessageBox.Show("非法的email地址");
return;
}
textBox2.Text=strs[0];
textBox3.Text=strs[1];
---数字累加器
String s1=textBox1.Text;
String s2=textBox2.Text;
int i1,i2;
if(int.TryParse(s1,out i1)==false)
{
MessageBox.Show("请输入数字");
return;
}
if(int.TryParse(s2,out i2)==false)
{
MessageBox.Show("输入的不是数字");
return;
}
if(i1>=i2)
{
int i3 = i1;
i1 = i2;
i2 = i3;
}
int sum=0;
for (int i = i1;i<= i2;i++)
{
sum+=i;
}
textBox3.Text =Convert.ToString(sum);
---登录框
String oldPwd = txt_old.Text;
String newPwd = txt_new.Text;
String newPwd2= txt_new2.Text;
if (oldPwd != "123")
{
MessageBox.Show("旧密码错误");
return;
}
if (newPwd != newPwd2)
{
MessageBox.Show("两次密码输入一样");
return;
}
MessageBox.Show("修改成功");
---学生信息管理系统
String user = textBox1.Text;
String pass = textBox2.Text;
String sql=string.Format("select count(1) from student where stuname={0} and stuno={1}",user,pwd);
String connStr = "server=.;databs=_1102studb;uid=sa,pwd=123 ";
SqlConnection conn = new SqlConnection();
//window 用户登录
String connStr = "server=.;databs=_1102studb;integrated;security=true";
//制定这个连接对象的连接字符串
conn.ConnectionString = connStr;
//打开这个连接，使用sql语句可以在上面执行
conn.Open();
//新建一个专门执行sql命令的对象
SqlCommand cmd = new SqlCommand();
//执行，什么命令
cmd.CommandText =sql;
//在那个连接上执行
cmd.Connection=conn;
//开始执行
Object obj = cmd.ExecuteScalar( );
int count=Convert.ToInt32(obj);
if(count>0)
{
MessageBox.Show("登录成功");
form2 f2=new Form2();
f2.Show();
this.Hide();
}else
{
MessageBox.Show("登录失败");
}