Comments by ajitha.pusapati

ajitha.pusapati 29-Jun-11 2:49am View

Thanks for ur reply. its very nice.
I prepate quary like the following. but i con't do two tings in that.

SELECT memNo,memberName,[18] AS LockerRent, [19] AS SubscriptionFees
FROM
(select c.ID as cid ,c.Membershipnumber as memNo,c.Name as memberName, mi.ID as ItemId, mi.Name as ItemName,mb.Amount as Amount from MemberMonthlyBill mb, MemberBill m ,MemberItems mi,Customer c
where mb.ItemID=mi.ID and m.ItemID=mi.ID and mb.BillingMonth=m.BillingMonth and m.CustomerID=c.ID and mb.CustomerID=c.ID and
mb.BillingMonth>='2011-04-1' and mb.BillingMonth<='2011-04-30') p
PIVOT
(
sum(Amount)
FOR ItemId IN
( [18], [19])
) AS pvt
ORDER BY pvt.cid;

1. except 18 and 19, for remaining item ids item name is Other.
2. it show multiple record for one customer .

result is
MemNo MemName LockerRent SubscriptionFees
A001 MR.A.V.R.K.KUMAR 25.00 NULL
A001 MR.A.V.R.K.KUMAR NULL 441.20
A002 MR. M. ADISANKAR NULL 441.20
A003 MR. ASHOK KUMAR GUPTA 25.00 NULL
A003 MR. ASHOK KUMAR GUPTA NULL 441.20

ajitha.pusapati 29-Jun-11 1:45am View

Deleted

Question updated

ajitha.pusapati 22-Jun-11 8:37am View

thanks this is really helpful.

ajitha.pusapati 9-Jun-11 8:36am View

can u explain clearly.

ajitha.pusapati 9-Jun-11 6:38am View

so nice.. Thanks..
for next line <br />.
for space ?.

ajitha.pusapati 7-Jun-11 5:41am View

if i enter "Reservation conformed to $Name$ on $Date$"
$Name$ and $Date$ enter through button clicking. reaming i entered normally.
name and date are variables. name and date color is blue and remaining black.

ajitha.pusapati 7-Jun-11 5:32am View

it should different form remaining text of text box. is it possible.

ajitha.pusapati 7-Jun-11 5:19am View

Thank u so much...
it will work.. but lastUsed.Text +="Hello" this is exactly i want.
i have to put a label instead of "Hello". is it possible

ajitha.pusapati 18-May-11 9:17am View

Thank u so much

ajitha.pusapati 18-May-11 8:19am View

can u give the direction..

ajitha.pusapati 18-May-11 8:17am View

ok..
which way is better..
i am fresher i dont know any thing..

ajitha.pusapati 18-May-11 8:00am View

I think in web application Application.lock()
But in windows forms...

ajitha.pusapati 18-May-11 7:57am View

This is my code

int maxcoid = Convert.ToInt32(CoreManager.DC.CheckIns.Max(a => a.CheckOutId));
if (maxcoid != null)
chkIn.CheckOutId = maxcoid + 1;
else
chkIn.CheckOutId = 1;

ajitha.pusapati 18-May-11 7:56am View

i cont understand this and i dont know how to impliment

ajitha.pusapati 16-May-11 8:00am View

can u explain clearly.

ajitha.pusapati 16-May-11 6:39am View

FoBillLineItem is a table name column haveing the values like 'luxry @ 5%' or 'Service @ 6%'.
In previous i send as it is by using "public string Name { get; set; }" its working now i want not display tax details. i.e. 'luxry @ 5%' will display 'luxry'

ajitha.pusapati 16-May-11 6:33am View

LineItem.Name does not have any value.
but discount property working

ajitha.pusapati 29-Mar-11 8:17am View

thank u.

ajitha.pusapati 29-Mar-11 6:29am View

sorry for that.. i already modify the question.
its windows forms

ajitha.pusapati 29-Mar-11 6:28am View

no, this can done in windows forms. but i dont kown how to do this..

ajitha.pusapati 23-Mar-11 11:15am View

windows 7 82 bit

ajitha.pusapati 23-Mar-11 11:09am View

same problem what i can do..

ajitha.pusapati 23-Mar-11 10:55am View

i just follow the following link
http://www.howtogeek.com/howto/windows-vista/enable-the-hidden-administrator-account-on-windows-vista/

but it its now show "net user administrator /active:yes" in command promt.
if i type it asking username and password.
my sys having one user.

ajitha.pusapati 23-Mar-11 10:46am View

sorry, i am asking run the setup administrative privileges

ajitha.pusapati 23-Mar-11 10:23am View

thanks for ur reply. 1st one and 2nd one i already did.but i dont know how to do 3rd one.
plz can u say..

ajitha.pusapati 14-Mar-11 10:00am View

i cont understand ur msg can u clarify plz

ajitha.pusapati 14-Mar-11 9:19am View

thanks for ur replay...
i will try at my Clint sys...

ajitha.pusapati 25-Feb-11 10:30am View

Thank u.i learn more things today.

ajitha.pusapati 25-Feb-11 10:15am View

its working...
i have to inherit into my code. thanks allot.
May i know what is type safe.
Why u using list instead of array list.

ajitha.pusapati 25-Feb-11 10:12am View

Thank u so much.

ajitha.pusapati 25-Feb-11 10:04am View

Thanks for ur replay but its not give derided out put.

ajitha.pusapati 25-Feb-11 9:49am View

S001
S002
S003 are sensors. that sensors doesnot have any childes. so i need like that and also evry Di node must have one or more sendores.

ajitha.pusapati 25-Feb-11 9:44am View

Deleted

S001
S002
S003 are sensors. that sensors doesnot have any childes. so i need like that

ajitha.pusapati 25-Feb-11 9:33am View

sorry..

ajitha.pusapati 25-Feb-11 9:28am View

try to make solution...
plz think my situation. i have just 7 months of exp and i dont have any guidance.
i have to develop this.

ajitha.pusapati 25-Feb-11 9:00am View

Deleted

thanks for ur reply.
in my in button click event i have to sent the above output.
in my tree view D9 have 3 childes. that childes does not have any childes.
i want last node Path which is having childes and i have to concatenate that node childes which is doesn't have any childes.

I have to send to an embedded device. they required like that bcz they have less memory. plz help me

ajitha.pusapati 24-Feb-11 5:07am View

this is my code this out put is
D1//D4//D5//D6
D1//D4//D5//D7
but my requirement is D1//D4//D5//D6//D7

ajitha.pusapati 24-Feb-11 5:05am View

private void button2_Click(object sender, EventArgs e)
{

ArrayList finalTVStrings = new ArrayList();

TreeNodeCollection nodes = tvAllData.Nodes;
for (int i = 0; i <= nodes.Count-1;i++)
{

// Select the root node
TreeNodeCollection Cnodes = tvAllData.Nodes[i].Nodes;
if (Cnodes.Count > 0)
{
//tvAllData.SelectedNode = Cnodes[0];
for (int j = 0; j <= Cnodes.Count - 1; j++)
{
TreeNodeCollection SCnodes = tvAllData.Nodes[i].Nodes[j].Nodes;
if (SCnodes.Count > 0)
{
for (int SC = 0; SC <= SCnodes.Count - 1; SC++)
{
TreeNodeCollection Sensornodes = tvAllData.Nodes[i].Nodes[j].Nodes[SC].Nodes;
if (Sensornodes.Count > 0)
{
for (int Sen = 0; Sen <= Sensornodes.Count - 1; Sen++)
{

tvAllData.SelectedNode = Sensornodes[Sen];
//MessageBox.Show(tvAllData.SelectedNode.FullPath, "Final");
MessageBox.Show(Sensornodes[Sen].Text, "Sensors");
finalTVStrings.Add(tvAllData.SelectedNode.FullPath);

}
}
else
{
tvAllData.SelectedNode = SCnodes[SC];
// MessageBox.Show(tvAllData.SelectedNode.FullPath);
MessageBox.Show(SCnodes[SC].Text, "SubChild");
finalTVStrings.Add(tvAllData.SelectedNode.FullPath);
}
}
}
else
{
tvAllData.SelectedNode = Cnodes[j];
// MessageBox.Show(tvAllData.SelectedNode.FullPath);
MessageBox.Show(Cnodes[j].Text, "SChild");
finalTVStrings.Add(tvAllData.SelectedNode.FullPath);
}
}
}
else
{
tvAllData.SelectedNode = nodes[i];
//MessageBox.Show(tvAllData.SelectedNode.FullPath);
MessageBox.Show(Cnodes[i].Text, "Child");
finalTVStrings.Add(tvAllData.SelectedNode.FullPath);
}

}

}

ajitha.pusapati 24-Feb-11 5:04am View

thanks for ur replay. i got the path upto last child node. this out put is not currect.
my desired out put is D1//D4//D5//D6//D7
D5 has two childs.

ajitha.pusapati 24-Feb-11 4:47am View

in c#.net windows forms

ajitha.pusapati 24-Feb-11 4:47am View

up to D6 i got the path. but my requirement is D5 has chils D6 and D7. and D6 and D7 does have childs.
that why...

ajitha.pusapati 28-Jan-11 6:17am View

thank u

ajitha.pusapati 4-Jan-11 1:49am View

thank u very much., same solution i found in msdn. its really helpful.

ajitha.pusapati 20-Nov-10 7:40am View

is there another way

ajitha.pusapati 20-Nov-10 7:40am View

i used gsmcommunication.dll

ajitha.pusapati 20-Nov-10 6:28am View

i alredy done with single msg.
now i want to send bulk sms.
i get the ans for this. thanks for ur reply

Comments by ajitha.pusapati (Top 46 by date)