hello all
I have a search button where I have the following query
select A.BELNR_ID,A.BELPOS_ID,A.ItemCode,A.ItemName,A.MENGE,B.SalPackUn,B.PicturName from BEAS_FTPOS A
Inner Join OITM B on A.ItemCode = B.ItemCode
where A.BELNR_ID = '@ORDENDEPRODUCCION'
Inner Join OITM B on A.ItemCode = B.ItemCode
where A.BELNR_ID = '@ORDENDEPRODUCCION'
which requires loading a label with information from my office.
but sometimes my production order me back several lines of data
| BELNR_ID | BELPOS_ID | ItemCode | ItemName | MENGE |
| 10290 | 10 | 809133SA3B-A | LH POCKET BACK COVER FR PG05 | 100 |
| 10290 | 20 | 809123SA3B-A | RH POCKET BACK COVER FR PG05 | 100 |
| 10290 | 30 | 829123SA3B-A | RH POCKET BACK COVER RR PG05 | 100 |
| 10290 | 40 | 829133SA3B-A | LH POCKET BACK COVER RR PG05 | 100 |
I have 4 rows of labels, my question is how I can do or take to cycle when pressing seek me send this information to the labels that I have separately
EXAMPLE:
| label 1 | 809133SA3B-A | LH POCKET BACK COVER FR PG05 | 100 |
| label 2 | 809123SA3B-A | RH POCKET BACK COVER FR PG05 | 100 |
| label 3 | 829123SA3B-A | RH POCKET BACK COVER RR PG05 | 100 |
| label 4 | 829133SA3B-A | LH POCKET BACK COVER RR PG05 | 100 |
Bikesh SrivastavaPosted Sep 20, 2016, 2:56 AM
antonio sanchezPosted Sep 19, 2016, 4:59 PM
{
comando.Connection = conexion;
conexion.Open();
string SqlAction = "select A.BELNR_ID,A.BELPOS_ID,A.ItemCode,A.ItemName,A.MENGE,B.SalPackUn from BEAS_FTPOS A Inner Join OITM B on A.ItemCode = B.ItemCode WHERE BELNR_ID = @BELNR_ID ";
// "SELECT MOLDE, PROYECTO, ITEMPARTE, COLOR, SNP FROM PARTE WHERE ITEMPARTE = @ITEMPARTE";
SqlCommand cmd = new SqlCommand(SqlAction, conexion);
cmd.Parameters.AddWithValue("@BELNR_ID", TXTORDEN_PRODUCCION.Text);
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read()) ;
{
while (dr.Read())
{
groupBox2.Text = Convert.ToString(dr["ItemName"]);
TXTOR1.Text = Convert.ToString(dr["MENGE"]);
SNP1.Text = Convert.ToString(dr["SalPackUn"]);
}
// groupBox2.Text = Convert.ToString(dr["ItemName"]);
// TXTOR1.Text = Convert.ToString(dr["MENGE"]);
// SNP1.Text = Convert.ToString(dr["SalPackUn"]);
// TXTNUMERODEPARTE.Text = Convert.ToString(dr["ITEMPARTE"]);
// TXTSNP.Text = Convert.ToString(dr["SNP"]);
dr.Close();
}
}
finally
{
}
antonio sanchezPosted Sep 19, 2016, 11:12 AM
Bikesh SrivastavaPosted Sep 16, 2016, 3:38 AM
Nirav DaraniyaPosted Sep 16, 2016, 12:29 AM
Hello Antonio,foreach (DataTable table in dataSet.Tables){foreach (DataRow row in table.Rows){foreach (DataColumn column in table.Columns){object item = row[column]; // read column and item}}}
Midhun TpPosted Sep 15, 2016, 9:07 PM