上机实习报告总结结尾_关于实习报告总结范本

2020-02-28 实习报告下载本文

上机实习报告总结结尾由刀豆文库小编整理，希望给你工作、学习、生活带来方便，猜你可能喜欢“关于实习报告总结范本”。

上机实习报告总结结尾

一.首页

代码如下;

using System;

using;

namespace WindowsApplication1

{

public partial cla Form5 : Form {

public Form5()

{

InitializeComponent();

}

private void button1_Click(object sender, {

logo from = new logo();

();EventArgs e)

} private void button2_Click(object sender, EventArgs e){

Form2 from = new Form2();

();

} private void button3_Click(object sender, EventArgs e)http:///shijuan/ 试卷 {

Form3 from = new Form3();

();

} private void button4_Click(object EventArgs e){

Form4 from = new Form4();

();

}

二.登录模块

代码如下：

using System;

using;

sender,using

;

using;

namespace WindowsApplication1

{

public partial cla logo : Form

{

public logo()

{

InitializeComponent();

}

private void Form1_Load(object sender, EventArgs e)

{

} private void button1_Click(object sender, EventArgs e){ string

connstring

@“Data Source=panlunzhao;Initial Security=True”;

Catalog=;Integrated

SqlConnection conn = new SqlConnection(connstring);();

string username =();string paword =();SqlCommand comm =();

= “select * from manage where username='” + username + “' and paword='” + paword + “'”;

SqlDataReader sqlda =();

if(())

{ ifhttp:///gongzuobaogao/

工

作

报

告

(sqlda.ToString().Trim()== paword){

//(“恭喜您登陆成功!”, “登陆成功!”, ,);

//Form2 f = new Form2();

//();

Form3 from = new Form3();

();

}

else {(“密码错误，请重新输入!”, “错误

”, ,);}

}

else {(“此用户不存在，请您注册!”, “注册”, ,);}

();http:///dangtuangongzuozongjie/ 党团工作总结

();

} private void button2_Click(object sender, EventArgs e){

= “”;

}

三.会员管理模块

代码如下：

using System;

using;

namespace WindowsApplication1

{

public partial cla Form2 :

Form

{

protected SqlConnection conn;

protected SqlCommand cmd;

string connstring = @“Data Sou/article/ 述职报告rce=panlunzhao;Initial

Catalog=;Integrated Security=True”;

public Form2()

{

InitializeComponent();

}

private void Form2_Load(object sender, EventArgs e)

{

load1();

load();

}

protected void load1()

{

string sql = “select *from customer”;

conn = new SqlConnection(connstring);

();

SqlDataAdapter da = new SqlDataAdapter(sql, conn);DataSet ds = new DataSet();

(ds, “book”);

}

protected void load()

{

conn = new SqlConnection(connstring);

();

string sql_select = “SELECT ID FROM customer ”;cmd = new SqlCommand(sql_select, conn);

SqlDataReader dr =();

();

while(())

(dr);

();

}

private DataTable BindData(string sql)

{

string sql_select = sql;

conn = new SqlConnection(connstring);

SqlDataAdapter ad = new SqlDataAdapter(sql_select, conn);DataSet ds = new DataSet();

(ds, “customer”);

return;

} private void button1_Click(object sender, EventArgs e){

string sql = “select * from customer where ID='” +()+ “'”;

conn = new SqlConnection(connstring);

();

SqlCommand cmd = new SqlCommand(sql, conn);

SqlDataReader ds =();

();

= ds.ToString();

http:///xuexiaogongzuozongjie/ 学校工作总结 = ds.ToString();

= ds.ToString();

=(bool)ds;

} private void update_Click(object sender, EventArgs e){

string sql = “customer set

name=@name,Levels=@Levels,Birthday=@Birthday,Degree=@Degree,Addre=@Addre,Telephone=@Telephone,Email=@Email,Score=@Score where ID=@ID”;conn = new SqlConnection(connstring);

();

cmd = new SqlCommand(sql, conn);

(“@ID”,).Value =();

(“@name”, , 20).Value =();

(“@Levels”,).Value =();

(“@Birthday”,).Value =();

(“@Degree”, ,20).Value =();

(“@Addre”, , 256).Value =();

(“@Telephone”, ,50).Value =();

(“@Email”, , 50).Value =();

(“http:///yundonghuiyanjianggao/ 运动会演讲稿 @Gender”,).Value =(bool);

(“@Score”,).Value =();

();

SqlDataReader ds =();

();

load1();

}

private void _Click(object sender, EventArgs e){

string sql_ = “ into

customer(Name,Levels,Gender,Birthday,Degree,Addre,Telephone,Email,Score)

values(@Name,@Levels,@Gender,@Birthday,@Degree,@Addre,@Telephone,@Email,@Score)”;

cmd = new SqlCommand(sql_, conn);

try

{

();

(“@Name”, ,20).Value =();

(“@Levels”,).Value =(());(“@Birthday”,).Value =

(());

(“@Degree”, ,20).Value =();

(“@Addre”, , 256).Value =();

(“@Telephone”, ,50).Value =();

(“@Email”, ,50).Value =();

(“@Score”,).Value =(());

if()

{

(“@Gender”,).Value = “true”;

}

else

{

(“@Gender”,).Valuhttp:///yuegongzuozongjie/ 月工作总结 e = “false”;

}

int count =();

if(count == 1)

{

if((“确认添加读者吗?”, “提示”, ,)==)return;

(“添加成功！”, “提示!”);}

else

{

(“添加失败”, “提示”，);

}

catch(Exception ex)

{

();

}

finally

{

();

}

四.增加、删除、修改图书模块

代码如下：

using System;

using;

namespace WindowsApplication1

{

public partial cla Form3 : Form

{

protected SqlConnection conn;

protected SqlComhttp:///shijicailiao/ mand cmd;

事迹材料

string connstring = @“Data Source=panlunzhao;Initial Security=True”;

public Form3()

{

InitializeComponent();

}

Catalog=;Integrated

private void textBox7_TextChanged(object sender, EventArgs e){

} private void label6_Click(object sender, EventArgs e){

} private void select_Click(object sender, EventArgs e){

string book_name =();

string pre =();

string Author =();

StringBuilder sb1 = new StringBuilder();

(“select * from book where ”);

if()

((“Name LIKE '%{0}%'”, book_name));

if(&&)(“AND ”);

if()

{

((“Pre = '{0}'”, pre));}

if(&&)(“AND ”);

if()

{

((“Author LIKE '%{0}%'”, Author));

}

= Binhttp:///banzhurengongzuojihua/ 班主任工作计划 dData(());} private void reset_Click(object sender, EventArgs e){

= true;

= false;

= “”;

} private void button1_Click(object sender, EventArgs e){

string sql = “select * from book where ISBN='” +()+ “'”;

conn = new SqlConnection(connstring);

();

SqlCommand cmd = new SqlCommand(sql, conn);

SqlDataReader ds =();

();

= ds.ToString();

= ds.ToString(http:///shiyongqigongzuozongjie/ 试用期工作总结);

= ds.ToString();

=(bool)ds;

= ds.ToString();

} private void button2_Click(object sender, EventArgs e){

string sql = “ into

book(ISBN,name,author,pre,publishdate,price,pages,barcode,cd,storage)

values(@ISBN,@name,@author,@pre,@publishdate,@price,@pages,@barcode,@cd,@storage)”;

conn = new SqlConnection(connstring);

();

cmd = new SqlCommand(sql, conn);

(“@isbn”, , 10).Value =();

(“@name”, , 256).Value =();

(“@author”, , 100).Value =();

(“@pre”, , 50).Value =();

(“@publishdate”, ,50).Value =();

(“@price”, , 50).Value =();

(“@pages”, , 50).Value

=();

(“@barcode”, SqlDbTypehttp:///dangxiaoxuexixindetihui/ 党校学习心得体会.NVarChar,50).Value =();

(“@cd”, , 50).Value =(bool);

(“@storage”, ,50).Value =();

();

load1();

load();

}

private void save_Click(object sender, EventArgs e)

{

string sql = “book set

name=@name,author=@author,pre=@pre,publishdate=@publishdate,price=@price,pages=@pages,barcode=@barcode,cd=@cd,Storage=@Storage where ISBN=@ISBN”;

conn = new SqlConnection(connstring);

();

cmd = new SqlCommand(sql, conn);

(“@isbn”, , 10).Value =();

(“@name”, , 256).Value =();

(“@author”, , 100).Value =();

(“@pre”, , 50).Value =();

(“@publishdate”, ,50).Value =();

(“@price”, , 50).Value =();

(“@pages”, , 50).Value =();

(“@barcode”, ,50).Value =();

(“@cd”, , 50).Value =(bool);

(“@storage”, ,50).Value =();

();

SqlDataReader ds =();

();

load1();

}

private void quxiaosave_Click(object sender, EventArgs e){

= “”;

= “&http:///shenbaocailiao/ 申报材料quot;;

= ”“;

= false;

= ”“;

}

private void _Click(object sender, EventArgs e){

string sql = ” from book where isbn=@isbn“;conn = new SqlConnection(connstring);

cmd = new SqlCommand(sql, conn);

();

(”@isbn“, , 10).Value =();

();

load1();

load();

}

private void Form3_Load(object sender, EventArgs e){

load();

load1();

}

protected void load()

{

conn = new SqlConnection(connstring);

();

string sql_select = ”SELECT DISTINCT FROM ORDER BY “;

cmd = new SqlCommand(sql_select, conn);

SqlDataReader dr =();

();

while(())

(dr);

();

= ”SELECT DISTINCT FROM ORDER BY “;

SqlDataReader ds =();

();

while(())

(ds);

();

= ”SELECT DISTINCT FROM ORDER BY “;

SqlDataReader st =();

();

while(())

(st);

();

}

protected void load1()

{

string sql = ”select *from book“;

conn = new SqlConnection(connstring);

();

SqlDataAdapter da = http:///qingkuangbaogao/ 情况报告new SqlDataAdapter(sql, conn);DataSet ds = new DataSet();

(ds, ”book“);

}

private DataTable BindData(string sql)

{

string sql_select = sql;

conn = new SqlConnection(connstring);

SqlDataAdapter

new SqlDataAdapter(sql_select, conn);DataSet ds = new DataSet();

(ds, ”Book“);

return;

}

private void all_Click(object sender, EventArgs e)

{

string sql = ”select *from book“;

conn = new SqlConnection(connstring);

();

SqlDataAdapter da = new SqlDataAdapter(sql, conn);

DataSet ds = new DataSet();

(ds, ”book“);

=;}

}

五.借书模块

代码如下：

using System;

using;

namespace WindowsApplication1

{

public partial cla Form4 : Form

{

protected SqlConnection conn;

protected SqlCommand cmd;string

connstring

@”Data Source=panlunzhao;Initial Catalog=:///banjigongzuojihua/ 班级工作计划 F;Integrated Security=True“;

public Form4()

{

InitializeComponent();

}

private void Form4_Load(object sender, EventArgs e)

{

try

{

conn = new SqlConnection(@”Data

Source=panlunzhao;Initial Catalog=;Integrated

Security=True“);

();

}

catch(Exception exp)

{

(”无法建立数据连接:“ +);();

}

protected void InitData()

{

cmd = new SqlCommand(”select distinct from Book order By “, conn);

SqlDataReader reader1 =();

();

while(())

(reader1);

();

cmd = new SqlCommand(”select id from reader order by“,conn);

SqlDataReader reader2 =();

();

while(())

(reader2);

();

} private void select_Click(object sender, EventArgs e)http:///chengxinyanjianggao/ 诚信演讲稿 {

string sql = ”select * from book where ID='“ +

()+ ”'“;

conn = new SqlConnection(connstring);

();

SqlCommand cmd = new SqlCommand(sql, conn);

SqlDataReader ds =();

();

= ds.ToString();

=(bool)ds;

= ds.ToString();

} private void jieshu_Click(object sender, EventArgs e){

string sql = ”select * from reader where ID='“ +()+ ”'“;

conn = new SqlConnection(connstring);

();

SqlDataAdapter da = new SqlDataAdapter(sql, conn);DataSet ds = new DataSet();

(ds, ”book“);

string sql_up = ”book set Storage=Storage-1 where ID='“ +()+ ”'“;

cmd = new SqlCommand(sql_up, conn);

();

DataSet hs = new DataSet();

(hs, ”book“);

if(== ”“)

return;

= ”SELECT * FROM WHERE =“ +;

SqlDataReader reader1 = null;

try

{

reader1 =();

if(())

{

textBhttp:///gerengongzuojihua/ = reader1.ToString();

}

else

{

(”没有符合条件的记录“, ”提示“, ,);

}

catch(Exception exp)

{

(”数据访问错误:“ + +, ”错误", ,);}

finally

{

if(reader1!= null &&!)

个人工作计划

();

}

总结

此次实训综合考查了所学的c#知识，让我知道一个项目从构思、设计、实结题报告现、测试的过程。在实训中也综合运用了所学的知识，也涵盖了数据库的知识，用数据库存放数据，用脚本实现功能。

相关专题关于实习报告总结范本实习报告结尾关于实习报告总结范本实习报告结尾

[实习报告]相关推荐

[实习报告]热门文章