database conectivity in C#
-
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....
-
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....
try http://en.kioskea.net/forum/affich-61898-how-to-make-database-connectivity-in-asp-net[^]
Regards Aman Bhullar www.arlivesupport.com[^]
-
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....
This might help you: Simple Movie Database in C# using Microsoft Access[^] :)
-
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....
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 procedureSqlCommand 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
-
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....
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