Comments by vikram_shinde

vikram_shinde 20-Nov-12 10:51am View

As a string. But in WSDL it has type restriction as Date so whatever you assign to it , it becomes CheckInDate="2012-11-25 12:00:00 AM".

After applying datetime formatting I am getting result as CheckInDate="2012-11-25"
but after assigning this formatted result it appends time stamp.

I have done like -

WSProxy.HotelSearchRequestCT hs = new HotelSearchRequestCT();
hs.City = "WAS";
DateTime d = DateTime.Parse("2012-11-25");
hs.CheckInDate = d.ToString("yyyy-MM-dd"); // CheckInDate = 2012-11-25 12:00:00 AM

vikram_shinde 20-Nov-12 8:39am View

I tried by doing same way but still it's appending timestamp.

vikram_shinde 15-Nov-12 7:23am View

You are right, backup file is corrupted.

vikram_shinde 14-Nov-12 14:18pm View

I tried - giving file name in different ways, properly checked for any typos by me,
changed file location . Yes, file actually exists on hard drive. I will check for whether file is corrupted.

vikram_shinde 14-Nov-12 14:01pm View

I have been through this article. But still getting error.

vikram_shinde 14-Nov-12 13:34pm View

Backup file is on local machine and it has to be restored on SQL server running on same local machine.

Backup is not password protected also there are no more than one backup files.

vikram_shinde 2-Nov-12 7:35am View

c# webapp.
Wants to send csv file with web request.

vikram_shinde 2-Nov-12 7:06am View

It's in initial stage so I haven't created SP. Just trying using simple query.

vikram_shinde 14-Mar-12 11:57am View

many thanks...

vikram_shinde 14-Mar-12 7:30am View

no luck .... it's giving error... says Incorrect syntax near the keyword 'where'

vikram_shinde 14-Mar-12 7:12am View

StateCode are nvarchar . So still I have to use CONVERT?

vikram_shinde 6-Mar-12 11:01am View

many thanks ... I am using same ....I tried find and replace but there are lots of records and still there are more ..... i think find and replace won't work in this case..... CSV file is 900 mb so you can imagine ......

vikram_shinde 6-Mar-12 10:53am View

i am using SQL Server Import and Export wizard...........

vikram_shinde 6-Mar-12 10:52am View

it's 900MB CSV file.... even it's hard to open.....

vikram_shinde 27-Feb-12 7:21am View

I want to take this application bit further.... When user click on "Show Data" button instead of showing gridview control on same page, the new page window should popup. SO I will get rid of "Hide Data" button... Is it possible to add this functionality.......

vikram_shinde 27-Feb-12 5:32am View

it's working now..... many thanks for helping novice like me :)

vikram_shinde 27-Feb-12 5:32am View

Deleted

it's working now..... many thanks for helping novice like me :)

vikram_shinde 24-Feb-12 5:19am View

it's giving error ---
Column 'payment_txn_status_ref.description ' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

vikram_shinde 23-Feb-12 10:58am View

Deleted

why it's giving me error -- Ambiguous column name 'order_type' and Invalid column name order_status_ref.

vikram_shinde 23-Feb-12 10:56am View

order_status_ref has two column - order_type and description

vikram_shinde 23-Feb-12 10:39am View

yah.. that's the mapping ....

vikram_shinde 22-Feb-12 7:37am View

select Year(date_created),order_type,sum(order_value)
from tpayment_order
group by Year(date_created),order_type

after using Year()...it worked ....
many thanks

Comments by vikram_shinde (Top 22 by date)