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)
{
}
}
}