sql - Need Help To Create DataBase? -

-

i going create database in sql server 2014 have problem .

a need use option : when user want register , select country , city of country display , select .

for example : when user select u.s.a , display (newyourk , washington , . . . )

pic of prog 

create table orders (     orderid int identity (1,1) not null primary key,     fname varchar(50) not null,     lname varchar(50) not null,     tel varchar(15),     counts int not null,      daysid int not null,     countryid int not null,     cityid int not null,     address varchar(1024) not null,     foreign key (daysid) references weekdays(daysid),     foreign key (countryid) references country(contryid),     foreign key (cityid) references city(cityid) ) go create table weekdays (     daysid int identity (10000001,1) not null primary key,     daysname varchar(50) not null ) go create table country (     countryid int identity (2000000,1) not null primary key,     countryname varchar(100) ) create table city (     cityid int identity (2000000,1) not null primary key,     cityname varchar(100) )

for must have foreign key of countryid in city table can fetch cities of usa

create table city (     cityid int identity (2000000,1) not null primary key,     cityname varchar(100)     countryid int      foreign key (countryid ) references country(countryid ) )  --fetch records  select * form city countryid=1 -- or whatever id of country

Comments

Post a Comment

Popular posts from this blog

Hatching array of circles in AutoCAD using c# -

-
i beginner in autocad plugins .i have created array of circle using following code. now, have hatch circles in array .how that??how hatch circles @ once? moreover, how can return hatch method , use hatch objects.sorry language.thanks in advance. [assembly: commandclass(typeof(beamsection.class1))] namespace beamsection { public class class1 { //class1 obj = new class1(); [commandmethod("beamatsupport")] public void addlightweightpolyline() { // current document , database document acdoc = application.documentmanager.mdiactivedocument; database accurdb = acdoc.database; promptpointresult ppr = acdoc.editor.getpoint("\nselect starting point "); var ucs = acdoc.editor.currentusercoordinatesystem; point3d startingpt = ppr.value.transformby(ucs); list<double> radius = new list<double>(); radius.add(0.5);
Read more

ios - UITEXTFIELD InputView Uipicker not working in swift -

-
hello trying pop uipickerview view programmatically when user clicks on textfield. have tried doesn't doing anything. isn't working. nothing happening when click textfield class userprofiletableviewcontroller: uitableviewcontroller,uitextfielddelegate,uipickerviewdelegate,uipickerviewdatasource { var itempicker: uipickerview! = uipickerview() @iboutlet weak var gendertxtfield: uitextfield! var gender = ["male","female"] override func viewdidload() { super.viewdidload() gendertxtfield.delegate = self itempicker!.delegate = self itempicker!.datasource = self itempicker!.backgroundcolor = uicolor.blackcolor() self.gendertxtfield.inputview = itempicker } func numberofcomponentsinpickerview(pickerview: uipickerview) -> int{ return 1 } // returns # of rows in each component.. func pickerview(pickerview: uipickerview, numberofrowsincomponent component:
Read more