为什么读取不出来呢?

zjkwangjie 2009-07-21 03:05:02

...全文

90 13 打赏收藏转发到动态举报

写回复

用AI写文章

13 条回复

切换为时间正序

请发表友善的回复…

发表回复

erytbc 2009-07-21

打赏
举报

这个。

zjkwangjie 2009-07-21

打赏
举报

谢谢大家批评.就是个登陆的
我给下全部的代码吧



using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Data.SqlClient;

using System.Configuration;



public partial class _Default : System.Web.UI.Page 

{

    protected void Page_Load(object sender, EventArgs e)

    {



    }

 

    protected void Button1_Click1(object sender, EventArgs e)

    {

        string userName = Request["username"];

        string pwd = Request["pwd"];

        string constr = ConfigurationManager.ConnectionStrings["RegisterConnection"].ConnectionString;

        SqlConnection sql = new SqlConnection(constr);

        string selectsql = "SELECT mastername, masterpwd FROM master";

        SqlCommand cmd = new SqlCommand(selectsql,sql);

        

      

       



    }

}



<body>

    <form id="form1" runat="server">

    <h1 class="title">欢迎登陆</h1>

    <p>用户名：<input type="text" class="username" id="username" /></p>

    <p>密　码：<input type="text" class="pwd" id="pwd"/></p>

    <p><asp:Button ID="Button1" runat="server" Text="登陆" onclick="Button1_Click1" />　<input type="button" value="取消" /></p>

   

    </form>

</body>

就是想连接数据库和数据库对比一下 ,然后跳转到下个页面.

目前我是想直接把从数据库读取出来的值显示出来, 不知道为什么不显示,

WonderfulGame 2009-07-21

打赏
举报

新手要多练多看·
习惯不良
太不规范

zcxverygood123456 2009-07-21

打赏
举报

从你给的代码，不知要实现什么效果?
或者想问什么问题？

hsabout 2009-07-21

打赏
举报

string userName = Request["username"];
string pwd = Request["pwd"];
string constr = ConfigurationManager.ConnectionStrings["RegisterConnection"].ConnectionString;
SqlConnection sql = new SqlConnection(constr);
string selectsql = "SELECT mastername, masterpwd FROM master";
SqlCommand cmd = new SqlCommand(selectsql,sql);
sql.Open();
DataSet ds=new DataSet();
SqlDataAdapter ada = new SqlDataAdapter(cmd);
ada.Fill(ds);
if(ds.Table[0].Rows.Count>0)
{
Response.Write(ds.Table[0].Rows[0]["mastername"].ToString());
Response.Write(ds.Table[0].Rows[0]["masterpwd "].ToString());
}

zcxverygood123456 2009-07-21

打赏
举报

string userName = Request["username"]; 

        string pwd = Request["pwd"];

不知这个代码有什么用？

ljhcy99 2009-07-21

打赏
举报

string userName = Request["username"];
string pwd = Request["pwd"];
string constr = ConfigurationManager.ConnectionStrings["RegisterConnection"].ConnectionString;
SqlConnection sql = new SqlConnection(constr);
sql.Open();
string selectsql = "SELECT mastername, masterpwd FROM master";
SqlCommand cmd = new SqlCommand(selectsql,sql);
SqlDataReader read = cmd.ExecuteReader();
//不知道你那几个string变量想干嘛？作为参数的话，拼接sql就可以。
//还有connection对象别这样起名字，你起名为sql，很容易将人误导为他是一个查询语句，

zjkwangjie 2009-07-21