Hello All...i m really grate full to c such a website where developers try to help people like us who face problems in s/w develepment...I am shobhit Gupta...23 years of age prusuing B.Tech in I.T. Engg. Final Year from Kurukshetra University, Kurukshetra. Recently, i have been working on a project which is to be implemented in a hospital for real life use...Its a s/w for hospital management which, basically, will be used for record keeping and reports generating... Records will containg info about patients and various tests conducted on them... i have made this s/w in C#.NET and tht a windows application..not a web application.....its almost complete....bt the final stage is the major problem for me...i dnt know how to run this project on network.....here is wat the customer i.e. hospital owner wants :-
A CENTRALIZED DATABASE....i.e. the .exe file of the s/w will be copied on clients and server but the Database will be present only in the main server and the clients must retrieve and save data directly fron and in the server.....i.e. transanctions shuld b made b/w client-server...but i wil b using the same application on client as well as on server...no seperate applications...
i am a new developer and its my first project so, i will request you to please help me in details bcause i may not be having adequate knowledge...please help me...please...
i tried to run in a simpler way...i shared the directory of the server in which .exe file is present...then i accessed that folder on client and created a shortcut of the .exe file so that being accessed from client,...the main works shul be done on server...but, its got failed.....it is not able to acces the data from the database.....here is the lisst of errors that i got.....ERROR LIST BEGINS
Expand|Select|Wrap|Line Numbers
- See the end of this message for details on invoking
- just-in-time (JIT) debugging instead of this dialog box.
- ************** Exception Text **************
- System.Security.SecurityException: Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
- at System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet)
- at System.Security.PermissionSet.Demand()
- at System.Data.Common.DbConnectionOptions.DemandPermission()
- at System.Data.SqlClient.SqlConnection.PermissionDemand()
- at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection)
- at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
- at System.Data.SqlClient.SqlConnection.Open()
- at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
- at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
- at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
- at Hospital_Management.opddisplay.button1_Click(Object sender, EventArgs e)
- at System.Windows.Forms.Control.OnClick(EventArgs e)
- at System.Windows.Forms.Button.OnClick(EventArgs e)
- at System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
- at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
- at System.Windows.Forms.Control.WndProc(Message& m)
- at System.Windows.Forms.ButtonBase.WndProc(Message& m)
- at System.Windows.Forms.Button.WndProc(Message& m)
- at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
- at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
- at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
- The action that failed was:
- Demand
- The type of the first permission that failed was:
- System.Data.SqlClient.SqlClientPermission
- The Zone of the assembly that failed was:
- Internet
- ************** Loaded Assemblies **************
- mscorlib
- Assembly Version: 2.0.0.0
- Win32 Version: 2.0.50727.42 (RTM.050727-4200)
- CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
- ----------------------------------------
- Hospital Management
- Assembly Version: 1.0.3239.24658
- Win32 Version: 1.0.3239.24658
- CodeBase: file://192.168.0.1/New%20Folder/Hospital%20Management.exe
- ----------------------------------------
- System.Windows.Forms
- Assembly Version: 2.0.0.0
- Win32 Version: 2.0.50727.42 (RTM.050727-4200)
- CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
- ----------------------------------------
- System
- Assembly Version: 2.0.0.0
- Win32 Version: 2.0.50727.42 (RTM.050727-4200)
- CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
- ----------------------------------------
- System.Drawing
- Assembly Version: 2.0.0.0
- Win32 Version: 2.0.50727.42 (RTM.050727-4200)
- CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
- ----------------------------------------
- System.Data
- Assembly Version: 2.0.0.0
- Win32 Version: 2.0.50727.42 (RTM.050727-4200)
- CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
- ----------------------------------------
- System.Xml
- Assembly Version: 2.0.0.0
- Win32 Version: 2.0.50727.42 (RTM.050727-4200)
- CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
- ----------------------------------------
- System.Configuration
- Assembly Version: 2.0.0.0
- Win32 Version: 2.0.50727.42 (RTM.050727-4200)
- CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
- ----------------------------------------
- ************** JIT Debugging **************
- To enable just-in-time (JIT) debugging, the .config file for this
- application or computer (machine.config) must have the
- jitDebugging value set in the system.windows.forms section.
- The application must also be compiled with debugging
- enabled.
- For example:
- <configuration>
- <system.windows.forms jitDebugging="true" />
- </configuration>
- When JIT debugging is enabled, any unhandled exception
- will be sent to the JIT debugger registered on the computer
- rather than be handled by this dialog box.
com.ConnectionString = "user id = sa; password = sa; database = hosital_manag";
Please show me a way to run ma project on netwrok