日期:2014-05-17 浏览次数:20707 次
string strCnn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("你的access.mdb");
OleDbConnection conn = new OleDbConnection(strCnn);
conn.Open();
string sql = "insert into form (gzsx,fzr,jdr,jhwcsj,sjwcsj,knd,wcjg) values ('" + gzsx_TextBox.Text + "','" + fzr_TextBox.Text + "','" + jdr_TextBox.Text + "','" + jhwcsj_TextBox.Text + "','" + sjwcsj_TextBox.Text + "','" + knd_TextBox.Text + "','" + wcjg_TextBox.Text + "')";
OleDbCommand cmd = new OleDbCommand(sql, conn);
cmd.ExecuteNonQuery();
Response.Write("添加成功");
conn.Close();
/绑定数据到DataGridView
public void selects()
{
string str1 = "select * from table1";
dataGridView1.DataSource = SqlHelper.GetDataView(str1,CommandType.Text);
}
//执行sql语句,返回DataGridView
public static DataView GetDataView(string commText, CommandType commType)
{
OleDbCommand command = new OleDbCommand(commText, Connection);
OleDbDataAdapter da = new OleDbDataAdapter(command);
DataSet ds = new DataSet();
da.Fill(ds, "table");
return d