Employee Data Application

This application is a Employee Data Application built using ASP.NET and SQL Server. Here's a guide to configure and run the application.

Database Configuration

1. Open SQL Server Management Studio (SSMS)
2. Create a new database named DataPribadi
3. Execute the following SQL script to create the table:

CREATE TABLE Biodata ( 
    NIK NUMERIC NOT NULL PRIMARY KEY,
    NamaLengkap TEXT NOT NULL,
    JenisKelamin VARCHAR(1) NOT NULL,
    TanggalLahir DATE,
    Alamat TEXT,
    Negara VARCHAR(50)
);

Column descriptions:

• NIK: National Identity Number
• NamaLengkap: Full Name
• JenisKelamin: Gender
• TanggalLahir: Date of Birth
• Alamat: Address
• Negara: Country

Connection String Configuration

1. Open appsettings.json
2. Adjust the connection string according to your SQL Server configuration:

{
  "ConnectionStrings": {
    "DefaultConnection": "Server=YOUR_SERVER;Database=DataPribadi;Trusted_Connection=True;MultipleActiveResultSets=true;TrustServerCertificate=True;Connect Timeout=60;Pooling=false;"
  }
}

Replace YOUR_SERVER with your SQL Server name. In this example, it uses DESKTOP-C5VJL4V\\SQLEXPRESS.

Connection String Parameters Explained:

• Server: SQL Server instance name
• Database: Target database name
• Trusted_Connection: Uses Windows Authentication
• MultipleActiveResultSets: Enables multiple active result sets
• TrustServerCertificate: Bypasses certificate validation
• Connect Timeout: Connection timeout in seconds
• Pooling: Connection pooling settings

Running the Application

1. Open the solution in Visual Studio
2. Ensure all NuGet packages are installed
3. Build the solution
4. Run the application by pressing F5 or clicking the Start button

Troubleshooting

If you encounter database connection issues:

1. Verify SQL Server is running
2. Check server name and database name in the connection string
3. Ensure your Windows user has database access
4. Check firewall settings if using a remote server

Biodata Table Structure

Column	Data Type	Description
NIK	NUMERIC	Primary Key
NamaLengkap	TEXT	Full name (Required)
JenisKelamin	VARCHAR(1)	Gender (Required)
TanggalLahir	DATE	Date of birth (Optional)
Alamat	TEXT	Address (Optional)
Negara	VARCHAR(50)	Country (Optional)

Development Notes

• The application uses Windows Authentication for database connection
• Make sure to have appropriate permissions in SQL Server
• Table names and columns are in Indonesian language as per original requirements
• Gender (JenisKelamin) is stored as a single character

Support

If you encounter any issues or need assistance:

1. Check the troubleshooting section
2. Verify your development environment meets the system requirements
3. Ensure all configuration settings are correct