100分--我又来了
依然是分页的问题。
还请各位大哥不要说喊我去论坛搜起自己看。我送分的啊。
论坛的我都看的差不多了。好多都是语言不怎么通，而且好多都是自己做函数来分页。我这里用的控件的。只是出错而已。
尝试，打开页面显示全部数据。
第搜索时，分页也应该正常。但是这里的bind()出错了。
提示：重载“bind”方法未获取“0”参数
数据连接与细节是没错的。只是这里怎么传递参数不会。
小弟是自学。纯熟菜鸟级人物。还望各位说详细点。
<script runat= "server " language= "c# ">
protected void Page_Load(object sender, EventArgs e)
{
if(!IsPostBack)
{
string strConnection= "Provider=Microsoft.Jet.OleDb.4.0;Data Source= ";
strConnection+=Server.MapPath( "1.mdb ");
OleDbConnection objConnection=new OleDbConnection (strConnection);
String ee5= "update jinhuo,DS_ClassInf set jinhuo.classname2=DS_ClassInf.classname where jinhuo.ClassID2=DS_ClassInf.ClassID ";
OleDbCommand objCommand115 = new OleDbCommand(ee5,objConnection);
objCommand115.Connection.Open();
objCommand115.ExecuteNonQuery();
objCommand115.Connection.Close();
String sql = "select bianhao as 教材编号,bookname as 教材名称,shuliang as 进货数量,booktime as 进货时间,Classname as 类别2,Classname2 as 类别1 from jinhuo ORDER by [booktime] desc ";
DataSet ds = new DataSet();
OleDbDataAdapter myada = new OleDbDataAdapter(sql,strConnection);
myada.Fill(ds, "jinhuo ");
dgrdMain.DataSource = ds.Tables[ "jinhuo "].DefaultView;
dgrdMain.DataBind();
}
else
{
bind();
}
public void bind(object sender, EventArgs e)
{
string strConnection= "Provider=Microsoft.Jet.OleDb.4.0;Data Source= ";
strConnection+=Server.MapPath( "1.mdb ");
OleDbConnection objConnection=new OleDbConnection (strConnection);
String sql = "select bianhao as 教材编号,bookname as 教材名称,shuliang as 进货数量,booktime as 进货时间,Classname as 类别2,Classname2 as 类别1 from jinhuo where bianhao= ' " + bianhao.Text + " ' and format([booktime], 'yyyy-mm-dd HH:mm:ss ')> = ' "+shijian1.Text+ " ' and format([booktime], 'yyyy-mm-dd HH:mm:ss ') <= ' "+shijian2.Text+ " ' ORDER by [booktime] desc ";
DataSet ds = new DataSet();
OleDbDataAdapter myada = new OleDbDataAdapter(sql,strConnection);
myada.Fill(ds, "jinhuo ");
dgrdMain.DataSource = ds.Tables[ "jinhuo "].DefaultView;
dgrdMain.CurrentPageIndex=0;
dgrdMain.DataBind();
}
public void MyDataGrid_Page(object sender, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
dgrdMain.CurrentPageIndex = e.NewPageIndex;
DataBind();
}
</script>
<asp:Button ID= "Button1 " Text= "开始查询 " OnClick= "bind " runat= "server " />
<asp:DataGrid AllowCustomPaging= "false " AllowPaging= "true " BorderColor= "#999999 " BorderWidth= "1 " CellPadding= "5 " CellSpacing= "0 " CssClass= "STYLE3 " ID= "dgrdMain " PageSize= "5 " runat= "server " OnPageIndexChanged= "MyDataGrid_Page ">
<PagerStyle NextPageText= "下一页 " PrevPageText= "上一页 "> </PagerStyle>
</asp:DataGrid>
[解决办法]
up
[解决办法]
public void bind(object sender, EventArgs e)这个函数是你自己写吧？？
这个是不要参数的
改成
public void bind()
{
string strConnection= "Provider=Microsoft.Jet.OleDb.4.0;Data Source= ";
strConnection+=Server.MapPath( "1.mdb ");
OleDbConnection objConnection=new OleDbConnection (strConnection);
String sql = "select bianhao as 教材编号,bookname as 教材名称,shuliang as 进货数量,booktime as 进货时间,Classname as 类别2,Classname2 as 类别1 from jinhuo where bianhao= ' " + bianhao.Text + " ' and format([booktime], 'yyyy-mm-dd HH:mm:ss ')> = ' "+shijian1.Text+ " ' and format([booktime], 'yyyy-mm-dd HH:mm:ss ') <= ' "+shijian2.Text+ " ' ORDER by [booktime] desc ";
DataSet ds = new DataSet();
OleDbDataAdapter myada = new OleDbDataAdapter(sql,strConnection);
myada.Fill(ds, "jinhuo ");
dgrdMain.DataSource = ds.Tables[ "jinhuo "].DefaultView;
dgrdMain.CurrentPageIndex=0;
dgrdMain.DataBind();
}
[解决办法]
public void bind(object sender, EventArgs e) 你这个函数为什么要带参数呢
直接写成private void bind()
[解决办法]
如果是重载的话要加上override关键字的
比如重载onmousemove方法
protected override onmousemove(object sender, EventArgs e)
{
}
[解决办法]
顶者有分，快上
[解决办法]
else
{
bind(sender,e);
}
[解决办法]
bind(); //这个是你调用的没有传递参数但是你下面却给函数写了参数，所以导致出错。
public void bind(object sender, EventArgs e) //这里不应该多两个参数
因为你数据库连接做在函数里了，所以不传递参数也不影响。
如果想传值可以用ViewState，可以查下MSDN，很详细，就是相当于页面级变量依然可以不给函数传递参数，直接给ViewState变量赋值调用。
例：ViewState[ "UserName "] = "MyName "
public void bind()
{
string strName = ViewState[ "UserName "].ToString();
}
[解决办法]
//自己定义的函数，不事委托哦
public void bind()
{
代码内容
}
[解决办法]
bind();-> bind(sender,e);
[解决办法]
代码太长，有空帮你看看
[解决办法]
public void bind()
{}
[解决办法]
不懂JS,友情帮顶
[解决办法]
bind(); 改为： bind(null,e);
[解决办法]
我又来接分了
