DataSet, sqlDataAdapter 使用

DataSet, sqlDataAdapter 使用

private void btnSearch_Click(object sender, RoutedEventArgs e)
{
long resault;//这个只是给下一行TryParse用的，没有实际用途
if (tbNumber.Text.Length < 7 || tbNumber.Text.Length > 11 || !long.TryParse(tbNumber.Text, out resault))
{
MessageBox.Show("输入号码有误，无法查询。");
return;
}
string numsection = tbNumber.Text.Substring(0, 7);
string connStr = ConfigurationManager.ConnectionStrings["dbConnStr"].ConnectionString;
using (SqlConnection conn = new SqlConnection(connStr))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
//cmd.CommandText = "select * from T_Nums where NumSection=1300000";
cmd.CommandText = "select * from T_Nums where NumSection=@numsection";
cmd.Parameters.Add(new SqlParameter("@numsection", numsection));
DataSet ds = new DataSet();
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
adapter.Fill(ds);
//DataRow row = ds.Tables[0].Rows[0];
if (ds.Tables[0].Rows.Count == 0)
{
MessageBox.Show("没有查询到结果。");
return;
}
//foreach (DataRow row in ds.Tables[0].Rows)
//{
// string AddressStr = row["AddressStr"].ToString();
// MessageBox.Show(AddressStr);
//}
DataRow row = ds.Tables[0].Rows[0];
MessageBox.Show(tbNumber.Text + "\n号码归属地为：" + row["AddressStr"] +
"\n号码类型为：" + row["NumType"] + "\n区号为：" + row["AreaCode"]);
}
}
}