When I view my web page there's no error that prompts and I can even click my delete button, but when I open my Excel sheet the data is still there. I need your suggestion.
public void delete_Click(Object Src, EventArgs E)
{
string connectionString;
connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
@"Data Source=C:\Documents and Settings\ojt04\My Documents\mySit\payroll\database\profile... +
"Extended Properties=Excel 8.0;";
OleDbConnection connA = new OleDbConnection(connectionString);
connA.Open();
OleDbCommand command1 = new OleDbCommand("DELETE FROM [profilesheet$](FirstName) WHERE IDNo=txtid.Text",connA);
connA.Close();
txtid.Text="";
txtfname.Text="";
txtlname.Text="";
txtmname.Text="";
txtadd.Text="";
txtbday.Text="";
txtcontact.Text="";
txtposition.Text="";
txtdept.Text="";
}
Error deleting record on Excel using C# code, under Microsoft Expression Web. Please Help. Here is my code:?
This isn't right:
"DELETE FROM [profilesheet$](FirstName) WHERE IDNo=txtid.Text"
It should be
"DELETE FROM [profilesheet$](FirstName) WHERE IDNo=" + txtid.Text
That was the first problem I saw anyway.
Reply:Are you deleting each cell at a time ??? that's the only you can change a excel spreadsheet
Saturday, May 22, 2010
Error deleting record on Excel using C# code, under Microsoft Expression Web. Please Help. Here is my code:?
When I view my web page there's no error that prompts and I can even click my delete button, but when I open my Excel sheet the data is still there. I need your suggestion.
public void delete_Click(Object Src, EventArgs E)
{
string connectionString;
connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
@"Data Source=C:\Documents and Settings\ojt04\My Documents\mySit\payroll\database\profile... +
"Extended Properties=Excel 8.0;";
OleDbConnection connA = new OleDbConnection(connectionString);
connA.Open();
OleDbCommand command1 = new OleDbCommand("DELETE FROM [profilesheet$](FirstName) WHERE IDNo=txtid.Text",connA);
connA.Close();
txtid.Text="";
txtfname.Text="";
txtlname.Text="";
txtmname.Text="";
txtadd.Text="";
txtbday.Text="";
txtcontact.Text="";
txtposition.Text="";
txtdept.Text="";
}
Error deleting record on Excel using C# code, under Microsoft Expression Web. Please Help. Here is my code:?
You don't seem to be getting any help so I will just ask if you know whether the statement
connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
@"Data Source=C:\Documents and Settings\ojt04\My Documents\mySit\payroll\database\profile... +
"Extended Properties=Excel 8.0;";
needs a continuation character at the end of the second line and perhaps and end quote before it and an opening quote the start line 3?
If I am wrong, just give this answer a thumbs down and I will remove it to increase (however slightly) your chances that someone else will provide and answer.
public void delete_Click(Object Src, EventArgs E)
{
string connectionString;
connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
@"Data Source=C:\Documents and Settings\ojt04\My Documents\mySit\payroll\database\profile... +
"Extended Properties=Excel 8.0;";
OleDbConnection connA = new OleDbConnection(connectionString);
connA.Open();
OleDbCommand command1 = new OleDbCommand("DELETE FROM [profilesheet$](FirstName) WHERE IDNo=txtid.Text",connA);
connA.Close();
txtid.Text="";
txtfname.Text="";
txtlname.Text="";
txtmname.Text="";
txtadd.Text="";
txtbday.Text="";
txtcontact.Text="";
txtposition.Text="";
txtdept.Text="";
}
Error deleting record on Excel using C# code, under Microsoft Expression Web. Please Help. Here is my code:?
You don't seem to be getting any help so I will just ask if you know whether the statement
connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" +
@"Data Source=C:\Documents and Settings\ojt04\My Documents\mySit\payroll\database\profile... +
"Extended Properties=Excel 8.0;";
needs a continuation character at the end of the second line and perhaps and end quote before it and an opening quote the start line 3?
If I am wrong, just give this answer a thumbs down and I will remove it to increase (however slightly) your chances that someone else will provide and answer.
How can i Fix my c-media hardware? help pls.?
i accidentally delete my c-media. pls pls help.
How can i Fix my c-media hardware? help pls.?
You could download your drivers at http://www.cmedia.com.tw/?q=en/driver and install it again. Or if you still have your driver CD you could just install it from there. They usually include the driver CD when you buy your PC.
Reply:I guess the hardware must be a sound device since C-Media makes sound devices
First u need to know what integrated sound chip you have by tell me what mainboard model you have then go and download drivers from their website
U can also try going to Windows Update website to find hardware drivers if you are lucky you may just find it
How can i Fix my c-media hardware? help pls.?
You could download your drivers at http://www.cmedia.com.tw/?q=en/driver and install it again. Or if you still have your driver CD you could just install it from there. They usually include the driver CD when you buy your PC.
Reply:I guess the hardware must be a sound device since C-Media makes sound devices
First u need to know what integrated sound chip you have by tell me what mainboard model you have then go and download drivers from their website
U can also try going to Windows Update website to find hardware drivers if you are lucky you may just find it
Windows XP installed on d:\(fat32 logic drive) Win98 on c:\ ;Want WinXp on c:\?
I have my windows XP on d:\.(logical drive) . I don't want to for mat and install fresh windows again. How can I change the drve letter d: to c:\ to have c:\windowsXp .
If I delete my c:\ partition with partition magic I may not be able to boot windows XP because the c:\ contain the boot manager information.
What can I do ?
Windows XP installed on d:\(fat32 logic drive) Win98 on c:\ ;Want WinXp on c:\?
generally you cannot swap the drives after the installation. your OS may get corrupt. so better to reinstall.
If I delete my c:\ partition with partition magic I may not be able to boot windows XP because the c:\ contain the boot manager information.
What can I do ?
Windows XP installed on d:\(fat32 logic drive) Win98 on c:\ ;Want WinXp on c:\?
generally you cannot swap the drives after the installation. your OS may get corrupt. so better to reinstall.
The C Drive on my computer is full. I keep deleting things, but it still says full. Help?
I have deleted a least 30GB of stuff and whe i update it, the screen shows i've done nothing. The computer still runs at the same speed.....slow. I have tried going through the C Drive and directly deleting things, and sometimes it lets me or an error saying i need permission pop's up.I've gone through the performance info i my control pannel and doing disk clean up, also deleting things, again..nothing. My computer says I have 6-7 GB left, and I need about 40 to be free. I have tried everything I can think of. I need a computer genius. Please help me if you can.
The C Drive on my computer is full. I keep deleting things, but it still says full. Help?
You should try deleting more stuff....If it doesn't work try reinstalling windows then only install what you half to...or go buy a bigger hard drive
Reply:I'm assuming you use Windows. Sometimes when you uninstall programs through "add or remove programs" (or "programs and features" if you have Vista), some files get left behind. If I were you, I would go searching the Program Files folder on the C drive and delete any trialware or files from programs you already uninstalled. If you have any problems deleting files, or if you get any errors, try deleting them in safe mode. Be careful not to delete any necessary files! I would also create a restore point before you begin...just in case. If it's speed you're worried about, try defragging the system (Start | All Programs | Accessories | System Tools | Disk Defragmenter). Or, make sure there are not a lot of files in the startup folder of the Start Menu. This can also slow down your PC. If your internet is slow and you use Internet Explorer, try removing any toolbars you added on.
In response to Jason H's answer, here's a link to a great program that will scan for and delete any temporary files on your PC. I highly recommend it:
http://www.download.com/Advanced-Disk-Cl...
If this doesn't work, you can do it manually, like Jason H mentioned above.
If you have any questions, respond, and I may be able to answer them.
Reply:Just a hunch here but try turning off the pc, opening the case and re-seating all of your cables one at a time. especially the ide cables. Pull each one out then re-plug them. This may just fix your problem. If not, start trying to transfer your important files to a back-up source such as another hard drive and do it soon cause this may be an indication of a near future hd failure. I hope this helps. J
Reply:log ogg of your current username and log back on with user name administrator. if it requires a password try administrator. Then run a search for C:/temp or *.tmp and delete all of them. defrag. and you shuld have cleared some space.
Reply:Disable restore, and then reboot and reenable it
The C Drive on my computer is full. I keep deleting things, but it still says full. Help?
You should try deleting more stuff....If it doesn't work try reinstalling windows then only install what you half to...or go buy a bigger hard drive
Reply:I'm assuming you use Windows. Sometimes when you uninstall programs through "add or remove programs" (or "programs and features" if you have Vista), some files get left behind. If I were you, I would go searching the Program Files folder on the C drive and delete any trialware or files from programs you already uninstalled. If you have any problems deleting files, or if you get any errors, try deleting them in safe mode. Be careful not to delete any necessary files! I would also create a restore point before you begin...just in case. If it's speed you're worried about, try defragging the system (Start | All Programs | Accessories | System Tools | Disk Defragmenter). Or, make sure there are not a lot of files in the startup folder of the Start Menu. This can also slow down your PC. If your internet is slow and you use Internet Explorer, try removing any toolbars you added on.
In response to Jason H's answer, here's a link to a great program that will scan for and delete any temporary files on your PC. I highly recommend it:
http://www.download.com/Advanced-Disk-Cl...
If this doesn't work, you can do it manually, like Jason H mentioned above.
If you have any questions, respond, and I may be able to answer them.
Reply:Just a hunch here but try turning off the pc, opening the case and re-seating all of your cables one at a time. especially the ide cables. Pull each one out then re-plug them. This may just fix your problem. If not, start trying to transfer your important files to a back-up source such as another hard drive and do it soon cause this may be an indication of a near future hd failure. I hope this helps. J
Reply:log ogg of your current username and log back on with user name administrator. if it requires a password try administrator. Then run a search for C:/temp or *.tmp and delete all of them. defrag. and you shuld have cleared some space.
Reply:Disable restore, and then reboot and reenable it
I have a little pop-up box that says it is deleting files from my C drive?
The little box comes up once in awhile and is running a little green bar and says Deleting files from C drive.It looks scary to me,I always click the cancle button,which is the only option.What could it be deleting?
I have a little pop-up box that says it is deleting files from my C drive?
I agree with Dusty. Seems like a trojan, or at least spyware.
All of his download suggestions are good. I would recommend a visit to PC Pitstop first, though. If it's a trojan, it may interfere with downloading, so an online scan like PC Pitstop would be an alternative. It will also give you a good idea of your machine's performance, along with processes running (a good clue to virii and spyware), and a relative comparison with other computers similarly equipped.
The other suggestion about "Hijack This" is also good. This program will give you detailed information about all processes running, including those that may be hidden from the Task Manager. Please avail yourself of the experienced community of Hijack This users so you don't end up deleting something by mistake that is essential to your computer's operation.
Sites listed below are PCPitstop, Download.com (HijackThis page), Spybot S%26amp;D, and Merijn.org (excellent anti-spyware resource.
Good luck!
Reply:You're very welcome. I hope all your issues were resolved. Report It
Reply:You can try to do a System Restore to a previous date (to before you downloaded a virus from somewhere). If that doesn't work, you will probably have to try System Recovery. If that doesn't work, you will have to have your hard drive reformatted by a specialist. Good Luck. P. S. You might want to get a good anti-virus program.
Reply:Sounds like a Trojan. Run a GOOD scan like AVG and you should be able to remove it. You can get AVG from GRIsoft.
You should also be running ZoneAlarm as a (best for home PC) fire wall. Then, If you don't have them, go get Ad-aware, Spybot search and destroy, Spywareblaster, and last but not least, get a "Hosts" file. These are all free for home use and can be down-loaded from most any public domain site such as ZD net, download.com etc.
Reply:go to download.com and get a free pop up stopper.
or go to
http://www.panicware.com/popupcenter.htm...
I have it and it is great and free.
I think that will solve your pop up silly stuff.
:-)
Reply:You have a virus. DOwnload hijackthis (the most recent version), and then go seek help in online forums. They can help u remove the virus/malware.
Reply:I think it's time to run an Anti-virus tool. If this doesn't work, do a "system recovery". Don't forget to make back ups of your stuff first!:) Good Luck.
Reply:I agree, spyware. Download anti-spyware beta from Microsoft, also AVG virus protection or even Norton or McAfee. If problems persist the worse case scenario is you'll have to reinstall the operating system to wipe that out.
Reply:It's more than likely a virus. Chek your C: Drive to see if anything is missing. It could actually be deleting files, or it's just a little annoying thing to make you worry.
Reply:Catch hold of a spyware and get it removed.
Reply:There is a windows utility called disk cleanup, which may be what you are experiencing. It does not delete any important files, it merely cleans up crap from your hard drive.
If that is what pops up, youve no need to worry.
If its not that, it might be something sinister, ie, a virus or adware
Reply:Well windows automatically compress and delete un neccessary files..such as temp, cache files and stuff like that..you need not to worry..your files are safe...unless u delete them ur self
Reply:it may be spyware, go to www.download.com and search for ad-aware
Reply:na its just a scam, spyware or some gimik some site is trying to do, if you click that popup, it will make things worst. Best practice, use firefox instead of explorer, and oh, dont click popups!
Reply:You got a virus.
Reply:could be spyware, probably a virus.
:]
Reply:it probably means that you have run out of disc space on drive c, and it is deleting things from your recycle bin and temporary internet files. if you let it run, it should bring up a dialog box letting you choose what stuff to delete... or you could just go to start, accessories, system tools, disc cleanup... that works too...
Reply:Could you provide more info on the error and if you remeber what program you were in or was open at the time it happened?
jasmine
I have a little pop-up box that says it is deleting files from my C drive?
I agree with Dusty. Seems like a trojan, or at least spyware.
All of his download suggestions are good. I would recommend a visit to PC Pitstop first, though. If it's a trojan, it may interfere with downloading, so an online scan like PC Pitstop would be an alternative. It will also give you a good idea of your machine's performance, along with processes running (a good clue to virii and spyware), and a relative comparison with other computers similarly equipped.
The other suggestion about "Hijack This" is also good. This program will give you detailed information about all processes running, including those that may be hidden from the Task Manager. Please avail yourself of the experienced community of Hijack This users so you don't end up deleting something by mistake that is essential to your computer's operation.
Sites listed below are PCPitstop, Download.com (HijackThis page), Spybot S%26amp;D, and Merijn.org (excellent anti-spyware resource.
Good luck!
Reply:You're very welcome. I hope all your issues were resolved. Report It
Reply:You can try to do a System Restore to a previous date (to before you downloaded a virus from somewhere). If that doesn't work, you will probably have to try System Recovery. If that doesn't work, you will have to have your hard drive reformatted by a specialist. Good Luck. P. S. You might want to get a good anti-virus program.
Reply:Sounds like a Trojan. Run a GOOD scan like AVG and you should be able to remove it. You can get AVG from GRIsoft.
You should also be running ZoneAlarm as a (best for home PC) fire wall. Then, If you don't have them, go get Ad-aware, Spybot search and destroy, Spywareblaster, and last but not least, get a "Hosts" file. These are all free for home use and can be down-loaded from most any public domain site such as ZD net, download.com etc.
Reply:go to download.com and get a free pop up stopper.
or go to
http://www.panicware.com/popupcenter.htm...
I have it and it is great and free.
I think that will solve your pop up silly stuff.
:-)
Reply:You have a virus. DOwnload hijackthis (the most recent version), and then go seek help in online forums. They can help u remove the virus/malware.
Reply:I think it's time to run an Anti-virus tool. If this doesn't work, do a "system recovery". Don't forget to make back ups of your stuff first!:) Good Luck.
Reply:I agree, spyware. Download anti-spyware beta from Microsoft, also AVG virus protection or even Norton or McAfee. If problems persist the worse case scenario is you'll have to reinstall the operating system to wipe that out.
Reply:It's more than likely a virus. Chek your C: Drive to see if anything is missing. It could actually be deleting files, or it's just a little annoying thing to make you worry.
Reply:Catch hold of a spyware and get it removed.
Reply:There is a windows utility called disk cleanup, which may be what you are experiencing. It does not delete any important files, it merely cleans up crap from your hard drive.
If that is what pops up, youve no need to worry.
If its not that, it might be something sinister, ie, a virus or adware
Reply:Well windows automatically compress and delete un neccessary files..such as temp, cache files and stuff like that..you need not to worry..your files are safe...unless u delete them ur self
Reply:it may be spyware, go to www.download.com and search for ad-aware
Reply:na its just a scam, spyware or some gimik some site is trying to do, if you click that popup, it will make things worst. Best practice, use firefox instead of explorer, and oh, dont click popups!
Reply:You got a virus.
Reply:could be spyware, probably a virus.
:]
Reply:it probably means that you have run out of disc space on drive c, and it is deleting things from your recycle bin and temporary internet files. if you let it run, it should bring up a dialog box letting you choose what stuff to delete... or you could just go to start, accessories, system tools, disc cleanup... that works too...
Reply:Could you provide more info on the error and if you remeber what program you were in or was open at the time it happened?
jasmine
Windows won't let me delete partition?
I am trying to re-install Windows and wipe out everything (I already zipped stuff I need and sent them to another computer). When I do the setup and try to delete my C: Partition, it doesn't let me. It says it is unable to do so since there are temporary files on there needed for setup. How do I get around this?
Windows won't let me delete partition?
If you are re-installing windows totally from a disk, you need to use a Windows 98 start up disk to remove your non-dos partition.
Reply:Hi,
just do this, put your windows install disc into your CD drive and then reboot your system, when it boots from the disc select install, then reformat, then install again (back onto the same partition again (that's important) and "Bingo" you have done a clean install of windows XP, and don't forget to backup all your stuff first. hope this helps you.
Windows won't let me delete partition?
If you are re-installing windows totally from a disk, you need to use a Windows 98 start up disk to remove your non-dos partition.
Reply:Hi,
just do this, put your windows install disc into your CD drive and then reboot your system, when it boots from the disc select install, then reformat, then install again (back onto the same partition again (that's important) and "Bingo" you have done a clean install of windows XP, and don't forget to backup all your stuff first. hope this helps you.
Subscribe to:
Posts (Atom)