cycles to read lines in sql and c#

Question

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'

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 Srivastava · Answer

Hi , you can customize you report using tablix or matrix.

antonio sanchez · Answer

I have something this try { 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 { } which sends information like me want, just send me the same information on all labels

antonio sanchez · Answer

had something thought of as a switch by the BELPOS_ID

Bikesh Srivastava · Answer

Hi, You query is related to display of data or in query.???????????

Nirav Daraniya · Answer

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 Tp · Answer

Hi, Are you getting the given result into an dataset?