DEV Community: Ibrahim Dabwan Al Mekhlafi

How to connect DataBase SQL in windows Form How to connect DataBase SQL in windows Form

Ibrahim Dabwan Al Mekhlafi — Thu, 27 Aug 2026 15:52:39 +0000

Create file .cs
`
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;
using System.Data;
using System.Windows.Forms;

namespace PharmachyManagementSystem
{
class function
{
protected SqlConnection getConnection()
{
SqlConnection con = new SqlConnection();
con.ConnectionString = "Server=ServerName;database=DataBaseName; integrated security = True";
return con;

        }

    public DataSet getData(String query)
    {
        SqlConnection con = getConnection();
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = con;
        cmd.CommandText = query;
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        DataSet ds = new DataSet();
        da.Fill(ds);
        return ds;

    }

    public void setData(String query, string msg)
    {
        SqlConnection con = getConnection();
        SqlCommand cmd = new SqlCommand();
        cmd.Connection= con;
        con.Open();
        cmd.CommandText= query;
        cmd.ExecuteNonQuery();
        con.Close();
        MessageBox.Show(msg, "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);

    }
}

}
`
End .

CinemaCineGlide — A Cinema Management System

Ibrahim Dabwan Al Mekhlafi — Wed, 26 Aug 2026 20:46:58 +0000

I recently worked on CinemaCineGlide, a cinema management system built to make movie booking and cinema management easier and more organized.

What does it do?

The system provides features for managing movies, cinemas, bookings, and customers in one place.

The main goal was to build a practical project while improving my skills in software development, database design, and building real-world applications.

What I learned

While working on this project, I gained more experience with:

Designing a database structure
Building application logic
Managing user and booking data
Creating a simple and usable interface
Organizing a complete software project

This project also helped me understand how different parts of an application work together as one system.

What's next?

I’m planning to keep improving the project and add more features over time.

You can check out the project on GitHub:

https://github.com/IBR4NX/CinemaCineGlide

Feedback and suggestions are welcome.

Next.js

Ibrahim Dabwan Al Mekhlafi — Wed, 18 Feb 2026 01:19:15 +0000