Click here to Skip to main content
15,887,434 members
Home / Discussions / Article Writing
   

Article Writing

 
GeneralRe: Published Article Updates by Community member Pin
Osama Saleem (live)18-Dec-18 8:05
professionalOsama Saleem (live)18-Dec-18 8:05 
GeneralRe: Published Article Updates by Community member Pin
Richard Deeming18-Dec-18 11:06
mveRichard Deeming18-Dec-18 11:06 
QuestionAngular JS Versions Supported for Visual studio Pin
rajesh vs30-Oct-18 22:23
rajesh vs30-Oct-18 22:23 
AnswerRe: Angular JS Versions Supported for Visual studio Pin
Richard MacCutchan30-Oct-18 22:26
mveRichard MacCutchan30-Oct-18 22:26 
QuestionWhere is the rejected Article Pin
Er.Vaibhav Singh Chauhan30-Oct-18 19:13
professionalEr.Vaibhav Singh Chauhan30-Oct-18 19:13 
AnswerRe: Where is the rejected Article Pin
Pete O'Hanlon30-Oct-18 21:36
mvePete O'Hanlon30-Oct-18 21:36 
GeneralRe: Where is the rejected Article Pin
Er.Vaibhav Singh Chauhan31-Oct-18 1:25
professionalEr.Vaibhav Singh Chauhan31-Oct-18 1:25 
Questionwhat is going wrong Pin
Member 1403295125-Oct-18 8:32
Member 1403295125-Oct-18 8:32 
C#
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

AnswerRe: what is going wrong Pin
Richard Deeming25-Oct-18 9:21
mveRichard Deeming25-Oct-18 9:21 
QuestionEmail notification that my article was changed. Pin
Jim Meadors18-Oct-18 18:01
Jim Meadors18-Oct-18 18:01 
AnswerRe: Email notification that my article was changed. Pin
Nelek18-Oct-18 19:14
protectorNelek18-Oct-18 19:14 
AnswerRe: Email notification that my article was changed. Pin
Nelek18-Oct-18 19:17
protectorNelek18-Oct-18 19:17 
AnswerRe: Email notification that my article was changed. Pin
Pete O'Hanlon18-Oct-18 21:12
mvePete O'Hanlon18-Oct-18 21:12 
AnswerRe: Thanks Nelek and Pete Pin
Jim Meadors19-Oct-18 16:17
Jim Meadors19-Oct-18 16:17 
GeneralRe: Thanks Nelek and Pete Pin
Nelek22-Oct-18 5:19
protectorNelek22-Oct-18 5:19 
QuestionWhich language for piece of code ? Pin
Patrice T16-Oct-18 14:13
mvePatrice T16-Oct-18 14:13 
Questionwhere are my Mars Mission articles? Pin
Christ Kennedy11-Oct-18 7:27
Christ Kennedy11-Oct-18 7:27 
AnswerRe: where are my Mars Mission articles? Pin
Matthew Dennis11-Oct-18 8:29
sysadminMatthew Dennis11-Oct-18 8:29 
GeneralRe: where are my Mars Mission articles? Pin
Christ Kennedy12-Oct-18 13:48
Christ Kennedy12-Oct-18 13:48 
GeneralRe: where are my Mars Mission articles? Pin
Chris Maunder22-Oct-18 4:48
cofounderChris Maunder22-Oct-18 4:48 
AnswerRe: where are my Mars Mission articles? Pin
Chris Maunder1-Feb-19 4:04
cofounderChris Maunder1-Feb-19 4:04 
QuestionFix broken image links Pin
JL Doty9-Oct-18 3:59
professionalJL Doty9-Oct-18 3:59 
AnswerRe: Fix broken image links Pin
JL Doty9-Oct-18 6:44
professionalJL Doty9-Oct-18 6:44 
QuestionCan't post an article Pin
JL Doty7-Oct-18 5:00
professionalJL Doty7-Oct-18 5:00 
AnswerRe: Can't post an article Pin
JL Doty7-Oct-18 5:46
professionalJL Doty7-Oct-18 5:46 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.