protected void BIndDataBusq()
{
DataTable DtB = new DataTable();
Cnx.SelecBD();
using (SqlConnection sqlConB = new SqlConnection(Cnx.GetConex()))
{
if (!TxtBusqMon.Text.Trim().Equals("") && !TxtBusqAno.Text.Trim().Equals("") && !TxtBusqMes.Text.Trim().Equals(""))
{
sqlConB.Open();
using (SqlCommand SC = new SqlCommand("EXEC SP_Pantalla_Moneda 3, @Mnd, @Yr, @Mn,'','',0,0,0,@ICC,'01-01-1','01-01-1'", sqlConB))
{
SC.Parameters.AddWithValue("@Mnd", TxtBusqMon.Text.Trim());
SC.Parameters.AddWithValue("@Yr", TxtBusqAno.Text.Trim());
SC.Parameters.AddWithValue("@Mn", TxtBusqMes.Text.Trim());
SC.Parameters.AddWithValue("@ICC", Session["!dC!@"]);
SqlDataAdapter DAB = new SqlDataAdapter(SC);
DAB.SelectCommand = SC;
DAB.Fill(DtB);
if (DtB.Rows.Count > 0)
{
GrdDatosH.DataSource = DtB; GrdDatosH.DataBind();
}
else
{
DtB.Rows.Add(DtB.NewRow());
GrdDatosH.DataSource = DtB;
GrdDatosH.DataBind();
GrdDatosH.Rows[0].Cells.Clear();
GrdDatosH.Rows[0].Cells.Add(new TableCell());
DataRow[] Result = Idioma.Select("Objeto= 'SinRegistros'");
foreach (DataRow row in Result)
{
GrdDatosH.Rows[0].Cells[0].Text = row["Texto"].ToString();
}
GrdDatosH.Rows[0].Cells[0].HorizontalAlign = HorizontalAlign.Center;
}
}
}
}
}
protected void IbtCloseHist_Click(object sender, ImageClickEventArgs e)
{
TxtBusqMon.Text = ""; TxtBusqAno.Text = ""; TxtBusqMes.Text = "";
GrdDatosH.DataSource = null; GrdDatosH.DataBind(); MultVw.ActiveViewIndex = 0;
}
