Comments by DINESH K MAURYA

DINESH K MAURYA 5-Jun-18 0:59am View

sir how to install the certificate, when I debug the code and run it find and ask for dongal password means it works but after published and hot it in IIS not work.
Please suggest

DINESH K MAURYA 13-Jan-17 2:36am View

Sir,
If i update 1066141L PREM SINGH which is already with add with zero see persid=137, If i update persid =129 then erros msg goes primary key violence.
So when update then check that another no in this column is add with zero or not if it have then skip other wise update with zero.

DINESH K MAURYA 13-Jan-17 2:27am View

Deleted

.

DINESH K MAURYA 13-Jan-17 2:26am View

PersId		PersonUID    	PersonnelName
137		01066141L	PREM SINGH  
128		02679425F	RADHAKRISHANAN
129		1066141L	PREM SINGH
130		04457802P	MOTI SINGH  
135		02365847P        Ramesh

only Ramesh is update..
or which is less than 9 except the slimier with zero
I have 5K record in which some of similer with zero and some is less than 9.

DINESH K MAURYA 13-Jan-17 2:21am View

sir,
I want to update skip those record which is already zero and rest of record which is less than 9 update with zero. personuid is primary key.
thanks in advance.

DINESH K MAURYA 13-Jan-17 2:16am View

Yes Peter you are right, thanks alot
I follow the link which you provide, so pls let me know how to find the this(Pram singh) type of record.

DINESH K MAURYA 19-May-15 0:44am View

Yes dll in bin folder. exact problem is when i use code in windows 7 system it does not work but when i use same code in windows 8 laptop it work..
I have also check in different windows 7 laptop it does't work same error message show.

DINESH K MAURYA 23-Apr-15 6:49am View

No

DINESH K MAURYA 29-Aug-14 2:23am View

Thanks alot..

I have find other solution like "Server.URLDecode()"

DINESH K MAURYA 29-Aug-14 2:05am View

i just put "test id" but it is name field..

DINESH K MAURYA 29-Aug-14 1:59am View

okwhen user put space then how to avoid it.

DINESH K MAURYA 11-Jul-14 2:34am View

how to add edit button on server side in gridview

DINESH K MAURYA 2-Jul-14 5:34am View

Thanks alot

DINESH K MAURYA 2-Jul-14 5:08am View

As you suggest that I have change accordingly
blow modified code, but same result


CREATE TABLE #DataTable (Attribute_SubID INT, AttributeID INT, Attribute_Sub NVARCHAR(50));

INSERT INTO #DataTable (Attribute_SubID, AttributeID, Attribute_Sub) VALUES (3, 2, 'xyz'), (4, 2, 'abc'), (3, 2, 'def');

 
DECLARE @ColumnsTable TABLE (Col VARCHAR(10));

INSERT INTO @ColumnsTable (Col)
SELECT DISTINCT Attribute_SubID FROM #DataTable;

DECLARE @SQL VARCHAR(MAX);

SET @SQL = ';WITH Data
AS
(
SELECT Attribute_SubID, Attribute_Sub, ROW_NUMBER() OVER (PARTITION BY Attribute_SubID
ORDER BY Attribute_Sub desc) AS RowNumber
FROM #DataTable
where Attribute_Sub <> ''--''
)
SELECT ' + (SELECT STUFF((SELECT ', ISNULL([' + Col + '], ''--'') AS [' + Col + ']'
FROM @ColumnsTable
FOR XML PATH('')), 1, 2, '')) +
'
FROM Data
PIVOT
(
MAX(Attribute_Sub)
FOR Attribute_SubID IN
(' + (SELECT STUFF((SELECT ', [' + Col + ']'
FROM @ColumnsTable
FOR XML PATH('')), 1, 2, '')) + ')
) AS pvt;';

--SELECT @SQL;
 
EXEC(@SQL);

 
DROP TABLE #DataTable;

DINESH K MAURYA 2-Jul-14 4:48am View

Deleted

As you suggest that I have change accordingly
blow modified code, but same result


CREATE TABLE #DataTable (Attribute_SubID INT, AttributeID INT, Attribute_Sub NVARCHAR(50));
 
INSERT INTO #DataTable (Attribute_SubID, AttributeID, Attribute_Sub) VALUES (3, 2, 'xyz'), (4, 2, 'abc'), (3, 2, 'def');
 

DECLARE @ColumnsTable TABLE (Col VARCHAR(10));
 
INSERT INTO @ColumnsTable (Col)
SELECT DISTINCT Attribute_SubID FROM #DataTable;
 
DECLARE @SQL VARCHAR(MAX);
 
SET @SQL = ';WITH Data
AS
(
	SELECT Attribute_SubID, Attribute_Sub, ROW_NUMBER() OVER (PARTITION BY Attribute_SubID
																ORDER BY Attribute_Sub desc) AS RowNumber
	FROM #DataTable
	where Attribute_Sub <> ''--''
)
SELECT ' + (SELECT STUFF((SELECT ', ISNULL([' + Col + '], ''--'') AS [' + Col + ']'
                                   FROM @ColumnsTable
                                   FOR XML PATH('')), 1, 2, '')) +
'
FROM Data
PIVOT
(
	MAX(Attribute_Sub)
	FOR Attribute_SubID IN
	(' + (SELECT STUFF((SELECT ', [' + Col + ']'
                                   FROM @ColumnsTable
                                   FOR XML PATH('')), 1, 2, '')) + ')
) AS pvt;';
 
--SELECT @SQL;

EXEC(@SQL);
 

DROP TABLE #DataTable;

DINESH K MAURYA 2-Jul-14 2:44am View

Yes may be increase or descress
because i have generate this table after pivot

DINESH K MAURYA 2-Jul-14 2:30am View

Thanks for reply
If the color1 and color2 are dynamic then how to do this

DINESH K MAURYA 1-Jul-14 2:26am View

I have a table xyz which row is
colortype colorname
--------------
color1 Green
color2 black
color1 yelow
color1 Pink
color2 white

I have pivot it
and reslut as in question but i want to show like
color1 color 2
__________________
Green Black
yellow White

I have show in gridview it

DINESH K MAURYA 29-Jun-14 5:25am View

Here is nothing..

DINESH K MAURYA 28-Jan-13 5:59am View

Dear Amy, i want to use like weather services or new services which use in our application and i want to use it on server not local machine..

DINESH K MAURYA 25-Jan-13 6:34am View

can be get any information to client which is uniqe.
i want to give permission to specific computer to login the application.

DINESH K MAURYA 11-Dec-12 7:29am View

Dear Humayan,

I have a order form which i have make public web service for other websites
Thanks alot in advance

DINESH K MAURYA 20-Nov-12 4:41am View

Thanks

DINESH K MAURYA 20-Nov-12 4:14am View

This return :-
where
Manufactured_In=case when A P I INDIA is null then Manufactured_In
else A P I INDIA
end
Order by p.SeriesId Desc

An expression of non-boolean type specified in a context where a condition is expected, near 'P'.

DINESH K MAURYA 18-Nov-12 0:47am View

Dear all,

i have change connection string in sqlhelper class its ok but when i want to access from the webconfig file it is not access that string name

DINESH K MAURYA 16-Nov-12 8:20am View

please change it "LocalMySqlServer" after that it shows same error msg.

DINESH K MAURYA 4-Nov-12 8:08am View

ok can u give some grid view example

DINESH K MAURYA 13-Oct-12 6:09am View

table 3 is out put table

DINESH K MAURYA 9-Oct-12 3:41am View

suppose i have a table name tb
and column name
alphabate
and his rows value like
a
b
c
d
arrange it
a
c
b
d

DINESH K MAURYA 9-Oct-12 3:23am View

thank,
trying it.
can be short row if row value like this..
a,b,c,d
arrange it a,c,b,d

DINESH K MAURYA 1-Oct-12 3:25am View

Dear Mukhtar
i have make it public
but when u create View Class Diagram then there is no class show
i have create in 2008 and its working fine but this problem is vs 2010.

DINESH K MAURYA 9-Aug-12 8:20am View

thans for answer, but there is multiuser application on the web

DINESH K MAURYA 23-Jul-12 2:38am View

it work on IE and FireFox.

DINESH K MAURYA 7-Jul-12 7:10am View

please tell what try This and Edit?

DINESH K MAURYA 28-Jun-12 6:52am View

thanks mehdi and Damith

DINESH K MAURYA 28-Jun-12 6:26am View

many many Thanks .
but what is the reason?
it working fine when record was few.

DINESH K MAURYA 20-Jun-12 6:00am View

Deleted

code:-
Public Function Bookings_SELECT(ByVal objSearch As CIns_Booking_Search, _
ByVal startIndex As Integer, ByVal endIndex As Integer, _
ByRef TotalRecords As Integer) As List(Of CIns_Booking)

Dim sqlParam As SqlParameter() = New SqlParameter() {}
Dim reader As SqlDataReader
Dim objList As New List(Of CIns_Booking)

sqlParam = New SqlParameter() {New SqlParameter("@ContactID", objSearch.SessionContactID), _
New SqlParameter("@UserTypeID", objSearch.SessionUserType), _
New SqlParameter("@SubUserType", objSearch.SessionSubUserType), _
New SqlParameter("@UserID", objSearch.UserID), _
New SqlParameter("@AgentID", objSearch.AgentID), _
New SqlParameter("@PaxName", IIf(objSearch.PaxName = String.Empty, DBNull.Value, objSearch.PaxName)), _
New SqlParameter("@PolicyNo", IIf(objSearch.PolicyNo = 0, DBNull.Value, objSearch.PolicyNo)), _
New SqlParameter("@FromDate", IIf(objSearch.FromDate = String.Empty, DBNull.Value, objSearch.FromDate)), _
New SqlParameter("@ToDate", IIf(objSearch.ToDate = String.Empty, DBNull.Value, objSearch.ToDate)), _
New SqlParameter("@Status", IIf(objSearch.Status = String.Empty, DBNull.Value, objSearch.Status)), _
New SqlParameter("@startIndex", startIndex), _
New SqlParameter("@endIndex", endIndex)}

reader = SqlHelper.ExecuteReader(SqlHelper.ConnectionString_SimphonI, Data.CommandType.StoredProcedure, "dbo.pd_vs_Ins_Bookings_SELECT", sqlParam)
If reader.Read Then
While reader.Read
Dim obj As New CIns_Booking

If Not IsDBNull(reader("BookingID")) Then obj.BookingID = reader("BookingID")
If Not IsDBNull(reader("BookedBy")) Then obj.BookedBy = reader("BookedBy")
If Not IsDBNull(reader("DepartDate")) Then obj.DepartDate = reader("DepartDate")
If Not IsDBNull(reader("ReturnDate")) Then obj.ReturnDate = reader("ReturnDate")
If Not IsDBNull(reader("CreatedOn")) Then obj.CreatedOn = CDate(reader("CreatedOn")).ToString("dd/MM/yyyy hh:mm:ss")
If Not IsDBNull(reader("Status")) Then obj.Status = reader("Status")
If Not IsDBNull(reader("strStatus")) Then obj.strStatus = reader("strStatus")
If Not IsDBNull(reader("Premium")) Then obj.Premium = reader("Premium")
If Not IsDBNull(reader("Pax")) Then obj.Pax = reader("Pax")
If Not IsDBNull(reader("Age")) Then obj.Age = reader("Age")
If Not IsDBNull(reader("Duration")) Then obj.Duration = reader("Duration")
If Not IsDBNull(reader("Destination")) Then obj.Destination = reader("Destination")
If Not IsDBNull(reader("InsID")) Then obj.InsID = reader("InsID")
If Not IsDBNull(reader("Paxes")) Then obj.Paxes = reader("Paxes")
If Not IsDBNull(reader("AgentID")) Then obj.AgentID = reader("AgentID")
If Not IsDBNull(reader("Trip")) Then obj.Trip = reader("Trip")
If Not IsDBNull(reader("Source")) Then obj.Source = reader("Source")

objList.Add(obj)
End While
End If
Return objList
Catch ex As Exception
Return objList
End Try
End Function

query:-
-------------
declare part

declare @ContactID int
set @ContactID=1
declare @Us

DINESH K MAURYA 20-Jun-12 3:45am View

yes both question are same, but my question is when query result is 1 row after taking 25 sec, but when i search record by the portal reader does not return any record.
thanks in advance

DINESH K MAURYA 20-Jun-12 3:41am View

thanks alot,

DINESH K MAURYA 20-Jun-12 3:34am View

clarify the online folder,
if user upload any file it should be uploaded fileuploadfolder

DINESH K MAURYA 20-Jun-12 1:46am View

My query is given below

declare @ContactID int
set @ContactID=1
declare @UserTypeID int
set @UserTypeID=1
declare @SubUserType int
set @SubUserType=1
declare @UserID int
set @UserID=0
declare @AgentID int
set @AgentID =0
declare @PaxName varchar(50)
set @PaxName=N'Neharika'
declare @PolicyNo int
set @PolicyNo=53504975
declare @FromDate varchar(50)
set @FromDate=NULL
declare @ToDate varchar(50)
set @ToDate=NULL
declare @Status varchar(50)
set @Status=N'1,2,5'
declare @startIndex int
set @startIndex='0'
declare @endIndex int
set @endIndex='20'

Select
Booking.AgentID ,
Booking.BookingID ,
BookedBy = Case @UserTypeID
when 1 then
case Booking.Type
when 1 then (Select Name from pd_tbSI_Users where ContactID = Booking.CreatedBy) + ' (Booked for : Self )'
when 2 then (Select Name from pd_tbSI_Users where ContactID = Booking.CreatedBy)+ ' (Booked for : Agent - ' + (Select Name from pd_tbSI_Agents where AgentID = Booking.AgentID) + ')'
else (Select Name from pd_tbSI_Agents where AgentID = Booking.AgentID)
end
when 2 then
case Booking.Type
when 0 then (Select Name from pd_tbSI_Agents_Users where ContactID = Booking.CreatedBy)
else (Select Name from pd_tbSI_Users where ContactID = Booking.CreatedBy) + ' (Booked by Travel Protector)'
end
end,

Booking.DepartDate ,
Booking.ReturnDate ,
Booking.CreatedOn ,
Booking.Status ,
strStatus = case Booking.Status
when 1 then 'Ready'
when 2 then 'Booked'
when 3 then 'Booked'
when 5 then 'Cancelled'
end,

Premium = dbo.fn_INS_CustPrice (Booking.InsID ,Booking.Age,Booking.Duration) ,
Booking.Pax ,
Booking.Age ,
Booking.Duration ,
Booking.Destination ,
Booking.InsID ,
Booking.Trip ,
ins.Source,
Paxes = dbo.fn_INS_Booking_AllPaxes(Booking.BookingID)

from pd_tbIns_Booking Booking
inner join pd_tbInsurance ins
on Booking.InsID=ins.InsID
where

Booking.BookingID in
(
Select innerTable.BookingID
from
(
Select
temp.BookingID,
ROW_NUMBER () over(order by temp.createdon desc) as rowNum
from pd_tbIns_Booking temp
where
(
( temp.CreatedBy = case when (@UserTypeID = 2 and @SubUserType = 1) OR
(@UserTypeID = 1 and @SubUserType in (1,2))
then temp.CreatedBy
else @ContactID
end

and

temp.AgentID = case when @UserTypeID = 2
then (Select AgentID from pd_tbSI_Agents_Users
where ContactID = @ContactID )
else temp.AgentID
end
)

OR

(
temp.AgentID in (Select intValue from dbo.fnIntegersArray
(dbo.fn_INS_Booking_SEARCHQUERY(@ContactID,temp.AgentID,@UserTypeID,@SubUserType))
)

and

temp.CreatedBy = case when @UserTypeID = 2 and @SubUserType =2
then @ContactID
else temp.CreatedBy
end
)
)

and

temp.CreatedBy = case when @UserID = 0
then temp.CreatedBy
else @UserID
end

and

temp.AgentID = case when @AgentID = 0
then temp.AgentID
else @AgentID
end
and

temp.CreatedOn >= case when @FromDate is null
then temp.CreatedOn
else CONVERT (datetime,@FromDate,103)
end
and

temp.CreatedOn <= case when @ToDate is null
then temp.CreatedOn
else CONVERT (datetime,@ToDate,103)
end

and

1 = case when @PolicyNo IS not null
then dbo.fn_INS_Booking_PolicyNo(temp.BookingID ,@PolicyNo )
else 1
end

and

1 = case when @PaxName <> ''
then d

DINESH K MAURYA 18-Jun-12 8:08am View

record 17543 rows,
i am not using index
but when i search all record it working fine.

DINESH K MAURYA 28-May-12 8:43am View

thanks i try it..

DINESH K MAURYA 28-Apr-12 5:16am View

dear tulasiram i try it but it open new window i want to open same browser new tab,,...

DINESH K MAURYA 24-Apr-12 7:26am View

thanks for
but this code not working in serverside
i have try this ...
please suggest me .

DINESH K MAURYA 19-Apr-12 5:25am View

Deleted

i want to open when i edit button click then open a popup window. after editing when submit then give a want to give message in popupwindow.

DINESH K MAURYA 17-Apr-12 1:18am View

it open but twice click
i want to open single click event

DINESH K MAURYA 17-Apr-12 0:49am View

thank for..
but i use ValidationGroup for many clintside control as two three textbox.

<td align="left" valign="top" width="25%">
<asp:TextBox runat="server" ID="txtEmailID" Width="50%" MaxLength="50" onpaste="return false"
oncopy="return false" oncut="return false" CssClass="unwatermarked">
<asp:RequiredFieldValidator ID="rfvTxtEmail" runat="server" ControlToValidate="txtEmailID"
ValidationGroup="Register" ErrorMessage="Required Field Missing<br />Please type your Email ID"
Display="None" />
</td>

second text

<td align="left" valign="top" width="25%">
<asp:TextBox runat="server" ID="txtPSWD" MaxLength="30" TextMode="Password" onpaste="return false"
oncopy="return false" oncut="return false" Width="50%" CssClass="unwatermarked">
<cc1:TextBoxWatermarkExtender ID="tbwPasword" runat="server" TargetControlID="txtPSWD"
WatermarkText="....." WatermarkCssClass="watermarked">

<asp:RequiredFieldValidator ID="rfvPassword" runat="server" ErrorMessage="Required Field Missing<br/>Please type Password"
Display="None" ControlToValidate="txtPSWD" SetFocusOnError="True" ValidationGroup="Register">
</td>

<td align="right" width="35%">
<asp:Button ID="btnRegester" runat="server" Text="Save" ValidationGroup="Register"
CausesValidation="true" Height="30px" Width="90px" CssClass="savebutton" />
</td>

i use button click event validation in serverside.
Please how to solve it,...

DINESH K MAURYA 17-Apr-12 0:43am View

my question is how to validate true in server side.
because my validation is false as i show in code(page.IsValid)
how to validation true here...

DINESH K MAURYA 16-Apr-12 8:51am View

thanks..

DINESH K MAURYA 5-Mar-12 6:57am View

thanks all i found what is problem in it.
and i wana inform all the reader that if he use gmail a/c smtp then disable 2 step verification.and send email
........

DINESH K MAURYA 28-Feb-12 0:34am View

thanks alot

DINESH K MAURYA 19-Jan-12 0:57am View

thanks
i use it but it not get current date.
for your kind information i use Event date varchar.

DINESH K MAURYA 30-Dec-11 5:12am View

thanks for try to solve but
i want to select which record wher zone from and zone to does not match
zone to repet or zone from repet does not matter only zone to and zone from bothe not sam

DINESH K MAURYA 23-Dec-11 2:18am View

Thanks

DINESH K MAURYA 23-Dec-11 2:18am View

thanks

DINESH K MAURYA 15-Dec-11 8:16am View

Dear sir i your insert two color in colorid then what will happen
my problem that if your insert two color for a model.

DINESH K MAURYA 7-Dec-11 1:00am View

i want to select every month such as nov, sep, jun, may

DINESH K MAURYA 12-Nov-11 4:22am View

but it not open in new window

DINESH K MAURYA 12-Oct-11 7:06am View

thanks....

DINESH K MAURYA 12-Oct-11 7:05am View

thanks

DINESH K MAURYA 12-Oct-11 7:04am View

thanks....

DINESH K MAURYA 12-Sep-11 4:45am View

it work nice but my html page in which i defing botton get blank

DINESH K MAURYA 27-Jul-11 9:31am View

yes

Comments by DINESH K MAURYA (Top 64 by date)