Comments by shreeniwas kushwah (Top 26 by date)

OK i try

Hi Arvind,
It Shows correct data in webpage,
Issue is in print out paper
unfortunately It Prints correct data when printing with Ctrl+P

Hi Chandra Mohan,
Yes Installed,when I Print Report with Ctrl+P then Prints correctly,
But when I Print by print button given in Crystal report It Prints Boxes instead of Fonts

I have some if else in TVF so View can not be created Bhavesh :(

Yes Bhavesh !

i have created indexes in all tables used in query.
But in Actual Execution Plan TVF has no info, its cost shows 0% cost.

So where and what i do with tables used in TVF.


I will try to create view if no any confliction occures

.

Bhavesh !!!

Thanks to reply....but by temp table i think i will face prob. e.g.

insert into @Ptemp
select * from dbo.GetSTNInfo(S.STNID,TD.Code,S.ReasonTypeDetailID)

in this query STN table has 200000 rows and for search criteria (for ex. stnid=12541)
then all rows inserted in temp first and then joins .


Pls Give me more suggestion.

Can any one help me??
I have been frausted :(

Reason for my vote of 5 \n Best article for beginner.

Thanks alot.

:)

I want NonCommon Data ......
:)

ok

can any one help me????

If i use private method LoadSTN() then if list has 10000000 records then 10000000 objects of STN class created and if i use Approch two then single object initialize memory 10000000 times

then what is better approch????

I have used modelPopUp Extender control in same page twice..its not working properly ???

OK Now how analysing query by profiler ???

Please tell me??

How can I show Plan and Time of Execution etc info in sql server (to view data searching after creating Indexes)

How Can I call this Script from Front End???
(due to Excel OpenRowSet)

because i use DataTable to In-Memory Data for Excel

IF EXISTS(SELECT 1 FROM ModelIMEI MI
WHERE
(@IMEI<>'' AND @IMEI IS NOT NULL AND( MI.IMEI=@IMEI OR MI.SecondaryIMEI=@IMEI OR MI.IMEI3=@IMEI OR MI.IMEI4=@IMEI))
OR
(@IMEI2 <>'' AND @IMEI2 IS NOT NULL AND( MI.IMEI=@IMEI2 OR MI.SecondaryIMEI=@IMEI2 OR MI.IMEI3=@IMEI2 OR MI.IMEI4=@IMEI2))
OR
(@IMEI3 <>'' AND @IMEI3 IS NOT NULL AND (MI.IMEI=@IMEI3 OR MI.SecondaryIMEI=@IMEI3 OR MI.IMEI3=@IMEI3 OR MI.IMEI4=@IMEI3))
OR
(@IMEI4 <>'' AND @IMEI4 IS NOT NULL AND (MI.IMEI=@IMEI4 OR MI.SecondaryIMEI=@IMEI4 OR MI.IMEI3=@IMEI4 OR MI.IMEI4=@IMEI4))
)
BEGIN
SELECT 'IMEI Already Exists'
RETURN
END

IF EXISTS (SELECT 1 FROM ProductDetail PD
WHERE
(@IMEI<>'' AND @IMEI IS NOT NULL AND (PD.IMEINumber=@IMEI OR PD.IMEI2=@IMEI OR PD.IMEI3=@IMEI OR PD.IMEI4=@IMEI))
OR
(@IMEI2 <>'' AND @IMEI2 IS NOT NULL AND(PD.IMEINumber=@IMEI2 OR PD.IMEI2=@IMEI2 OR PD.IMEI3=@IMEI2 OR PD.IMEI4=@IMEI2))
OR
(@IMEI3 <>'' AND @IMEI3 IS NOT NULL AND(PD.IMEINumber=@IMEI3 OR PD.IMEI2=@IMEI3 OR PD.IMEI3=@IMEI3 OR PD.IMEI4=@IMEI3))
OR
(@IMEI4 <>'' AND @IMEI4 IS NOT NULL AND (PD.IMEINumber=@IMEI4 OR PD.IMEI2=@IMEI4 OR PD.IMEI3=@IMEI4 OR PD.IMEI4=@IMEI4))
)
BEGIN
SELECT 'IMEI Already Exists'
RETURN
END

SqlCommand command = CreateCommand();
command.Connection.Open();
command.CommandText = "BulkIMEFromExcel1";

command.Parameters.Add(new SqlParameter("@IMEI", SqlDbType.VarChar)).Value = imei;
command.Parameters.Add(new SqlParameter("@IMEI2", SqlDbType.VarChar)).Value = imei2;
command.Parameters.Add(new SqlParameter("@IMEI3", SqlDbType.VarChar)).Value = imei3;
command.Parameters.Add(new SqlParameter("@IMEI4", SqlDbType.VarChar)).Value = imei4;

So which class i should use for transaction Handling for Web Apps ??

Gridview datasource is very huge (50 MB approx.) so in every pageindex_changing the data back and forth from client to server .
To Resolve this i tried