先上一段代码,高手看看,为什么Web页面连接 不到数据库。fanghuojianhujilurizhi是我的数据库的名字。DataGV是gridview控件的ID.namespace ElectLock.Manage
{
public partial class fanghuojianhujilurizhi(数据库的名字) : System.Web.UI.Page
{ protected void Page_Load(object sender, EventArgs e)
{
try
{
//if (!IsPostBack)
{
ViewState["WhereString"] = "";
try
{
string sWhereStr=Request.QueryString["WhereString"].ToString();
ViewState["WhereString"] = sWhereStr;// Server.UrlDecode(sWhereStr);
}
catch { }
try
{
int iPageIndex = 0;
string sPageindex = Request.QueryString["PageIndex"].ToString();
iPageIndex = Convert.ToInt32(sPageindex);
DataGV.PageIndex = iPageIndex;
}
catch { } GridDataBind("", ViewState["WhereString"].ToString(),0); }
}
catch
{ }
}
private void GridDataBind( string SortString,string sWhereString,int mode )
{ string DeptID = "";
string WhereString = "";
try
{
DeptID = Session["DEPTID"].ToString();
}
catch { } try
{
DeptID = this.Request.QueryString["DEPTID"];
}
catch { }
try
{
WhereString = this.Request.QueryString["WhereString"];
}
catch { } try
{ //string SELECT_SQL = " SELECT *" + // " FROM fanghuojianhujilurizhi a " + // " WHERE (a.DEPTID like '" + DeptID + "%' or a.DEPTID is null ) " + ViewState["WhereString"].ToString() + SortString; string SELECT_SQL = " SELECT *" + " FROM fanghuojianhujilurizhi a" + ViewState["WhereString"].ToString() + SortString;
//对要绑定到gridview的表数据进行排序 DataSet ds = DBSQLServer.Query(SELECT_SQL);
DataTable sdt = ds.Tables[0];
DataView dv = sdt.DefaultView;
if (SortString == "") dv.Sort = "id desc"; DataGV.DataKeyNames = new string[] {"danwei"};
if (sdt.Rows.Count == 0)
{
sdt.Rows.Add(sdt.NewRow());
DataGV.DataSource = sdt;
DataGV.DataBind();
int columnCount = sdt.Columns.Count;
DataGV.Rows[0].Cells.Clear();
DataGV.Rows[0].Cells.Add(new TableCell());
DataGV.Rows[0].Cells[0].ColumnSpan = columnCount;
DataGV.Rows[0].Cells[0].Text = "该表没有数据";
DataGV.Rows[0].Cells[0].Style.Add("text-align", "center");
DataGV.RowStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center;
lbDataCount.Text = "0"; }
else
{
if(mode==1)
DataGV.PageSize = sdt.Rows.Count;
lbDataCount.Text = sdt.Rows.Count.ToString(); DataGV.DataSource = sdt;
DataGV.DataBind();
} lbCurrPage.Text = (DataGV.PageIndex+1).ToString();
lbPageCount.Text = DataGV.PageCount.ToString(); }
catch(Exception err)
{ this.Response.Write("<script language=javascript>alert('"+err.ToString()+"');</script>");
} } private string GetDataIdFromGridView( )
{
int icount = 0;
string id="" ;
for (int i = 0; i < DataGV.Rows.Count; i++)
{
CheckBox chkbox=(CheckBox)DataGV.Rows[i].Cells[0].FindControl("CheckSelect");
if (chkbox.Checked == true)
{
icount += 1;
id = DataGV.DataKeys[i].Value.ToString(); }
}
{
public partial class fanghuojianhujilurizhi(数据库的名字) : System.Web.UI.Page
{ protected void Page_Load(object sender, EventArgs e)
{
try
{
//if (!IsPostBack)
{
ViewState["WhereString"] = "";
try
{
string sWhereStr=Request.QueryString["WhereString"].ToString();
ViewState["WhereString"] = sWhereStr;// Server.UrlDecode(sWhereStr);
}
catch { }
try
{
int iPageIndex = 0;
string sPageindex = Request.QueryString["PageIndex"].ToString();
iPageIndex = Convert.ToInt32(sPageindex);
DataGV.PageIndex = iPageIndex;
}
catch { } GridDataBind("", ViewState["WhereString"].ToString(),0); }
}
catch
{ }
}
private void GridDataBind( string SortString,string sWhereString,int mode )
{ string DeptID = "";
string WhereString = "";
try
{
DeptID = Session["DEPTID"].ToString();
}
catch { } try
{
DeptID = this.Request.QueryString["DEPTID"];
}
catch { }
try
{
WhereString = this.Request.QueryString["WhereString"];
}
catch { } try
{ //string SELECT_SQL = " SELECT *" + // " FROM fanghuojianhujilurizhi a " + // " WHERE (a.DEPTID like '" + DeptID + "%' or a.DEPTID is null ) " + ViewState["WhereString"].ToString() + SortString; string SELECT_SQL = " SELECT *" + " FROM fanghuojianhujilurizhi a" + ViewState["WhereString"].ToString() + SortString;
//对要绑定到gridview的表数据进行排序 DataSet ds = DBSQLServer.Query(SELECT_SQL);
DataTable sdt = ds.Tables[0];
DataView dv = sdt.DefaultView;
if (SortString == "") dv.Sort = "id desc"; DataGV.DataKeyNames = new string[] {"danwei"};
if (sdt.Rows.Count == 0)
{
sdt.Rows.Add(sdt.NewRow());
DataGV.DataSource = sdt;
DataGV.DataBind();
int columnCount = sdt.Columns.Count;
DataGV.Rows[0].Cells.Clear();
DataGV.Rows[0].Cells.Add(new TableCell());
DataGV.Rows[0].Cells[0].ColumnSpan = columnCount;
DataGV.Rows[0].Cells[0].Text = "该表没有数据";
DataGV.Rows[0].Cells[0].Style.Add("text-align", "center");
DataGV.RowStyle.HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center;
lbDataCount.Text = "0"; }
else
{
if(mode==1)
DataGV.PageSize = sdt.Rows.Count;
lbDataCount.Text = sdt.Rows.Count.ToString(); DataGV.DataSource = sdt;
DataGV.DataBind();
} lbCurrPage.Text = (DataGV.PageIndex+1).ToString();
lbPageCount.Text = DataGV.PageCount.ToString(); }
catch(Exception err)
{ this.Response.Write("<script language=javascript>alert('"+err.ToString()+"');</script>");
} } private string GetDataIdFromGridView( )
{
int icount = 0;
string id="" ;
for (int i = 0; i < DataGV.Rows.Count; i++)
{
CheckBox chkbox=(CheckBox)DataGV.Rows[i].Cells[0].FindControl("CheckSelect");
if (chkbox.Checked == true)
{
icount += 1;
id = DataGV.DataKeys[i].Value.ToString(); }
}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货