From1 listview空间,查询按钮button,点击查询button跳转到From2.From2连接数据库查询数据,查询的结果返回到From1的listview。问题是我现在From1 listview什么值都没有的到。本人小白,所以各位最好详情点,谢谢。
AseDataReader reader = null;
Myplayer myplayer =new Myplayer();
AseConnection conn = new AseConnection("Data Source='192.168.7.88';Port='5000';UID='sa';PWD='';Database='GZMCH'; MaxPoolSize = 10;MinPoolSize = 5;ConnectionTimeout = 15;");
try
{
conn.Open();
// String sqlstr = "select phone,filename from call_phone_takelog_ago where logtime>" + starttime + " and logtime<" + endtime + "";
String sqlstr = "exec sp_lylisten";
AseCommand cmd = new AseCommand(sqlstr, conn); reader = cmd.ExecuteReader();
while (reader.Read())
{
ListViewItem lv = new ListViewItem();
lv.SubItems.Clear();
lv.SubItems.Add(Convert.ToString(reader["rowid"]));
lv.SubItems.Add(Convert.ToString(reader["phone"]));
lv.SubItems.Add(Convert.ToString(reader["filename"]));
myplayer.listView1.Items.Add(lv);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
this.Hide();
reader.Close();
conn.Close();
}
AseDataReader reader = null;
Myplayer myplayer =new Myplayer();
AseConnection conn = new AseConnection("Data Source='192.168.7.88';Port='5000';UID='sa';PWD='';Database='GZMCH'; MaxPoolSize = 10;MinPoolSize = 5;ConnectionTimeout = 15;");
try
{
conn.Open();
// String sqlstr = "select phone,filename from call_phone_takelog_ago where logtime>" + starttime + " and logtime<" + endtime + "";
String sqlstr = "exec sp_lylisten";
AseCommand cmd = new AseCommand(sqlstr, conn); reader = cmd.ExecuteReader();
while (reader.Read())
{
ListViewItem lv = new ListViewItem();
lv.SubItems.Clear();
lv.SubItems.Add(Convert.ToString(reader["rowid"]));
lv.SubItems.Add(Convert.ToString(reader["phone"]));
lv.SubItems.Add(Convert.ToString(reader["filename"]));
myplayer.listView1.Items.Add(lv);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
this.Hide();
reader.Close();
conn.Close();
}
解决方案 »
- 关于通过创建satellite集,实现culture的resource文件
- (100散分帖)请大家讨论Socket及WCF分布式开发的应用领域?(在线等)
- C#问题?
- 【【又来狂甩分了】】请问WinForm下的DataGrid怎么用?【200分,帮顶有喜哈】
- 请问用.net开发web ,要精通javascipt吗
- listview如何设置工作区大小
- 桌面型数据库应用使用SQL Server 2005 Express取代Access数据库是否好?
- [求助]利用AVIwriter将Bitmap写入AVI时,无法释放内存
- 这是能算一个合格的软件吗?
- 根据已有的datatable创建新表!!
- C# datagridview 两列相乘
- 请教listbox的显示问题
具体的你可以看一下这个
http://www.csharpwin.com/csharpspace/11464r9594.shtml
//Form2
public Form1 Test { get; set; }
//Init为Form1中的ListView的初始化方法
Test.Init(DataTable dt);
Form2 f2 = new Form2();
f2.Test = this;
f2.Show();这样就相当于你将Form2中得到的Datatable传回给Form1了