Comments by Member 12926744 (Top 39 by date)

Tried everything on google but nothing could solve the problem .

I tried changing to X64 , x86 ,Any Cpu.But nothing helps .

how to check it with current time as I am stuck there

No I need to select all hrs in a day between 12:00 Am to 12:00 PM . such as
12:00 AM ,1:00 AM,2:00 AM......12:00 PM .
I am getting these in the following query "select distinct CONVERT(varchar(15),CAST( dateadd(hour,number-1,'01-jan-2017' ) AS TIME),100) as slots from master..spt_values where number>=1 and number<=24"

But the problem is that ,for example if the current time is 3:00 pM , I need only those times between 3:00 pm and 12 :00 pm and so on.

no

Its's an integer value.

Thank you very much for your answer . How to select it based on date ie suppose there is a date field in scheduling table and I need to get the free time slots based on that date.

select e.emp, ts.*
from employee e cross join
timeslots ts left join
scheduling s
on s.emp = e.emp and s.timeslot_id = ts.timeslot_id
where s.emp is null;

This is what I have tried .I am stuck in filtering out the time slots .

Time columns is stored as two time columns

select distinct CONVERT(varchar(15),CAST( dateadd(minute,30 * (number-1),'01-jan-2017' ) AS TIME),100) as slots from master..spt_values where number>1 and number<=50 order by slots
Thank you I got the answer . Thank you very much for your help.

Thank you very much for your answer but this will give it in 24 hr format.I want it as 12 hr format with am and pm . Any help will be really appreciated.

Sorry that was my mistake...actually date column should be less than the current date.Even if I changed to less than, still it is not working .It is hiding all the buttons in all rows.

No...they all are in the same column

I am using google chrome

Thank you very much.It worked.

The value of IN028_01 be like 'REF123434556'

<asp:BoundField DataField="IN028_01" HeaderText="Cl Ref.No"
ItemStyle-HorizontalAlign="Center" ItemStyle-Width="70px"
SortExpression="IN028_01" NullDisplayText="-" >
<ItemStyle HorizontalAlign="Center" Width="70px" />

Its a datafield value of gridview.

Still its not working.Is there any problem with my javascript.The value is not passing to the script.

How can we save it to a specific folder in server .

Thank you.It worked.One more thing how to eliminate the extra white spaces before the word hundred because after removing the word there are three white spaces after Thousand.

However I am getting an error 'too many arguments' while giving this code.

Thank you very much.It worked.

Thank you very much .It worked.Its opening in new tab.But I need to open it in new window.Can you please help me.I am new to javascript.

Product.aspx?cid=[object%20HTMLInputElement]chdate=%20[object%20HTMLInputElement]%20&%20pname=%20[object%20HTMLInputElement],%20null,scrollbars=yes,top=10,left=10

The values is passed like this .ie I think the variables are not getting textbox values.

While doing it I am getting an error "The Controls collection cannot be modified because the control contains code blocks (i.e. <% ... %>)."Can you please help me

Thank you very much.Got the answer
<asp:Button runat="server" ID="btn" OnClientClick='<%# string.Format("window.open(\"add.aspx?cid={0}¶m2=\" + document.getElementById(\"{1}\").value, null,\"scrollbars=yes,top=10,left=10\", \"true\");", Eval("psid"), Form.FindControl("txt_chqdate").ClientID) %>' />

Well got the answer.

<asp:Button runat="server" ID="btn" OnClientClick='<%# string.Format("window.open(\"add.aspx?cid={0}¶m2=\" + document.getElementById(\"{1}\").value, null,\"scrollbars=yes,top=10,left=10\", \"true\");", Eval("psid"), Form.FindControl("txt_chqdate").ClientID) %>' />

Thank you very much for your help.

OnClientClick attribute is on an imagebutton.
<asp:templatefield>
<itemtemplate>
<asp:ImageButton ID="ibut_Print" runat="server" target="_blank" OnClientClick='<%# Eval("psid", "window.open(\"add.aspx?cid={0}\", null,\"scrollbars=yes,top=10,left=10\", \"true\");") %>'
AlternateText="View" CssClass="btn5" ForeColor="White" ToolTip="Print Invoice" />

<ItemStyle HorizontalAlign="Center" Width="15px" />

<asp:TextBox ID="txt_chq" CssClass="txtch" Width="250px" runat="server">
This is my textbox field to be passed.
However I am getting an error 'does not contain a definition for FindControl " in the above code.Could you please help me.

Thanks for your reply.Can we pass a textbox value as parameter.If so ,could you please tell me how.Since I couldn't find an appropriate way though.

The file is downloaded on a button click.

Thank you very much for the information .Since I'm new to C# I don't know about it.

Thank you very much for the information .Since I'm new to C# I don't know about it.