Comments by Mohd Arif Khan

Mohd Arif Khan 17-Dec-13 0:29am View

hii,Tadit
after doing this the same problem its happening like A->B->C->D->E respectively these are child in alphabetical order when E registered the money earned by D is suppose 5000. and and C gets 2000 so the new amount for C is 7000 at this level it's ok, when B's amount just become 13000 to 21000, m not not how it's value get so much. and after this no level value is modifying.

Mohd Arif Khan 16-Dec-13 5:56am View

have a look to the flow but it could not update the 3rd level and one more thing on 2nd level it's updating the value by awkward way

Mohd Arif Khan 16-Dec-13 5:53am View

declare @nextparent varchar(20)
declare @money decimal(18,0)
if(@bookingamt<=25000)
set @money=1000
else
set @money=2000

insert into tbl_level(Parentid,childid,rewardpoint,earnedmoney,noofchild) values(@parentkey,@CusId,1,convert(decimal,(@BookingAmt/10)),1)
if exists (select 1 from tbl_level where childid=@parentkey)
begin

select @nextParent=parentid from tbl_level where childid=@parentkey

update tbl_level set earnedmoney+=@money where parentid=(select Parentid from tbl_level where Childid=@parentkey)

if exists (select 1 from tbl_level where childid=@nextParent)
begin
select @nextParent=childid from tbl_level where childid=@nextParent

update tbl_level set earnedmoney= earnedmoney+@money where parentid=(select Parentid from tbl_level where Childid=@nextParent)
end
if exists (select 1 from tbl_level where childid=@nextParent)
begin
select @nextParent=childid from tbl_level where childid=@nextParent

update tbl_level set earnedmoney= earnedmoney+@money where parentid=(select Parentid from tbl_level where Childid=@nextParent)
end
if exists (select 1 from tbl_level where childid=@nextParent)
begin
select @nextParent=childid from tbl_level where childid=@nextParent

update tbl_level set earnedmoney= earnedmoney+@money where parentid=(select Parentid from tbl_level where Childid=@nextParent)
end
if exists (select 1 from tbl_level where childid=@nextParent)
begin
select @nextParent=childid from tbl_level where childid=@nextParent

update tbl_level set earnedmoney= earnedmoney+@money where parentid=(select Parentid from tbl_level where Childid=@nextParent)
end
end

Mohd Arif Khan 16-Dec-13 5:51am View

i understand and did the same brother but it's not going to update the upper level.

Mohd Arif Khan 16-Dec-13 5:06am View

hello Tadit, i'hv applied it but it's just updating upto one level

Mohd Arif Khan 16-Dec-13 0:29am View

tbl_level
parentid childid earnedmoney
cus_1 cus_2 5000
cus_2 cus_3 5000
cus_3 cus_4 5000

i want when cus_4 becomes parent of node cus_5 the parent of cus_3 get commissiom and cus_2 and this gone upto 4 level how to perform it.

Mohd Arif Khan 14-Dec-13 5:37am View

@Joy Please mention what you have updated in existing code. and insert statement is needed to be executed one time only.

Mohd Arif Khan 14-Dec-13 4:21am View

select @nextParent=childid from tbl_level where childid=@parentkey this line is getting error of Incorrect syntax near '='.

Mohd Arif Khan 14-Dec-13 3:45am View

it's getting error Incorrect syntax near '='. on select @nextParent=childid from tbl_level where childid=@parentkey line, and childid column is varchar type and you have matched it with in select statement how it will matched ever

Mohd Arif Khan 14-Dec-13 3:19am View

Deleted

But how @nextparent variable get value

Mohd Arif Khan 14-Dec-13 2:07am View

sir upto one level its fine but how to get select its upper level and update it

Mohd Arif Khan 26-Oct-13 7:04am View

Thanks Zubair. but problem is arising on firefox and chrome and Also The IE

Mohd Arif Khan 25-Oct-13 5:10am View

this way i have already tried. not worked

Mohd Arif Khan 25-Oct-13 4:43am View

no it's not working, exception is thrown it is a physical path but virtual path is expected

Mohd Arif Khan 25-Oct-13 3:00am View

it can not find the path of the uploaded file. phil.o the , is for sepration for multiple files

Mohd Arif Khan 25-Oct-13 2:59am View

i mailsending function the error has thrown.
ex = {"Could not find file 'C:\\Program Files\\Common Files\\Microsoft Shared\\DevServer\\10.0\\2.jpg,'.":"C:\\Program Files\\Common Files\\Microsoft Shared\\DevServer\\10.0\\2.jpg,"}

Mohd Arif Khan 25-Oct-13 2:55am View

file not found

Mohd Arif Khan 12-Oct-13 4:33am View

Not working.

Mohd Arif Khan 11-Oct-13 2:49am View

it is on.

Mohd Arif Khan 3-Oct-13 7:42am View

Thanks Azee :)

Mohd Arif Khan 3-Oct-13 7:29am View

i have tried to give min-height of gridview thru css,but it's not working

Mohd Arif Khan 3-Oct-13 7:27am View

ok

Mohd Arif Khan 3-Oct-13 7:15am View

i have already tried it. but not worked.

Mohd Arif Khan 1-Oct-13 7:29am View

i have not tried conditional operators i was checking on rowbound event.

Mohd Arif Khan 1-Oct-13 7:17am View

Thanq :)

Mohd Arif Khan 25-Sep-13 0:18am View

thanks for your concern i have solved it.

Mohd Arif Khan 24-Sep-13 9:28am View

i mean in filename variable which is stored in database as image name. in that field

Mohd Arif Khan 24-Sep-13 2:55am View

yeah, thanks a lot :)

Mohd Arif Khan 24-Sep-13 2:44am View

Thanks a lot :)

Mohd Arif Khan 24-Sep-13 2:16am View

thanks 2nd statement working :)

Mohd Arif Khan 24-Sep-13 2:16am View

Deleted

Thanks 2nd statement working :)

Mohd Arif Khan 23-Sep-13 4:27am View

nope

Mohd Arif Khan 23-Sep-13 4:23am View

i have tried it before you telling bro

Mohd Arif Khan 23-Sep-13 4:10am View

it is giving this error
the best overloaded method match for 'string.IsNullOrEmpty(string)' has some invalid arguments

Mohd Arif Khan 14-Sep-13 7:04am View

Thanks a ton :)

Mohd Arif Khan 14-Sep-13 6:22am View

no actual it just name del, i want to get the row index and redirect the page to other page.

Mohd Arif Khan 14-Sep-13 3:45am View

i have tried earlier with inline css. but is not working

Mohd Arif Khan 14-Sep-13 3:39am View

it's not working, and how to define width and height of background image

Mohd Arif Khan 14-Sep-13 3:33am View

if i'm putting an extra div between <img> and anchor tag all controls are scattered.

Mohd Arif Khan 14-Sep-13 3:32am View

one image for all

Mohd Arif Khan 13-Sep-13 2:51am View

Thanks :)

Mohd Arif Khan 12-Sep-13 6:06am View

it is solved label tag has created such problem.

Mohd Arif Khan 12-Sep-13 6:03am View

that was complete section which has problem bro.

Mohd Arif Khan 11-Sep-13 8:12am View

RyanDev i know but could you concentrate on problem

Mohd Arif Khan 11-Sep-13 5:54am View

ok

Mohd Arif Khan 11-Sep-13 5:17am View

@ Khandwawala Hatim it is also not working in my page

Mohd Arif Khan 11-Sep-13 4:31am View

sir source code is

<label>
Area(in Sq Ft)
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="Txtarea"
ValidationGroup="1"> <img alt=""
src='<%=ResolveClientUrl("~/Images/erroricon.png")%>' />
<asp:TextBox ID="Txtarea" runat="server">

<br />
Region
<asp:TextBox ID="Txtregion" runat="server">
Name<span>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="TxtName"
ErrorMessage="Enter Your Name" ValidationGroup="1"> <img
alt="" src='<%=ResolveClientUrl("~/Images/erroricon.png")%>' />
<asp:TextBox ID="TxtName" runat="server">
Mobile No.
<asp:TextBox ID="txtmobile" runat="server">

<asp:RegularExpressionValidator ID="RegularExpressionValidator1" runat="server" ValidationExpression="^[0-9]{10}"
ControlToValidate="txtmobile" ErrorMessage="Incorrect Number" ValidationGroup="1">
<img alt="" src='<%=ResolveClientUrl("~/Images/erroricon.png")%>' />
<br />
<div style="clear: both; padding-top: 22px;">
</div>
<asp:Button ID="Btnsave" runat="server" Text="Send" Width="78px" Style="color: #fff;
font-size: 12px; line-height: 15px; background: url(../images/button-1.jpg) 0 0 repeat-x #08489f;
border-top: #339ed3 1px solid; border-right: #2881c3 1px solid; border-bottom: #1a62b1 1px solid;
border-left: #2881c3 1px solid; display: inline-block; text-decoration: none;
padding: 5px 21px 7px 19px; cursor: pointer;" OnClick="Btnsave_Click" ValidationGroup="1" />

<asp:Label ID="Label1" runat="server" ForeColor="Black">
</span></label>

Mohd Arif Khan 5-Sep-13 5:38am View

Thanks sir

Comments by Mohd Arif Khan (Top 48 by date)