c# database Access 2000

Daniel Morais

The code is
I have a small probleme with this code
When i click on on a post title that is set in a listbox from de database
it only bring me to the last written post
is there a way in c# to manage this so i can read read the post
that go's with the title clicked.

 

private void 
lb_SelectedIndexChanged(object sender, EventArgs e)

{ 

Myconnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0; Password=; Data 
Source=" + File_Name);

Myconnection.Open();

OleDbCommand cmd = 
Myconnection.CreateCommand();

cmd.CommandText = "SELECT * FROM POST";

OleDbDataAdapter dta = new 
OleDbDataAdapter(cmd.CommandText, 
Myconnection);

dta = new OleDbDataAdapter(cmd); 

DataSet dts = new DataSet("POST");

dta.Fill(dts, "POST");

foreach (DataRow row 
in dts.Tables["POST"].Rows)

{

TitleBox.Text = row[1, DataRowVersion.Current].ToString();

rtf.Rtf = row[2, DataRowVersion.Current].ToString();

} 

Myconnection.Close();

lb.Visible = false;

}

Tank-you

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Santhosh N16y ago
Accepted answer
Consider to have a string builder and apend all the posts in the loop and assign that to the titlebox after the loop..
StringBuilder sb = new StringBuilder();
foreach (DataRow row in dts.Tables["POST"].Rows)
{
sb.Append(row[1, DataRowVersion.Current].ToString();
rtf.Rtf = row[2, DataRowVersion.Current].ToString());
sb.Append("\n"); //check here for differrent combinations depending on if you want a new line
}
TitleBox.Text = sb.ToString();
Myconnection.Close();
lb.Visible = false;
}
Daniel Morais16y ago
tank you for this int i will try it soon