I have a search button and datagrid in c#

hi all

I have a search button and datagrid in c#, I require perform a query in the database and load the data in me datagrid

the Question is, as can I load the data back my search datagrid

it is my code

conexion.ConnectionString = @"Data Source = SHINIL-PC040\SQLEXPRESS; Initial Catalog = produccion; Integrated Security = True";
if(TXTORDEN_PRODUCCION.Text == "" || TXTTURNO.Text == "" || TXTMAQUINAS.Text == "" || TXTHORAINICIO.Text == "" || TXTHORAFIN.Text == "")
{
MessageBox.Show("Te falta campo");
}
else
{
if (checkBox1.Checked == true)
{
try
{
comando.Connection = conexion;
conexion.Open();
string SqlAction = "select orden, turno, operador, horainicio, horafin, articulo, totalpiezasok, totalcajas, piezascondefecto, maquina from conteo2 where CONVERT(varchar(10), horafin, 108) >= @horainicio and CONVERT(varchar(10), horafin, 108)<= @horafin and orden = @orden and turno = @turno and maquina = @maquina ";
// "SELECT MOLDE, PROYECTO, ITEMPARTE, COLOR, SNP FROM PARTE WHERE ITEMPARTE = @ITEMPARTE";
SqlCommand cmd = new SqlCommand(SqlAction, conexion);
cmd.Parameters.AddWithValue("@orden", TXTORDEN_PRODUCCION.Text);
cmd.Parameters.AddWithValue("@turno", TXTTURNO.Text);
cmd.Parameters.AddWithValue("@maquina", TXTMAQUINAS.Text);
cmd.Parameters.AddWithValue("@horainicio", TXTHORAINICIO.Text);
cmd.Parameters.AddWithValue("@horafin", TXTHORAFIN.Text);
}
conexion.Close();
}
catch (Exception Ex)
{
MessageBox.Show(Ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
}
MessageBox.Show("selecciono ok produccion");
}
if (checkBox2.Checked == true)
{
MessageBox.Show("selecciono paros");
}
if (checkBox1.Checked == false & checkBox2.Checked == false)
{
MessageBox.Show("tiene que seleccionar un reporte");
}
}

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Tapan Patel10y ago
you can do like this...
yourdatagridview.DataSource=yourobjectofDataTable
0
Midhun Tp10y ago
Hi,

Please follow below articles-
http://www.c-sharpcorner.com/uploadfile/0c1bb2/searching-records-from-database-and-display-in-gridview-usin/
http://www.c-sharpcorner.com/uploadfile/cd7c2e/different-type-of-search-on-database-and-display-result-on-g/
0