Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by vanisudha2000

  1. vanisudha2000

    How do I send an email from a stored procedure

    Thankyou, now I am not getting that error. Now my problem is I am having a column in the database which takes hours like 1, 2,3 integer values. I have written a stored procedure like this CREATE PROCEDURE [dbo].[SendEmail] As BEGIN SET NOCOUNT ON; Select...
  2. vanisudha2000

    Gridview does not show up if there are no records in the database

    Thanks, I could get the message now. Now How do I show the Details grid when there are zero records in the database and Insert a new record into the database. I am not able to see the detailsView on the page , when there are no records in the database. Can you please help me..
  3. vanisudha2000

    Gridview does not show up if there are no records in the database

    Hello, If there are no records in the database then the Gridview does not show up in the asp page. Can you help me in giving code atleast to put some message on the page if the gridview does not have any records in the database. Thanks in advance
  4. vanisudha2000

    Validation messages overlap on each other , How to separate???

    Hello, I am having a detailsView, On which I want to put some validation on each of the fields, Now I am facing two problems, 1. When I type more than one words in the fields then in the output i see that each word is in a single line and the size of that field is going on increasing, HOW...
  5. vanisudha2000

    How do I send an email from a stored procedure

    I have added these lines in the above stored procedure . EXEC Issues.dbo.xp_sendmail @recipients=Alias, @message=N'Reminder !!! This issue should be closed with in 30 minutes.' ; I am getting this error, Cannot add rows to sysdepends for the current object because it depends on the...
  6. vanisudha2000

    How do I send an email from a stored procedure

    Hello, I am having a stored procedure which is like this below, How can I send an email from this stored procedure Can you please help me with the code ... Thanks in advance... CREATE PROCEDURE [dbo].[SendEmail] As BEGIN select Alias,ExpireAt,CreatedAt,(completetime*60 - 30) From...
  7. vanisudha2000

    How to update a field

    Thanks for your reply, Can you please help me with the code , how to call the stored procedure on the page_load and bind the data to the datagrid with the selected records. Can you please help me with code, thanks in advance.
  8. vanisudha2000

    How to update a field

    I have created a stored procedure to update the status fied like this Declare @expireat datetime, @createat datetime, @status varchar(10) Select expireat From Issues Where expireat < getdate() Update Issues Set status = 'Closed' Where expireat < getdate()...
  9. vanisudha2000

    How to update a field

    Thanks for the reply, I got your point but @status would be changed only if the storedprocedure will be called. I want the @status to be changed automatically once the @createat > @expireat . I have a datagrid to display all the records with status = open only. Can I write a stored proc on...
  10. vanisudha2000

    How to update a field

    CREATE PROCEDURE [dbo].[CalculateIssueExpiryTime] -- Add the parameters for the stored procedure here @alias nchar(10), @title ntext, @description ntext, @completetime int AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements...
  11. vanisudha2000

    How to update a field

    Hello, I have written a stored procedure where I have set the status = open, this stored procedure runs on click of the insert button , it inserts the record taking all the fields entered from the detailsview. in the data base i have currentdate that is the systemdate and datewhich is 2...
  12. vanisudha2000

    How can I show system date in a field in a detailsview

    Actually I was not very clear, I am having the following fields in my database title varchar(50) desc varchar(50) createdtime datetime expiredtime datetime addminutes int The user enters only title, desc and addminutes from the DetailsView (ASP>NET 2.0)and click on the insert button, now i...
  13. vanisudha2000

    How can I set a value range in detailsView

    I have added minimum and maximum value in the client script. I could do it. Thanks
  14. vanisudha2000

    How can I show system date in a field in a detailsview

    Hello, I am having a detailsview , which is accessing data from the database, there is a field which should show the system date in it, but I am not able to get that, Can you please help me .. Thanks in advance.
  15. vanisudha2000

    How can I set a value range in detailsView

    Hello, I am having a detailsview in which I am getting the data from the database. Now in one of the columns data I have to check if the value entered should not be greater than 6 and less than 1, that is range is 1 to 6. How can I do that, How can I access that column to do furthur checking...
See more

Part and Inventory Search

Back
Top