c#几种常用代码及c#与access数据库连接应用Word文档格式.docx
《c#几种常用代码及c#与access数据库连接应用Word文档格式.docx》由会员分享,可在线阅读,更多相关《c#几种常用代码及c#与access数据库连接应用Word文档格式.docx(6页珍藏版)》请在冰点文库上搜索。
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<
s.Length;
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.ComponentModel;
usingSystem.Data;
usingSystem.Drawing;
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
登录失败"
abcdefg"
MessageBoxButtons.YesNo,MessageBoxIcon.Question);
privatevoidbutton1_Click()
C#与ACCESS数据库连接应用
namespaceT3
DataSource=123.mdb"
//-----------------------------
stringSql="
select*fromStudent"
OleDbDataAdapteroda=newOleDbDataAdapter(Sql,conn);
//---------------------------------
t1"
//-----------------------
dataGridView1.DataSource=ds.Tables["
];
privatevoidbutton2_Click(objectsender,EventArgse)
select*fromStudentwhereID='
+textBox1.Text+"
privatevoidbutton3_Click(objectsender,EventArgse)
sjbsjb1=newsjb();
select*fromStudentwhereSex='
dataGridView1.DataSource=sjb1.getsjb(sql);
privatevoidbutton4_Click(objectsender,EventArgse)
sjbsjb2=newsjb();
deletefromStudentwhereID='
+textBox3.Text+"
dataGridView1.DataSource=sjb2.getsjb(sql);
privatevoiddataGridView1_CellContentClick(objectsender,DataGridViewCellEventArgse)