[Mono-list] POSGRESQL / NPGSQL / MONO / DATASET

[KiOrKY]

ggrrrrrrrr,,,,,
kiorky@doldit100:~/npg$ mcs select_mono.cs -r:System.Data -r:Npgsql
select_mono.cs(38) error CS0103: The name `LogLevel.Debug' could not be found in `ado.generique.requete.select.adapterposgresql2.Appli'
Compilation failed: 1 error(s), 0 warnings
kiorky@doldit100:~/npg$ 

help ;)
the code is
/*
 * mpasquet le 21/04/2004 a 14h30
 * 
 *  premier programme d'acces aux donnees
 * 
 **/

namespace ado
{
	namespace generique
	{
			namespace requete
			{
				namespace select
				{
					namespace adapterposgresql2
					{	
						/**     INCLUDES NECCESSAIRES  **/
						using System;
						using ado.generique; // acces generique
						using System.Data;					
					
						/**              ALIAS        **/
						using cout=System.Console;
						/** DEBUT CODE **/
						class Appli	
						{
							public static void Main(string[] args)
							{
								cout.WriteLine("-----------------------------------------\n");
								cout.WriteLine(" Salut   ----> DEBUT  requete_select_adapter)\n");
								cout.WriteLine("         attente touche ...\n");
								cout.WriteLine("-----------------------------------------\n");									
								/****/
								try
								{		
									// Enable logging.
									Npgsql.NpgsqlEventLog.Level = LogLevel.Debug;
									Npgsql.NpgsqlEventLog.LogName = "NpgsqlTests.LogFile";
									//modOutils mnoutil = new modOutils();//System.IO.File.Copy(mnoutil.renvoipathfichiercfg(),@"ADO.exe.config",true);
									string srequet =@"delete from popo;";
									srequet+=@"insert into popo(sssss,xdsd)";
									srequet+=@"values('59','aaaaa');";
									srequet+=@"insert into popo(sssss,xdsd)";
									srequet+=@"values('519','aaaaa');";
									srequet+=@"insert into popo(sssss,xdsd)";
									srequet+=@"values('529','aaaaa');";
									srequet+=@"insert into popo(sssss,xdsd)";
									srequet+=@"values('359','aaaaa');";
									srequet+=@"insert into popo(sssss,xdsd)";
									srequet+=@"values('459','aaaaa');";	
									srequet+=@"SELECT *  FROM popo";								
									string scnxtring=@"Server=126.10.0.1;Port=5432;User Id=Pasquet;Database=";
									scnxtring+=@"Marrot;Password=kiorky";
									Npgsql.NpgsqlConnection toto = new Npgsql.NpgsqlConnection(scnxtring);
									Npgsql.NpgsqlCommand cmd = new Npgsql.NpgsqlCommand(srequet,toto);
									Npgsql.NpgsqlDataAdapter DaAd = new Npgsql.NpgsqlDataAdapter(cmd);									
									DataSet Dsdset = new DataSet();							
									DaAd.Fill(Dsdset);
									Dsdset.AcceptChanges();									
									DataTableCollection dtccol = Dsdset.Tables;
									foreach(DataTable dtta in dtccol)
									{
										
										cout.WriteLine( dtta.TableName);
										foreach(DataRow drro in dtta.Rows)
										{
											cout.WriteLine("c1: {0} <-> c2: {1} <-> \n",(Int32)drro.ItemArray[0],drro.ItemArray[1]);				
										}
									}
									toto.Close();	
								}
								catch(System.Exception e)
								{
									cout.WriteLine("Exception  levée: "+ e.Message);
								}
								/****/
								cout.WriteLine("-----------------------------------------\n");
								cout.WriteLine(" Bye   ----> FIN  requete_select_adapter\n");
								cout.WriteLine("         attente touche ...\n");
								cout.WriteLine("-----------------------------------------\n");		
								cout.ReadLine();
							}
						}// fin classe APPLI
					}
				}
		
		}
	}
}


Francisco Figueiredo Jr. <fxjrlists@yahoo.com.br> a écrit :

> KiOrKY wrote:
> 
> &gt;In fact dont help, the goal is to migrate entirely an windows application
> into mono environnment and the base opf this application is to
> &gt;dataadpter.fill(dataset)
> &gt;
> &gt;in anyway, i have tested datareader which work fine !
> &gt;
> &gt;just a litlle precision :)
> &gt;
> &gt;mono is a dream, its the last error i have at the moment !
> &gt;
> &gt;all the classses we need at enterprise are working well !
> &gt;
> &gt;  
> &gt;
> 
> Hi Kiorky!
> 
> Wow! Very nice to know you are heading you development environment to Mono!
> 
> I hope I can help you in this last error you are getting! :)
> 
> While I'm setting up my devel environment, could you try add the 
> following lines and send me (can be in private) the log you get?
> 
> Thanks in advance.
> 
> // Enable logging.
> NpgsqlEventLog.Level = LogLevel.Debug;
> NpgsqlEventLog.LogName = &quot;NpgsqlTests.LogFile&quot;;
> 
> 
> Regards,
> 
> Francisco Figueiredo Jr.

-- 
----------------------------
    I{ i () r |{ Y
    Debian User
---------------------------------------------
-- Mathieu PASQUET     
-- Testeur Debian SID
-- irc: #debian-fr / irc.freenode.net port: 6667 
-- Site: www.fr.debian.org 
---------------------------------------------