public DataTable Load(string sql)
{
UtilLocalDB objSqlCeServerDAL = GetInstance(connString);
objSqlCeServerDAL.Open();
SqlCeDataAdapter dAd = new SqlCeDataAdapter(sql, objSqlCeServerDAL.objSqlCeConnection);
dAd.SelectCommand.CommandType = CommandType.Text;
DataSet dSet = new DataSet();
try
{
dAd.Fill(dSet, "Tabela");
return(dSet.Tables["Tabela"]);
}
catch
{
throw;
}
finally
{
dSet.Dispose();
dAd.Dispose();
objSqlCeServerDAL.Dispose();
}
}
public int Insert(string sql)
{
UtilLocalDB objSqlCeServerDAL = GetInstance(connString);
objSqlCeServerDAL.Open();
SqlCeCommand dCmd = new SqlCeCommand(sql, objSqlCeServerDAL.objSqlCeConnection);
dCmd.CommandType = CommandType.Text;
try
{
return(dCmd.ExecuteNonQuery());
}
catch
{
throw;
}
finally
{
dCmd.Dispose();
objSqlCeServerDAL.Dispose();
}
}