Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. C#
  4. database conectivity in C#

database conectivity in C#

Scheduled Pinned Locked Moved C#
questioncsharpdatabasehelptutorial
5 Posts 5 Posters 1 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • M Offline
    M Offline
    MahaKh
    wrote on last edited by
    #1

    i m very new to C#...just started working in C#.... i need to make a database like attendence record of a departmemt employees, in which only outhorized users can update the records...i need to make login interface n then database view of records....how can i do it in C#? how to connect to the data base...ialready have made tables of employee n there attendence in Microsoft Access, now how to connect it into C# n use it? plzzzzzzzzzzzzzz help me out. thankx in advance....

    L B C N 4 Replies Last reply
    0
    • M MahaKh

      i m very new to C#...just started working in C#.... i need to make a database like attendence record of a departmemt employees, in which only outhorized users can update the records...i need to make login interface n then database view of records....how can i do it in C#? how to connect to the data base...ialready have made tables of employee n there attendence in Microsoft Access, now how to connect it into C# n use it? plzzzzzzzzzzzzzz help me out. thankx in advance....

      L Offline
      L Offline
      Lost User
      wrote on last edited by
      #2

      try http://en.kioskea.net/forum/affich-61898-how-to-make-database-connectivity-in-asp-net[^]

      Regards Aman Bhullar www.arlivesupport.com[^]

      1 Reply Last reply
      0
      • M MahaKh

        i m very new to C#...just started working in C#.... i need to make a database like attendence record of a departmemt employees, in which only outhorized users can update the records...i need to make login interface n then database view of records....how can i do it in C#? how to connect to the data base...ialready have made tables of employee n there attendence in Microsoft Access, now how to connect it into C# n use it? plzzzzzzzzzzzzzz help me out. thankx in advance....

        B Offline
        B Offline
        bilal haider 0
        wrote on last edited by
        #3

        This might help you: Simple Movie Database in C# using Microsoft Access[^] :)

        1 Reply Last reply
        0
        • M MahaKh

          i m very new to C#...just started working in C#.... i need to make a database like attendence record of a departmemt employees, in which only outhorized users can update the records...i need to make login interface n then database view of records....how can i do it in C#? how to connect to the data base...ialready have made tables of employee n there attendence in Microsoft Access, now how to connect it into C# n use it? plzzzzzzzzzzzzzz help me out. thankx in advance....

          C Offline
          C Offline
          CoderForEver
          wrote on last edited by
          #4

          Hey dude I might help u if u can work on SQL .............. Here is some

          using System.Data.SqlClient;

          public SqlConnection con = null;
          SqlDataAdapter da = new SqlDataAdapter();
          /* for the connection
          String conStr = @"Data Source=Database Path;" +
          "AttachDbFilename=" + input1 +
          ";Integrated Security=True;" +
          "Connect Timeout=30; User Instance=True";
          con = new SqlConnection(conStr);
          /* to update the database using stored procedure

          SqlCommand cmd = new SqlCommand();
          cmd.Connection = con;
          cmd.CommandType = CommandType.StoredProcedure;
          cmd.CommandText = "Procedure Name";
          cmd.Parameters.Add("@a", SqlDbType.VarChar).Value = "xxx";
          MessageBox.Show("Employee Removed", "Successfull",);

                      cmd.ExecuteScalar();
          

          If it is ok dig out more

          1 Reply Last reply
          0
          • M MahaKh

            i m very new to C#...just started working in C#.... i need to make a database like attendence record of a departmemt employees, in which only outhorized users can update the records...i need to make login interface n then database view of records....how can i do it in C#? how to connect to the data base...ialready have made tables of employee n there attendence in Microsoft Access, now how to connect it into C# n use it? plzzzzzzzzzzzzzz help me out. thankx in advance....

            N Offline
            N Offline
            nelsonpaixao
            wrote on last edited by
            #5

            what i advice you to do is to design your database scheme first of all turn off the computer, write everthing down before you hit the keyboard after you have your database scheme, take your time to build the database, i advice you to manage login in sql (create user table with id/user/pass and trigger a login store_procedure). go to c# only after database is donne - - - About the connection to the database in the previous post you see a way to do that You can find lots of stuff on google if you use key word like "c# database connection" but i advise you to download microsoft absolute beginners lessons videos, it´s free and you will understand it better in alternative download a project here in codeproject

            nelsonpaixao@yahoo.com.br trying to help & get help

            1 Reply Last reply
            0
            Reply
            • Reply as topic
            Log in to reply
            • Oldest to Newest
            • Newest to Oldest
            • Most Votes


            • Login

            • Don't have an account? Register

            • Login or register to search.
            • First post
              Last post
            0
            • Categories
            • Recent
            • Tags
            • Popular
            • World
            • Users
            • Groups