dataGridView1.Rows.Add(prodcod.Text, articulo.Text, talla.Text, manga.Text, unidad.Text, cantidad.Text, preciou.Text, subtotal.Text, descuento.Text, total.Text);

SqlConnection cn = new SqlConnection(@"Data Source=10.1.1.1novtosa; user=usr; password=Nov; Initial Catalog=menu;");
            cn.Open();
            SqlCommand cmd = new SqlCommand("SELECT PRODCOD, ARTICULO, MANGA, TALLA, UNIDAD, CANTIDAD, PRECIOUNIT, SUBTOTAL, PORCEN_DESCUENTO, TOTAL, NUM_REMISION from borradorlineas where NUM_REMISION like @idd", cn);
            cmd.Parameters.AddWithValue("@idd", Convert.ToString(Buscarborrador.Borradorseleccionado.Numremision));
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataTable dt = new DataTable();
            da.Fill(dt);
            dataGridView1.Columns[0].DataPropertyName = "PRODCOD";
            dataGridView1.Columns[1].DataPropertyName = "ARTICULO";
            dataGridView1.Columns[2].DataPropertyName = "MANGA";
            dataGridView1.Columns[3].DataPropertyName = "TALLA";
            dataGridView1.Columns[4].DataPropertyName = "UNIDAD";
            dataGridView1.Columns[5].DataPropertyName = "CANTIDAD";
            dataGridView1.Columns[6].DataPropertyName = "PRECIOUNIT";
            dataGridView1.Columns[7].DataPropertyName = "SUBTOTAL";
            dataGridView1.Columns[8].DataPropertyName = "PORCEN_DESCUENTO";
            dataGridView1.Columns[9].DataPropertyName = "TOTAL";
            dataGridView1.AutoGenerateColumns = false;
            dataGridView1.DataSource = dt;
            cn.Close();