protected void Button1_Click(object sender, EventArgs e)
{
conn.Open();
MySqlCommand cmd = conn.CreateCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = "select * from serviceprovider";
cmd.ExecuteNonQuery();
DataTable dtt = new DataTable();
MySqlDataAdapter daa = new MySqlDataAdapter(cmd);
daa.Fill(dtt);
GridViews.DataSource = dtt;
GridViews.DataBind();
conn.Close();
}
/// <summary>
/// The SetUpBatteryColumns.
/// </summary>
private void SetUpBatteryColumns()
{
//create 10 ICollectionViews for the columns
//at first, put all elements in the first column
for (int i = 0; i < 10; i++)
{
ICollectionView tmpView = new AutoUpdatingCollectionView(BatteryGridItemSource);
if (i == 0)
{
tmpView.Filter = TrueFilter;
}
else
{
tmpView.Filter = FalseFilter;
}
tmpView.Refresh();
GridViews.Add(tmpView);
}
}
public MainWindow()
{
InitializeComponent();
List <object> myData = new List <object>()
{
new { Id = 1, Name = "John" },
new { Id = 2, Name = "Mary" },
new { Id = 3, Name = "Anna" },
};
GridViews.Add(new MyGrid {
Data = myData
});
GridViews.Add(new MyGrid {
Data = myData
});
GridViews.Add(new MyGrid {
Data = myData
});
DataContext = this;
}
private void BindGrid()
{
SqlConnection con = new SqlConnection(dbConnectionString);
SqlCommand cmd = new SqlCommand("Employees");
con.Open();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "spEmployeesProcedure";
cmd.Parameters.AddWithValue("@Action", "SELECT");
cmd.Parameters.AddWithValue("@Id", 509);
cmd.Parameters.AddWithValue("@User_name", "Nara");
cmd.Parameters.AddWithValue("@Department", "Hr");
cmd.Parameters.AddWithValue("@MngerId", 500);
SqlDataAdapter dataAdapter = new SqlDataAdapter();
cmd.Connection = con;
dataAdapter.SelectCommand = cmd;
DataSet dt = new DataSet();
dataAdapter.Fill(dt);
GridViews.DataSource = dt.Tables[0];
GridViews.DataBind();
}
