asp.net手机号码归属地查询代码(1/2)

create table t_phone
(
id int identity(1,1) not null primary key,
startno varchar(11) not null,
endno varchar(11) not null,
cityname nvarchar(50) not null
)

用户查询

sqlconnection con = new sqlconnection(system.configuration.configurationmanager.connectionstrings["conn"].tostring());
            con.open();
            string strtestno = this.userphoneno.text.trim();
            sqlcommand cmd = new sqlcommand();
            cmd.connection = con;
            cmd.commandtext = "select cityname from t_phone where startno<=@no and endno >=@no";
            sqlparameter sp = new sqlparameter("@no", sqldbtype.varchar, 50);
            sp.value = strtestno;
            cmd.parameters.add(sp);
            object ob = cmd.executescalar();
            messagebox.show(ob.tostring());

首页 1 2 末页