C# Discussion Boards - CodeProject

Re: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code

11-Jul-12 2:45

Your SQL query is broken. That is pretty obvious and why I've given you a 1, because you've clearly not even tried to understand before wasting our time here. Furthermore, you haven't shown us the SQL query you're using so there is no way we can possibly tell you what's wrong with it, except you have a stray 'w' in it.

manikantaer11-Jul-12 17:45

manikantaer

11-Jul-12 17:45

thank u.. am very much new to .NET so ..

Re: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code

Wes Aday11-Jul-12 3:03

Wes Aday

11-Jul-12 3:03

So far I am not very impressed with the story line. The characters are two dimensional and the plot is obvious,.

Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Please stand in front of my pistol, smile and wait for the flash - JSOP 2012

Re: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code

Dave Kreskowiak11-Jul-12 4:29

Dave Kreskowiak

11-Jul-12 4:29

You might want to look at the stack trace next time to get a better clue of where the error actually is.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak

Re: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code

Luc Pattyn11-Jul-12 4:46

Luc Pattyn

11-Jul-12 4:46

. As Dave said, look at the details provided by the stack trace.
And don't use release builds when there are still big issues in your code; with a debug build, the stack trace would provide actual line numbers rather than offsets.

Smile | :)

Luc Pattyn [My Articles] Nil Volentibus Arduum

Exception: Syntax Error in INSERT TO.

kaycey9011-Jul-12 2:37

kaycey90

11-Jul-12 2:37

Hi,
I wrote a code to export my data in gridview to excel. But at runtime it throws an exception saying "syntax error in INSERT TO" on execution of the command. I stepped through the code to see the output of the sql statement and I see nothing wrong with it. Can anyone assist me quickly on this please? Very many thanks in advance.

NB: The table creates perfectly, but the INSERT statement gives the exception.

My Code:

public static void ExportStudentsToXls(string filepath, List<Student> students)
        {
            using (ExcelHelper helper = new ExcelHelper(filepath))
            {
                helper.Hdr = "YES";
                helper.Imex = "0";
                Dictionary<string, string> tableDefinition = new Dictionary<string, string>();
                tableDefinition.Add("StudentID", "int");
                tableDefinition.Add("RegNo", "varchar(50)");
                tableDefinition.Add("Surname", "varchar(100)");
                tableDefinition.Add("Firstname", "varchar(100)");
                tableDefinition.Add("Middlename", "varchar(100)");
                tableDefinition.Add("LevelID", "int");
                tableDefinition.Add("Sex", "varchar(10)");
                tableDefinition.Add("DOB", "decimal");
                tableDefinition.Add("Religion", "varchar(50)");
                tableDefinition.Add("Nationality", "varchar(100)");
                tableDefinition.Add("StateOfOrigin", "varchar(100)");
                tableDefinition.Add("ClassID", "int");
                tableDefinition.Add("ParentID", "int");
                tableDefinition.Add("Address", "varchar(150)");
                tableDefinition.Add("HomePhone", "varchar(20)");
                tableDefinition.Add("MobilePhone", "varchar(20)");
                tableDefinition.Add("Email", "varchar(255)");
                tableDefinition.Add("NextofKin", "varchar(100)");
                tableDefinition.Add("KinAddress", "varchar(200)");
                tableDefinition.Add("BloodGroup", "varchar(50)");
                tableDefinition.Add("Genotype", "varchar(50)");
                tableDefinition.Add("Disability", "varchar(50)");
                tableDefinition.Add("SessionID", "int");
                tableDefinition.Add("TermAdmitted", "varchar(50)");
                tableDefinition.Add("LevelAdmitted", "varchar(50)");
                tableDefinition.Add("ClassAdmitted", "varchar(50)");
                tableDefinition.Add("DateAdmitted", "decimal");
                tableDefinition.Add("Hobbies", "varchar(50)");
                tableDefinition.Add("Picture", "varchar(50)");
                tableDefinition.Add("DateRegistered", "decimal");
                tableDefinition.Add("Status", "varchar(50)");
                tableDefinition.Add("Deleted", "varchar(5)");
                helper.WriteTable("Students", tableDefinition);

                string decimalQuoter = (CultureInfo.CurrentCulture.NumberFormat.NumberDecimalSeparator.Equals(",") ? "\"" : String.Empty);

                foreach (var student in students)
                {
                    StringBuilder sb = new StringBuilder();
                    sb.Append("INSERT INTO [Students] (StudentID, RegNo, Surname, Firstname, Middlename, LevelID, Sex, DOB, Religion, Nationality, StateOfOrigin, ClassID, ParentID, Address, HomePhone, MobilePhone, Email, NextofKin, KinAddress, BloodGroup, Genotype, Disability, SessionID, TermAdmitted, LevelAdmitted, ClassAdmitted, DateAdmitted, Hobbies, Picture, DateRegistered, Status, Deleted) VALUES(");
                    sb.Append(student.StudentID); sb.Append(",");
                    sb.Append('"'); sb.Append(student.RegNo); sb.Append("\",");
                    sb.Append('"'); sb.Append(student.Surname); sb.Append("\",");
                    sb.Append('"'); sb.Append(student.Firstname); sb.Append("\",");
                    sb.Append('"'); sb.Append(student.Middlename); sb.Append("\",");
                    sb.Append(student.LevelID); sb.Append(",");
                    sb.Append('"'); sb.Append(student.Sex); sb.Append("\",");
                    sb.Append(decimalQuoter); sb.Append(student.DOB.Value.ToOADate()); sb.Append(decimalQuoter); sb.Append(",");
                    sb.Append('"'); sb.Append(student.Religion); sb.Append("\",");
                    sb.Append('"'); sb.Append(student.Nationality); sb.Append("\",");
                    sb.Append('"'); sb.Append(student.StateOfOrigin); sb.Append("\",");
                    sb.Append(student.ClassID); sb.Append(",");
                    sb.Append(student.ParentID); sb.Append(",");
                    sb.Append('"'); sb.Append(student.Address); sb.Append("\",");
                    sb.Append('"'); sb.Append(student.HomePhone); sb.Append("\",");
                    sb.Append('"'); sb.Append(student.MobilePhone); sb.Append("\",");
                    sb.Append('"'); sb.Append(student.Email); sb.Append("\",");
                    sb.Append('"'); sb.Append(student.NextofKin); sb.Append("\",");
                    sb.Append('"'); sb.Append(student.KinAddress); sb.Append("\",");
                    sb.Append('"'); sb.Append(student.BloodGroup); sb.Append("\",");
                    sb.Append('"'); sb.Append(student.Genotype); sb.Append("\",");
                    sb.Append('"'); sb.Append(student.Disability); sb.Append("\",");
                    sb.Append(student.SessionID); sb.Append(",");
                    sb.Append('"'); sb.Append(student.TermAdmitted); sb.Append("\",");
                    sb.Append('"'); sb.Append(student.LevelAdmitted); sb.Append("\",");
                    sb.Append('"'); sb.Append(student.ClassAdmitted); sb.Append("\",");
                    sb.Append(decimalQuoter); sb.Append(student.DateAdmitted.Value.ToOADate()); sb.Append(decimalQuoter); sb.Append(",");
                    sb.Append('"'); sb.Append(student.Hobbies); sb.Append("\",");
                    sb.Append('"'); sb.Append(student.Picture); sb.Append("\",");
                    sb.Append(decimalQuoter); sb.Append(student.DateAdmitted.Value.ToOADate()); sb.Append(decimalQuoter); sb.Append(",");
                    sb.Append('"'); sb.Append(student.Status); sb.Append("\",");
                    sb.Append('"'); sb.Append(student.Deleted); sb.Append("\",");
                    sb.Append(")");

                    helper.ExecuteCommand(sb.ToString());
                }
            }

Pete O'Hanlon11-Jul-12 2:42

Pete O'Hanlon

11-Jul-12 2:42

kaycey90 wrote:
sb.Append('"'); sb.Append(student.Deleted); sb.Append("\",");
sb.Append(")");

You have a , just before your closing ). You don't need to put that in. BTW, why did you not consider using sb.AppendFormat instead? You could have saved yourself a lot of sb.Append work there.

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

BobJanova11-Jul-12 2:43

11-Jul-12 2:43

Use a parameterised query! And if that's too hard (it's not), at least escape the input strings. You're going to break things when you meet Mr. O'Brien. (Not to mention Bobby Tables.)

SQL doesn't use double quotes, it uses single quotes. But I will re-emphasise, building a query string like this is the wrong way.

PIEBALDconsult11-Jul-12 3:30

PIEBALDconsult

11-Jul-12 3:30

That deserves more than a 5.

Richard Andrew x6411-Jul-12 5:25

Richard Andrew x64

11-Jul-12 5:25

I've heard of Bobby Tables, but could you provide a link to Mr. O'Brien?

The difficult we do right away...
...the impossible takes slightly longer.

BobJanova11-Jul-12 6:29

11-Jul-12 6:29

That's not a comic reference, just the first Irish name that came to mind. Irish surnames are the source of most real world accidental query failures of this kind.

Richard Andrew x6411-Jul-12 8:18

Richard Andrew x64

11-Jul-12 8:18

Oh I see. The apostrophe.

The difficult we do right away...
...the impossible takes slightly longer.

Pete O'Hanlon11-Jul-12 8:35

Pete O'Hanlon

11-Jul-12 8:35

My post was just above and the first Irish name that came to mind was O'Brien?

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

BobJanova11-Jul-12 23:21

11-Jul-12 23:21

Haha sorry Pete, I don't usually read the column of poster names when I'm perusing a thread!

Passing an object through different window classes in Windows Forms

PIEBALDconsult11-Jul-12 3:37

PIEBALDconsult

11-Jul-12 3:37

I want to further emphasize what the others said. Use a parameterized query every time. It's safer and it's quicker if you reuse the command many times:

Set the command and add the parameters
Loop
  Set the paramater values
  Execute the command
Endloop

And what's with the Dictionary? Confused | :confused:

There's no guarantee which order the columns will be in when you create the table. A List of Tuples might be a better idea.

nstk11-Jul-12 0:55

Re: Passing an object through different window classes in Windows Forms

11-Jul-12 0:55

In a Windows Forms application, I have a class Students and then I create a new object student inside the class Form1 which represents the main window of my application.

So far so good, but I need a second window which will show the user some of the student's data. Therefore I create a second class derived from Form, let's say
StudentsData : Form
and then I let a new object of that class be created inside the Form1 class, and again through ShowDialog() I let that new Window be visible.

What I do not succeed is to pass the student's data into that window. I think the real question should be, how do I make an object persist through different other classes/objects?

Any help would be appreciated.

Pete O'Hanlon11-Jul-12 1:02

Pete O'Hanlon

11-Jul-12 1:02

If all you are trying to do is to pass the Students class through to your second form, you simply need to make sure you have added this into your StudentsData form before you call ShowDialog. Now, you could do this by passing it in a constructor in StudentsData, or you could simply expose a property that accepts StudentsData. Depending on what you are trying to achieve with this, I would choose the property because you are probably going to want to be reading the contents of this after your dialog has closed.

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

Re: Passing an object through different window classes in Windows Forms

nstk11-Jul-12 3:47

Re: Passing an object through different window classes in Windows Forms

11-Jul-12 3:47

I have a main Form
public partial class Form1 : Form
a Data Form
public partial class Data : Form
and a class Students in another file with
public string Name
{ get; set; }

Now on Form1 I create
Students stud = new Students();
and then I give
stud.Name = "hisname";

Then by clicking a button on Form 1 the following happens

Data datawindow = new Data();
datawindow.ShowDialog();

When Data Form loads I want to get in a text box
txtName.Text = stud.Name;

But the object stud is not available on Data form.

DaveyM6911-Jul-12 4:02

DaveyM69

11-Jul-12 4:02

In Data class:

private Students students;

public Students Students
{
    get{ return students; }
    set
    {
        students = value;
        txtName.Text = students.Name;
    }
}

In your Button Click handler in Form1:

Data datawindow = new Data();
datawindow.Students = stud;
datawindow.ShowDialog();

Dave

Binging is like googling, it just feels dirtier.
Please take your VB.NET out of our nice case sensitive forum.
Astonish us. Be exceptional. (Pete O'Hanlon)

BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)

Re: Passing an object through different window classes in Windows Forms

nstk12-Jul-12 1:36

Re: Passing an object through different window classes in Windows Forms

12-Jul-12 1:36

Thanks for your help.

Unfortunately I am getting an error, and I think I have seen it before when I was trying to solve that problem, maybe because I have a class Students on a file students.cs

The error is:
Inconsistent accessibility: property type 'Studentstest.Students' is less accessible than property 'Studentstest.Data.Students'

Where Studentstest is the name of the project containing the following classes:
Form1.cs, Data.cs and Students.cs

nstk12-Jul-12 1:44

Re: Passing an object through different window classes in Windows Forms

12-Jul-12 1:44

OK, I found this
http://msdn.microsoft.com/en-us/library/532wtsbc%28v=vs.90%29.aspx
and corrected accordingly.

Thanks again.

modified 12-Jul-12 7:52am.

BobJanova11-Jul-12 2:41

Re: Passing an object through different window classes in Windows Forms

11-Jul-12 2:41

There's two common approaches I use for modal dialogs. The first is to write a method in StudentsDataForm (yes I just renamed your class Smile | :)

) which takes the Student, shows the form and returns a modified version:

public Student EditStudent(Student input){
 this.firstNameTextBox.Text = input.FirstName;
 // ... etc to copy data into other controls
 // you could also use data binding
 if(DialogResult.OK == ShowDialog()){
  Student result = new Student();
  result.FirstName = firstNameTextBox.Text;
  // etc
  return result;
 } else return input;
}

There's also a variant of this where you update the input object in place, and return the DialogResult, which you can use if you always want the data object to be updated by the form when OK is used.

The second way is to have a property in the second form:

public Student Student {
 get {
  Student student = new Student();
  student.FirstName = firstName.Text;
  // etc
  return student;
 }
 set {
  firstName.Text = value.FirstName;
  // etc
 }
}

Then you push the data into the form, and use the data from it if the user pressed OK:

studentDataForm.Student = someStudent;
if(DialogResult.OK == studentDataForm.ShowDialog(this)){
 // Do something with studentDataForm.Student to store the changed data
}

nstk14-Jul-12 7:40