一个简单的查询问题？

[yang528119]

String strSql = "select [table_option] from table_option where [table_name]='wz'";
我怎么把满足条件是"wz"的那一个值显示出来呀？
用DATASET可以吗？怎么写

[duwx]

DataRow [] dr = ds.Table[0].Select("[table_name]='wz'");

[yang528119]

还是不得行呀？下面是我写的代码：
String strSql = "select [table_option] from table_option where [table_name]='wz'";
SqlCommand sqlCmd = new SqlCommand(strSql,new SqlConnection("data source=ZHOU;initial catalog=gsgl_xt;persist security info=False;user id=sa;workstation id=ZHOU;packet size=4096"));
SqlDataAdapter sqlDA = new SqlDataAdapter(sqlCmd);
DataSet dataSet = new DataSet();
sqlDA.Fill(dataSet,"table_option");
string iCount = dataSet.Tables["table_option"].Rows[0][0].ToString();
帮我看看