Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C#4.0 TSQL
Hello I'm developing project that will use online hosted database .
in my windows forms app , I have some kind of schedule maker which makes notes and schedules based on user . I want to provide login form in this application which will be passed by registered ones and then edit their own notes and information which will be also hosted on online server
 
I will need :
 
1 DB for usernames and passwords
and another for personal notes and info , I am not professional with SQL Server , but I will learn , so I need your plans and advices how to complete this part of the project , thanks in advance .
 
I want DB to be hosted on online server , and how my program will access it ? (also)
 
OP's additional content moved from non-solution below
as I know MVC needs Windows serverto be hosted , and in my country it's problem , but is it possible to host on free server ?

and also , user need to open browser to look and use my MVC app , needn't they ?

plus in MVC how can I improve design ? like webpage ?
Posted 24-Nov-12 6:54am
Edited 25-Nov-12 1:14am
Nelek60.4K
v3
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

I would suggest entity framework.
 
However, why use winforms? you could just as easily exapand the range and accessibility of the application, but simple using an MVC web app, coupled with Entity framework.
 
You could knock up something like this relatively easily using those technologies.
 
I would suggest you look at http://www.asp.net/mvc[^] and watch the pluralsight videos on the right of the page as well as go through the tutorials.
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 3

Hi as you are using windows application and you want to access DB which is hosted on Server
means if your want to Login then they should have internet connection which can access this account simply in app.config file you need to add DB connection with user name and Password credentials which will authorize user to access that DB from server. before that you need to check for Internet connection available at user machine or not then only he/she would be able to access DB. For Net Connection Check you can use below Code.
public static bool HasConnection()
{
    try
    {
        System.Net.IPHostEntry i = System.Net.Dns.GetHostEntry("www.google.com");
        return true;
    }
    catch
    {
        return false;
    }
} 
Add Db Connection in app Config like Below.
<connectionstrings>
    <add name="ApplicationServices" connectionstring="Data Source=;Initial Catalog=;Integrated Security=True;username=;password=;">
      providerName="System.Data.SqlClient"  />
  </add></connectionstrings>
  Permalink  
v2

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

  Print Answers RSS
0 OriginalGriff 7,903
1 Sergey Alexandrovich Kryukov 7,142
2 DamithSL 5,604
3 Manas Bhardwaj 4,986
4 Maciej Los 4,820


Advertise | Privacy | Mobile
Web03 | 2.8.1411023.1 | Last Updated 25 Nov 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

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