请教：数据库插入数据的问题
现在做的是Windows mobile 6.0 移动应用程序开发
[code=C#][/code]
private SqlCeConnection conn = null;
private SqlCeCommand sqlCom;
private SqlCeDataReader myReader;
//==========================================================================
//连接数据库：
public void PPCSQL()
{
string apppath = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().ManifestModule.FullyQualifiedName);//取得当前程序目录
apppath += "\\AppDatabase2.sdf";
try
{
conn = new SqlCeConnection("Data Source=" + apppath);
sqlCom = new SqlCeCommand();
sqlCom.Connection = conn;
// conn.Open();
// int nun = sqlCom.ExecuteNonQuery();
/*
if (nun >0)
{
MessageBox.Show("插入成功 ");
}*/
// conn.Close();
}
catch (Exception ex)
{
MessageBox.Show("PPCSQL()\r\n" + ex.Message);
}
}
//==========================================================================
//操作前先打开数据库：
public bool Open()
{
bool res = false;
try
{
if (conn.State == System.Data.ConnectionState.Broken)
{
conn.Close();
}
conn.Open();
res = conn.State == System.Data.ConnectionState.Open;
}
catch (Exception ex)
{
MessageBox.Show("Open()\r\n" + ex.Message);
conn.Close();
}
return res;
}
//==========================================================================
//插入新记录:
// public void insterOneItem(object_HaoMaObj Qi)
public void insterOneItem()
{
// string sql = "insert into shuju(menu_id,menu_name,c,d,e,f,u,a,b) values(" + Qi.Menu_id.ToString() + "," + Qi.Menu_name.ToString() + "," + Qi.C.ToString() + "," + Qi.D.ToString() + "," + Qi.E.ToString() + "," + Qi.F.ToString() + "," + Qi.U.ToString() + "," + Qi.A.ToString() + "," + Qi.B.ToString() + ")";
// string sql = "insert into shuju(menu_id,menu_name,c,d,e,f,u,a,b) values(@menu_id,@menuname,@c,@d,@e,@f,@u,@a,@b)";
string sql = "insert into shuju(menu_id,menu_name,c,d,e,f,u,a,b) values(" + 1 + "," + 1 + "," + 1 + "," + 1 + "," + 1 + "," + 1 + "," + 1 + "," + 1 + "," + 1 + ")";
try
{
sqlCom.CommandText = sql;
//sqlCom =new SqlCeCommand(sql ,conn );
//sqlCom.Connection = conn;
/*
sqlCom.Parameters.Add("@menu_id", SqlDbType.Int);
sqlCom.Parameters["@menu_id"].Value = Qi.Menu_id;
sqlCom.Parameters.Add("@menuname", SqlDbType.Int);
sqlCom.Parameters["@menuname"].Value = Qi.Menu_name; ;
sqlCom.Parameters.Add("@c", SqlDbType.Int);
sqlCom.Parameters["@c"].Value = Qi.C;
sqlCom.Parameters.Add("@d", SqlDbType.Int);
sqlCom.Parameters["@d"].Value = Qi.D;
sqlCom.Parameters.Add("@e", SqlDbType.Int);
sqlCom.Parameters["@e"].Value = Qi.E;
sqlCom.Parameters.Add("@f", SqlDbType.Int);
sqlCom.Parameters["@f"].Value = Qi.F;
sqlCom.Parameters.Add("@u", SqlDbType.Int);
sqlCom.Parameters["@u"].Value = Qi.U;
sqlCom.Parameters.Add("@a", SqlDbType.Int);
sqlCom.Parameters["@a"].Value = Qi.A;
sqlCom.Parameters.Add("@b", SqlDbType.Int);
sqlCom.Parameters["@b"].Value = Qi.B;*/
/*
sqlCom.Parameters.Add("@menu_id", SqlDbType.Int,4);
sqlCom.Parameters["@menu_id"].Value = 1;
sqlCom.Parameters.Add("@menuname", SqlDbType.Int,4);
sqlCom.Parameters["@menuname"].Value = 1; ;
sqlCom.Parameters.Add("@c", SqlDbType.Int,4);
sqlCom.Parameters["@c"].Value = 1;
sqlCom.Parameters.Add("@d", SqlDbType.Int,4);
sqlCom.Parameters["@d"].Value =1;
sqlCom.Parameters.Add("@e", SqlDbType.Int,4);
sqlCom.Parameters["@e"].Value = 1;
sqlCom.Parameters.Add("@f", SqlDbType.Int,4);
sqlCom.Parameters["@f"].Value = 1;
sqlCom.Parameters.Add("@u", SqlDbType.Int,4);
sqlCom.Parameters["@u"].Value = 1;
sqlCom.Parameters.Add("@a", SqlDbType.Int,4);
sqlCom.Parameters["@a"].Value = 1;
sqlCom.Parameters.Add("@b", SqlDbType.Int,4);
sqlCom.Parameters["@b"].Value = 1;*/
sqlCom.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show("insterOneItem()\r\n" + ex.Message);
}
}
// =====================================================================================
以上是代码，为什么插入数据时，没有报错但是没有插入数据，在插入数据的函数里，我试过三种办法，现在看的函数里其他方法被我屏掉了，我试了一天了，都没有结果，还有，我查看数据库是否成功插入数据是这样查看的，一种方法是运行程序后，没错了就停止调试，然后再在VS2005的数据源窗口中将我的数据库打开来查看数据库，还有一种就是我直接拖一个datagrid控件，将数据表拖放在控件里，在调试时直接在这个控件里看，现在的问题是不管我怎么，都没办法插入数据，请大家帮帮我！！！对了，我用的是SQL server 2005 mobile editor
[解决办法]
http://download.csdn.net/source/3009185
