Comments by Member 13142345 (Top 72 by date)

yes the response page is alive. when i did not use the encoded query string then the page is loading. but when i included the encoded query string then the error appears as 404 not found.

Thanks for the solution wevper. i tried to post the values as byte array after encoding. This works fine and they are encoded but after redirecting to response page in the central project the browser says 404 NOT FOUND Error. the page is available on the project but the same error

Yes. I did that using Javascript previously for POSTING the values.
But there is a KEY value i am receving from the paymentgateway, based on that keyvalue i have to dynamically change the URL. but in the action method in aspx page need to write only one address in the URL. so can you help me to navigate to the different URL's based on key the value from the backend.
Thanks in advance

Dim info as string
and cardinfo is byte type
and i am converting that byte into string and i will get the above string
info = System.Text.ASCIIEncoding.ASCII.GetString(CardInfo)

from that string i want to retrieve only cardtype,tower,starttime,endtime,floor and Room

Thank you Griff :) After sending NULL to Empty values it works like a charm...

Wrong Question... Thank you....

another query, what if i want to add a condition to that query to show only the rooms based on condition

Hide   Copy Code

SELECT RM.room_no, RM.room_status, RM.housekeeping_status, CASE WHEN GR.roomno IS NULL THEN 'F' ELSE 'R' END AS FreeOrReservedFROM room_master AS RM LEFT JOIN (    SELECT *    FROM guestreservation     WHERE arrivaldate = CAST(GETDATE() AS SMALLDATETIME)) AS GR ON RM.room_no = GR.roomno and room_status='Vacant' and housekeeping_status='Ready' 

if i wrote like this it is picking all the rooms omitting the where condition and the results are also many. can you help me

thank you for the solutions and for the correction.

Thank You. It worked with modifications.

As per hotel structure their base level starts at 7, and then it is up to 20 floors. so after communicating with the support team of the key-card they told to place 1 in place of 7 in 32 bit charcter string and place 1 in place of floor the guest checkin

so i have written

If floor = 8 Then
FlrSelection1 = "00000000000000000000000011000000"
ElseIf floor = 9 Then
FlrSelection1 = "00000000000000000000000101000000"
ElseIf floor = 10 Then
FlrSelection1 = "00000000000000000000001001000000"
ElseIf floor = 11 Then
FlrSelection1 = "00000000000000000000010001000000"
ElseIf floor = 12 Then
FlrSelection1 = "00000000000000000000100001000000"
ElseIf floor = 13 Then
FlrSelection1 = "00000000000000000001000001000000"
ElseIf floor = 14 Then
FlrSelection1 = "00000000000000000010000001000000"
ElseIf floor = 15 Then
FlrSelection1 = "00000000000000000100000001000000"
ElseIf floor = 16 Then
FlrSelection1 = "00000000000000001000000001000000"
ElseIf floor = 17 Then
FlrSelection1 = "00000000000000010000000001000000"

but it is not generic. so i want to write a neat code to add the 1 based on floor number

Webforms

i am not using install shield for creating the setup. i am using visual studio installer projects

It solves the problem and the result is '0' if there is an empty value.
But the field name is not displaying as amount. it is showing as (No Column Name).

so i modified it as
SELECT ISNULL(SUM(AMOUNT),0) as amount FROM(SELECT isnull(SUM(amount),0) as amount from getbillsfortaxinvoice WHERE code IN ('TT') and fno = '02112017416202742' and bill_desc not like '%GST%' GROUP BY folio_Id,room_no,guest_name) as X

Thank You for the query

when i omit the group by then the amount is showing as '0'. But the result is different from expected result as i have not written the group by

No records are returned. if there is an amount it is showing the amount but if there is no amount it is showing as empty

the dll application is developed on the .net framewrok 2.0

Did you mean to do this

return sb.ToString().ToUpper();

So can you suugest me a solution how to acheive that mismatch error if i am doing it as hex string.

Thanks For the Response and Explanation.
In the documentation it is stated as hexadecimal. So how can my above code should be encoded to hexadecimal format. can you please help me with that.

Noted... Thank YOu

So, Is there any other suggestion to send the formatted text as an email body?

ok... Thank you Jochen for your answer...

I have searched the google for converting the rtf to html code. But i found the converters not the code. Some says use RTF parser. But it is not avilabel on visual studio 2008.

SO, can you advice me on this Please..

The user entered data in the format of
We hope you enjoy the stay in our hotel. Looking forward to serve you

Hotel features:
542 rooms and suites.
Guestrooms overlooking lush terrace garden or Victoria Harbour.
Seven exclusively appointed Grand Club floors offering a private reception lounge, all day tea / coffee service, complimentary breakfast, evening cocktails with canapés.

Hotel features:
542 rooms and suites.
Guestrooms overlooking lush terrace garden or Victoria Harbour.
Seven exclusively appointed Grand Club floors offering a private reception lounge, all day tea / coffee service, complimentary breakfast, evening cocktails with canapés.

Hotel features:
542 rooms and suites.
Guestrooms overlooking lush terrace garden or Victoria Harbour.
Seven exclusively appointed Grand Club floors offering a private reception lounge, all day tea / coffee service, complimentary breakfast, evening cocktails with canapés.


when i send the email to the guest it displayed as

We hope you enjoy the stay in our hotel. Looking forward to serve you Hotel features: 542 rooms and suites. Guestrooms overlooking lush terrace garden or Victoria Harbour. Seven exclusively appointed Grand Club floors offering a private reception lounge, all day tea / coffee service, complimentary breakfast, evening cocktails with canapés. Hotel features: 542 rooms and suites. Guestrooms overlooking lush terrace garden or Victoria Harbour. Seven exclusively appointed Grand Club floors offering a private reception lounge, all day tea / coffee service, complimentary breakfast, evening cocktails with canapés. Hotel features: 542 rooms and suites. Guestrooms overlooking lush terrace garden or Victoria Harbour. Seven exclusively appointed Grand Club floors offering a private reception lounge, all day tea / coffee service, complimentary breakfast, evening cocktails with canapés.

I have used the multiline textbox and nvarchar(max) to store the data.
strsql= "select message from hotel_info"

message is the feild in hotel_info table where it can store the mail body enterd from the user.

now i have retrieved the message and send it as an email body.

I have written the below code

Dim myMailHTMLBody = " " + mailbody + " "

so the mail body is sending in single line without spaces and paragraphs.

can you help me with this.

Thanks for the Response Jochen. I have used the multiline textbox for the user to enter data and i have used nvarchar(MAX) to store the data into the database.
So, when displaying the stored data into the textbox it is displaying with spaces, new lines and paragraphs same as the entered data.

i have tried to send that data as email body to the user. But it was sent without new lines and paragraphs. can you help me to send the data with the user entered database, paragraph and spaces

Thanks in Advance

I want to store the data in text box with spaces and new lines as the user entered format into the sql database

Sorry for the uncleared question...

i am posting the example data to textbox

i am entering the below data

We hope you enjoy the stay in our hotel. Looking forward to serve you

Hotel features:
542 rooms and suites.
Guestrooms overlooking lush terrace garden or Victoria Harbour.
Seven exclusively appointed Grand Club floors offering a private reception lounge, all day tea / coffee service, complimentary breakfast, evening cocktails with canapés.

Hotel features:
542 rooms and suites.
Guestrooms overlooking lush terrace garden or Victoria Harbour.
Seven exclusively appointed Grand Club floors offering a private reception lounge, all day tea / coffee service, complimentary breakfast, evening cocktails with canapés.

Hotel features:
542 rooms and suites.
Guestrooms overlooking lush terrace garden or Victoria Harbour.
Seven exclusively appointed Grand Club floors offering a private reception lounge, all day tea / coffee service, complimentary breakfast, evening cocktails with canapés.


the total data i am storing it as a string to the database . It is storing in a line and when i query the data and see the form it is all appearing in single line.

hope you understand

Thanks for the link.
But the code is not working in vb .net
I am using .net framework 3 applicaion

I want the image to be displayed within the body but not as an attachment.
Now the above code is doing both scenarios.

i don't want the image as an attachment

Sorry. I didn't get you...

These are two different tables. From one table i am accessing the details of a student and from another table i am accessing the college name and logo and other information

I already did that and it is applying same color to the 3 the values. But i want each value in the y axis could be colored separately. i.e., 3 different colours

Simple and Superb.:)

can you suggest me the better way to do it.

forms is visual basic collection of forms.
Remove Removes an element from the collection of objects and it takes key as string

That string variable need to take the specail characters like &,(,/ to cancel that invoice

i have written that string variable called feename that it was not accepting the gridvalue as it is there in the grid when the subject name is having the literal string '&'.

Hi Griff, It was an developed project and i am doing modifications for it.
the requirement is to delete the invoice whenever they click on the cancel button. For that i have written that string variable. In the database i am not deleting that row. I am only deleting the row in the webpage for the user. It has to be shown that the invoice is canceled. For that i need to delete the row. Could you suggest me way that i do this. As the grid is not having an id to match with the database id. i am unable to do with the id field. i have to do it with the string variable.

Yes.. The folder is not creating in the Attachment Folder. That is what the problem is.

WHen the loop is executing the following is there in dr[description] for 5 values
<a href='EmployeeDetails.aspx?mtype='Events'&id="

but in dt.rows[i]["id"] is having values from 0 to 5

The id value is from 1 to 5.It is the integer value. when the loop is executing the value changes from 1 to 5 and it has to assign to the id of the query string. sorry, I don't know how to get the entire query string in the employeedetailspageview, the one which you asked.

I am passing two parameters in the querystring. In the page load it can be able to get the mtype value. But it is not getting the id value. So the if condition fails.

No. It is not working. I have changed the id. But value is NULL only. So the if condition fails

I have changed the name for the id. But it is not working. It is giving the NULL value.

Directory is not creating on the specific path. So it is not founding.

If possible can you show me the solution how to do that..

Yay... Thank You.. You gave me confidence that i can also write queries with small errors as i am new to programming also...

Thank you.....

i am sorry. It is an event header string in the database and i need to attach the hyperlink to that heading in the calendar. Whenever i click on that it needs to navigate to the task details page. In the previous code when i used the data row in for loop i have written that line. Now the header is displaying for the corresponding dates. But i need a link to that. For every Event in Every Date there is a corresponding task associated with it and i have written that tasks in another page. I need to navigate to that page for loading the details.

I am not getting the expected output as the combination of roomcharge and breakfast as i have shown in my question. Rather it is displaying roomcharge and breakfast rows separately. i need to combine those rows

Thank you very much.
Now i am getting the events from the database.
One doubt, how could i hyperlink the header like in the above code.
dr["Heading"] = "<a href="Details.aspx" "";

For each and every header in a date there is hyperlink associated with it to navigate through the taskdetails

DO i need to remove the For loop.
Can you post the modified code if possible

Yes. I have changed the column as per the database.
for (int i = 0; i < dt.Rows.Count; i++)
{

dr = dt.NewRow();
dr["StartDate"] = dt.Rows[i]["StartDate"].ToString();
dr["EndDate"] = dt.Rows[i]["EndDate"].ToString();
dr["Heading"] = "" + dt.Rows[i]["Heading"].ToString() + "";
dr["EventForeColor"] = "Black";
dr["EventBackColor"] = "Yellow";
dt.Rows.Add(dr);
}


Only 5 rows are there in the table.but the for loop is looping infinetly.

Thank You so much Mr.Briyan.
when i add this It worked.
Thank you for finding the problem with the jquery refernce.

It is working fine if i took new asp calendar and write this javascript to hide the weekends. But in the given project it is not working. I don't know why?

Yes. Jquery V3.1.1. I have installed it from nuget packages and checked. But it is not working

There is no Error message. Initially when i placed the calendar code. It shows all the days from Sunday to Saturday. Now, I don't want to display the days Sunday and Saturday in the calendar. For that i have written the java script function and i am calling that function from the calendar. but it is not working.
Can you please suggest me that how can i hide the Entire columns of Sunday and Saturday including the Dayheaders.

There is no Error Message. I have that calendar and it is displaying the 7 days from Sunday to Saturday.
Now, I want to hide the Entire Column of Sunday and Saturday including the day headers. For that i have written that java script function. I have tested that function with asp calendar and it is working absolutely correct.
But i have this project and they have used this Event Calendar. So that java script is not Working with the Calendar.

It is a Calendar Extender like asp calendar.