asp.net入门来一遍----数据存取

asp.net|数据

因为正在设在设计一个asp.net+xml+delphi的三层设计
所以在对一简单的东西做了一下整理。
下面是对xml,access,mssql数据存取
protected DataSet LoadMyPBData()
{
string sourceXml = Server.MapPath("phone.xml");
DataSet dataSet = new DataSet();
try
{
dataSet.ReadXml(sourceXml);
}
catch (Exception e)
{

dataSet = null;
}
return dataSet;
}

void Page_Load(object sender, EventArgs e)
{
if (!(Page.IsPostBack))
{
gridv.DataSource = LoadMyPBData();
gridv.DataBind();
}
}
-------------------------------
String StrSql="Data Source=127.0.0.1;Initial Catalog=dotnet;persist security info=True;user id=sa;password=1234;packet size=4096";
SqlConnection MyConn = new SqlConnection(StrSql);
MyConn.Open();
string CommSql = "select * from gbook order by id desc";
SqlDataAdapter adp = new SqlDataAdapter(CommSql,MyConn);
DataSet ds = new DataSet();
adp.Fill(ds);
DataGrid1.DataSource = ds;
DataGrid1.DataBind();
MyConn.Close();
---------------------------------------
if(!IsPostBack)
{
OleDbConnection MyConnection =new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("new.mdb"));
OleDbDataAdapter myCommand=new OleDbDataAdapter("SELECT id,typename FROM bb ",MyConnection);
DataSet ds= new DataSet();
myCommand.Fill(ds,"bb");
DropDownList2.DataSource = ds.Tables["bb"].DefaultView;
DropDownList2.DataTextField = "typename";
DropDownList2.DataValueField = "id";
DropDownList2.DataBind();