Error message when compiling SQL and C# project

[Duck]

Hey recently I have begun with my SQL and C# project. I have a table that have a row called "log" and a table also called as "log". I then try and make it so that when I press a button with the name of the log should get a message box with history. Below you can see the code and error message. Someone who knows. please help me to get it to work?

private void logToolStripMenuItem_Click (object sender, EventArgs e) 
{ 
string transID; 
datatable_log = new Bluetooth_Sender_v._1._4.data_blue.logDataTable(); 
datatable_log = dataadapter_log.GetDataBy(transID); 
if (datatable_log.Rows.Count == 0) 
{ 
MessageBox.Show ("The Log is empty"); 
} 
else 
{ 
string log_alert; 
foreach (DataRow row in datatable_log.Rows) 
{ 
log_alert = row ["log"]. ToString (); 
} 
MessageBox.Show (log_alert); 
} 
}

Error Message:

Error CS0165: Use of unassigned local variable 'transID'
Error CS0165: Use of unassigned local variable 'log_alert'

[Lemog]

"use of unassigned local variable" error message clearly indicates that you are using variables that has not been assigned any value. In your case, the compiler is unable to find any values for "transID" and "log_alert" variables.

[Duck]

All right thanks but whatever it does not work either. So if someone could help me with this then it would be great.

[Ashok.M]

I think the following will work. It is probably also appropriate to add the line breaks after each line of the log that is added to logMsg.

Good luck

private void logToolStripMenuItem_Click (object sender, EventArgs e) 
{
// Declare variables 
String transId = String.Empty; // Transaction Id that we want to show 
String logMsg = String.Empty; // Message 
datatable_log = new Bluetooth_Sender_v._1._4.data_blue.logDataTable ();

// Retrieve data 
/* 
* This assumes that 'dataadapter_log' is instansiert in class 'logToolStripMenuItem_Click' 
* Are in, and that it has a valid connection string. 
*/ 
datatable_log = dataadapter_log.GetDataBy (transId); 

// Processes and view data 
if (datatable_log.Count == 0) 
{
logMsg = "The log is empty."; 
}
else 
{
foreach (DataRow row in datatable_log.Rows)
{ 
if (row ["log"]! = null) 
logMsg += (String) row ["log"]; 
}
}
MessageBox.Show (logMsg); 
}