Help! Why my code can not write string to MDB ?

[roopeman]

i need your help, my code as below :
//-----------------------------------------------------------------------
//Wrote by Michael April 30 2005
//-----------------------------------------------------------------------

using System.Text;
using System.Diagnost ics;
using System.Threadin g;
using System;
using System.Text.Reg ularExpressions ;
using System.Data.Ole Db;

public class LogInfo4
{
public static void Main(String[] args)
{

string log="System";
string machine="MyDC00 1";
EventLog aLog = new EventLog();
aLog.Log = log;
aLog.MachineNam e = machine;

Console.WriteLi ne("There are {0} entr[y|ies] in the log:",
aLog.Entries.Co unt);
//get string for print Message
foreach (EventLogEntry entry in aLog.Entries)
{

string strText = entry.Message;
string PrintDocNum,
PrintDocName,Pr intUser,PrintSe rverName,PrintB yte,PrintIp,Pri ntPages;
string strMatch = @"^Document (\d+), *(.+) owned by (.+) was printed on
(.*) via port IP_(\d{1,3}\.\d {1,3}\.\d{1,3}\ .\d{1,3})\. Size in bytes:
(\d+); pages printed: (\d+)";
Regex re = new Regex(strMatch) ;
Match m = re.Match(strTex t);
if(m.Success)
{
PrintDocNum = m.Groups[1].ToString();
PrintDocName = m.Groups[2].ToString();
PrintUser = m.Groups[3].ToString();
PrintServerName = m.Groups[4].ToString();
PrintIp = m.Groups[5].ToString();
PrintByte = m.Groups[6].ToString();
PrintPages = m.Groups[7].ToString();
OleDbConnection conn = new OleDbConnection ();
// TODO: Modify the connection string and include any
// additional required properties for database.
conn.Connection String = @"Provider=Micr osoft.Jet.OLEDB .4.0;" +
@"Data source= E:\April30\Db\T estDb.mdb" ;
conn.Open();
string sqlInsert=@"ins ert into
TestTable(DocNu m,DocName,User, ServerName,Byte ,Ip,Pages) values
(@PrintDocNum,@ PrintDocName,@P rintUser,@Print ServerName,@Pri ntByte,@PrintIp ,@PrintPages)";
OleDbCommand cmd1=new OleDbCommand(sq lInsert,conn);
cmd1.Parameters .Add("@PrintDoc Num",System.Dat a.OleDb.OleDbTy pe.VarChar,50,P rintDocNum);

cmd1.Parameters .Add("@PrintDoc Name",System.Da ta.OleDb.OleDbT ype.VarChar,50, PrintDocName);
cmd1.Parameters .Add("@PrintUse r",System.Data. OleDb.OleDbType .VarChar,50,Pri ntUser);
cmd1.Parameters .Add("@PrintSer verName",System .Data.OleDb.Ole DbType.VarChar, 50,PrintServerN ame);
cmd1.Parameters .Add("@PrintByt e",System.Data. OleDb.OleDbType .VarChar,50,Pri ntByte);
cmd1.Parameters .Add("@PrintIp" ,System.Data.Ol eDb.OleDbType.V arChar,50,Print Ip);
cmd1.Parameters .Add("@PrintPag es",System.Data .OleDb.OleDbTyp e.VarChar,50,Pr intPages);
//Console.WriteLi ne("Command Created");
cmd1.ExecuteNon Query();//insert string
//Console.WriteLi ne("insert end");
conn.Close();
}

}
}
}

[Ignacio Machin \( .NET/ C# MVP \)]

hi

where r u getting the error?

did you try to insert the same values directly in access?

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"roopeman" <ro******@discu ssions.microsof t.com> wrote in message
news:F7******** *************** ***********@mic rosoft.com...

i need your help, my code as below :
//-----------------------------------------------------------------------
//Wrote by Michael April 30 2005
//-----------------------------------------------------------------------

using System.Text;
using System.Diagnost ics;
using System.Threadin g;
using System;
using System.Text.Reg ularExpressions ;
using System.Data.Ole Db;

public class LogInfo4
{
public static void Main(String[] args)
{

string log="System";
string machine="MyDC00 1";
EventLog aLog = new EventLog();
aLog.Log = log;
aLog.MachineNam e = machine;

Console.WriteLi ne("There are {0} entr[y|ies] in the log:",
aLog.Entries.Co unt);
//get string for print Message
foreach (EventLogEntry entry in aLog.Entries)
{

string strText = entry.Message;
string PrintDocNum,
PrintDocName,Pr intUser,PrintSe rverName,PrintB yte,PrintIp,Pri ntPages;
string strMatch = @"^Document (\d+), *(.+) owned by (.+) was printed on
(.*) via port IP_(\d{1,3}\.\d {1,3}\.\d{1,3}\ .\d{1,3})\. Size in bytes:
(\d+); pages printed: (\d+)";
Regex re = new Regex(strMatch) ;
Match m = re.Match(strTex t);
if(m.Success)
{
PrintDocNum = m.Groups[1].ToString();
PrintDocName = m.Groups[2].ToString();
PrintUser = m.Groups[3].ToString();
PrintServerName = m.Groups[4].ToString();
PrintIp = m.Groups[5].ToString();
PrintByte = m.Groups[6].ToString();
PrintPages = m.Groups[7].ToString();
OleDbConnection conn = new OleDbConnection ();
// TODO: Modify the connection string and include any
// additional required properties for database.
conn.Connection String = @"Provider=Micr osoft.Jet.OLEDB .4.0;" +
@"Data source= E:\April30\Db\T estDb.mdb" ;
conn.Open();
string sqlInsert=@"ins ert into
TestTable(DocNu m,DocName,User, ServerName,Byte ,Ip,Pages) values
(@PrintDocNum,@ PrintDocName,@P rintUser,@Print ServerName,@Pri ntByte,@PrintIp ,@PrintPages)";
OleDbCommand cmd1=new OleDbCommand(sq lInsert,conn);
cmd1.Parameters .Add("@PrintDoc Num",System.Dat a.OleDb.OleDbTy pe.VarChar,50,P rintDocNum);

cmd1.Parameters .Add("@PrintDoc Name",System.Da ta.OleDb.OleDbT ype.VarChar,50, PrintDocName);
cmd1.Parameters .Add("@PrintUse r",System.Data. OleDb.OleDbType .VarChar,50,Pri ntUser);
cmd1.Parameters .Add("@PrintSer verName",System .Data.OleDb.Ole DbType.VarChar, 50,PrintServerN ame);
cmd1.Parameters .Add("@PrintByt e",System.Data. OleDb.OleDbType .VarChar,50,Pri ntByte);
cmd1.Parameters .Add("@PrintIp" ,System.Data.Ol eDb.OleDbType.V arChar,50,Print Ip);
cmd1.Parameters .Add("@PrintPag es",System.Data .OleDb.OleDbTyp e.VarChar,50,Pr intPages);
//Console.WriteLi ne("Command Created");
cmd1.ExecuteNon Query();//insert string
//Console.WriteLi ne("insert end");
conn.Close();
}

}
}
}

[roopeman]

Hi,Ignacio, it 's end at "send error to Microsoft or not" pop menu, i can
insert the same
values to Mdb manually.and i am beginner in C#,Would please take a carefully
check
at my code?

"Ignacio Machin ( .NET/ C# MVP )" wrote:

hi

where r u getting the error?

did you try to insert the same values directly in access?

cheers,

--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

"roopeman" <ro******@discu ssions.microsof t.com> wrote in message
news:F7******** *************** ***********@mic rosoft.com...

i need your help, my code as below :
//-----------------------------------------------------------------------
//Wrote by Michael April 30 2005
//-----------------------------------------------------------------------

using System.Text;
using System.Diagnost ics;
using System.Threadin g;
using System;
using System.Text.Reg ularExpressions ;
using System.Data.Ole Db;

public class LogInfo4
{
public static void Main(String[] args)
{

string log="System";
string machine="MyDC00 1";
EventLog aLog = new EventLog();
aLog.Log = log;
aLog.MachineNam e = machine;

Console.WriteLi ne("There are {0} entr[y|ies] in the log:",
aLog.Entries.Co unt);
//get string for print Message
foreach (EventLogEntry entry in aLog.Entries)
{

string strText = entry.Message;
string PrintDocNum,
PrintDocName,Pr intUser,PrintSe rverName,PrintB yte,PrintIp,Pri ntPages;
string strMatch = @"^Document (\d+), *(.+) owned by (.+) was printed on
(.*) via port IP_(\d{1,3}\.\d {1,3}\.\d{1,3}\ .\d{1,3})\. Size in bytes:
(\d+); pages printed: (\d+)";
Regex re = new Regex(strMatch) ;
Match m = re.Match(strTex t);
if(m.Success)
{
PrintDocNum = m.Groups[1].ToString();
PrintDocName = m.Groups[2].ToString();
PrintUser = m.Groups[3].ToString();
PrintServerName = m.Groups[4].ToString();
PrintIp = m.Groups[5].ToString();
PrintByte = m.Groups[6].ToString();
PrintPages = m.Groups[7].ToString();
OleDbConnection conn = new OleDbConnection ();
// TODO: Modify the connection string and include any
// additional required properties for database.
conn.Connection String = @"Provider=Micr osoft.Jet.OLEDB .4.0;" +
@"Data source= E:\April30\Db\T estDb.mdb" ;
conn.Open();
string sqlInsert=@"ins ert into
TestTable(DocNu m,DocName,User, ServerName,Byte ,Ip,Pages) values
(@PrintDocNum,@ PrintDocName,@P rintUser,@Print ServerName,@Pri ntByte,@PrintIp ,@PrintPages)";
OleDbCommand cmd1=new OleDbCommand(sq lInsert,conn);
cmd1.Parameters .Add("@PrintDoc Num",System.Dat a.OleDb.OleDbTy pe.VarChar,50,P rintDocNum);

cmd1.Parameters .Add("@PrintDoc Name",System.Da ta.OleDb.OleDbT ype.VarChar,50, PrintDocName);
cmd1.Parameters .Add("@PrintUse r",System.Data. OleDb.OleDbType .VarChar,50,Pri ntUser);
cmd1.Parameters .Add("@PrintSer verName",System .Data.OleDb.Ole DbType.VarChar, 50,PrintServerN ame);
cmd1.Parameters .Add("@PrintByt e",System.Data. OleDb.OleDbType .VarChar,50,Pri ntByte);
cmd1.Parameters .Add("@PrintIp" ,System.Data.Ol eDb.OleDbType.V arChar,50,Print Ip);
cmd1.Parameters .Add("@PrintPag es",System.Data .OleDb.OleDbTyp e.VarChar,50,Pr intPages);
//Console.WriteLi ne("Command Created");
cmd1.ExecuteNon Query();//insert string
//Console.WriteLi ne("insert end");
conn.Close();
}

}
}
}