I would start out by modifying the SQL query to hard code values to see if you have an issue with your sql and parameters.
Hard code some values in your code and see if the record saves.
Hello
I have the following code
public class LoggedEvent : Microsoft.Practices.EnterpriseLibrary.Logging.LogEntry
{
}
this code is exposed over a WCF.
public void LogEvent(LoggedEvent loggedEvent)
{
el.LogWriter elw =...
if you are a local admin, then you should not need the admin password, but if you clicked "run as admin" and you are asked for the PW, then you may not be local admin.
It may be worth asking an admin to enter his credentials just to get it out.
UAC is user access control. Its new in Vista. when the UCA level (Set in control panel\users\user access control) is set high, allot of things will not work as expected. But if you run the application as administrator (right click on applications icon and select "run as administrator") you may...
are you using SQL Server Authentication or Windows Security only? I know you said you can connect with AD Admin's but are you trying sql authentication also? I wonder if there is an issue with UAC. Can you run this application as administrator and see if that has any impact?
Can you connect from that same win 7 machine to that same db with other applications, like Sql Server Management Studio? Take you application out of play.
if you do something like this
insert into table values
('John''s)
you would get John's
Since you are using input data you way need to write a wrapper that will replace any ' with ''
Does the user the code will execute under have write permissions to that share? Can you log on to the machine as the same user and run the same command manually to see if you get an output file?
You should be able to open it. What type of file are you trying to open? .cs? .sln? .csproj?
It may asked you to upgrade the project for VS 2005 to open it, but is should allow you to open it. (if so, just walk through the wizard)
RalphTrent
did you reference the MySql library in your project? If you are not using Visual Studio to create a project, is the library in the GAC (Global Assembly Cache) (%windir%\assembly)? Or somewhere in your site folder?
first you need to have getWzList return your data
public DataTable getWzList(int month, int year)
Then when you execute your query you need to store the data somewhere to return it
DataTable ldtResults = new DataTable();
SqlDataAdapter lSqlAdap = new SqlDataAdapter();
try
{...
If you are going to code for excel 2007 or greater, I would look at this open source project:
http://epplus.codeplex.com/
I use it all the time and its pretty simple. You may think its easier to convert a vb.net app to c# but in this case, I would implement this new library. With this library...
try this
DirectoryInfo di = new DirectoryInfo(@"C:\files");
string lstrSearchPattern = "prtx010.prtx010.0199.";
foreach (FileInfo fi in di.GetFiles(lstrSearchPattern+"*"))
{
string newName = fi.Name.Substring(lstrSearchPattern.Length, 6);
fi.MoveTo(newName);
}
di = null;
It sounds like what you want to do svchost.exe will do for you but I do not see an easy way to hook your dll onto svchost, but i did come across article that may help you.
http://social.msdn.microsoft.com/Forums/en-US/netfxbcl/thread/b38e755e-41d5-4dc3-a4ec-986d2a76209a/
Scroll to the bottom...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.