Asp.net Remove and comare district id get related values

Question

Hi I am storing related state multiple district values to data base splited by  like district values 12 like that now what i need based on district id remove  and get district id values comapare this values to district table need to related district names dropdown checkbox list either store procedure arec# code

Midhun T P · Answer

Hi You can try like below in procedure if you need data for a particular row. DECLARE @districts VARCHAR(100) SET @districts=(SELECT district FROM statetable WHERE srno =1) DECLARE @tbl TABLE (district VARCHAR(20) NOT NULL) DECLARE @pos int @nextpos int @valuelen int SELECT @pos = 0 @nextpos = 1 WHILE @nextpos > 0 BEGIN SELECT @nextpos = charindex('' @districts @pos + 1) SELECT @valuelen = CASE WHEN @nextpos > 0 THEN @nextpos ELSE len(@districts) + 1 END - @pos - 1 INSERT @tbl (district) VALUES (substring(@districts @pos + 1 @valuelen)) SELECT @pos = @nextpos END SELECT * FROM districttable WHERE districtid IN( SELECT district FROM @tbl) Marked variables are names of columns and tables which you have to change accordingly

Asp.net Remove , and comare district id get related values