下面的代码老是有, "Parameter @Doc has no default value "错误, 请问要怎么解决?//-----------------------------------------------------------------------
//Wrote by Michael April 30 2005
//-----------------------------------------------------------------------using System.Text;
using System.Diagnostics;
using System.Threading;
using System;
using System.Text.RegularExpressions;
using System.Data.OleDb;public class LogTest
{
public static void Main(String[] args)
{string log="Application";
string machine=".";
EventLog aLog = new EventLog();
aLog.Log = log;
aLog.MachineName = machine;Console.WriteLine("There are {0} entr[y|ies] in the log:",
aLog.Entries.Count);foreach (EventLogEntry entry in aLog.Entries)
{string strText = entry.Message;
//Console.WriteLine(strText);OleDbConnection conn = new OleDbConnection();
// TODO: Modify the connection string and include any
// additional required properties for database.
conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" +
@"Data source= c:\test\TestDb2.mdb" ;string sqlInsert=@"insert into TestTable(Doc) values (@Doc)";
OleDbCommand cmd1=new OleDbCommand(sqlInsert,conn);
cmd1.Parameters.Add("@Doc",System.Data.OleDb.OleDbType.VarChar,100,strText);
try
{
conn.Open();
cmd1.ExecuteNonQuery();
}
catch(Exception ex)
{
Console.WriteLine(ex.Message.ToString());
}
finally
{
conn.Close();
}}
}
}
//Wrote by Michael April 30 2005
//-----------------------------------------------------------------------using System.Text;
using System.Diagnostics;
using System.Threading;
using System;
using System.Text.RegularExpressions;
using System.Data.OleDb;public class LogTest
{
public static void Main(String[] args)
{string log="Application";
string machine=".";
EventLog aLog = new EventLog();
aLog.Log = log;
aLog.MachineName = machine;Console.WriteLine("There are {0} entr[y|ies] in the log:",
aLog.Entries.Count);foreach (EventLogEntry entry in aLog.Entries)
{string strText = entry.Message;
//Console.WriteLine(strText);OleDbConnection conn = new OleDbConnection();
// TODO: Modify the connection string and include any
// additional required properties for database.
conn.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;" +
@"Data source= c:\test\TestDb2.mdb" ;string sqlInsert=@"insert into TestTable(Doc) values (@Doc)";
OleDbCommand cmd1=new OleDbCommand(sqlInsert,conn);
cmd1.Parameters.Add("@Doc",System.Data.OleDb.OleDbType.VarChar,100,strText);
try
{
conn.Open();
cmd1.ExecuteNonQuery();
}
catch(Exception ex)
{
Console.WriteLine(ex.Message.ToString());
}
finally
{
conn.Close();
}}
}
}
OleDbCommand cmd1=new OleDbCommand(sqlInsert,conn);
OleDbParameter parm1=new OleDbParameter("@Doc",System.Data.OleDb.OleDbType.VarChar,100);
parm1.Value=strText;
No value given for one or more required parameter