|
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 />
|
|
|
|
|
Hi,
I have a small project to try and keep our ADSL lines up and running 24/7. At the moment we have firewalls at each of our stores (5 of them) and on at HO. All contected by VPN.
Our problem is now and again the ADSL line seems to drop and the firewalls don't seem to come back up unless we reboot them.
So i'm planing to write a application in VB.NET that will install on the servers and ping a IP address and then when it fails x times it will reboot the firewall. I did try this using a telnet client put got a lot of socket errors.
So i thought what about SSH, so that he plan but i need some adivce on components for SSH. I've found a few that i could pay for but was hoping to find a free one. Anyone got any recommendations?
|
|
|
|
|
HI,
I encrypted a file and now I want to decrypt it but not in another file but in a stringbuilder.
Thanks
|
|
|
|
|
You would decrypt it in memory, surely ? Why do you need to use a stringbuilder ?
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
hi,thanks for your answer.
I need the information to put it in a stringbuilder.
thanks again
|
|
|
|
|
You would need to decrypt it first, then pass the data to the stringbuider.
-- Always write code as if the maintenance programmer were an axe murderer who knows where you live.
Upcoming FREE developer events:
* Glasgow: Agile in the Enterprise Vs. ISVs, Mock Objects, SQL Server CLR Integration, Reporting Services, db4o ...
* Reading: SQL Bits
My website
|
|
|
|
|
OK, so you need a string. I'd imagine you'd get a byte array back from a decryption method ? You would use an Encoding class to turn that into a string, depending on if it's Unicode, ASCII, or something else.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
thanks guys.
I resolved the problem.
Thanks again.
|
|
|
|
|
cmd.CommandText = "update ceasrjuice set fatname = " & x & " and reglz set fatrname = " & x & " where fatname LIKE '%" & TextBox1.Text & "%' "
how can i update two tables with on word according to this condition
plz it's urgent
|
|
|
|
|
It's always urgent, isn't it ?
Your strings are not in quotes, only the LIKE statement is. I assume x is a string, and I assume you know that this code makes your database completely insecure, and easily destroyed by a malicious end user. Look up SQL injection attacks on this site.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Please explain your problem in Detail, you mean to say you want to Update two different table from one command, I think it is not possbile from one line, you have to do it one by one,
Or If I mis-understood your problem, then please explain clearly.
Bhaskar Shetty
|
|
|
|
|
yes that's what i mean
i wanna to update 2 tables with one command
|
|
|
|
|
You can't do it within one statement. You can send 2 different statements in one command by putting a semi-colon between them.
Another option is to create a trigger that will update the other table for you in sql server itself...
|
|
|
|
|
Hi Friends
I am Bala from Srilanka
New Member
I have the problem to Take the backup from sql server 2000 & 2005 through vb6. Please Sent the coding
Bala
K.Balakumar
|
|
|
|
|
I've never done the database backup thought code. What we used to do is that we create a job for backing up the database or we did manually.
As this article Perform an MSDE database backup through Transact-SQL mentions, you can create a job in SQL database by using this T-SQL script~
USE msdb<br />
EXEC sp_add_job @job_name = 'BackupJob',<br />
@enabled = 1,<br />
@description = 'BackupJob',<br />
@owner_login_name = 'sa',<br />
@notify_level_eventlog = 2,<br />
@notify_level_email = 2,<br />
@notify_level_netsend =2,<br />
@notify_level_page = 2<br />
@notify_email_operator_name = 'myMailAddress'<br />
go<br />
-- Data backup<br />
USE msdb<br />
EXEC sp_add_jobstep @job_name = 'BackupJob',<br />
@step_name = 'msdb database backup',<br />
@subsystem = 'TSQL',<br />
@command = 'BACKUP DATABASE msdb TO DISK = ''c:\msdb.dat_bak''',<br />
@on_success_action = 3,<br />
@retry_attempts = 5,<br />
@retry_interval = 5<br />
go<br />
-- Log file backup<br />
USE msdb<br />
EXEC sp_add_jobstep @job_name = 'myTestBackupJob',<br />
@step_name = 'msdb Log backup',<br />
@subsystem = 'TSQL',<br />
@command = 'BACKUP LOG msdb TO DISK = ''c:\msdb.log_bak''',<br />
@on_success_action = 1,<br />
@retry_attempts = 5,<br />
@retry_interval = 5<br />
go<br />
-- Server specification<br />
USE msdb<br />
EXEC sp_add_jobserver @job_name = 'BackupJob', @server_name = N'(local)'<br />
<br />
-- Immediate job execution<br />
USE msdb<br />
EXEC sp_start_job @job_name = 'myTestBackupJob'
then, execute the following code thought VB6.
OSQL -Usa -P -i BackupJob.sql -n
OR ~
You may try to use "SQL/DMO object library" in VB6 application.
http://www.freevbcode.com/ShowCode.asp?ID=2579[^]
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you. 
|
|
|
|
|
Dear friends,
I would like to see two different highlight colors in word when user executes a macro.
Please help me!
thanks,
|
|
|
|
|
hello frnds,
i am using VB.Net 2.0 and i have some groups in my active directory,
i am able to share a directory/folder programatically but unable to add the groups in that sharing
please any one help me...
any link / code ??
thankx in advance
koolprasad2003
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|
|
how to direct from 1form to another form & when i try to connected to Database the following error msg displays
"username not found"
the code
str ="username=hasitha;password=randika;databasemike;server=suntwo"
hello
|
|
|
|
|
how to direct from 1form to another form & when i try to connected to Database the following error msg displays
"username not found"
i think you are open particular user detail from form1 and show this detail to another form (form2). you can make a procedure on form2 which take UserID as argument and then basis on this UserID you can write query.call this procedure from Form1 and at this moment if user exist then load form2 otherwise dont transter focus to form2
the code
str ="username=hasitha;password=randika;databasemike;server=suntwo"
what is this ? i think it is connectionstring. Please look at database argument.
hope this helps
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
|
1 - try giving your subject some meaning
2 - try explaining your self a little more. The code you posted means nothing, except that I now know how to hack into your DB. The error does not come from this line, so where does it come from ?
3 - it sounds to me like you're usng online help to work on the edge of your skillset. Try reading through some books, so you understand basics like how to work with more than one form
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Error in your connectionstring statement, correct that, see this.
server=servername;database=DatabaseName;uid=UserName;pwd=Password.
Bhaskar Shetty
|
|
|
|
|
|
i am using vb .net 2005
is there a way to make datagridview readonly property become false when we bind a datagridview with datatable ??
|
|
|
|
|
aphei wrote: a way to make datagridview readonly property become false
What wrong with this code? DataGrid1.ReadOnly = false;
Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)
If you want to thank me for my help, please vote my message by clicking one of numbers beside "Rate this message". Why vote? Plz Read it here. Thank you.
|
|
|
|
|
that's nothing wrong with that script.
but i still can't edit the columns.
when i write "datagrid1.Columns.Item(0).ReadOnly = False"
it become error
how can i edit my datagrid when i bind it?? thank's
-- modified at 2:22 Tuesday 21st August, 2007
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
