神马品牌网我的世界网易怎么踢人:谁会asp.net连接数据库？c#的．加30分！！
来源：百度文库 编辑：神马品牌网 时间：2024/05/04 05:49:05
不好意思，忘说了，我用的是SQL server数据库，希望能用
SQLCONNECTION的方法，而且希望有将查询出来的信息能够显示出来．
代码要完整一些比方说要有USING．．．
我是个菜鸟，希望大家能帮助我．
string query = "select username from userinfo where username='" + a1 + "'";
string strConn = "uid=sa;pwd=;database=tu;server=";
SqlConnection conn = new SqlConnection(strConn);
conn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = query;
cmd.Connection = conn;
SqlDataReader aaa = cmd.ExecuteReader();
aaa.Close();
conn.Close();
}
OleDbConnection conn = new OleDbConnection("连接字符串");
OleDataAdapter oda = new OleDataAdapter("select * from 表名", conn);
conn.Open();
DataSet ds = new DataSet();
oda.Fill(ds);
conn.Close();
using System.Data;
using System.Data.SqlClient;
private SqlConnection con;
con=new SqlConnection("server=.;uid=sa;pwd=;database=数据库");
<%@ Page Language="C#" ContentType="text/html" debug="true"%>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb"%>
<%@ Register Tagprefix="tmenu" TagName="menu" Src="topmenu.ascx"%>
<script language="c#" runat="server">
string value1,value2;
OleDbCommand comm;
OleDbConnection conn;
protected void Page_Load(Object Src, EventArgs E)
{
if(Request.QueryString["action"]=="out"){
HttpCookie cookie =new HttpCookie("user");
cookie.Expires = DateTime.Now.AddDays(-1);
Response.AppendCookie(cookie);
Response.Redirect("index.aspx");
}
if(Request.Cookies["user"]!=null){
value1=Convert.ToString(Request.Cookies["user"]["username"]);
}
conn=new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("data/db.mdb"));
comm=new OleDbCommand("SELECT TOP 7 * from [news] where mytype='热点新闻' order by id DESC",conn);
conn.Open();
OleDbDataReader grid1=comm.ExecuteReader();
DataGrid1.DataSource=grid1;
DataGrid1.DataBind();
grid1.Close();
comm.CommandText="select top 7 * from [news] where mytype='新闻' order by id DESC";
OleDbDataReader grid2=comm.ExecuteReader();
DataGrid2.DataSource=grid2;
DataGrid2.DataBind();
grid2.Close();