i am designing an accounts package for a certain company, and i have to design the bill as per requirements. this application is not web-based. what i have to do is to make the bill printable. i should have a print option in the bill and it will print the bill. i have no idea how to add that functionality. can anybody please tell me the logic or if possible, post me a sample code??
thanx in advance.
AmiMitra
Last Activity: Aug 14 '09, 05:02 AM
Joined: Apr 26 '09
Location:
-
designing printable bill
-
well, i solved it. i think i should post it here so that someone else can be helped.
i used the following code in the .cs page
bl1.items.add( new listitem( "hotel", "page.aspx? aa"+ bb));
bl1 is the id of the bulleted list. -
let me explain. i have a page where a bulleted list exists , with the list items as hotel, car , flight , railways.
each list item is hyperlinked to the booking form.
the parameters to pass are name of the place and booking type.
passing the booking type is not a problem.
but the name of the place comes from the previous page.
i get it by the code
string placename = commonutility.g etQueryStringVa lue("placename" );...Leave a comment:
-
i am getting the value in the code behind, in the .cs page. how can i use that variable in the aspx page?? the value is coming from the previous page.Leave a comment:
-
passing parameter through navigateUrl
i am having problem with passing parameter through navigateUrl property of a hyperlink.
in the page where i am using the hyperlink , i am getting the data thorugh commonutility. i want to pass this data to the next page through navigateUrl. plz help. -
ok, that might be the cause. so if i want to continue with the idea that a seperate resv_id count shud be there for each book , i have to go without the foreign key constraint.
thanx a ton for all your concern. this site is really being helpful to me for my project.Leave a comment:
-
yes u got it right...i want a seperate resv_id count for each book...but what is very surprising to me is that...i have created both of the tables in one machine. and it gave out no error. then i simply saved the queries and then copy pasted in another machine, where it is giving this error. how come that is possible? and obviously i have downloaded mysql from the same site in both the machines.Leave a comment:
-
if i specify the first table as innodb or dont specify anything at all...then the first table cannot be created..it gives an error which says ...auto increment should be assigned to only one column and that must be declared as primary key..only myisam lets me create the table as i want it.
i didnot try specifying the 2nd table as myisam...but as u told...that table wont use the foreign key constraint.
so what to do...Leave a comment:
-
actually i created both the tables in one machine and it did not give any error but when trying to do the same in another machine...givin g this error... i simply dont know what to do...Leave a comment:
-
Error 1005 when creating tables on some servers.
i am using mysql 5.1. i have one table named as resv_record. the format is
[code=mysql]create table resv_record ( book enum('h','c','r ','f','t') , resv_id int(8) auto_increment not null , user_id varchar(12) not null , primary key( book , resv_id))engine =myisam;[/code]
i am creating a new table named flight_book as
[code=mysql]create table flight_booking ( resv_id int(8) not null , jrny_dt date not null , from_place varchar(20)...Last edited by Atli; May 22 '09, 07:17 AM. Reason: Added [code] tags and improved the title a little. -
ok i solved it. if i use the convert.datetim e function , it again changes the format to dd/mm/yy format. so i need not do that. all i have to do is simply insert the changed format text as string and it is done. it is then inserted as 'yyyy-mm-dd' in the database.am i right?Leave a comment:
-
thanx for your concern , but please can u help me once more?
when i create the table in mysql where i want to insert that date, should i keep it as varchar or date? because any format i get is in the form .text , which is a string. is there any way to convert string to date?Leave a comment:
-
mysql date problem
i am using asp.net......i have a textbox where i am inserting a date in the format 'dd/mm/yyyy' . i have to insert this data into database. but mysql date format is 'yyyy-mm-dd'...how to do that? please help... -
thanx a lot for your concern...it finally worked the way i wanted it to. :)..Leave a comment:
-
yes i am using mysql querybrowser. i will tell you what i've got.
if i right click on the procedure name showing under "schemata" in the right window pane , it shows an option as "edit procedure". when i click on that, the procedure opens in a new resulteset tab. i can edit the procedure there. but i cant find how to save the changes made. please help.Leave a comment:
-
editing existing procedured in mysql
i am using mysql 5.1. i have written a procedure name proc. now i want to edit some codes in it. whats the way out?
i tried writing "create or replace procedure proc", but it shows error .
i tried "drop procedure if exists" but this also shows error.
please tell me what to do. -
yes i tried this one but it shows some error like
incorrect column specifier for column 'id' , error no 1063.
just for information , i m using mysql 5.1.Leave a comment:
-
yes perhaps u r right. actually i was thinking as per the requirement documentation. but i also think choosing only the auto_increment function will do the work. thanx for consulting :)Leave a comment:
-
no this is not to display to the user. it will be saved in the database only. if it is not possible , then i would go for numeric data only.Leave a comment:
-
auto_increment
i am designing a website for travel agency. the requirement is everytime any user books anything( car, hotel etc) a reservation id is generated for internal use. i want to start the resv_id with 'resv' and then a number following it. please tell me how to do it using auto_increment. is there any other way to do that? i have a table with attributes user_id ( created by the user) and resv_id ( generated) and the primary key is the composite key .please...
No activity results to display
Leave a comment: