我在论坛里搜过了 好像没有这方面的解答、、、、
多的不说了 我先上一段关键代码: ss_sql = "select OPBasi_Worker_ID,OPMana_ClientIP_IP,OPMana_ClientIP_MAC, "
+ " OPMana_ClientIP_Host,OPBasi_NETPort_ID,OPMana_ClientIP_LAN, "
+ " OPMana_ClientIP_Extranet,OPMana_ClientIP_Status "
+ " from OPMana_ClientIP "
+ " where OPBasi_Worker_ID=" + unfe.getUserID(textBox6.Text.Trim()) + "or "
+ " OPMana_ClientIP_IP like '%" + textBox6.Text.Trim() + "%'or "
+ " OPMana_ClientIP_MAC like '%" + textBox6.Text.Trim() + "%'";
m_reader = m_dbclass.getReader(ss_sql);
DataTable m_dt = new DataTable();
m_dt.Columns.Add("姓名", typeof(string));
m_dt.Columns.Add("姓名ID", typeof(string));
m_dt.Columns.Add("IP地址", typeof(string));
m_dt.Columns.Add("MAC地址", typeof(string));
m_dt.Columns.Add("计算机名", typeof(string));
m_dt.Columns.Add("网口编号", typeof(string));
m_dt.Columns.Add("内网状态", typeof(string));
m_dt.Columns.Add("外网状态", typeof(string));
m_dt.Columns.Add("状态", typeof(string)); if (m_reader.HasRows)
{
while (m_reader.Read())
{
DataRow m_dr = m_dt.NewRow();
string Idtoname;
Idtoname = unfe.getUsernameFromUserID(Convert.ToInt32(m_reader["OPBasi_Worker_ID"])).ToString();
m_dr[0] = Idtoname;
m_dr[1] = m_reader["OPBasi_Worker_ID"].ToString().Trim();
m_dr[2] = m_reader["OPMana_ClientIP_IP"].ToString().Trim();
m_dr[3] = m_reader["OPMana_ClientIP_MAC"].ToString().Trim();
m_dr[4] = m_reader["OPMana_ClientIP_Host"].ToString().Trim();
m_dr[5] = m_reader["OPBasi_NETPort_ID"].ToString().Trim();
m_dr[6] = m_reader["OPMana_ClientIP_LAN"].ToString().Trim();
m_dr[7] = m_reader["OPMana_ClientIP_Extranet"].ToString().Trim();
m_dr[8] = m_reader["OPMana_ClientIP_Status"].ToString().Trim();
m_dt.Rows.Add(m_dr);
}
}
dataGridView1.DataSource = m_dt;
然后现在我做了一个搜索功能,点击搜索确实能显示全部的数据,但是我想不用点搜索就直接在datagridview中显示全部内容应该怎么做??脑子比较笨、请帮我解答下 谢谢
多的不说了 我先上一段关键代码: ss_sql = "select OPBasi_Worker_ID,OPMana_ClientIP_IP,OPMana_ClientIP_MAC, "
+ " OPMana_ClientIP_Host,OPBasi_NETPort_ID,OPMana_ClientIP_LAN, "
+ " OPMana_ClientIP_Extranet,OPMana_ClientIP_Status "
+ " from OPMana_ClientIP "
+ " where OPBasi_Worker_ID=" + unfe.getUserID(textBox6.Text.Trim()) + "or "
+ " OPMana_ClientIP_IP like '%" + textBox6.Text.Trim() + "%'or "
+ " OPMana_ClientIP_MAC like '%" + textBox6.Text.Trim() + "%'";
m_reader = m_dbclass.getReader(ss_sql);
DataTable m_dt = new DataTable();
m_dt.Columns.Add("姓名", typeof(string));
m_dt.Columns.Add("姓名ID", typeof(string));
m_dt.Columns.Add("IP地址", typeof(string));
m_dt.Columns.Add("MAC地址", typeof(string));
m_dt.Columns.Add("计算机名", typeof(string));
m_dt.Columns.Add("网口编号", typeof(string));
m_dt.Columns.Add("内网状态", typeof(string));
m_dt.Columns.Add("外网状态", typeof(string));
m_dt.Columns.Add("状态", typeof(string)); if (m_reader.HasRows)
{
while (m_reader.Read())
{
DataRow m_dr = m_dt.NewRow();
string Idtoname;
Idtoname = unfe.getUsernameFromUserID(Convert.ToInt32(m_reader["OPBasi_Worker_ID"])).ToString();
m_dr[0] = Idtoname;
m_dr[1] = m_reader["OPBasi_Worker_ID"].ToString().Trim();
m_dr[2] = m_reader["OPMana_ClientIP_IP"].ToString().Trim();
m_dr[3] = m_reader["OPMana_ClientIP_MAC"].ToString().Trim();
m_dr[4] = m_reader["OPMana_ClientIP_Host"].ToString().Trim();
m_dr[5] = m_reader["OPBasi_NETPort_ID"].ToString().Trim();
m_dr[6] = m_reader["OPMana_ClientIP_LAN"].ToString().Trim();
m_dr[7] = m_reader["OPMana_ClientIP_Extranet"].ToString().Trim();
m_dr[8] = m_reader["OPMana_ClientIP_Status"].ToString().Trim();
m_dt.Rows.Add(m_dr);
}
}
dataGridView1.DataSource = m_dt;
然后现在我做了一个搜索功能,点击搜索确实能显示全部的数据,但是我想不用点搜索就直接在datagridview中显示全部内容应该怎么做??脑子比较笨、请帮我解答下 谢谢
解决方案 »
- 新手求助:怎样改变datagridview的显示值?
- WPF DataGridTextColumn列如何让其中的单元格不可编辑
- .net cf 登入窗体求助
- .NET2.0做图片左右或上下切换效果怎么弄?
- 关于contextMenu与linklabel建立对应关系的问题
- 我要让右键的功能等同于左键的功能怎么实现啊!
- 请问可以让windows服务定时执行项目的中的一个可多少form吗?
- 组合算法
- 如果在VC#中调用Outlook Express来发信(在线等待)
- graphicspath.transform(matrix)是怎么变换的?
- ~~~~(>_<)~~~~ 哪位大哥知道怎么使折线图的横坐标轴可伸缩哇,好难哦好难
- 在web页面上打开服务器已经存在的word等文件,路径也提供
{
if(!IsPostBack())
{
ShowAll();
}
}void ShowAll()
{
ss_sql = "select OPBasi_Worker_ID,OPMana_ClientIP_IP,OPMana_ClientIP_MAC, "
+ " OPMana_ClientIP_Host,OPBasi_NETPort_ID,OPMana_ClientIP_LAN, "
+ " OPMana_ClientIP_Extranet,OPMana_ClientIP_Status "
+ " from OPMana_ClientIP "
+ " where OPBasi_Worker_ID=" + unfe.getUserID(textBox6.Text.Trim()) + "or "
+ " OPMana_ClientIP_IP like '%" + textBox6.Text.Trim() + "%'or "
+ " OPMana_ClientIP_MAC like '%" + textBox6.Text.Trim() + "%'";
m_reader = m_dbclass.getReader(ss_sql);
DataTable m_dt = new DataTable();
m_dt.Columns.Add("姓名", typeof(string));
m_dt.Columns.Add("姓名ID", typeof(string));
m_dt.Columns.Add("IP地址", typeof(string));
m_dt.Columns.Add("MAC地址", typeof(string));
m_dt.Columns.Add("计算机名", typeof(string));
m_dt.Columns.Add("网口编号", typeof(string));
m_dt.Columns.Add("内网状态", typeof(string));
m_dt.Columns.Add("外网状态", typeof(string));
m_dt.Columns.Add("状态", typeof(string)); if (m_reader.HasRows)
{
while (m_reader.Read())
{
DataRow m_dr = m_dt.NewRow();
string Idtoname;
Idtoname = unfe.getUsernameFromUserID(Convert.ToInt32(m_reader["OPBasi_Worker_ID"])).ToString();
m_dr[0] = Idtoname;
m_dr[1] = m_reader["OPBasi_Worker_ID"].ToString().Trim();
m_dr[2] = m_reader["OPMana_ClientIP_IP"].ToString().Trim();
m_dr[3] = m_reader["OPMana_ClientIP_MAC"].ToString().Trim();
m_dr[4] = m_reader["OPMana_ClientIP_Host"].ToString().Trim();
m_dr[5] = m_reader["OPBasi_NETPort_ID"].ToString().Trim();
m_dr[6] = m_reader["OPMana_ClientIP_LAN"].ToString().Trim();
m_dr[7] = m_reader["OPMana_ClientIP_Extranet"].ToString().Trim();
m_dr[8] = m_reader["OPMana_ClientIP_Status"].ToString().Trim();
m_dt.Rows.Add(m_dr);
}
}
dataGridView1.DataSource = m_dt;
}
click事件是做关键字搜索的,只是我在textbox前后加了“%”来做模糊搜索,模糊搜索还是必须的、、、
form_load
{
ShowAll();
}
找到lode了,稍等 我验证下