|
Hello all.
I have this ASP.NET webform which has many data input in order to create an appointment. This data is stored in our database. Yet the customer has asked if it is possible to send the appointment into Outlook/Exchange so that the customer can receive an email with the appointment. Is there any component (.NET, COM) or any way to do this?
Thanks in advance.
Hope is the negation of reality - Raistlin Majere
|
|
|
|
|
Hi Fernando,
I would use the information from the database to create a vCalendar file (you can Google vCalendar format to get the specifics on how to build the file) and then send that as an attachment to the user to import into their Calendar.
Hope this helps.
|
|
|
|
|
Thanks! I'll look for this vCalendar file thing.
Hope is the negation of reality - Raistlin Majere
|
|
|
|
|
hi everybody i have a problem with customising the javascript function for a validation control
i explain my pronlem with an exmple
i have two input on a table one is an email the other is the forename
a simple validation control for the email input is done
but when the email input is not empty i must
fill the forename input
so the html is like that
<asp:textbox id="forname" runat="server">
<asp:requiredfieldvalidator id="RequiredFieldValidator1" runat="server" errormessage="RequiredFieldValidator" ....=""> | <asp:textbox id="email" runat="server">
<asp:regularexpressionvalidator id="RegularExpressionValidator1" runat="server" controltovalidate="email"
="" errormessage="please write a valid email!!" validationexpression="^\w+@[a-zA-Z_]+?\.[a-zA-Z]{2,3}$"> |
how can i overwrite the validartor for the forname text to have a function in javascript that on submit event
do amessage error if the email is valid and the forname input is not filled
i explain when someone fill the email the forname must be filled and when the email is empty no control for the two input
thank you for help!!
|
|
|
|
|
You need to write some code that stores the client side Ids of the two controls as javascript strings, then you can use those names to write a custom validator that finds both controls and does the validation for you.
You may also be able to use two normal validators, and write a custom one that calls both and only sets the valid state to false if both of them fail.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
thank you christian for you answer but i am a beginner in validation controls may be an example or a portion of code could help me thank you in advance for your answer 
|
|
|
|
|
OK, I think there is actually a control on this site which validates multiple controls, I'd suggest looking for that
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
helo alll...,
this is my data:
my table is item(productid,stock) ,order(customerid,no_order), and orderdetail (no_order,productid,quantity)
example:
order and orderdetail displayed in gridview....
order is displayed like this:
--------customerid-------no_order
detail-------A---------------1
detail-------B---------------2
when i click detail in row 2, it's display orderdetail:
no_order_________productid_________quantity
____2________________c1________________2
____2________________p1________________3
i have make all this is ok. but i want to decrease stok in item with quantity in orderdetail.
my code in procedure like:
CREATE PROCEDURE [dbo].[order_item]
(
@productid AS varchar,
@quantity AS INT
)
AS
BEGIN
BEGIN TRANSACTION
DECLARE @no_order AS INT
DECLARE @stock AS INT
INSERT INTO [Orderdetail]
(
[ProductId],
[Quantity]
)
VALUES
(
@productId,
@quantity
)
SET @no_order = SCOPE_IDENTITY()
SET @Stock = (SELECT [Stock] FROM [item] WHERE [ProductId] = @productId)
UPDATE [item]
SET
[Stock] = @Stock - @quantity
WHERE
[ProductId] = @productId
COMMIT TRANSACTION
END
return
it can't work..
how about his true code in store procedure?
ok..., thx..
-- modified at 14:41 Monday 3rd September, 2007
|
|
|
|
|
1 - use the right forum ( this is a SQL question )
2 - define 'it can't work', does it compile ? What does it return ?
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hello.
I have made a user information to store in session.
But when admin blocks the users, it shoud kill the users session if exsist.
I want to avoid using database.
|
|
|
|
|
You can't block the users session - the only way that you could do this would be to have some mechanism where the user queries to see if they still have access to things. You may be able to do this with the Cache if you want to avoid the database.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Then only one think is could be done.... By checking every time post back, if user is valid.
Does server being overloaded if every post back is checked by using database?
|
|
|
|
|
Hello.
How can i make certan code piece to be executed only one at the time (Preventing to be executed if 2 diffrent users attempt to accsess same section)?
|
|
|
|
|
hi guys
i am having a asp.net application which is done in .net 2003 version, the problem here , i am having a text box with a range validator control for that.. when i changed controltovaliate property of the validator , the size of all the tables in the asp.net page is getting changed ,,such that the alignment is totally collapsed .. i have no idea how the sizes of tables (height and width of tables are dynamically changed)
regards
winnie
|
|
|
|
|
That's normal behaviour for tables. The size of the cells in a table are calculated from the size of the content in the cells. If you put something in a cell that is larger than the previously calculated size, the cell will grow and the other cells will be resized to give it space.
codelinks wrote: a very serious problem
How serious could it be? Serious enough to mention in the subject? 
---
single minded; short sighted; long gone;
|
|
|
|
|
Guffa wrote: How serious could it be? Serious enough to mention in the subject?
coz i didnt find any solution for this ,, can u tell what will be the solution for the above problem..
winnie
|
|
|
|
|
codelinks wrote: coz i didnt find any solution for this
Almost everyone that post here, does so because they can't find a solution. That doesn't make everything "very serious".
codelinks wrote: can u tell what will be the solution for the above problem..
Not without knowing anything more about how you use the tables.
My first advice would of course be not to use table based layouts. They were great ten years ago, when there were no alternatives. Compared to the alternatives available today, they suck.
---
single minded; short sighted; long gone;
|
|
|
|
|
Make them fixed width. Oh yuck - I can't believe I just recommended that. Seriously though, if you don't want the sizes to be recalculated you have to make them fixed width.
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
You could set the validator Display property to "none" and use a ValidationSummary so you can move the error message into it's own table. This way, it's display doesn't affect your control layout.
|
|
|
|
|
hi
i want to create a report with crystal report. my report has two table (master ,detail).
in this report each master information must be in separate page as page header and detail information must be in a table under header.
how can i create this report?
tanks
|
|
|
|
|
Hi
I am having one problem with sql query.In my application i am
taking candidate first and last name and showing them to a
column if in database both field are null then i want to show
his pet name in that column.How can i do this.Please guide me.
Ex:--If first name is john,last name is mathew and petname is abc then i
am showing fullname-john mathew if both field are null in database
then i want to show its pet name in that column
fullname--abc
Rahul
|
|
|
|
|
You can test the retrieved data against DBNull.Value and act accordingly.
Talal
-- If this is a post that has been helpful to you, please vote for it. Thank you!
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning."
--Rich Cook
|
|
|
|
|
hi
i think is better you remove allow null in your table and then set a default value such as '-' for when is not any thing for insert.
now you can simple manage your request.
|
|
|
|
|
You can use Coalesce to return a value only if previous values were null.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Thanks for reply but
what is Coalesce i dont know about it.Can u please tell me about that?
Thanks.
Rahul
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
