高手指点我这段代码哪里有问题，并指出如何修改，谢谢

[scdygwlj520]

private void button1_Click(object sender, EventArgs e)
{


SqlConnection con = new SqlConnection("server=.;database=dxdata;uid=sa;pwd= ");
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
string bh = textBox1.Text;
string sql = "select id,name,add from VIEW_db_Owner where id='" + bh + "'";
con.Open();
OdbcDataReader myread;
myread = con.ToString;
while(myread.Read())
{
textBox3.Text=myread.GetString(0);
textBox4.Text=myread.GetString(1);
comboBox1.Text=myread.GetString(2);

}

}

[EveryCase]

你最好自己单步调试一下。看看哪里出的问题！！

[hhlys]

OdbcDataReader myread;
myread = con.ToString;
楼主应该是这两句错了。
第一：OdbcDataReader 类用于与ODBC数据库打交道，从你其余代码来看，你现在是跟SQL数据库打交道，所以应该用SqlDataReader
第二：myread是OdbcDataReader 类型，myread = con.ToString;这句话明显不对；
应写为myread = cmd.ExecuterReader();

[PandaIT]

//好好去看看基础的ado.net
private void button1_Click(object sender, EventArgs e) 
        { 
            string bh = textBox1.Text; 
            string sql = "select id,name,add from VIEW_db_Owner where id='" + bh + "'"; 
            SqlConnection con = new SqlConnection("server=.;database=dxdata;uid=sa;pwd= "); 
            SqlConnection connection= new SqlConnection(con);
            con.Open(); 
            SqlCommand cmd = new SqlCommand(sql,connection); 
            
            SqlDataReader myread=cmd.ExecuteReader(); 
            while(myread.Read()) 
          { 
          textBox3.Text=myread.GetString(0); 
          textBox4.Text=myread.GetString(1); 
          comboBox1.Text=myread.GetString(2); 
          
          } 

        }

[hlgchina]

[Quote=引用 3 楼 zhoukang0916 的回复:]
C# code//好好去看看基础的ado.net
private void button1_Click(object sender, EventArgs e)
{
string bh = textBox1.Text;
string sql = "select id,name,add from VIEW_db_Owner where id='" + bh + "'";
SqlConnection con = new SqlConnection("server=.;database=dxdata;uid=sa;pwd= ");
SqlConnection connection= new SqlConnection(con);
…
[/Quote]


赞同，楼主的代码怎么看都像是asp的代码

[scdygwlj520]

myread = cmd.ExecuterReader();改为此句后出现下面的错误提示呢：

错误 1 “System.Data.SqlClient.SqlCommand”不包含“ExecuterReader”的定义，并且找不到可接受类型为“System.Data.SqlClient.SqlCommand”的第一个参数的扩展方法“ExecuterReader”(是否缺少 using 指令或程序集引用?)

[endlessw]

using System.data.Sqlclient;

[liu4545533]

[Quote=引用楼主 scdygwlj520 的帖子:]
private void button1_Click(object sender, EventArgs e)
{


SqlConnection con = new SqlConnection("server=.;database=dxdata;uid=sa;pwd= ");
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
string bh = textBox1.Text;
string sql = "select id,name,add from VIEW_db_Owner where id='" + bh + …
[/Quote]
myread里面根本就是空的 根本就没有查询数据