Skip to content

Instantly share code, notes, and snippets.

View programmmerr's full-sized avatar

Spiros programmmerr

View GitHub Profile
@programmmerr
programmmerr / select.cs
Created October 23, 2025 07:45
SELECT – Ανάγνωση δεδομένων #sql #c_sharp
//Όταν περιμένεις πολλές γραμμές:
List<Product> products = new List<Product>();
using (SqlConnection conn = new SqlConnection(connectionString))
{
string query = @"SELECT ProductId, Name, Price FROM Products WHERE Category = @Category";
using (SqlCommand cmd = new SqlCommand(query, conn))
{
cmd.Parameters.AddWithValue("@Category", categoryName);
conn.Open();
@programmmerr
programmmerr / controls.cs
Last active October 22, 2025 10:15
Clear All controls on a form #c_sharp #sql #devexpress
private void ClearAllControls()
{
// Local recursive function to clear controls
void ClearCollection(Control.ControlCollection controls)
{
foreach (Control ctrl in controls)
{
// Specific DevExpress controls
if (ctrl is DevExpress.XtraEditors.ComboBoxEdit combo)
{
@programmmerr
programmmerr / combobox.cs
Last active October 22, 2025 09:54
Add items list on Devexpress Combobox from SQL table #sql #devexpress #combobox
using System.Data;
using System.Data.SqlClient;
using DevExpress.XtraEditors;
// connection string
string connectionString = @"Server=.\SQLEXPRESS;Database=MyDatabase;Trusted_Connection=True;";
private void LoadComboBox()
{
using (SqlConnection conn = new SqlConnection(connectionString))