windows.form增删改查 -尊龙游戏旗舰厅官网
主界面
using system;
using system.collections.generic;
using system.componentmodel;
using system.data;
using system.drawing;
using system.linq;
using system.text;
using system.threading.tasks;
using system.windows.forms;
namespace windowsformsapplication2
{
public partial class form1 : form
{
public static int bs = 0;
public form1()
{
initializecomponent();
}
private void form1_load(object sender, eventargs e)
{
carda da = new carda();
datagridview1.datasource = da.select();
datagridview1.clearselection();
brandda bbb = new brandda();
combobox1.datasource = bbb.select();
combobox1.displaymember = "brand_name";
combobox1.valuemember = "brand_code";
}
private void button2_click(object sender, eventargs e)
{
messageboxbuttons btn = messageboxbuttons.yesnocancel;
if (messagebox.show("确定要删除么？", "删除数据", btn) == dialogresult.yes)
{
car data = datagridview1.selectedrows[0].databounditem as car;
carda da = new carda();
da.delete(data.code);
datagridview1.datasource = da.select();
}
}
private void button3_click(object sender, eventargs e)
{
if (datagridview1.selectedrows.count > 0)
{
//carda da = new carda();
car data = datagridview1.selectedrows[0].databounditem as car;
xiugai xg = xiugai.newxiugai(data.code);
xg.show();
xg.focus();
//datagridview1.datasource = da.select();
}
else
{
messagebox.show("没有选中任何项！");
}
}
private void button1_click(object sender, eventargs e)
{
tianjia tj = tianjia.newtianjia();
tj.show();
tj.focus();
}
private void timer1_tick(object sender, eventargs e)
{
if (bs == 1)
{
carda da = new carda();
datagridview1.datasource = da.select();
bs = 0;
}
}
private void button4_click(object sender, eventargs e)
{
string name = textbox1.text;
string brand=combobox1.selectedvalue.tostring();
carda da = new carda();
datagridview1.datasource = da.select(name,brand);
datagridview1.autogeneratecolumns = false;
}
}
}
连接类
using system;
using system.collections.generic;
using system.linq;
using system.text;
using system.threading.tasks;
using system.data.sqlclient;
namespace windowsformsapplication2
{
public class dbconnect
{
private static string connstring="server=.;database=mydb;user=sa;pwd=1023823348";
public static sqlconnection conn
{
get
{
return new sqlconnection(connstring);
}
}
}
}
实体类
using system;
using system.collections.generic;
using system.linq;
using system.text;
using system.threading.tasks;
namespace windowsformsapplication2
{
public class car
{
private string code;
public string code
{
get { return code; }
set { code = value; }
}
private string name;
public string name
{
get { return name; }
set { name = value; }
}
private string brand;
public string brand
{
get { return brand; }
set { brand = value; }
}
private datetime time;
public datetime time
{
get { return time; }
set { time = value; }
}
private decimal oil;
public decimal oil
{
get { return oil; }
set { oil = value; }
}
private int powers;
public int powers
{
get { return powers; }
set { powers = value; }
}
private int exhaust;
public int exhaust
{
get { return exhaust; }
set { exhaust = value; }
}
private decimal price;
public decimal price
{
get { return price; }
set { price = value; }
}
private string pic;
public string pic
{
get { return pic; }
set { pic = value; }
}
}
}
操作类
using system;
using system.collections.generic;
using system.linq;
using system.text;
using system.threading.tasks;
using system.data.sqlclient;
namespace windowsformsapplication2
{
public class carda
{
private sqlconnection _conn;
private sqlcommand _cmd;
private sqldatareader _dr;
public carda()
{
_conn = dbconnect.conn;
_cmd = _conn.createcommand();
}
public list
{
list
_cmd.commandtext = "select * from car ";
_conn.open();
_dr = _cmd.executereader();
if (_dr.hasrows)
{
while (_dr.read())
{
car data = new car();
data.code = _dr[0].tostring();
data.name = _dr[1].tostring();
data.brand = _dr[2].tostring();
data.time = convert.todatetime(_dr[3]);
data.oil = convert.todecimal(_dr[4]);
data.powers = convert.toint32(_dr[5]);
data.exhaust = convert.toint32(_dr[6]);
data.price = convert.todecimal(_dr[7]);
data.pic = _dr[8].tostring();
list.add(data);
}
}
_conn.close();
return list;
}
public car select(string code)
{
_cmd.commandtext = "select * from car where code=@code";
_cmd.parameters.clear();
_cmd.parameters.addwithvalue("@code", code);
_conn.open();
_dr = _cmd.executereader();
car data = new car();
if (_dr.hasrows)
{
_dr.read();
data.code = _dr[0].tostring();
data.name = _dr[1].tostring();
data.brand = _dr[2].tostring();
data.time = convert.todatetime(_dr[3]);
data.oil = convert.todecimal(_dr[4]);
data.powers = convert.toint32(_dr[5]);
data.exhaust = convert.toint32(_dr[6]);
data.price = convert.todecimal(_dr[7]);
data.pic = _dr[8].tostring();
}
_conn.close();
return data;
}
public void delete(string code)
{
_cmd.commandtext = "delete from car where code=@code";
_cmd.parameters.clear();
_cmd.parameters.addwithvalue("@code", code);
_conn.open();
_cmd.executenonquery();
_conn.close();
}
public void update(string code, string name, string brand, datetime time, decimal oil, int powers, int exhaust, decimal price, string pic)
{
_cmd.commandtext = "update car set name=@name,brand=@brand,time=@time,oil=@oil,powers=@powers,exhaust=@exhaust,price=@price,pic=@pic where code = @code";
_cmd.parameters.clear();
_cmd.parameters.addwithvalue("@code", code);
_cmd.parameters.addwithvalue("@name", name);
_cmd.parameters.addwithvalue("@brand", brand);
_cmd.parameters.addwithvalue("@time", time);
_cmd.parameters.addwithvalue("@oil", oil);
_cmd.parameters.addwithvalue("@powers", powers);
_cmd.parameters.addwithvalue("@exhaust", exhaust);
_cmd.parameters.addwithvalue("@price", price);
_cmd.parameters.addwithvalue("@pic", pic);
_conn.open();
_cmd.executenonquery();
_conn.close();
}
public void insert(string code, string name, string brand, datetime time, decimal oil, int powers, int exhaust, decimal price, string pic)
{
_cmd.commandtext = "insert into car values(@code, @name,@brand,@time,@oil,@powers,@exhaust,@price,@pic) ";
_cmd.parameters.clear();
_cmd.parameters.addwithvalue("@code", code);
_cmd.parameters.addwithvalue("@name", name);
_cmd.parameters.addwithvalue("@brand", brand);
_cmd.parameters.addwithvalue("@time", time);
_cmd.parameters.addwithvalue("@oil", oil);
_cmd.parameters.addwithvalue("@powers", powers);
_cmd.parameters.addwithvalue("@exhaust", exhaust);
_cmd.parameters.addwithvalue("@price", price);
_cmd.parameters.addwithvalue("@pic", pic);
_conn.open();
_cmd.executenonquery();
_conn.close();
}
public list
{
string tj1 = " 1=1 ";
string tj2 = " 1=1 ";
if (name != "")
{
tj1 = " name like @name ";
}
if (brand != "")
{
tj2 = " brand = @brand ";
}
string ztj = " where " tj1 " and " tj2;
list
_cmd.commandtext = "select * from car " ztj;
_cmd.parameters.clear();
_cmd.parameters.addwithvalue("@name", "%" name "%");
_cmd.parameters.addwithvalue("@brand", brand);
_conn.open();
_dr = _cmd.executereader();
if (_dr.hasrows)
{
while (_dr.read())
{
car data = new car();
data.code = _dr[0].tostring();
data.name = _dr[1].tostring();
data.brand = _dr[2].tostring();
data.time = convert.todatetime(_dr[3]);
data.oil = convert.todecimal(_dr[4]);
data.powers = convert.toint32(_dr[5]);
data.exhaust = convert.toint32(_dr[6]);
data.price = convert.todecimal(_dr[7]);
data.pic = _dr[8].tostring();
list.add(data);
}
}
_conn.close();
return list;
}
}
}
添加页面
using system;
using system.collections.generic;
using system.componentmodel;
using system.data;
using system.drawing;
using system.linq;
using system.text;
using system.threading.tasks;
using system.windows.forms;
namespace windowsformsapplication2
{
public partial class tianjia : form
{
private static tianjia tj = null;
public tianjia()
{
initializecomponent();
}
private void tianjia_load(object sender, eventargs e)
{
carda da = new carda();
textbox1.text = "";
textbox2.text = "";
textbox3.text = "";
textbox4.text = "";
textbox5.text = "";
textbox6.text = "";
textbox7.text = "";
textbox8.text = "";
textbox9.text = "";
}
public static tianjia newtianjia()
{
if (tj == null || tj.isdisposed)
{
tj = new tianjia();
}
return tj;
}
private void button1_click_1(object sender, eventargs e)
{
string _code = textbox1.text;
string _name = textbox2.text;
string _brand = textbox3.text;
datetime _time = convert.todatetime(textbox4.text);
decimal _oil = convert.todecimal(textbox5.text);
int _powers = convert.toint32(textbox6.text);
int _exhaust = convert.toint32(textbox7.text);
decimal _price = convert.todecimal(textbox8.text);
string _pic = textbox9.text;
carda aaa = new carda();
aaa.insert(_code, _name, _brand, _time, _oil, _powers, _exhaust, _price, _pic);
form1.bs = 1;
this.close();
}
}
}
修改页面
using system;
using system.collections.generic;
using system.componentmodel;
using system.data;
using system.drawing;
using system.linq;
using system.text;
using system.threading.tasks;
using system.windows.forms;
namespace windowsformsapplication2
{
public partial class xiugai : form
{
private string code = "";
private static xiugai xg = null;
public xiugai()
{
initializecomponent();
}
public xiugai(string code)
{
initializecomponent();
this.code = code;
}
private void xiugai_load(object sender, eventargs e)
{
carda da = new carda();
car data = da.select(code);
textbox1.text = data.code;
textbox2.text = data.name;
textbox3.text=data.brand;
textbox4.text = data.time.tostring("yyyy-mm-dd hh:mm:ss");
textbox5.text=data.oil.tostring();
textbox6.text=data.powers.tostring();
textbox7.text=data.exhaust.tostring();
textbox8.text=data.price.tostring();
textbox9.text = data.pic;
}
public static xiugai newxiugai(string code)
{
if (xg == null || xg.isdisposed)
{
xg = new xiugai(code);
}
return xg;
}
private void button1_click(object sender, eventargs e)
{
string _code = textbox1.text;
string _name = textbox2.text;
string _brand = textbox3.text;
datetime _time =convert.todatetime(textbox4.text);
decimal _oil = convert.todecimal(textbox5.text);
int _powers = convert.toint32(textbox6.text);
int _exhaust = convert.toint32(textbox7.text);
decimal _price = convert.todecimal(textbox8.text);
string _pic = textbox9.text;
carda aaa = new carda();
aaa.update(_code, _name, _brand, _time, _oil, _powers, _exhaust, _price, _pic);
form1.bs = 1;
this.close();
}
}
}
brand系列
using system;
using system.collections.generic;
using system.linq;
using system.text;
using system.threading.tasks;
namespace windowsformsapplication2
{
public class brand
{
private string brand_code;
public string brand_code
{
get { return brand_code; }
set { brand_code = value; }
}
private string brand_name;
public string brand_name
{
get { return brand_name; }
set { brand_name = value; }
}
}
}
using system;
using system.collections.generic;
using system.linq;
using system.text;
using system.threading.tasks;
using system.data.sqlclient;
namespace windowsformsapplication2
{
public class brandda
{
private sqlconnection _conn;
private sqlcommand _cmd;
private sqldatareader _dr;
public brandda()
{
_conn = dbconnect.conn;
_cmd = _conn.createcommand();
}
public list
{
_cmd.commandtext = "select * from brand";
_conn.open();
_dr = _cmd.executereader();
list
if (_dr.hasrows)
{
while (_dr.read())
{
brand data = new brand();
data.brand_code = _dr[0].tostring();
data.brand_name= _dr[1].tostring();
list.add(data);
}
}
_conn.close();
return list;
}
public string brandname(string code)
{
string name = "";
_cmd.commandtext = "select brand_name from brand where brand_code=@code";
_cmd.parameters.addwithvalue("@code", code);
_conn.open();
_dr = _cmd.executereader();
if (_dr.hasrows)
{
_dr.read();
name = _dr[0].tostring();
}
_conn.close();
return name;
}
}
}
转载于:https://www.cnblogs.com/shi2172843/p/5828292.html
与50位技术专家面对面20年技术见证，附赠技术全景图总结
以上是尊龙游戏旗舰厅官网为你收集整理的windows.form增删改查的全部内容，希望文章能够帮你解决所遇到的问题。
- 上一篇：
- 下一篇： bootstrap3系列：下拉菜单