Devart Forums

Code: Select all

            MySqlConnection conn = new MySqlConnection();
            try
            {
                conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["Main.ConnectionString"].ToString());
                conn.Open();
                MySqlCommand cmd = new MySqlCommand();
                cmd.CommandText = "select username, lastactivity from vB_user";
                cmd.Connection = conn;
                MySqlDataTable dt = new MySqlDataTable();
                MySqlDataAdapter da = new MySqlDataAdapter(cmd);
                da.Fill(dt);

                MySqlDataTable dt2 = new MySqlDataTable();
                dt2.Columns.Add("index");
                dt2.Columns.Add("username");
                dt2.Columns.Add("lastactivity");
                int count = 0;
                foreach (DataRow dr in dt.Rows)
                {
                    count++;
                    DataRow dr2;
                    dr2 = dt2.NewRow();
                    dr2[0] = count;
                    dr2["username"] = dr[0];
                    dr2["lastactivity"] = Utility.ConvertFromUnixTimestamp(Convert.ToDouble(dr[1]));
                    dt2.Rows.Add(dr2);
                }
                GridView1.DataSource = dt;
                GridView1.DataBind();
                Response.Write("Het is gelukt.");

            }
            catch (Exception ex)
            {
                Label1.Text  = ex.Message;
            }
            finally
            {
                conn.Close();
            }
        }

Code: Select all

	
	
		
		
	

	
		
		
			
				
				
				
			
		
		

		 section enables configuration 
            of the security authentication mode used by 
            ASP.NET to identify an incoming user. 
        -->
		 section enables configuration 
            of what to do if/when an unhandled error occurs 
            during the execution of a request. Specifically, 
            it enables developers to configure html error pages 
            to be displayed in place of a error stack trace.

        
            
            
        
        -->
	

Code: Select all

try{
...
}
catch (Exception ex){
      Label1.Text  = ex.StackTrace;
}
finally{
...
} 

Code: Select all

at System.Collections.Hashtable.Find (System.Object key) [0x00000] at System.Collections.Hashtable.Contains (System.Object key) [0x00000] at System.Data.Common.DataTableMappingCollection.Contains (System.String value) [0x00000] at (wrapper remoting-invoke-with-check) System.Data.Common.DataTableMappingCollection:Contains (string) at CoreLab.MySql.MySqlDataAdapter.a (System.Data.DataTable[] A_0, CoreLab.MySql.MySqlDataReader A_1, System.Data.DataSet A_2, System.String A_3, Int32 A_4, Int32 A_5) [0x00000] at CoreLab.MySql.MySqlDataAdapter.a (System.Data.DataTable[] A_0, IDataReader A_1, System.Data.DataSet A_2, System.String A_3, Int32 A_4, Int32 A_5) [0x00000] at CoreLab.MySql.MySqlDataAdapter.a (System.Data.DataTable A_0, IDataReader A_1, Boolean A_2) [0x00000] at CoreLab.MySql.MySqlDataAdapter.Fill (System.Data.DataTable table, IDataReader dataReader) [0x00000] at System.Data.Common.DbDataAdapter.Fill (System.Data.DataTable dataTable, IDbCommand command, CommandBehavior behavior) [0x00000] at System.Data.Common.DbDataAdapter.Fill (System.Data.DataTable dataTable) [0x00000] at (wrapper remoting-invoke-with-check) System.Data.Common.DbDataAdapter:Fill (System.Data.DataTable) at TestOnWebserver.Default.Page_Load (System.Object sender, System.EventArgs e) [0x00000] 

Code: Select all

  
            MySqlDataAdapter da = new MySqlDataAdapter();
            MySqlDataSet ds = new MySqlDataSet();            
            da.TableMappings.Add("MySQLServer_DEPT", "dept");            
            da.TableMappings.Add("MySQLServer_EMP", "emp");            
            da.Fill(ds);