|
Hi,
If there is 10 records with the Server date, and if there is no record on the 11 row ,it should display the first record with the 11 th day date which is the server date.
I hope this will give a clear idea.
Logu
|
|
|
|
|
Could this be
SELECT TOP 1 * FROM TableName ORDER BY [date] desc
Sorry if i didn't understand yet
|
|
|
|
|
Thanks for your help.I have got the answer.
Logu
|
|
|
|
|
I would like to share me that answer if you don't mind.
|
|
|
|
|
What have you already written ? What do you mean by 'a record per day' ? What's 'the 100 days', just an example ?
What is your database schema ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
For Everypost back i am getting different messages. But i want only one message per day for every postback. And i want to know the query for that and my database schema is
MessageId : Int
Message :varchar(Max)
Dispalydate: datetime
Logu
|
|
|
|
|
Hi guys,
Is it possible to execute Batch files and executable files on the server using ASP.NET assuming i have all necessary and directory permissions. I would also like to be able to pass arguments and get the return code.
|
|
|
|
|
try to use System.Diagnostics.Process.Start
|
|
|
|
|
Is TextBox Supports Databound?
I want to display(& modify) a field into a textbox. I don't want to use DetailView or GridView controls. Is it possible using AccessDataSource control and a TextBox?
Please Suggest a least manual code solution.
dutta
|
|
|
|
|
Do you have only one text box and in which only only one text or line ?
Means why you want to bind data with text box ?
<l>Thanks and Regards
Sandeep
|
|
|
|
|
Hi all,
Does anybody have an idea of how do we create an editable dropdownlist and shows a panel with values starting with letters the user types.I want something similar to that of a browsers address bar or the search dropdown provided by google toolbar. I cant`t use any third party control or Ajax toolkit. Is there any other option of doing this in .NET itself??
|
|
|
|
|
Why do you want Editable dd
you can do it with Textbox also put the selected text to be changed in the textbox and edit it
<l>Thanks and Regards
Sandeep
|
|
|
|
|
Sorry but u r not getting me.I want to give a textbox or a editable DD which on text changed should show a panel containing a list box with values starting from the letter typed.You can have a look at the DD provided by google toolbar.
|
|
|
|
|
HI friends
I am getting error while i am inserting record in database.
Records are aroung more than 60,000. I also tried timeout property of command object I want diff solution ....
Error Detail:
Timeout expired . Timeout period elapsed prior to completion or server is not responing
Thanks And regards
Yogesh M
|
|
|
|
|
HI,
You can try indexing your tables.
Sushant Duggal.
|
|
|
|
|
can u send me syntax for how to create index on table
|
|
|
|
|
How can i connect to any RSS feeder club ??
thks
|
|
|
|
|
Do you want to read a RSS from any website????
Websites provide RSS feed URLs. You can read the predefined tags and parse the XML data to make it useable for your application
Regards,
Sushant Duggal.
|
|
|
|
|
I want to develop a code which read the email sent at the address (upload@abc.com) and extract the picture (if any) from the email to upload it on my server.
|
|
|
|
|
i have a gridview it displays some records from database
and i added imagefield in the gridview the field does not in the database
i want to display an image in this field ,static image for all records
how can i do this?
thanks for help
MD_NADA
|
|
|
|
|
Means the image is related to database data or nothing t do with database only have to show ?
<l>Thanks and Regards
Sandeep
|
|
|
|
|
no the image not related to database
it is on folder in my project
MD_NADA
|
|
|
|
|
in your template column your image control would be there right! Just set the properties accordingly there, give your image url i.e. the folder path where the image is saved to the imageurl property of the image control.....
Gautham
|
|
|
|
|
1. How do I switch between 2 master pages for the same content page? For example: one master page for a logged in user and a different one for a visitor.
2. In a function in a code-behind page in c#, how do I navigate back one page, like in the "Back" button of the browser?
|
|
|
|
|
Ad.1
You can set the MasterPage file in PreInit event.
2. What exactly would you like to do?
|
|
|
|