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;
}
}
string sql = @"INSERT INTO Customers
(Name,NationalCode,Phone)
VALUES
(@name,@code,@phone)";
SqlCommand cmd = new SqlCommand(sql, con);
cmd.Parameters.AddWithValue("@name", txtName.Text);
cmd.Parameters.AddWithValue("@code", txtCode.Text);
cmd.Parameters.AddWithValue("@phone", txtPhone.Text);
cmd.ExecuteNonQuery();
string sql="DELETE FROM Customers WHERE Id=@id";
SqlCommand cmd=new SqlCommand(sql,con);
cmd.Parameters.AddWithValue("@id",id);
cmd.ExecuteNonQuery();
using ClosedXML.Excel;
XLWorkbook wb =
new XLWorkbook("Customers.xlsx");
IXLWorksheet ws =
wb.Worksheet(1);
foreach(var row in ws.RowsUsed().Skip(1))
{
string name =
row.Cell(1).GetString();
string phone =
row.Cell(2).GetString();
}
SqlCommand cmd = new SqlCommand(
@"INSERT INTO Customers
(Name,Phone)
VALUES(@n,@p)", con);
cmd.Parameters.AddWithValue("@n", name);
cmd.Parameters.AddWithValue("@p", phone);
cmd.ExecuteNonQuery();
string sql=
@"SELECT *
FROM Users
WHERE Username=@u
AND Password=@p";
SqlCommand cmd=
new SqlCommand(sql,con);
cmd.Parameters.AddWithValue("@u",txtUser.Text);
cmd.Parameters.AddWithValue("@p",txtPass.Text);
SqlDataReader dr=cmd.ExecuteReader();
if(dr.Read())
{
MessageBox.Show("ورود موفق");
}
else
{
MessageBox.Show("اطلاعات اشتباه");
}
}