用asp。net测了一下default.aspx.cs:using System; using System.Data; using System.Configuration; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls; using System.Data.SqlClient;public partial class _Default : System.Web.UI.Page { public string name; public string number; public string low; public string high; DataRow record; string type; protected System.Web.UI.WebControls.Label Label2; protected System.Web.UI.WebControls.Label Label3; DataSet sqldataset = new DataSet(); protected void Page_Load(object sender, EventArgs e) { type = Request.Params["type"]; type = "P"; SqlConnection sqlconn = new SqlConnection("server=192.168.102.208;database=master;uid=sa;pwd=sa; "); sqlconn.Open(); string str = "select * from spt_values where type= '" + type +"'"; SqlDataAdapter sqladapter = new SqlDataAdapter(str, sqlconn); sqladapter.Fill(sqldataset, "spt_values "); name = sqldataset.Tables["spt_values "].Rows[0]["name"].ToString(); number = sqldataset.Tables["spt_values "].Rows[0]["number"].ToString(); low = sqldataset.Tables["spt_values "].Rows[0]["low"].ToString(); high = sqldataset.Tables["spt_values "].Rows[0]["high"].ToString(); } } defalut.aspx:<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %><!DOCTYPE html PUBLIC "-//W3C//Dtd XHTML 1.0 Transitional//EN" "http://www.w3.org/tr/xhtml1/Dtd/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" > <head runat="server"> <title>无标题页</title> </head> <body> <form id="form1" runat="server"> <div> <table id= "Table1 " style= "left:20px; position: absolute; top: 42px " cellspacing= "1 " cellpadding= "1 " width= "700 " border= "0 "> <tr> <td align= "middle " height= "40 "> <font size= "3 " color= "#3300ff "> <b> <%=high%> </b> </font> </td> </tr> <tr> <td align= "middle "> name: <%=name%> number: <%=number%> <hr size= "1 " width= "400 "> </td> </tr> <tr> <td> <%=low%> </td> </tr> </table> </div> </form> </body> </html>
using System; using System.Collections.Generic; using System.Text; using System.Data.SqlClient; using System.Data;namespace ConsoleApplicationTestSqlServer { class Program { static void Main(string[] args) { DataSet sqldataset = new DataSet(); SqlConnection sqlconn = new SqlConnection("server=192.168.102.208;database=master;uid=sa;pwd=sa; "); sqlconn.Open(); string str = "select * from spt_values where type= 'P'"; SqlDataAdapter sqladapter = new SqlDataAdapter(str, sqlconn); sqladapter.Fill(sqldataset, "spt_values"); foreach (DataRow dr in sqldataset.Tables["spt_values"].Rows) Console.WriteLine("number:" + dr["number"].ToString());
sqlconn.Open();
string str = "select * from spt_vslues where type= " + type; SqlDataAdapter sqladapter = new SqlDataAdapter(str, sqlconn); sqladapter.Fill(sqldataset, "spt_values ");
web-config里面配置啊! <add name="ConnString" providerName="System.Data.SqlClient" connectionString="Data Source=ip地址;Initial Catalog=数据库名称;uid=用户名;pwd=密码"/>
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;public partial class _Default : System.Web.UI.Page
{
public string name;
public string number;
public string low;
public string high;
DataRow record;
string type;
protected System.Web.UI.WebControls.Label Label2;
protected System.Web.UI.WebControls.Label Label3;
DataSet sqldataset = new DataSet(); protected void Page_Load(object sender, EventArgs e)
{
type = Request.Params["type"];
type = "P";
SqlConnection sqlconn = new SqlConnection("server=192.168.102.208;database=master;uid=sa;pwd=sa; ");
sqlconn.Open();
string str = "select * from spt_values where type= '" + type +"'"; SqlDataAdapter sqladapter = new SqlDataAdapter(str, sqlconn); sqladapter.Fill(sqldataset, "spt_values "); name = sqldataset.Tables["spt_values "].Rows[0]["name"].ToString();
number = sqldataset.Tables["spt_values "].Rows[0]["number"].ToString();
low = sqldataset.Tables["spt_values "].Rows[0]["low"].ToString();
high = sqldataset.Tables["spt_values "].Rows[0]["high"].ToString();
}
}
defalut.aspx:<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %><!DOCTYPE html PUBLIC "-//W3C//Dtd XHTML 1.0 Transitional//EN" "http://www.w3.org/tr/xhtml1/Dtd/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<table id= "Table1 " style= "left:20px; position: absolute; top: 42px " cellspacing= "1 " cellpadding= "1 " width= "700 " border= "0 ">
<tr>
<td align= "middle " height= "40 "> <font size= "3 " color= "#3300ff "> <b> <%=high%> </b> </font>
</td>
</tr>
<tr>
<td align= "middle "> name: <%=name%> number: <%=number%>
<hr size= "1 " width= "400 ">
</td>
</tr>
<tr>
<td> <%=low%> </td>
</tr>
</table> </div>
</form>
</body>
</html>
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Data;namespace ConsoleApplicationTestSqlServer
{
class Program
{
static void Main(string[] args)
{
DataSet sqldataset = new DataSet(); SqlConnection sqlconn = new SqlConnection("server=192.168.102.208;database=master;uid=sa;pwd=sa; ");
sqlconn.Open();
string str = "select * from spt_values where type= 'P'"; SqlDataAdapter sqladapter = new SqlDataAdapter(str, sqlconn); sqladapter.Fill(sqldataset, "spt_values");
foreach (DataRow dr in sqldataset.Tables["spt_values"].Rows)
Console.WriteLine("number:" + dr["number"].ToString());
}
}
}
c#的控制台程序。