从http://www.shaiit.com/ASPNET/AspNetshili/3012网址学到!
可是用他那方法出现了许多错误!!!一时解决不了!麻烦大家帮忙!!!
数据库:表名:newtb
字段:ID content time (附:数据库里什么也没有加!想从FreeTextBox里加入)
FreeTextBox页面代码:
- C# code
using System;using System.Data;using System.Configuration;using System.Collections;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 FreeTextBoxControls;using FreeTextBoxControls.Design;using FreeTextBoxControls.Common;using System.Data.SqlClient;using System.Data.Common;public partial class _Default : System.Web.UI.Page{ private void Page_Load(object sender, EventArgs e) { //put user code to initialize the page here if (!IsPostBack) { SqlConnection myConn = new SqlConnection("server=(local);datdabase=newtb;uid=sa;pwd=123"); SqlCommand myCmd = new SqlCommand("select * from test where id=2", myConn); myConn.Open(); SqlDataReder myDr; myDr = myCmd.ExecuteReader(); myDr.Read(); Response.Write(myDr["content"].ToString()); myDr.Close(); myConn.Close(); } } private void Button1_Click(object sender, EventArgs e) { SqlConnection myConn = new SqlConnection("server=(local);database=newtb;uid=sa;pwd=123"); SqlCommand myCmd = new SqlCommand("insert into test (content) values('" + FreeTextBox1.Text + "')", myConn); myConn.Open(); myCmd.ExecuteNonQuery(); myConn.Close(); }}
运后出现这个错误:
编译错误
说明: 在编译向该请求提供服务所需资源的过程中出现错误。请检查下列特定错误详细信息并适当地修改源代码。
编译器错误信息: CS0246: 找不到类型或命名空间名称“SqlDataReder”(是否缺少 using 指令或程序集引用?)
源错误:
行 27: SqlCommand myCmd = new SqlCommand("select * from test where id=2", myConn);
行 28: myConn.Open();
行 29: SqlDataReder myDr;
行 30: myDr = myCmd.ExecuteReader();
行 31: myDr.Read();
------解决方案--------------------------------------------------------
SqlDataReder
SqlDataReader
写错啦,少了个a
------解决方案--------------------------------------------------------
你using System.Data.SqlClient;
为什么还会报这个错误?
你把你的页面的<%@Page里面添加 validateRequest="false" 试试
如果还不行,你再用try catch住代码,看下提示什么错误,
------解决方案--------------------------------------------------------
SqlConnection myConn = new SqlConnection("server=(local);datdabase=newtb;uid=sa;pwd=123");
SqlCommand myCmd = new SqlCommand("select * from test where id=2", myConn);
myConn.Open();
SqlDataReder myDr;
myDr = myCmd.ExecuteReader();
myDr.Read();
Response.Write(myDr["content"].ToString());
myDr.Close();
myConn.Close();
写错了 SqlDataReader myDr改改试试
------解决方案--------------------------------------------------------
------解决方案--------------------------------------------------------
晕死,你之前贴的错误只是因为少写了一个a,
你现在贴这么一点错误,
天知道什么问题,
------解决方案--------------------------------------------------------
下次细心点吧..