我用的是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
解决方案 »
- c#或者vb.net怎么实现多标签程序呢? 就是像比如chrome一样,打开新网页时候就不另开程序,而是在新标签里打开
- 大家帮我看一下,这个问题怎么解决
- c# 如何清理cookie
- C#窗体中用TIMER后窗体控件响应事件反应奇慢,请教解决办法!
- sqlserver 存储过程中字段是变量报错,如表名.@selectthismonth 报错
- 一个简单问题,不知该怎样写
- 如何优化该类阿
- webBrowser使用多线程问题
- Response.Write无法输出结果到页面
- 新手问一个关于开发C# WebService
- 從 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>");
}
}
改成这样子还是不行啊,怎么回事??