exception: Missing semicolon (;) at end of SQL statement [modified] - ASP.NET Discussion Boards

Re: Redirect to UnAuthorized Page in Windows Authentication

antony beula21-Jun-11 2:40

21-Jun-11 2:40

<customErrors defaultRedirect="ErrorPage.asp*x" mode="On">
<error statusCode="401" redirect="AccessDenied.aspx" />
</customErrors>

protected void Application_EndRequest(Object sender,
EventArgs e)
{
HttpContext context = HttpContext.Current;
if (context.Response.Status.Substring(0, 3).Equals("401"))
{
Response.Redirect("UnauthorisedPage.aspx");
}
}

if (!Request.IsAuthenticated)
{
Response.Redirect("UnauthorisedPage.aspx");
}

IIS > Virtual Directory properties > Custom Errors page > 401;2 > Properties

Textbox value doesn't change between postbacks

benams21-Jun-11 1:20

benams

21-Jun-11 1:20

I have a simple textbox with an initial text, when I type some other text in the textbox it and click my submit button, I see that the textbox.Text value stays the old initial value and the information which I typed has lost. How can I fix it?

Re: Textbox value doesn't change between postbacks

mcyogi21-Jun-11 1:37

mcyogi

21-Jun-11 1:37

It sounds like the text is being re-initialised each postback. Try the following (in VB):

If not Page.IsPostback

// Initialise textbox

End If

Re: Textbox value doesn't change between postbacks

Not Active21-Jun-11 2:26

Not Active

21-Jun-11 2:26

Have your verified EnableViewState is on for this control? Is the control being re-initialized during the postback?

I know the language. I've read a book. - _Madmatt

what are the configuratiions in the asp.net validation controls? and please give the code to the configurations?

hariprasad.yandrapu20-Jun-11 22:25

hariprasad.yandrapu

20-Jun-11 22:25

what are the configuratiions in the asp.net validation controls? and please give the code to the configurations?

Re: what are the configuratiions in the asp.net validation controls? and please give the code to the configurations?

Not Active21-Jun-11 2:24

Not Active

21-Jun-11 2:24

Your question makes no sense. Please try to restate clearly what you a trying to do, what you have tried and what issues you have.

I know the language. I've read a book. - _Madmatt

Re: what are the configuratiions in the asp.net validation controls? and please give the code to the configurations?

thatraja21-Jun-11 19:38

thatraja

21-Jun-11 19:38

There is configurations. You mean properties?

Important(common) properties of validators are,
ControlToValidate, Display, ErrorMessage, EnableClientScript, IsValid, Text

Additional properties are,

CompareValidator - ControlToCompare, Operator, Type, ValueToCompare
CustomValidator - ClientValidationFunction, OnServerValidate
RangeValidator - MaximumValue, MinimumValue, Type
RegularExpressionValidator - ValidationExpression
RequiredFieldValidator -

ValidationSummary - DisplayMode, HeaderText, ShowMessageBox, ShowSummary

Read this
ASP.NET Validation Server Controls[^]

thatraja

My Tip/Tricks
My Dad had a Heart Attack on this day so don't...

exception: Missing semicolon (;) at end of SQL statement [modified]

benams20-Jun-11 8:32

benams

20-Jun-11 8:32

I'm using msaccess(2007) database and I get the error message above while tryig to execute the following code:

OleDbCommand cmd = new OleDbCommand();
cmd.CommandText = "INSERT INTO tblCategory(CategoryName, OrderNum) " +
                  "VALUES(@CategoryName, @OrderNum) " +
                  "SELECT @@IDENTITY AS ID";
cmd.Parameters.Add(new OleDbParameter("@CategoryName", Category.CategoryName));
cmd.Parameters.Add(new OleDbParameter("@OrderNum", Category.Order));
cmd.Connection = DataAccess.CreateConnection("Malasot", false);
DataTable dt = new DataTable();
OleDbDataAdapter adapter = new OleDbDataAdapter(cmd);

if(cmd.Connection.State != ConnectionState.Open)
   cmd.Connection.Open();

adapter.Fill(dt); // ***the exception occurs here.***

note: I have tryed putting semicolon between the 2 statements and it doesn't solve the problem.

modified on Monday, June 20, 2011 2:38 PM

Re: exception: Missing semicolon (;) at end of SQL statement

Parwej Ahamad20-Jun-11 8:38

Parwej Ahamad

20-Jun-11 8:38

as your error stating, just place semi colon after the insert statement.

cmd.CommandText = "INSERT INTO tblCategory(CategoryName, OrderNum) " +
                      "VALUES(@CategoryName, @OrderNum); " +
                      "SELECT @@IDENTITY AS ID";

Parwej Ahamad
ahamad.parwej@gmail.com

Re: exception: Missing semicolon (;) at end of SQL statement

benams20-Jun-11 8:41

benams

20-Jun-11 8:41

I've just tryed it, it didn't help

Re: exception: Missing semicolon (;) at end of SQL statement

AspDotNetDev20-Jun-11 8:54

AspDotNetDev

20-Jun-11 8:54

How about adding a semicolon after the second SQL statement:

cmd.CommandText =
    "INSERT INTO tblCategory(CategoryName, OrderNum) " +
    "VALUES(@CategoryName, @OrderNum); " +
    "SELECT @@IDENTITY AS ID;";

Help a brotha out and vote Managing Your JavaScript Library in ASP.NET as the best ASP.NET article of May 2011.

Re: exception: Missing semicolon (;) at end of SQL statement

Parwej Ahamad20-Jun-11 8:55

Parwej Ahamad

20-Jun-11 8:55

Error is same OR giving different one? Can you try once to execute two separate statement on by one because I have double that Access generating instantly Identity value.

Thanks,
Parwej

Parwej Ahamad
ahamad.parwej@gmail.com

Re: exception: Missing semicolon (;) at end of SQL statement

benams20-Jun-11 23:13

benams

20-Jun-11 23:13

I've tryed adding semicolon and the error message I get is: "Characters found after end of SQL statement."
I guess it will work well if I execute 2 seperated commands, but my goal is to execute all in one command, if it's possible.

Re: exception: Missing semicolon (;) at end of SQL statement

Parwej Ahamad21-Jun-11 0:26

Parwej Ahamad

21-Jun-11 0:26

Hi Benames,

I haven't try from side, but I had searched on Google and they clearly mentioned that we can not execute multiple statement in single query against Ms Access DB. So may be cause of the error. So if possible execute two separated statement to achieve your goal.

Thanks,
Parwej

Parwej Ahamad
ahamad.parwej@gmail.com

Re: exception: Missing semicolon (;) at end of SQL statement

benams21-Jun-11 0:39

benams

21-Jun-11 0:39

Ok, probably you are right.
It goes well when I run it in 2 different commands.

UpdateProgress on upddatepanel triggers

Ali Al Omairi(Abu AlHassan)19-Jun-11 1:37

Ali Al Omairi(Abu AlHassan)

19-Jun-11 1:37

guys;
i want to show an UpdateProgress when triggering an updatepanel to be updated. like this

HTML

<asp:button id="button1" runat="server" text="button1" />
<asp:upddatepanel id="upddatepanel1" runat="server">
<triggers>
<asp:asyncpostbacktrigger ControlID="button1" EventName="Click" />
</triggers>
</asp:upddatepanel>
<asp:UpdateProgress ID="ModalUpdateProgress1" DisplayAfter="0"
        runat="server" AssociatedUpdatePanelID="upddatepanel1">
 <ProgressTemplate>
     Loading ...
 </ProgressTemplate>
</asp:UpdateProgress>

what do you think?

Help people,so poeple can help you.

Re: UpdateProgress on upddatepanel triggers

Parwej Ahamad20-Jun-11 8:35

Parwej Ahamad

20-Jun-11 8:35

You don't want to use UpdateProgress control?

Parwej Ahamad
ahamad.parwej@gmail.com

Re: UpdateProgress on upddatepanel triggers

Ali Al Omairi(Abu AlHassan)21-Jun-11 22:47

Ali Al Omairi(Abu AlHassan)

21-Jun-11 22:47

Sir;
The existing UpdateProgress shows its content on asynchrnous postbaks just in the case of the postback control was a child of the AssociatedUpdatePanel if any.
what i am trhinking of is inheriting from UpdateProgress adn add a new property of type List<string> named AssociatedUpdatePanelTriggers that holds triggers ids of the AssociatedUpdatePanel and push them to the javascript version of the class on method Render() though ClientScript.RegisterStartupScript()

what do you think?

Help people,so poeple can help you.

how to start MVC

somasekhara77718-Jun-11 4:40

somasekhara777

18-Jun-11 4:40

actually i worked with asp.net and now i will go throw MVC. i need example for MVC plz help me
thank u

j somasekhar

Re: how to start MVC

Philippe Mori18-Jun-11 5:04

Philippe Mori

18-Jun-11 5:04

Here you will find lot of usefull tutorials and videos. Check "Learning Resources" section. At the top of that section, there are also links for additionnal content.

http://www.asp.net/mvc[^]

Philippe Mori

Re: how to start MVC

somasekhara77718-Jun-11 6:37

somasekhara777

18-Jun-11 6:37

thank you

j somasekhar

Re: how to start MVC

Prasanta_Prince19-Jun-11 6:24

Prasanta_Prince

19-Jun-11 6:24

@Philippe Mori Good link.

Problem in web application deployment

sakssp17-Jun-11 20:19

sakssp

17-Jun-11 20:19

When I deploy my web application and when two persons (administrator, Encoder) logged in at same time to my web application then the pages gets interchanges between the logged in users.

We have develop the software in ASP.net VS-2008 and SQL Server 2005.

Re: Problem in web application deployment

R. Giskard Reventlov17-Jun-11 20:50

R. Giskard Reventlov

17-Jun-11 20:50

Not nearly enough information to be able to help. e.g. does this happen on the dev box as well? Are there any exceptions reported? Is it your design? Also, not clear what you mean by 'pages get interchanges betwen th elogged in users'???

"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
nils illegitimus carborundum

me, me, me

Re: Problem in web application deployment

somasekhara77718-Jun-11 4:57

somasekhara777

18-Jun-11 4:57

you are developing a web application rite. there is no problem how many users will be logged in. suppose with same user name u will login with different browsers rite there will be nothing happens. first ask the question clearly i am not getting ur question

j somasekhar

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