|
Why Dont you go for autocomplete extender..!
or you can go to teletrix controls thts only a suggestion
LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.
|
|
|
|
|
Well, using auto-complete extender of ajax in textbox
should not be a bad idea to achieve what you want.
If you stil wish to populate combo box, call a WebMethod
on click of your combo box (drop down list actually), then get the
data in xml format, read that xml using javascript and then attach the
items to your combo box.
|
|
|
|
|
suppose when user click on link or button for downloading file in asp.net then download start.
so i just want to know how to detect that the file as been downloaded in client machine.
is it possible to track from server side code. because i want to develop a file download section
from where user at a time can download only single file. so in this case when file download start
i will just capture client ip and store it in session and when file download will be over then i will
clear that session and in this way my purpose will be solved and restric user to downlolad multiple file.
few days back i post this same question bot did not got any good solution. i forget to ask u that how rapid share,hotfile do this.
in hot file i saw they allow download one file at a time. the moment one file is downladed then another can be download.what type of logic they
use. please let me know if u guys have any idea.
Thanks in advance
tbhattacharjee
|
|
|
|
|
Hi ,
How to make a screen shot of our aspx page ? any idea ?
With warm regards ...
|
|
|
|
|
|
after Alt + Ptr Scr, open mspaint and press Ctrl + V & Save it....
|
|
|
|
|
You're right: I didn't think: if he didn't know how to Alt+PrtScr how the hell would he know what to do next?
|
|
|
|
|
why you are extending this..
|
|
|
|
|
Because I can and it's fun.
|
|
|
|
|
alt+print screen ?.this forum is for developers bro.
|
|
|
|
|
We can use directly printscreen directly...... and then paste in paint
Naina
|
|
|
|
|
Sorry bros ,
I asked to make screenshot from code.I want to do it in a button click.I think I should use some client side scripts.
With regards ....
|
|
|
|
|
You can try like this
Onclientclick of a button ... call a function and inside write as below
window.print();
Naina
|
|
|
|
|
Well, why do you need the screen shot. What exactly you are trying
to do with screen shot?
I personally don't suggest to do so.
It is a security threat and most of the people will not allow
their browser to access the clipboard like this.
You can achieve it using ActiveX control but again
it will work only in IE that too with ActiveX enabled browser.
|
|
|
|
|
Do you mean the rendered html that you'd see if you right-click on the page and select view source? You might have thought you were being clear but you weren't.
|
|
|
|
|
Please Please stop this discussion.... dont understand why we are changing our job....
|
|
|
|
|
|
For this kind of issue use RowDataBound event of grid view
|
|
|
|
|
Hi,
Can we connect to Sybase Database from Asp.net without "Sybase ASE ODBC Driver".
My application is working fine without this Driver.
I am using Sybase.Data.AseClient in my code to access Sybase.
Can you please suggest which driver it is using to conncet Sybase
Thanks,
|
|
|
|
|
This is my store procedure but where i am doing wrong
ALTER PROCEDURE [dbo].[Engagement_Get_StandardYears]
(
@clientName NVARCHAR(255)=NULL
)
AS
BEGIN
SET NOCOUNT ON;
SELECT Distinct [Year]
FROM Engagement_Standards
WHERE [Year] IS NOT NULL AND [Client Name] like
CASE
WHEN @clientName IS NULL THEN %
ELSE @clientName
END
ORDER BY [Year];
END
|
|
|
|
|
|
can you please provide more info what kind of error you are getting
one syntax error is resolved
declare @clientName NVARCHAR(255)
SET NOCOUNT ON;
SELECT Distinct [Year]
FROM Engagement_Standards
WHERE [Year] IS NOT NULL AND
[Client Name] like
(CASE
WHEN @clientName IS NULL THEN '%'--error part
else @clientName END )
ORDER BY [Year];
|
|
|
|
|
WHERE [Year] IS NOT NULL
AND isNull(@clientName, [Client Name]) = [Client Name]
I think this is what you're after. If the parameter is null we're just saying if [Client Name] = [Client Name] which it will. If it's not null you'll be comparing the parameter with the column.
|
|
|
|
|
I have used some thing like this Rupert, is this method OK.
USE [INVENTORY_ MANAGEMENT]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date,,>
-- Description: <Description,,>
-- =============================================
Create PROCEDURE [dbo].[Engagement_Get_StandardsByCriteria]
-- Add the parameters for the stored procedure here
(
@ClientName NVARCHAR(255)=NULL,
@Year FLOAT=NULL,
@Application NVARCHAR(255) =NULL,
@Database NVARCHAR(255)=NULL,
@OS NVARCHAR(255)=NULL,
@QuickName NVARCHAR(MAX)=NULL
)
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
SELECT [Client Name] AS Client,[Year],[Application],
[Database],OS,[MLP Heading] As Heading,
[Standard Observation] AS Observation,[Standard Impact]AS Impact,
[Standard Recommendation] AS Recommendation
FROM Engagement_Standards
WHERE (@ClientName IS NULL OR [Client Name]=@ClientName)
And
(@Year IS NULL OR [Year]=@Year)
And
(@Application IS NULL OR [Application]=@Application)
And
(@Database IS NULL OR [Database]=@Database)
And
(@OS IS NULL OR OS=@OS)
And
(@QuickName IS NULL OR [Quick Name]=@QuickName);
END
|
|
|
|
|
That'll probably work but It might be a bit easier to read/maintain like this:
WHERE isNull(@ClientName, [Client Name]) = [Client Name]
AND isNull(@Year, [Year]) = [Year]
AND isNull(@Application, [Application]) = [Application]
AND isNull(@Database, [Database]) = [Database]
AND isNull(@OS, [OS]) = OS
AND isNull(@QuickName, [Quick Name]) = [Quick Name];
|
|
|
|