WEB开发网      婵犵數濞€濞佳囧磹婵犳艾鐤炬い鎰堕檮閸嬬喐銇勯弽銊с€掗梻鍕閺岋箑螣娓氼垱笑闂佽姘﹂褔婀佸┑鐘诧工妤犲憡绂嶉崜褏纾奸弶鍫涘妼缁楁岸鏌熷畡鐗堝殗闁诡喒鏅犲畷褰掝敃閵堝棙顔忔繝鐢靛仦閸ㄥ爼骞愰幘顔肩;闁规崘绉ぐ鎺撳亹闁绘垶锕╁Λ鍕⒑閹肩偛濡奸悗娑掓櫇缁顓兼径妯绘櫇闂佹寧绻傞弻濠囨晝閸屾稓鍘甸柣搴㈢⊕閿氶柣蹇ョ稻缁绘繃绻濋崘銊т紝闂佽鍨伴崯鏉戠暦閻旂⒈鏁傞柛鈾€鏅欑槐妯衡攽閻愬樊鍤熷┑顔藉劤铻為柛鏇ㄥ墯閸欏繘鏌嶉崫鍕櫣缂佲偓婢跺绠鹃柟瀛樼箘閿涘秵顨ラ悙顏勭伈闁诡喖缍婂畷鎯邦槻婵℃彃顭烽弻娑㈠Ω閵夈儺鍔夌紓浣稿€哥粔褰掑极閹剧粯鏅搁柨鐕傛嫹 ---闂傚倷鐒︾€笛兠洪埡鍛闁跨噦鎷�
开发学院WEB开发Jsp Asp.Net查询MSSQL数据库的一个例子 阅读

Asp.Net查询MSSQL数据库的一个例子

 2008-01-05 10:50:46 来源:WEB开发网 闂傚倷绶氬ḿ褍螞閹绢喖绠柨鐕傛嫹闂傚倷绀侀幉锟犲垂閻㈠灚宕查柟鎵閸庡秵銇勯幒鎴濃偓鐢稿磻閹炬枼妲堟繛鍡楃С濞岊亞绱撻崒姘扁枌闁瑰嚖鎷�婵犵數濮幏鍐川椤撴繄鎹曢梻渚€娼уú銈吤洪妸鈺佺劦妞ゆ帊鑳堕埊鏇㈡煏閸モ晛浠х紒杈╁仱閺佹捇鏁撻敓锟�闂傚倷绶氬ḿ褍螞閹绢喖绠柨鐕傛嫹  闂傚倷鑳舵灙缂佺粯顨呴埢宥夊即閵忕姵鐎梺缁樺姇閹碱偆鐥閺屾洘绻濊箛鏇犵獥闂佺厧澹婃禍婊堚€旈崘顏佸亾閿濆骸澧ù鐘欏嫮绠鹃柛顐ゅ枎閻忋儲銇勯弴妯哄姦妞ゃ垺鐟╅幃鈩冩償閵囧府鎷�
核心提示:一:使用System.Data.OleDb<%@page language="c#" debug="true"%><%@Import Namespace="System.Data"%><%@Import Namespace=&qu

  一:使用System.Data.OleDb
  <%@page language="c#" debug="true"%>
  <%@Import Namespace="System.Data"%>
  <%@Import Namespace="System.Data.OleDb"%>
  <script language="c#" runat="server">
  public void page_load(Object o,EventArgs e)
  {
  /**定义相关变量*/
  String strConn="PRovider=sqloledb.1;data source=localhost;initial catalog=pubs;user id=sa;passWord=lzjliu202080";
  String strSQL1="SELECT * FROM authors";
  String strSQL2="SELECT * FROM jobs";
  String strSQL3="SELECT * FROM sales";
  /**建立数据库连接*/
  OleDbConnection myConn=new OleDbConnection(strConn);
  try
  {
  /**查询数据*/
  OleDbDataAdapter myAdapter1=new OleDbDataAdapter(strSQL1,myConn);
  OleDbDataAdapter myAdapter2=new OleDbDataAdapter(strSQL2,myConn);
  OleDbDataAdapter myAdapter3=new OleDbDataAdapter(strSQL3,myConn);
  /**实例化DataSet*/
  DataSet myData=new DataSet();
  /**将数据资料存入DataSet*/
  myAdapter1.Fill(myData,"authors");
  myAdapter2.Fill(myData,"jobs");
  myAdapter3.Fill(myData,"sales");
  /**设置数据来源*/
  myGrid1.DataSource=myData.Tables["authors"].DefaultView;
  myGrid2.DataSource=myData.Tables["jobs"].DefaultView;
  myGrid3.DataSource=myData.Tables["sales"].DefaultView;
  /**数据绑定*/
  myGrid1.DataBind();
  myGrid2.DataBind();
  myGrid3.DataBind();
  }
  catch(Exception ex)
  {
  Response.Write("应用程序发生意外错误!");
  }
  finally
  {
  /**资源释放*/
  //myAdapter1.Close();
  //myAdapter2.Close();
  //myAdapter3.Close();
  myConn.Close();
  }
  }
  </script>
  <Html>
  <head>
  <title>Asp.Net数据查询</title>
  </head>
  <body>
  <form runat="server">
  <asp:DataGrid id="myGrid1" runat="server"
  allowPaging="true"
  pageSize="5"
  pagerStyle-mode="NumericPages"
  borderColor="black"
  borderWidth="1"
  cellPadding="3"
  cellSpacing="0"
  GridLines="Both"
  Font-Name="Verdana"
  Font-Size="8pt"
  HeaderStyle-BackColor="#aaaadd"
  AlternatingItemStyle-BackColor="#eeeeee"/>
  <asp:DataGrid id="myGrid2" runat="server"
  allowPaging="true"
  pageSize="5"
  pagerStyle-mode="NumericPages"/>
  <asp:DataGrid id="myGrid3" runat="server"
  allowPaging="true"
  pageSize="5"
  pagerStyle-mode="NumericPages"/>
  </form>
  </body>
  </html>
  
  二:使用System.Data.SqlClient
  <%@page language="c#" debug="true"%>
  <%@Import Namespace="System.Data"%>
  <%@Import Namespace="System.Data.SqlClient"%>
  <script language="c#" runat="server">
  protected void page_load(Object o,EventArgs e)
  {
  /**变量定义*/
  String strConn="server=localhost;database=pubs;user=sa;password=lzjliu202080";
  String strSQL1="SELECT * FROM authors";
  String strSQL2="SELECT * FROM jobs";
  String strSQL3="SELECT * FROM sales";
  /**建立数据库连接*/
  SqlConnection DBConn=new SqlConnection(strConn);
  /**查询资料*/
  SqlDataAdapter myAdapter1=new SqlDataAdapter(strSQL1,DBConn);
  SqlDataAdapter myAdapter2=new SqlDataAdapter(strSQL2,DBConn);
  SqlDataAdapter myAdapter3=new SqlDataAdapter(strSQL3,DBConn);
  /**实例化DataSet*/
  DataSet myData=new DataSet();
  /**将资料存入DataSet*/
  myAdapter1.Fill(myData,"author");
  myAdapter2.Fill(myData,"job");
  myAdapter3.Fill(myData,"sale");
  /**设置数据源*/
  Grid1.DataSource=myData.Tables["author"].DefaultView;
  Grid2.DataSource=myData.Tables["job"].DefaultView;
  Grid3.DataSource=myData.Tables["sale"].DefaultView;
  /**数据显示*/
  Grid1.DataBind();
  Grid2.DataBind();
  Grid3.DataBind();
  }
  </script>
  <form name="form1" runat="server">
  <Asp:DataGrid id="Grid1" runat="server"
  font-size="12px"/>
  <Asp:DataGrid id="Grid2" runat="server"
  font-size="12px"/>
  <Asp:DataGrid id="Grid3" runat="server"
  font-size="12px"/>
  </form>

Tags:Asp Net 查询

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接