Click here to Skip to main content
14,667,814 members
Rate this:
Please Sign up or sign in to vote.
See more:
Hai Friends,
I am developing school management project with windows applicaiton.school contain many branches that is controlled by specified admin.All admin uses same applicaiton to manipulating all datas. what is my doubt is how can i differentiate the particular data information for particular admin even they are using same application for entering data.
For example
two branches: admin
1.chennai-2 xxxxx
2.chennai-2 yyyyy

Admin xxxx and yyyy enter the student details in student registration form .In a situation that when xxxx want to see the student details for only chenniai-1 branch.How can we show data only branch(chennai-1) to his id.
Posted
Updated 22-Jul-12 8:13am
v2
Comments
Sandeep Mewara 22-Jul-12 14:07pm
   
Ok, just one question out of curiosity, based on what you say, its a Winform app but shared across schools.. so only reason for your problem statement could be sharing one single database from all apps. Is so? Or everyone have their own local DB? Or it's a website?
baskaran chellasamy 22-Jul-12 14:21pm
   
admin pages are only in winform and this data should be available for student,parent and teachers as a report page of web application project.i am still confuse how can i set database available for local windows application and also to web application .please clear this doubt. is it possible to centeralize database for all branches(windows application) and web applicaiton (report pages)?.
Sandeep Mewara 22-Jul-12 14:29pm
   
is it possible to centeralize database for all branches(windows application) and web applicaiton (report pages)?
Why not? All you need is a database server hosting a database and then just use correct 'connection string' from your apps. You would need internet connection to connect to it.
[no name] 22-Jul-12 14:32pm
   
Yes of course you can. As long as your database server is publicly available and your client application can access it through the network.

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

what is my doubt is how can i differentiate the particular data information for particular admin even they are using same application for entering data.
Add one more column in your database on who (which admin) inserted a particular record. This will track every insertion and based on this field you can get data just related to one.
   
Comments
baskaran chellasamy 22-Jul-12 14:35pm
   
I am very thankful for this reasonable reply.As i am a fresher i want to study about this through some article.please help me
Sandeep Mewara 22-Jul-12 14:43pm
   
Already shared what needs/can be done.
baskaran chellasamy 22-Jul-12 14:50pm
   
sorry for this silly question.how can search it by keyword
Sandeep Mewara 23-Jul-12 1:53am
   
What keyword?

You need to add 'AdminId' to your records table. You must be having 1 admin or so per school. Every particular school entry will have defined AdminID. In search, use this as a filter criteria.
baskaran chellasamy 23-Jul-12 3:31am
   
thanks. keyword means how to find related example articles

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100