|
namespace Testinsert
{
public partial class Form1 : Form
{
OleDbConnection con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=TSMSdBase.accdb ; Persist Security Info=False");
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
try{
string sql = "insert into masterStudent ( StudentName, Gender, Section, RollNo, masterClass_sl) values ('ww','F','B',2,3)";
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = con;
cmd.CommandText = sql;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}catch(Exception ex)
{
MessageBox.Show(ex.ToString());
if (con.State == ConnectionState.Open)
con.Close();
}
}
}
}
The exception :
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at Testinsert.Form1.button1_Click(Object sender, EventArgs e) in E:\schoolResult\Testinsert\Testinsert\Form1.cs:line 29
|
|
|
|
|
What, other than the fact that you've posted this in completely the wrong forum, and have removed any useful information from your exception details?
Post your question in the C# forum[^], and include the full details of the exception, not just the stack trace.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I got an email from @Deeksha-Shenoy saying:
"Changes have been made to your article https://www.codeproject.com/Articles/475041/Wordnet-Rightfully-Transmogrified.
"Please take a moment to review the article to ensure that there are no errors. If there are any problems, please let me know."
Yet there is no way to contact her as it says "Note: This message has been sent from an unattended email box."
I did review the article and couldn't detect what the changes were that were made. Is there any way to find out what changes were made, by whom or why?
<sig notetoself="think of a better signature">
<first>Jim</first> <last>Meadors</last>
</sig>
|
|
|
|
|
Left side menu --> Revisions
Look the list, if not all versions there, then "Show Minor Changes"
You can select two of them and "compare" button
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
As it looks... it was mostly correcting format or some capital letters / punctuation. Not really changing the content.
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
Deeksha is one of the CP editors. When you see an email like this, it generally means that the editors have gone through and done things like fixing capitalisation or spacing issues, or things like that.
This space for rent
|
|
|
|
|
I found that you were correct, minor points mostly the html markup. Which unfortunately reminds me that the whole article is overdue for an update or revision . Thanks again!
<sig notetoself="think of a better signature">
<first>Jim</first> <last>Meadors</last>
</sig>
|
|
|
|
|
You are welcome
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
I am writing an article with pieces of code from xbase family languages: dBase, Clipper, FoxPro ...
// Trial Division Square Root
function TD_SR(Prod)
Local D, Top
Top= int(sqrt(Prod))
for D= 2 to Top
if Prod % D = 0
return D
endif
next
return Prod
Does the <pre> tag know ghw to highlight such language, or which language is recommended ?
Patrice
“Everything should be made as simple as possible, but no simpler.” Albert Einstein
|
|
|
|
|
I've been away for 7 years and now I've just got back and I see that my last four articles(Mars Mission 1-4) are all gone? what up?!? I spent over six months working on that project and I was looking forward to getting back at it.
Christ
my code is perfect until i don't find a bug...
|
|
|
|
|
|
I looked in my listed of articles ... and they're all there except the Mars Mission ones.
is this Big-Brother suppression?
my code is perfect until i don't find a bug...
|
|
|
|
|
Definitely Big Brother suppression. We all know Mars was faked in a Toronto studio.
(We'll get to the bottom of this)
cheers
Chris Maunder
|
|
|
|
|
Sorry for taking so long to get back to you on this. Your articles are showing up in your list[^]:
cheers
Chris Maunder
|
|
|
|
|
I posted an article and all the image links are broken. They looked fine in the article editor, and when I previewed it, but now that it's up and running all the image links are broken. Here's the article: App for CPU Temps, Fan Speeds, etc., Part II.
JLD
|
|
|
|
|
A bit more information:
When I go back into the article editor, each image has a red bullet below it stating "image missing." They weren't missing during preview and when I posted it. The source zip file I uploaded is also missing.
I tried re-uploading one of the image files, and after doing so I now have two files listed with the same name: "300_HistoryZoomBoth.png". One appears to be okay, and the other still has the red "image missing" bullet below it.
I'm afraid to move forward and re-upload all the images because this looks like a real mess and I don't want to screw it up even more than it is.
JLD
|
|
|
|
|
Spent about a month putting together an article in bits and pieces, and kept it flagged as work-in-progress. Now, when I'm ready to post it, it won't post. Twice I've hit the post button, and on my "My Articles" page it's still listed as "This is an unfinished article." Both times I waited 24 hours and nothing changed. Any ideas why it's stuck?
JLD
|
|
|
|
|
I figured it out: I forgot to select a category for the article. Duh! Once I did that it seems to be unstuck.
JLD
|
|
|
|
|
I invested a great deal of time getting my blog together this weekend and after hours of writing and re-writing, I finally was able to get the article sent to CodeProject. It was approved. Then I saw something pop up saying that several people said that it was copied from somewhere else, which is impossible. But regardless, I can't find those notifications anywhere. There's no record of my articles even being picked up by CodeProject, much less being approved or removed or anything else.
Where would I find that log? What could these people be talking about, regarding my blog?
My blog is https://www.SevenDaysOfSchema.com by the way.
I know there are rules but geez that was a ton of work to go through for nothing.
|
|
|
|
|
Rick_Bishop wrote: said that it was copied from somewhere else, which is impossible
Oh really?
The "Formatting ..." blog is plagiarised. A random paragraph shows up identically on MSDN: GETDATE (Transact-SQL) | Microsoft Docs[^]
The "Query ..." blog is plagiarised. Worse, it's plagiarised by typing it in which introduces spelling errors!
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
As has already been stated, the attribution was an image and the image was surrounded by a link, directly to the source, which is Microsoft's website. Beside that, is a link to the GitHub repository where the Microsoft documentation can be reviewed by content editors, like me. It looks like your parser removed or mangled this part of the page, but it's plainly visible if you go to my website.
This reference information is included at the bottom of every one of my example queries. I did this because some information is really handy to have available right on the page. The process of acquiring the information about Transact-SQL language constructs and SQL Server stored procedures and other objects, figuring out what objects are present in my example query, and bringing everything together on a single page so that reference information can be viewed alongside the example query without having to find information spread across multiple locations on the Microsoft site, is a process that took more than a year to complete.
You are acting as though I am the enemy. Why is that? I'm just a dude that's trying to make the world a better place. If you don't like my book review, I can care less. I didn't mean for that to get posted anyway.
|
|
|
|
|
Rick_Bishop wrote: You are acting as though I am the enemy. Why is that?
Because we get far too many people who think that Google, Ctrl+A + Ctrl+C, switch to CodeProject, Ctrl+V, post is the way to become a published "author" here.
As a result, we take a zero-tolerance stance when it comes to plagiarism.
On some rare occasions, that can result in mistakes. I see you've replied to the original report, so you can discuss with Wendelius whether that's the case here.
You might also want to get @Sean-Ewington to take a look. If he's convinced it was a mistake, then he can restore your articles.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I am a volunteer Paramedic. I perform at exactly the same level when I'm being paid as when I'm not. I guess we just hold ourselves to different standards.
|
|
|
|
|
Still waiting for you to apologise to Nelek for your unwarranted and unacceptable abuse.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
You are terrible representative of this web site. You have been dishonest, rude and showed zero respect for me, despite the olive branches I have thrown you.
I, who has posted my name, photo and contact information on my profile, website and everything I write.
You two don't even have a picture. You could be literally anybody, so there's no accountability for you statements, is there? That make you cowards in my book and even when I am wrong and I am not wrong, I don't apologize to cowards. I will apologize to people who care for loved ones with special needs, for my use of the word "retard". Besides, people with special needs are not dishonest hacks, building "reputation" off of the works of others.
Oh and all those points you guys have? Those are just points you got while "volunteering" to criticize and down vote other people's work. Why this site gives points to down vote someone's work is beyond me, but hey, this isn't StackOverflow.
I am deleting my account, so go ahead and get all that down voting in while you can. Those points could be all you guys will amount to if you don't grow up.
|
|
|
|