Comments by bilawal121

bilawal121 13-Mar-12 4:24am View

oops but problem is not this sir

bilawal121 13-Mar-12 4:21am View

next page is open in same tab not seperate tab, ok i agree with you but tell me how to share session between two web applications through Stateserver

bilawal121 27-Feb-12 1:50am View

SELECT YEAR (DATE_RECIEVING) As [Yearnumber],
SUM( case current_status when 'Open' then 1 else 0 end ) as 'Open',
SUM( case current_status when 'Close' then 1 else 0 end ) as 'Closed',
SUM( case current_status when 'Pending' then 1 else 0 end ) as 'Pending',
SUM( case current_status when 'In Progress' then 1 else 0 end ) as 'InProgress',
SUM(1) as 'Total' from FileRegister group by YEAR(date_recieving)

this give me the result for one year like 2012 but i want as i mentioned

bilawal121 23-Feb-12 0:47am View

in my table named FileRegister there are 5 fields id,fileno,title,currentstatus and daterecieving.
when user input 2012 year the report only show the data for those which in datereceiving.

bilawal121 22-Feb-12 1:08am View

Thanks for your reply and it works for me but now how i show this on my report design??
i name each colum of report design open,close,pending and inprogress and in field column i write experession that give me error,
i write this expression
=Fields!CURRENT_STATUS.Value="Open"
=Fields!CURRENT_STATUS.Value="Closed"
=Fields!CURRENT_STATUS.Value="Pending"
=Fields!CURRENT_STATUS.Value="inprogress"

bilawal121 18-Jan-12 6:22am View

thanks for reply, i know how to get data from multiple tables but my question was how to get column values dynamically,mean at run time the column values i want only that particular columns should be displayed

bilawal121 18-Jan-12 6:21am View

thanks for reply, i know how to get data from multiple tables but my question was how to get column values dynamically,mean at run time the column values i want only that particular columns should be displayed

bilawal121 18-Jan-12 6:21am View

thanks for reply, i know how to get data from multiple tables but my question was how to get column values dynamically,mean at run time the column values i want only that particular columns should be displayed

bilawal121 21-Oct-11 8:22am View

Sir I have no knowlegde about xml, i am doing this task on Windows Form C#

bilawal121 21-Oct-11 6:27am View

Thanks alot sir

bilawal121 21-Oct-11 6:26am View

Thanku sir, this helps me alot :)

bilawal121 20-Oct-11 8:36am View

System.Windows.Forms.TreeNode' does not contain a definition for 'Add'

bilawal121 20-Oct-11 8:33am View

it only adds the node
like this
0
1
2
5

bilawal121 20-Oct-11 8:20am View

It gives an error of "Property or indexer 'System.Windows.Forms.TreeNode.Parent' cannot be assigned to -- it is read only

how i remove this?????

bilawal121 20-Oct-11 7:08am View

Sir i have completed my task aproximately half,
i get all the ParentId against the MenuId i have enter,
like i enter MenuID=87 it gives me all the ParentId's like 0,1,23 .
sir kindly tell me the treeview of that ParentID's
like this
0
1
23
0 should be parent of 1,and 1 should be parent of 23.

bilawal121 20-Oct-11 7:03am View

Sir i have completed my task aproximately half,
i get all the ParentId against the MenuId i have enter,
like i enter MenuID=87 it gives me all the ParentId's like 0,1,23 .
sir kindly tell me the treeview of that ParentID's
like this
0
1
23
0 should be parent of 1,and 1 should be parent of 23.

bilawal121 20-Oct-11 4:47am View

Yes sir we store parentID in ascending order,leave 0 is parent of zero.
i want to make Treeview of ParentID

bilawal121 19-Oct-11 7:36am View

no sir i want to make treeview of ParentID like this
0
1
23
o parent of 1, and 1 parent of 23.

bilawal121 19-Oct-11 6:23am View

kindly tell me the solution through coding

bilawal121 19-Oct-11 6:23am View

My Form APplication contains Button,TextBox,Treeview and a Table that contains
columns MenuID,FormName,Assembly,Caption,ParentID,OrderNo,Deleted.
Here are some sql queries,
<pre>
select * from tblMenu where menuid=87
select * from tblMenu where menuid=23
select * from tblMenu where menuid=1
select * from tblMenu where menuid=0
</pre>

Results:
<pre>
MenuID ParentID

87 23
23 1
1 0
0 0
</pre>

Look at query result, MenuID 87 have ParentID 23, then MenuID 23 have parentID1, then MenuID 1 have parentID 0.
when i write any MenuID in textbox then it shows the all the ParentID, like in above question when i write 87 in the
textbox it make the treeview of all ParentID 0,1,23.

Hope now you can better understand my question.
kindly help me that how that is possible through coding,

Please help me, thanks.

bilawal121 19-Oct-11 6:22am View

My Form APplication contains Button,TextBox,Treeview and a Table that contains
columns MenuID,FormName,Assembly,Caption,ParentID,OrderNo,Deleted.
Here are some sql queries,
<pre>
select * from tblMenu where menuid=87
select * from tblMenu where menuid=23
select * from tblMenu where menuid=1
select * from tblMenu where menuid=0
</pre>

Results:
<pre>
MenuID ParentID

87 23
23 1
1 0
0 0
</pre>

Look at query result, MenuID 87 have ParentID 23, then MenuID 23 have parentID1, then MenuID 1 have parentID 0.
when i write any MenuID in textbox then it shows the all the ParentID, like in above question when i write 87 in the
textbox it make the treeview of all ParentID 0,1,23.

Hope now you can better understand my question.
kindly help me that how that is possible through coding,

Please help me, thanks.

Comments by bilawal121 (Top 21 by date)