string str = "select * from testtable";
OdbcConnection myConnection = new OdbcConnection("dsn=testdb;uid=1;pwd=1");
myConnection.Open();
// OdbcCommand cmdCommand = new OdbcCommand(strCommandString, myConnection); OdbcDataAdapter adAdapter = new OdbcDataAdapter();
adAdapter.SelectCommand = new OdbcCommand(str , myConnection); DataSet dsDataSet = new DataSet(); adAdapter.Fill(dsDataSet, "testtable");//这里一直没反应。我直接执行select * from testtable 是有数据
adAdapter.Update();
return dsDataSet;
OdbcConnection myConnection = new OdbcConnection("dsn=testdb;uid=1;pwd=1");
myConnection.Open();
// OdbcCommand cmdCommand = new OdbcCommand(strCommandString, myConnection); OdbcDataAdapter adAdapter = new OdbcDataAdapter();
adAdapter.SelectCommand = new OdbcCommand(str , myConnection); DataSet dsDataSet = new DataSet(); adAdapter.Fill(dsDataSet, "testtable");//这里一直没反应。我直接执行select * from testtable 是有数据
adAdapter.Update();
return dsDataSet;
OdbcConnection myConnection = new OdbcConnection("Data Source=(local);Initial Catalog=testdb;uid=1;pwd=1");
myConnection.Open(); DataSet dsDataSet = new DataSet();
OdbcDataAdapter adAdapter =new SqlDataAdapter(str , myConnection);
adAdapter.Fill(dsDataSet, "testtable");
adAdapter.Fill(dsDataSet, "testtable");单步调试到这里,再按F10就没任何反应了。
OdbcConnection myConnection = new OdbcConnection("dsn=testdb;Initial Catalog=testdb;uid=prop;pwd=prop");还是不行。
后台是informix数据库。能insert数据,就是取不到数据我用MyReader = m_MyCommand.ExecuteReader();也是没反应。
我试过可以执行update和insert的操作,但要执行select到adp.Fill(tb);这句时就死了,也没有报错,占用cup还特别大