c#几种常用代码及c#与access数据库连接应用.docx
- 文档编号:12484984
- 上传时间:2023-04-19
- 格式:DOCX
- 页数:6
- 大小:15.03KB
c#几种常用代码及c#与access数据库连接应用.docx
《c#几种常用代码及c#与access数据库连接应用.docx》由会员分享,可在线阅读,更多相关《c#几种常用代码及c#与access数据库连接应用.docx(6页珍藏版)》请在冰豆网上搜索。
c#几种常用代码及c#与access数据库连接应用
C#字符串应用
usingSystem;
usingSystem.Collections.Generic;
usingSystem.Linq;
usingSystem.Text;
namespaceConsoleApplication1
{
classProgram
{
staticvoidMain(string[]args)
{
Console.WriteLine("输入一个字符串");
strings=Console.ReadLine();
strings1;
/*s1=s.Substring(2,2);
s1=s.Remove(2,3);
s1=s.Insert(3,"123");
s1=s.Replace("abcd","ABCD");
char[]s2=s.ToCharArray(2,3);
for(inti=0;i Console.WriteLine(s2[i]); inti=98765; s1=i.ToString(); s1=s.ToUpper(); string[]s3=s.Split('q'); Console.WriteLine(s3[0]); Console.WriteLine(s3[1]);*/ Console.WriteLine(s1); } } } C#用户登陆界面 usingSystem; usingSystem.Collections.Generic; usingSystem.ComponentModel; usingSystem.Data; usingSystem.Drawing; usingSystem.Linq; usingSystem.Text; usingSystem.Windows.Forms; usingSystem.Data.OleDb; namespace联系 { publicpartialclassForm1: Form { publicForm1() { InitializeComponent(); } privatevoidForm1_Load(objectsender,EventArgse) { } privatevoidbutton1_Click(objectsender,EventArgse) { strings="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=密码.mdb"; OleDbConnectionconn=newOleDbConnection(s); stringsql="select*frommimawhereid='"+textBox1.Text+"'andmi='"+textBox2.Text+"'"; OleDbDataAdapteroda=newOleDbDataAdapter(sql,conn); DataSetds=newDataSet(); oda.Fill(ds,"tablet1"); if(ds.Tables[0].Rows.Count==1) MessageBox.Show("登录成功! "); else MessageBox.Show("登录失败","abcdefg",MessageBoxButtons.YesNo,MessageBoxIcon.Question); } privatevoidbutton1_Click() { } } } C#与ACCESS数据库连接应用 usingSystem; usingSystem.Collections.Generic; usingSystem.ComponentModel; usingSystem.Data; usingSystem.Drawing; usingSystem.Linq; usingSystem.Text; usingSystem.Windows.Forms; usingSystem.Data.OleDb; namespaceT3 { publicpartialclassForm1: Form { publicForm1() { InitializeComponent(); } privatevoidbutton1_Click(objectsender,EventArgse) { strings="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=123.mdb"; OleDbConnectionconn=newOleDbConnection(s); //----------------------------- stringSql="select*fromStudent"; OleDbDataAdapteroda=newOleDbDataAdapter(Sql,conn); //--------------------------------- DataSetds=newDataSet(); oda.Fill(ds,"t1"); //----------------------- dataGridView1.DataSource=ds.Tables["t1"]; } privatevoidbutton2_Click(objectsender,EventArgse) { strings="Provider=Microsoft.Jet.OLEDB.4.0;DataSource=123.mdb"; OleDbConnectionconn=newOleDbConnection(s); //----------------------------- stringSql="select*fromStudentwhereID='"+textBox1.Text+"'"; OleDbDataAdapteroda=newOleDbDataAdapter(Sql,conn); //--------------------------------- DataSetds=newDataSet(); oda.Fill(ds,"t1"); //----------------------- dataGridView1.DataSource=ds.Tables["t1"]; } privatevoidbutton3_Click(objectsender,EventArgse) { sjbsjb1=newsjb(); stringsql="select*fromStudentwhereSex='"+textBox2.Text+"'"; dataGridView1.DataSource=sjb1.getsjb(sql); } privatevoidbutton4_Click(objectsender,EventArgse) { sjbsjb2=newsjb(); stringsql="deletefromStudentwhereID='"+textBox3.Text+"'"; dataGridView1.DataSource=sjb2.getsjb(sql); } privatevoiddataGridView1_CellContentClick(objectsender,DataGridViewCellEventArgse) { } privatevoidForm1_Load(objectsender,EventArgse) { } } }
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- c# 常用 代码 access 数据库连接 应用