Code:
DataSet dsSearch = m_objSearchSms.SearchSmsMessage(Program.IDKorisnika, dtpKeyDate.Value);
foreach (DataRowView rowVW in dsSearch.Tables[0].DefaultView)
{
string smsText = rowVW.Row[0].ToString();
string date = rowVW.Row[1].ToString();
string line = "-----------------------------------------------------------------------------------------------";
long deleteId = (long)rowVW.Row[3];
smsNumber += 1;
string sms = string.Format("\nSMS No: {0}, on date: {1}, ECode: ({4})\n{2}\n{3}\n{2}",
smsNumber, date, line, smsText, deleteId);
this.txtOldSms.Text += sms;
}
smsNumber = 0;
DataSet dsSearch = m_objSearchSms.SearchSmsMessage(Program.IDKorisnika, dtpKeyDate.Value);
foreach (DataRowView rowVW in dsSearch.Tables[0].DefaultView)
{
string smsText = rowVW.Row[0].ToString();
string date = rowVW.Row[1].ToString();
string line = "-----------------------------------------------------------------------------------------------";
long deleteId = (long)rowVW.Row[3];
smsNumber += 1;
string sms = string.Format("\nSMS No: {0}, on date: {1}, ECode: ({4})\n{2}\n{3}\n{2}",
smsNumber, date, line, smsText, deleteId);
this.txtOldSms.Text += sms;
}
smsNumber = 0;
Imam stored proceduru koja preko ovog ID-a i datuma pronadje sve poruke i u MS SQL to lepo radi, ali iz VS sve lepo radi do foreach petlje, gde u stvari ne uradi nista nego preskoci celu petlju, ne znam zasto to radi, kada samo treba da ispise podatke iz preuzete tabele?!