Comments by Member 15212425 (Top 14 by date)

data retrieving
while(dataReader.Read())
{
data.Add(Convert.ToString(dataReader[0]));

}
updating and storing that data to another array
for (int i = 0; i < data.Count; i++)
{
string mo = data[i] + dt;
// data[i] += dt;
cmd.CommandText = "update students SET Progress = 'Printed', Name= '" + mo + "' where Name like '" + data[i] + "%' ";
data[i] += dt;
cmd.ExecuteNonQuery();
}
string mono = string.Join(";", data.ToArray());

I want to perform both task in a single loop .

yes that one will also get updated . when i'm doing Student like '" + i% + "' ";
itz not working . how to code % on that ??

check if condition true and popup messagebox only once . my program showing messagebox each time when data is adding from datareader to lstbox .
i am storing count of listbox to q and another in r . to check integer im converting to numbers. on each adding of elements ,its checking , after full adding i want to check if condition .
i am new in c# programming

but when im giving if condition inside the lopp, im no still gettng the desired solution . if list box count is 2 ,itz only showing one and if p=q , still messagebox working

I want to check if datareader[0] count is greater than rowcount..
when fetching distinct values only ,dr[0] doesnt have rowcount number of data

int rowcount = Convert.ToInt32(Settings.Default["outercode"]);
string query2 = string.Format($" select Distinct top({ rowcount}) OuterCode,OuterCode_Result,MasterCode,PalletCode from BatchDetails Where OuterCode_Result = 1 and " +
" MasterCode IS NULL and PalletCode IS NULL");
using (SqlCommand sqlCommand = new SqlCommand(query2, sqlConn3))
{
sqlCommand.Parameters.AddWithValue("@OuterCode_Result", 1);
sqlCommand.Parameters.AddWithValue("@MasterCode", "NULL");
sqlCommand.Parameters.AddWithValue("@PalletCode", "NULL");
//sqlCommand.Parameters.Add(textBox2.Text,SqlDbType.Int);

SqlDataReader sqlDataReader1 = sqlCommand.ExecuteReader();

var dataReader = sqlDataReader1;

while (dataReader.Read())
{
if (datareader[0].count >= rowcount ){
listBox1.Items.Add(dataReader[0]);}
}

Thank you sir .when im doing this . i got it . but top itmes are same data . what if i need to take single data . if data is like 2,3,3,4,4,5,5,6 .. i want to take data as 2,3,4,5 so on .
i dont want duplication in my listbox

I tried many methods ..this is one ..
in sql they are showing this method ..thatz why i tried.
can u plz help me

Im not getting desired answer

the limit is user input data stored in app.config. respective to that number , i want to display data to listbox .