Comments by Ganesh Raja (Top 27 by date)

If u have 2 columns then what you need to show in nextvisitdate?
its a current(getdate()) date or some other?

What is the error?

You can use print statement to check the same in procedure(Ex: use print statement inside and outside of cursor and while )

Can you add some sample data?

What is the issue in that..?
Multiline text is hiding or you are facing some other issue?

Already the @DateFrom and @DateTo in datetime format then why u r trying to convert again?

U r facing the problem for specific host or all?
try to check any other test environment.
B'coz i have used TamirSSH and its working fine.

Which one is common column in both the table? or u r applying cross join?
Share some sample...

Share me the code to solve this or have u register more than one time in same page with prefix?

Thanks for the post...:)
Basically the row level lock will happen when we are trying to update and delete the data.But if more then 1 user access to update or delete the data in same time,then how can we handle the situation?[it will queued and will wait for certain time and process the request in db side but the first data updation taking long time then surly next queue data will throw the dead lock error right?]
Is this need to handle in db side or application side?

Thanks for the post...:)
Basically the row level lock will happen when we are trying to update and delete the data.But if more then 1 user access to update or delete the data in same time,then how can we handle the situation?[it will queued and will wait for certain time and process the request in db side but the first data updation taking long time then surly next queue data will throw the dead lock error right?]
Is this need to handle in db side or application side?

Hi ,First create a sample windows service application with required time interval(Enable logging) and install and check the same.

Refer this and change the timeframe accordingly...

http://stick2basic.wordpress.com/2013/02/22/how-to-schedule-a-c-windows-service-to-run-a-method-daily/

Can you explain the Question clearly..?

i have verified and this working fine when that particular condition (Length) is satisfied.

Have u verified the path(try to manually find the file using the path though explorer) and sheet name ?(xls or xlsx)

can you tell me, Earlier your user(RAKESH-PC\RAKESH) default database is mapped as HIREITDB..?

Once u change the path, u have given the service restart?

When ever u r using the page response's like upload, download, redirect things in update panel surly it will fail so that i have posted the code will help to disable the update panel for given time in(timeout).

OR

try another method to user the <Triggers>
.........................................

<UpdatePanel runat="server">
<contenttemplate>
...
<asp:Button runat="server" ID="myButton" />
...

<Triggers>
<asp:PostBackTrigger ControlID="myButton" />
</Triggers>

Can u pls check conversion in my code

The error is meaning the file is already opened or accessed by another user so can u kill the process of the file and check the same.

Before sorting only u r doing the conversion or before loading the data to gridview u r doing the conversion?

u can add the that code in "Button1_Click" event.

Note: If the data is available, add that code after binding or if the data not available add this code after adding the columns.