public string Showdata(showdata showdataform)
{
String strSQL;
MySqlConnection conn = GetConnection();
MySqlCommand objCmd = new MySqlCommand();
strSQL = "SELECT a.title,a.timeimage,b.username,b.id FROM savecs1 a Inner Join student b ON a.studentid=b.id";
conn.Open();
objCmd.Connection = conn;
objCmd.CommandText = strSQL;
objCmd.CommandType = CommandType.Text;
//MySqlDataReader reader = objCmd.ExecuteReader();
objCmd.ExecuteReader();
try
{
objCmd.ExecuteNonQuery();
}
catch (Exception e)
{
throw e;
}
return(null);
}
//------------------//
/*public void Addformteacher(Addfromteacher result)
* {
*
* String strSQL;
* MySqlConnection conn = GetConnection();
* MySqlCommand objCmd = new MySqlCommand();
*
* strSQL = "INSERT INTO `Sendform`(`Name`,`Form`) VALUES" +
* " ('" + result.name + "','" + result.form + "'); ";
*
* conn.Open();
* objCmd.Connection = conn;
* objCmd.CommandText = strSQL;
* objCmd.CommandType = CommandType.Text;
*
* try
* {
* objCmd.ExecuteNonQuery();
*
* }
* catch (Exception e)
* {
*
* throw e;
* }
*
* conn.Close();
*
* }*/
public void Addcommemt(showdata result)
{
String strSQL;
MySqlConnection conn = GetConnection();
MySqlCommand objCmd = new MySqlCommand();
strSQL = "INSERT INTO `student` VALUES" + " ('" + result.comment + "''); ";
conn.Open();
objCmd.Connection = conn;
objCmd.CommandText = strSQL;
objCmd.CommandType = CommandType.Text;
try
{
objCmd.ExecuteNonQuery();
}
catch (Exception e)
{
throw e;
}
conn.Close();
}