public void ShowStep(UserControl step)
{
ContainerPnl.Controls.Clear();
step.Dock = DockStyle.Fill;
ContainerPnl.Controls.Add(step);
}
using System.Data.SqlClient;
namespace EsfahanManager.database
{
public static class ContextDB
{
private static string connectionString = @"Server=.;Database=IsfahanTourDB;Trusted_Connection=True;";
public static SqlConnection GetConnection()
{
return new SqlConnection(connectionString);
}
}
}
using (SqlConnection conn = ContextDB.GetConnection())
{
string query = "SELECT * FROM Place";
SqlDataAdapter adapter = new SqlDataAdapter(query, conn);
DataTable dt = new DataTable();
conn.Open();
adapter.Fill(dt);
myDataGridView.DataSource = dt;
}
private void ResetOrderNumbers()
{
for (int i = 0; i < SelectedItems.Count; i++)
{
SelectedItems[i].VisitOrder = i + 1;
}
}
}
