Click here to Skip to main content
15,887,854 members
Home / Discussions / Visual Basic
   

Visual Basic

 
Questionradio button column in datagrid Pin
jhyn21-Aug-07 2:53
jhyn21-Aug-07 2:53 
Questionhashtable Pin
WhiteGirl2321-Aug-07 1:36
WhiteGirl2321-Aug-07 1:36 
AnswerRe: hashtable Pin
Christian Graus21-Aug-07 1:49
protectorChristian Graus21-Aug-07 1:49 
GeneralRe: hashtable Pin
WhiteGirl2321-Aug-07 1:52
WhiteGirl2321-Aug-07 1:52 
QuestionListivew Column Type Pin
ejaz_pk21-Aug-07 1:09
ejaz_pk21-Aug-07 1:09 
QuestionMultiLanguage Solution. Pin
portech21-Aug-07 1:05
portech21-Aug-07 1:05 
AnswerRe: MultiLanguage Solution. Pin
Johan Hakkesteegt23-Aug-07 3:17
Johan Hakkesteegt23-Aug-07 3:17 
Questionreplace function Pin
soniasan20-Aug-07 23:58
soniasan20-Aug-07 23:58 
Hi
All
i write one procedure whichdisplay the data
last statment of that proc is
one of the field service _provded the user is filling the long itenerary data.
for ex.....

23 Oct | Arrive Bangalore
Arrive and transfer to your hotel. This afternoon you visit the Lal Baugh Botanical Gardens, the 16th century Bull Temple and drive past the Vidhan Saudha. Overnight at hotel.
24 Oct | Bangalore - Mysore
Transfer by road to Mysore (120 kms / 3 hrs) en-route you visit the Shravanbelagola, home to the massive 18m monolithic Gomateshwara (or Bahubali) statue. Overnight at hotel.
25 Oct | Mysore
This morning visit the Mysore Palace known for its veritable treasure trove of exquisite carvings and works of art from world over, the Chamundi Hills for a panoramic view of Mysore city and the Rajendra Art Gallery which houses some remarkable selections of paintings by Raja Ravi Verma. The evening is at leisure for shopping some of Mysore's famous silks & fabrics. Overnight at hotel.
26 Oct | Mysore - Ooty
Transfer by road to Ooty (158 kms / 4 hrs) 'the Queen of Hill stations'. The rest of the day is at leisure to explore this picturesque hill station. Overnight at hotel.
27 Oct | Ooty
This morning you visit the Doddabetta Peak, the highest peak in the Nilgiri mountains, the beautifully landscaped Botanical Gardens and the scenic Ooty lake where you may enjoy an optional boat ride. Overnight at hotel.
28 Oct | Depart Banglore
Transfer to Bangalore airport ( 290 kms/ 7 hrs).



Now my problem is that when that procedures shows the
o/p it is not proper means suppose itenerary for 23oct finishes then immediately it stats with the next date 24 oct itenarary

i am looking for the something like replace function

Pl. Suggest
proc is given serv_provided is creating problem for me.

Thanks & regards

<br />
CREATE  proc showtrandetailreport<br />
(<br />
@conf_no varchar(20)<br />
<br />
)<br />
as<br />
set nocount on<br />
declare @tr_detail table(id int identity(1,1),tr_todate varchar(50), tr_fromdate varchar(50),entrycity varchar(100),exitcity varchar(100),ser varchar(100),sicpvt varchar(30),serv_Provided varchar(5000),remark varchar(2000),transfer_type varchar(2000))<br />
<br />
insert into @tr_detail(tr_fromdate,tr_todate,entrycity,exitcity,ser,sicpvt,serv_Provided,remark,transfer_type )(select convert(varchar(15),trn_fromdate,106),convert(varchar(15),trn_todate,106),entrycity,exitcity,service,sicpvt,serv_Provided,remark ,transfer_type from confirm_transfer_detail where  voucher_id = @conf_no)<br />
<br />
select  transfer_type as 'TRANSFER TYPE',entrycity as 'ENTRYCITY',exitcity as 'EXITCITY', serv_Provided  as 'SERVICES PROVIDED', remark as 'REMARK' ,tr_fromdate as 'ARRIVAL',tr_todate as 'DEPARTURE'  from @tr_detail order by id<br />
<br />
GO<br />
<br />
<br />

QuestionSSH Component for VB.NET Pin
hobbit66620-Aug-07 23:10
hobbit66620-Aug-07 23:10 
Questiondecrypt a file in stringbuilder Pin
WhiteGirl2320-Aug-07 23:03
WhiteGirl2320-Aug-07 23:03 
AnswerRe: decrypt a file in stringbuilder Pin
Christian Graus20-Aug-07 23:09
protectorChristian Graus20-Aug-07 23:09 
GeneralRe: decrypt a file in stringbuilder Pin
WhiteGirl2320-Aug-07 23:29
WhiteGirl2320-Aug-07 23:29 
GeneralRe: decrypt a file in stringbuilder Pin
Colin Angus Mackay20-Aug-07 23:58
Colin Angus Mackay20-Aug-07 23:58 
GeneralRe: decrypt a file in stringbuilder Pin
Christian Graus21-Aug-07 0:01
protectorChristian Graus21-Aug-07 0:01 
GeneralRe: decrypt a file in stringbuilder Pin
WhiteGirl2321-Aug-07 0:52
WhiteGirl2321-Aug-07 0:52 
QuestionUpdate statement Pin
magedhv20-Aug-07 22:48
magedhv20-Aug-07 22:48 
AnswerRe: Update statement Pin
Christian Graus20-Aug-07 23:11
protectorChristian Graus20-Aug-07 23:11 
AnswerRe: Update statement Pin
Bhaskar Shetty20-Aug-07 23:49
Bhaskar Shetty20-Aug-07 23:49 
GeneralRe: Update statement Pin
magedhv21-Aug-07 2:52
magedhv21-Aug-07 2:52 
GeneralRe: Update statement Pin
nlarson1121-Aug-07 3:32
nlarson1121-Aug-07 3:32 
QuestionSQL2000 & 2005 Backup in Vb6 Pin
Anubalan20-Aug-07 21:09
Anubalan20-Aug-07 21:09 
AnswerRe: SQL2000 & 2005 Backup in Vb6 Pin
Michael Sync21-Aug-07 15:22
Michael Sync21-Aug-07 15:22 
QuestionTwo text highlight colors in word Pin
Jwalant Natvarlal Soneji20-Aug-07 20:38
Jwalant Natvarlal Soneji20-Aug-07 20:38 
Questionhow can i add group to share folders for access using VB.Net 2.0 Pin
koolprasad200320-Aug-07 20:17
professionalkoolprasad200320-Aug-07 20:17 
Questionvb.net Pin
mikeicbt20-Aug-07 19:45
mikeicbt20-Aug-07 19:45 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.