我用的是C# DataGrid 直接与数据库绑定!
private void cx_Click(object sender, System.EventArgs e)
{
if(bh.Text.Length>0)
{
string selstring="select top 5 * from data where serialNumber='";
selstring=selstring+bh.Text+"'";
OleDbCommand myCmd = new OleDbCommand(selstring ,conn);
myCmd.Connection.Open();
OleDbDataReader dr;
dr = myCmd.ExecuteReader();
if(dr.Read())
{
ID =dr["id"].ToString();
Response.Redirect("serch.aspx?ID="+ID);
}
else
{
Response.Write("<script language=javascript>alert('没有符合条件的表单,请重新查询!');</script>");
}
myCmd.Connection.Close();
bind();
bh.Text = null;
rq.Text = null;
mc.Text = null;
}
可是查询的结果并没有显示在 DataGrid的第一行中,谁能帮我解答一下,不甚感激啊!
我编的是C#中的WebForm
private void cx_Click(object sender, System.EventArgs e)
{
if(bh.Text.Length>0)
{
string selstring="select top 5 * from data where serialNumber='";
selstring=selstring+bh.Text+"'";
OleDbCommand myCmd = new OleDbCommand(selstring ,conn);
myCmd.Connection.Open();
OleDbDataReader dr;
dr = myCmd.ExecuteReader();
if(dr.Read())
{
ID =dr["id"].ToString();
Response.Redirect("serch.aspx?ID="+ID);
}
else
{
Response.Write("<script language=javascript>alert('没有符合条件的表单,请重新查询!');</script>");
}
myCmd.Connection.Close();
bind();
bh.Text = null;
rq.Text = null;
mc.Text = null;
}
可是查询的结果并没有显示在 DataGrid的第一行中,谁能帮我解答一下,不甚感激啊!
我编的是C#中的WebForm
解决方案 »
- 关于升级程序的关闭旧版本,运行新版本问题,请高手解答!
- 请教关于Properties.Settings中的问题
- 【【在实战应用中,我该选择哪种缓存解决方案。】】【100】
- 一个很简单的问题, VS.NET 报错,请教大家.
- Remoting 服务器端配置文件问题,怎么解决阿,牛人帮帮我 。
- 怎样写代码实现“判断所输入SQL语句的正确性”
- 怎么机器总自动改我的代码啊???
- 请教有关类的问题(50')
- 关于C#导出的WORD中加入页眉页脚
- 小菜问题:枪分!答对立即给分!
- 從 System.String 至 System.Guid 的轉換無效 高分幫忙看一下
- 点击label控件(它没有焦点),在点击窗口其它地方,label控件怎么知道(leave用不了,没有焦点)?
{
string mysel;
mysel="select top 5 * from data order by serialNumber,bdate,bname";
// OleDbCommand myCmd=new OleDbCommand(mysel,conn);
OleDbDataAdapter myfill=new OleDbDataAdapter(mysel,conn);
OleDbCommandBuilder myBuilder=new OleDbCommandBuilder(myfill);
DataSet ds=new DataSet();
myfill.Fill(ds,"data");
cxDGrid.DataSource = ds.Tables["data"];
cxDGrid.DataBind(); }我用函数绑定的啊,bind();
DataGrid1.DataSource=;
DataGrid1.DataBind;
{
if(bh.Text.Length>0)
{
string selstring="select top 5 * from data where serialNumber='";
selstring=selstring+bh.Text+"'";
OleDbCommand myCmd = new OleDbCommand(selstring ,conn);
myCmd.Connection.Open();
// myCmd.Connection.Close(); OleDbDataAdapter myfill=new OleDbDataAdapter(selstring,conn);
OleDbCommandBuilder myBuilder=new OleDbCommandBuilder(myfill);
DataSet ds=new DataSet();
myfill.Fill(ds,"data");
cxDGrid.DataSource = ds.Tables["data"];
cxDGrid.DataBind();
OleDbDataReader dr;
dr = myCmd.ExecuteReader();
if(dr.Read())
{
ID =dr["id"].ToString();
Response.Redirect("serch.aspx?ID="+ID);
}
else
{
Response.Write("<script language=javascript>alert('没有符合条件的表单,请重新查询!');</script>");
}
bh.Text = null;
rq.Text = null;
mc.Text = null;
}
else if(rq.Text.Length>0)
{
string selstring="select top 5 * from data ID where bdate='"; selstring=selstring+rq.Text+"'";
OleDbCommand myCmd = new OleDbCommand(selstring ,conn);
myCmd.Connection.Open();
OleDbDataReader dr;
dr = myCmd.ExecuteReader();
if(dr.Read())
{
ID =dr["id"].ToString();
Response.Redirect("serch.aspx?ID="+ID);
}
else
{
Response.Write("<script language=javascript>alert('没有符合条件的表单,请重新查询!');</script>");
}
myCmd.Connection.Close();
rq.Text = null;
mc.Text = null;
}
else if(mc.Text.Length>0)
{
string selstring="select top 5 * from data where bname='"; selstring=selstring+mc.Text+"'";
OleDbCommand myCmd = new OleDbCommand(selstring ,conn);
myCmd.Connection.Open();
OleDbDataReader dr;
dr = myCmd.ExecuteReader();
if(dr.Read())
{
ID =dr["id"].ToString();
Response.Redirect("serch.aspx?ID="+ID);
}
else
{
Response.Write("<script language=javascript>alert('没有符合条件的表单,请重新查询!');</script>");
}
myCmd.Connection.Close();
mc.Text = null;
}
else
{
Response.Write("<script language=javascript>alert('请输入你要查询的信息!');</script>");
}
}
改成这样子还是不行啊,怎么回事??