asp.net mobile phone number attribution to the query code (1/2)

CREATE TABLE T_phone
(
ID int identity (1,1) not null primary key,
Startno varchar (one) is not NULL,
Endno varchar (one) is not NULL,
CityName nvarchar (m) NOT NULL
)

User Inquiries

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 ());

Home 1 2 last page