|
what should be the query for extracting the records from the particular month
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
select * from (tablename) where date between dateadd(dd,1,startdate) and enddate
be broad minded
Piyush Vardhan Singh
Programmer
TAS NewDelhi
India
|
|
|
|
|
thank you sir
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
SELECT * FROM tblTable WHERE MONTH(colDate) = 1 (or 2 or 3.. or 12)
Eliz.K
www.oin1.com
|
|
|
|
|
simply i deleted some records in the second page, then i returned to first page , page is loading very slow. i call some functions in the first page load.
|
|
|
|
|
Please don't post twice with the same issue.
Realistically, what do you expect us to tell you ? We have no idea what code you're running, what makes you think it's slow, or even if you've tested it more than once. Set breakpoints in your code, and work out which bit of your code is too slow, and if you can't work out why, post it here.
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 )
|
|
|
|
|
Not sure your question. But please have the PostBack checking on your every page before start your code:
if (!IsPostBack)
{
//Your Code here
}
This will ensure that your code is only run on the first load.
Eliz.K
www.oin1.com
|
|
|
|
|
when i run the application first web page is loading perfectly, then i move to first page to another page, i had deleted some records in the datagrid. i return to first page the loading is very slow and struck. plz give me the solution.I call the some functions in the first page load. based on the second page records.
|
|
|
|
|
What have you tried ? Where are you stuck ? What is arrgent ? Is that when a pirate is in a hurry ?
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 )
|
|
|
|
|
I want to open and save functionality inside gridview.
Measn,user select a file from one location and save that file in another location and if he want to view that file he can open that file also.
Thanks
|
|
|
|
|
Hi All,
I want to connect a crystal Report dynamically with database which changes accordingly but the table is same in all the database table name = “Stock “ Also I want to add condition “SELECT * FROM Stock Where Date BETWEEN ‘xyz’ AND ‘abc’” Database is used by me is ACCESS.
Any one help me. Thanks in advance.
Nikesh Kr. Yadav
CSS Infotech
Sec- 31
Gurgaon,
Haryana(India)
|
|
|
|
|
I just asked you what is the problem in the other forum. Pick one forum please, it is rude to cross post 
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
|
|
|
|
|
Looking at your message history, you post every question you have to at least three forums. Please don't do that, it's rude and annoying. Pick the right forum and ask there.
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 )
|
|
|
|
|
Hi, I have connected to and retrieved data from the database. I have yet to bind the data to any control since I'm uncertain which one is the most suitable control for storing large text files and displaying large text files. Please point me to a tutorial using asp.net 1.x, most of the ones I came across only show how to display records from the database where the records have only a couple of words instead of a whole page of paragraph. Thank you in advance for your help.
|
|
|
|
|
Text is text. Your main concern is, if the file is huge, the page will be huge. No control exists for the purpose of viewing large text files specifically, a label is as good a control as any. You may want to put it inside a div and use CSS to make a scrollable window, or something like that, depending on how big, is big.
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 )
|
|
|
|
|
Hey there Christ, just the person I want to talk to. Let me give you the details of my problem. The other day when I posted a similar question, I had data from a database bound to a listbox then when I display it I noticed that my listitems were replaced by the data from the database. I realized that I have to bind the data to another control if I want to keep my listitems so I can use them to make more selections. Someone who had responded to that post said that I can bind data to a second control, when I select a listitem from my first listbox. Then I can display the data thats bound to the second listbox. I've tried to make that work but thus far it doesn't work. Can you perhaps shed a little light on that? And please don't be vague, after all I'm new to this stuff. I took your advice and bought a book, its not the latest version since I'm still using Framework 1.1.
-- modified at 2:12 Friday 27th July, 2007
|
|
|
|
|
ASPnoob wrote: Hey there Christ, just the person I want to talk to.
LOL - Christ ?
If you set the datasource for a listbox, it will replace the contents. Instead, you can take a datatable and iterate over it, as in
foreach(DataRow row in myTable)
{
}
Inside this loop you can access data from the row by index ( row[0] ) or by column name ( row["CarName"] ) These methods return an object, use ToString() to turn them into strings, which they probably are. Or cast them.
Then you can add items to the listbox via myListbox.Items.Add(
In that way, you can add items without losing the ones that are there.
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 )
|
|
|
|
|
i am workling on the crystal reports.I saw - the design of the crystal page is reduced drastacially.Is there any way to get original page back
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
What original page ? How is it 'reduced' ? What did you do that you want to undo ?
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 )
|
|
|
|
|
problem is i was trying to dag drop the table fields in my crystal reports design.But due to less design space i am not being able to see the data fields completely , their a little portion gets hides are run time.
I don;t know how come the space got shrinked.
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
arrange ur width hight or do ur width and hight 100%
Piyush Vardhan Singh
Programmer
TAS NewDelhi
India
|
|
|
|
|
hi piyush,
where i can find this option ?
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
|
wait
Piyush Vardhan Singh
Programmer
TAS NewDelhi
India
|
|
|
|
|
Can you have idea abt my problem if you have help me
I want to connect a crystal Report dynamically with database which changes accordingly but the table is same in all the database table name = “Stock “ Also I want to add condition “SELECT * FROM Stock Where Date BETWEEN ‘xyz’ AND ‘abc’” Database is used by me is ACCESS.
Thanks in advance.
Nikesh Kr. Yadav
CSS Infotech
Sec- 31
Gurgaon,
Haryana(India)
|
|
|
|
|
Sorry to say , but i think u need a new thread.
Sonia Gupta
Soniagupta1@yahoo.co.in
Yahoo messengerId-soniagupta1
Love is Friendship and Friendship is Love....
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
