SqlDataReader错误

ircfan 2003-08-25 01:44:09
编译错误
说明: 在编译向该请求提供服务所需资源的过程中出现错误。请检查下列特定错误详细信息并适当地修改源代码。

编译器错误信息: BC30002: 未定义类型“SqlDataReader”。

源错误:



行 12:
行 13: Private Sub bindgrid2()
行 14: Dim myDataReader As SqlDataReader
行 15: Dim mySqlConnection As SqlConnection
行 16: Dim mySqlCommand As SqlCommand

源码:
<%@ page language="vb" %>
<%@ Import Namespace="System.Web" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient %>

<script runat="server">
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)
If Not Page.IsPostBack Then
bindgrid2()
End If
End Sub

Private Sub bindgrid2()
Dim myDataReader As SqlDataReader
Dim mySqlConnection As SqlConnection
Dim mySqlCommand As SqlCommand
mySqlConnection = New SqlConnection(ConfigurationSettings.AppSettings().Item("ConnectionString"))
mySqlCommand = New SqlCommand("select id,name,address,brief from companyinfo", mySqlConnection)
mySqlConnection.Open()
myDataReader = mySqlCommand.ExecuteReader(CommandBehavior.CloseConnection)
Repeater1.DataSource = myDataReader
Repeater1.DataBind()
End Sub
</script>

这是什么问题,怎么解决?
...全文
16 4 打赏 收藏 转发到动态 举报
写回复
用AI写文章
4 条回复
切换为时间正序
请发表友善的回复…
发表回复
liq1979 2003-08-25
  • 打赏
  • 举报
回复
Dim myReader As SqlDataReader
myReader = myCommand.ExecuteReader()
acewang 2003-08-25
  • 打赏
  • 举报
回复
若要创建 SqlDataReader,必须调用 SqlCommand 对象的 ExecuteReader 方法,而不直接使用构造函数。
Public Sub ReadMyData(myConnString As String)
Dim mySelectQuery As String = "SELECT OrderID, CustomerID FROM Orders"
Dim myConnection As New SqlConnection(myConnString)
Dim myCommand As New SqlCommand(mySelectQuery, myConnection)
myConnection.Open()
Dim myReader As SqlDataReader
myReader = myCommand.ExecuteReader()
' Always call Read before accessing data.
While myReader.Read()
Console.WriteLine((myReader.GetInt32(0) & ", " & myReader.GetString(1)))
End While
' always call Close when done reading.
myReader.Close()
' Close the connection when done with it.
myConnection.Close()
End Sub 'ReadMyData
gshope 2003-08-25
  • 打赏
  • 举报
回复
<%@ page language="vb" %>
<%@ Import Namespace="System.Web" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient %>

这几行也放在最开头呀!
ircfan 2003-08-25
  • 打赏
  • 举报
回复
错误是第14行
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace BS { public partial class frmLogin : Form { public static string str_name;//记录登录用户名字 public static string str_pwd;//记录登录用户密码 public static string str_right;//记录登录用户权限 BS.BaseOperate boperate = new BS.BaseOperate(); BS.OperateAndValidate opAndvalidate = new BS.OperateAndValidate(); public frmLogin() { InitializeComponent(); } private void timer1_Tick(object sender, EventArgs e) { DateTime dt = DateTime.Now; //在登录页面显示获取的系统当前时间 label5.Text = "当前时间:"+dt.Year + "年" + dt.Month + "月" + dt.Day + "日" + dt.Hour + "时" + dt.Minute + "分" + dt.Second + "秒"; } private void button2_Click(object sender, EventArgs e) { Application.Exit(); } private void button1_Click(object sender, EventArgs e) { SqlDataReader sqlread = boperate.getread("select UserName,UserPwd from tb_User where UserName='" + cbox.Text.Trim() + "' and UserPwd='" + txtPwd.Text.Trim() + "'"); sqlread.Read();//HasRows属性用来获取一个值,指示SqlDataReader是否包含一行或多行 if (sqlread.HasRows) { str_name = cbox.Text; str_pwd = txtPwd.Text.Trim(); frmMain fmain = new frmMain(); this.Hide();//Hide()方法用来隐藏窗体 fmain.Show();//Show()方法用来显示执行窗体 } else { MessageBox.Show("用户名或密码错误!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); txtPwd.Text = ""; cbox.Focus();//Focus()方法用来为控件获取焦点 } sqlread.Close(); } private void frmLogin_Load(object sender, EventArgs e) { //通过调用公共类OpenAndValidate中的cboxBind方法对显示用户登录名的ComboBox控件进行数据绑定 opAndvalidate.cboxBind("select UserName from tb_User","tb_User","UserName",cbox); } private void cbox_SelectedIndexChanged(object sender, EventArgs e) { //通过调用公共类BaseOperate类中的getread方法成一个SqlDataReader对象 SqlDataReader sqlread=boperate.getread("select UserName,UserRight from tb_User where UserName='"+cbox.Text+"'"); //Read()方法用来使 SqlDataReader对象前进到下一条记录 if(sqlread.Read()) { label4.Text=sqlread["UserRight"].ToString(); str_right=label4.Text; } sqlread.Close();//Close方法用来关闭SqlDataReader对象} }
很简单!刚学的!有登录和注册using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace WindowsFormsApplication2 { public partial class Form1 : Form { SqlConnection conn = null; public Form1() { InitializeComponent(); } private void button1_Click(object sender, EventArgs e) { try{ SqlCommand com = conn.CreateCommand(); string users = textBox1.Text; string password = textBox2.Text; com.CommandText = "select * from T_login where LOGIN_user='"+users+"'"; SqlDataReader reader = com.ExecuteReader(); if (reader.Read()) { //用户名正确! string dbpassword = reader.GetString(reader.GetOrdinal("LOGIN_password")); if (password == dbpassword) { MessageBox.Show("登陆成功!"); } else { MessageBox.Show("密码错误!"); } } else { MessageBox.Show("用户名错误!"); } reader.Close(); } catch(Exception ex) { MessageBox.Show(ex.Message); } } private void Form1_Load(object sender, EventArgs e) { string connString = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True"; try { conn = new SqlConnection(connString); conn.Open(); MessageBox.Show("成功!"); } catch (Exception ex) { MessageBox.Show(ex.Message); } } private void Form1_FormClosing(object sender, FormClosingEventArgs e) { conn.Dispose(); } private void button3_Click(object sender, EventArgs e) { try { SqlCommand com = conn.CreateCommand(); string users = textBox1.Text; string password = textBox2.Text; com.CommandText = "select * from T_login"; SqlDataReader reader = com.ExecuteReader(); label3.Text = "id,用户名,密码\n"; while (reader.Read()) { label3.Text = label3.Text +"\n"+ string.Format("{0},{1},{2}", reader[0], reader[1], reader[2]); } reader.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } private void button2_Click(object sender, EventArgs e) { try { SqlCommand com = conn.CreateCommand(); string users = textBox1.Text; string password = textBox2.Text; com.CommandText = "select * from T_login where LOGIN_user='" + users + "'"; SqlDataReader reader = com.ExecuteReader(); if (reader.Read()) { //用户名存在! MessageBox.Show("用户名已经存在"); reader.Close(); } else { reader.Close(); //可以注册 com.CommandText = "INSERT INTO T_login (LOGIN_user, LOGIN_password) VALUES ('"+users+"', '"+password+"')"; com.ExecuteNonQuery(); MessageBox.Show("注册成功!"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } } }
企业客户资源管理系统 using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; namespace CRM { public partial class frmLogin : Form { public static string M_str_name;//记录登录用户名字 public static string M_str_pwd;//记录登录用户密码 public static string M_str_right;//记录登录用户的权限 CRM.BaseClass.BaseOperate boperate = new CRM.BaseClass.BaseOperate(); CRM.BaseClass.OperateAndValidate opAndvalidate = new CRM.BaseClass.OperateAndValidate(); public frmLogin() { InitializeComponent(); } private void frmLogin_Load(object sender, EventArgs e) { opAndvalidate.cboxBind(\"select UserName from tb_User\", \"tb_User\", \"UserName\", cboxUName); } private void cboxUName_SelectedIndexChanged(object sender, EventArgs e) { SqlDataReader sqlread = boperate.getread(\"select UserName,UserRight from tb_User where UserName=\'\" + cboxUName.Text + \"\'\"); if (sqlread.Read()) { labURight.Text = sqlread[\"UserRight\"].ToString(); M_str_right = labURight.Text; } sqlread.Close(); } private void btnLogin_Click(object sender, EventArgs e) { SqlDataReader sqlread=boperate.getread(\"select UserName,UserPwd from tb_User where UserName=\'\"+cboxUName.Text.Trim()+\"\' and UserPwd=\'\"+txtPwd.Text.Trim()+\"\'\"); sqlread.Read(); if (sqlread.HasRows) { M_str_name = cboxUName.Text; M_str_pwd = txtPwd.Text.Trim(); frmMain fmain = new frmMain(); this.Hide(); fmain.Show(); } else { MessageBox.Show(\"用户名或密码错误!\", \"提示\", MessageBoxButtons.OK, MessageBoxIcon.Information); txtPwd.Text = \"\"; cboxUName.Focus(); } sqlread.Close(); } private void btnExit_Click(object sender, EventArgs e) { Application.Exit(); } private void frmLogin_FormClosing(object sender, FormClosingEventArgs e) { Application.Exit(); } } }

62,025

社区成员

发帖
与我相关
我的任务
社区描述
.NET技术交流专区
javascript云原生 企业社区
社区管理员
  • ASP.NET
  • .Net开发者社区
  • R小R
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告

.NET 社区是一个围绕开源 .NET 的开放、热情、创新、包容的技术社区。社区致力于为广大 .NET 爱好者提供一个良好的知识共享、协同互助的 .NET 技术交流环境。我们尊重不同意见,支持健康理性的辩论和互动,反对歧视和攻击。

希望和大家一起共同营造一个活跃、友好的社区氛围。

试试用AI创作助手写篇文章吧