ASP.NET Forum RSS Feed (Replies Included)

Re: SqlException unhandled : Incorrect syntax near '12'

Thu, 20 Jun 2013 03:14:03 -0700

please check record variable name in database and queries, your logic is good try to review variable.

Re: SqlException unhandled : Incorrect syntax near '12'

Thu, 20 Jun 2013 03:12:12 -0700

please check record variable name in database and queries, your logic is good try to review variable.

Re: SqlException unhandled : Incorrect syntax near '12'

Thu, 20 Jun 2013 03:10:22 -0700

please check record variable name in database and queries, your logic is good try to review variable.

SqlException unhandled : Incorrect syntax near '12'

Wed, 19 Jun 2013 23:56:07 -0700

Dear users,

I am having problem with inserting date into SQL server. My code is as following:

        protected void btnSave_Click(object sender, EventArgs e)

        {
            using (SqlConnection con = new SqlConnection("Data Source=MEHDI-PC\\SQLEX;Initial Catalog=PIMS;Integrated Security=True"))
            {
                using (SqlCommand cmd = new SqlCommand())
                {

                    string DatePrinted = "";

                    if (txtDatePrinted.Text != "")
                        DatePrinted = DateTime.ParseExact(txtDateReceived.Text, "G", CultureInfo.GetCultureInfo("en-US")).ToString("yyyy-MM-dd");
                    else
                        DatePrinted = "NULL";

                    string DateReceived = "";

                    if (txtDateReceived.Text != "")
                        DateReceived = DateTime.ParseExact(txtDateReceived.Text, "G", CultureInfo.GetCultureInfo("en-US")).ToString("yyyy-MM-dd");
                    else
                        DateReceived = "NULL";

                    string DueDate = "";

                    if (txtDueDate.Text != "")
                        DueDate = DateTime.ParseExact(txtDateReceived.Text, "G", CultureInfo.GetCultureInfo("en-US")).ToString("yyyy-MM-dd");
                    else
                        DueDate = "NULL";

                    string ActualDate = "";

                    if (txtActualDate.Text != "")
                        ActualDate = DateTime.ParseExact(txtDateReceived.Text, "G", CultureInfo.GetCultureInfo("en-US")).ToString("yyyy-MM-dd");
                    else
                        ActualDate = "NULL";

                    String sql = "Insert into dbo.Documents(Ref,Subject,Src,Dst,Medium,Date_Prin
ted,Date_Received,Document_Type,Action_Required,Du
e_Date,Actual_Date,[Content],Tag,Issue_No,Attachme
nt,Notes,Assigned_To,Reply_Ref,Priority,Status,Res
ponse) values ('" + txtRef.Text + "','" + txtSubject.Text + "','" + ddlSource.Text + "' ,'" + ddlDestination.Text + "','" + ddlMedium.Text + "','" + DatePrinted + "','" + DateReceived + "','" + ddlDocumentType.Text + "','" + cbxAction.Checked + "','" + DueDate + "','" + ActualDate + "','" + txtContent.Text + "','" + txtTag.Text + "','" + txtIssue.Text + "','" + txtAttachment.Text + "','" + txtNotes.Text + "','" + ddlAssignedTo.Text + "','" + txtReplyRef.Text + "','" + ddlPriority.Text + "','" + ddlStatus.Text + "','" + ddlResponse.Text + "')";
  
                    cmd.Connection = con;
                    cmd.CommandText = sql;

                    con.Open();
                    //dataset object to get all select statement results
                    //DataSet ds = new DataSet();

                    //sql dataadoptor to fill dataset
                    cmd.ExecuteNonQuery();
                }
                if (con.State == ConnectionState.Open)
                {
                    con.Close();
                }

                MultiView1.SetActiveView(vRecord);
                txtRef.Text = string.Empty;
                txtSubject.Text = string.Empty;
                ddlSource.Text = string.Empty;
                ddlDestination.Text = string.Empty;
                ddlMedium.Text = string.Empty;
                txtDatePrinted.Text = string.Empty;
                txtDateReceived.Text = string.Empty;
                ddlDocumentType.Text = string.Empty;
                cbxAction.Checked = false;
                txtDueDate.Text = string.Empty;
                txtActualDate.Text = string.Empty;
                txtContent.Text = string.Empty;
                txtTag.Text = string.Empty;
                txtIssue.Text = string.Empty;
                txtAttachment.Text = string.Empty;
                txtNotes.Text = string.Empty;
                ddlAssignedTo.Text = string.Empty;
                txtReplyRef.Text = string.Empty;
                ddlPriority.Text = string.Empty;
                ddlStatus.Text = string.Empty;
                ddlResponse.Text = string.Empty;
            }

            }

After I run this code, and enter any date value in the datefield, it throws this message:

SqlException unhandled : Incorrect syntax near '12'

I am failed to see anything wrong with my code. Please help me identify the problem.

You help will be much appreciated.

Regards

SqlException unhandled : Incorrect syntax near '12'

Wed, 19 Jun 2013 23:53:05 -0700

Dear users,

I am having problem with inserting date into SQL server. My code is as following:

        protected void btnSave_Click(object sender, EventArgs e)

        {
            using (SqlConnection con = new SqlConnection("Data Source=MEHDI-PC\\SQLEX;Initial Catalog=PIMS;Integrated Security=True"))
            {
                using (SqlCommand cmd = new SqlCommand())
                {

                    string DatePrinted = "";

                    if (txtDatePrinted.Text != "")
                        DatePrinted = DateTime.ParseExact(txtDateReceived.Text, "G", CultureInfo.GetCultureInfo("en-US")).ToString("yyyy-MM-dd");
                    else
                        DatePrinted = "NULL";

                    string DateReceived = "";

                    if (txtDateReceived.Text != "")
                        DateReceived = DateTime.ParseExact(txtDateReceived.Text, "G", CultureInfo.GetCultureInfo("en-US")).ToString("yyyy-MM-dd");
                    else
                        DateReceived = "NULL";

                    string DueDate = "";

                    if (txtDueDate.Text != "")
                        DueDate = DateTime.ParseExact(txtDateReceived.Text, "G", CultureInfo.GetCultureInfo("en-US")).ToString("yyyy-MM-dd");
                    else
                        DueDate = "NULL";

                    string ActualDate = "";

                    if (txtActualDate.Text != "")
                        ActualDate = DateTime.ParseExact(txtDateReceived.Text, "G", CultureInfo.GetCultureInfo("en-US")).ToString("yyyy-MM-dd");
                    else
                        ActualDate = "NULL";

                    String sql = "Insert into dbo.Documents(Ref,Subject,Src,Dst,Medium,Date_Prin
ted,Date_Received,Document_Type,Action_Required,Du
e_Date,Actual_Date,[Content],Tag,Issue_No,Attachme
nt,Notes,Assigned_To,Reply_Ref,Priority,Status,Res
ponse) values ('" + txtRef.Text + "','" + txtSubject.Text + "','" + ddlSource.Text + "' ,'" + ddlDestination.Text + "','" + ddlMedium.Text + "','" + DatePrinted + "','" + DateReceived + "','" + ddlDocumentType.Text + "','" + cbxAction.Checked + "','" + DueDate + "','" + ActualDate + "','" + txtContent.Text + "','" + txtTag.Text + "','" + txtIssue.Text + "','" + txtAttachment.Text + "','" + txtNotes.Text + "','" + ddlAssignedTo.Text + "','" + txtReplyRef.Text + "','" + ddlPriority.Text + "','" + ddlStatus.Text + "','" + ddlResponse.Text + "')";
  
                    cmd.Connection = con;
                    cmd.CommandText = sql;

                    con.Open();
                    //dataset object to get all select statement results
                    //DataSet ds = new DataSet();

                    //sql dataadoptor to fill dataset
                    cmd.ExecuteNonQuery();
                }
                if (con.State == ConnectionState.Open)
                {
                    con.Close();
                }

                MultiView1.SetActiveView(vRecord);
                txtRef.Text = string.Empty;
                txtSubject.Text = string.Empty;
                ddlSource.Text = string.Empty;
                ddlDestination.Text = string.Empty;
                ddlMedium.Text = string.Empty;
                txtDatePrinted.Text = string.Empty;
                txtDateReceived.Text = string.Empty;
                ddlDocumentType.Text = string.Empty;
                cbxAction.Checked = false;
                txtDueDate.Text = string.Empty;
                txtActualDate.Text = string.Empty;
                txtContent.Text = string.Empty;
                txtTag.Text = string.Empty;
                txtIssue.Text = string.Empty;
                txtAttachment.Text = string.Empty;
                txtNotes.Text = string.Empty;
                ddlAssignedTo.Text = string.Empty;
                txtReplyRef.Text = string.Empty;
                ddlPriority.Text = string.Empty;
                ddlStatus.Text = string.Empty;
                ddlResponse.Text = string.Empty;
            }

            }

You help will be much appreciated.

Re: How to receive JSON array?

Wed, 19 Jun 2013 01:06:10 -0700

The Latest Discounts on Skin & Champion: 6.18 - 6.21

From June 18th to 21th, the latest discounts on skin and champion for limited time in League of Legends will be released. During this period, you'll be able to buy Baron Von Veigar for 487 RP, Woad Ashe for 260 RP, Bandito Fiddlesticks for 260 RP, Rengar for 487 RP, Orianna for 440 RP, and Olaf for 395 RP.

http://lol.gameguyz.com/news/news/the-latest-discounts-on-skin-champion-6-18-6-21.html

[url=http://lol.gameguyz.com/]League of Legends[/url]
[url=http://lol.gameguyz.com/news.html]LOL S3 champions[/url]
[url=http://lol.gameguyz.com/videos.html]lol s3 masteries[/url]
[url=http://lol.gameguyz.com/pictures.html]league of legends artwork[/url]

How to receive JSON array?

Tue, 18 Jun 2013 05:49:21 -0700

Help me, please with receiving some JSON array

If i sent request(by Fiddler) with Request Body like this:

[{"name":"Homerius", "tonumber":"155555", "fromnumber":"166666", "text":"&&??!"}, {"name":"Stone", "tonumber":"9654999", "fromnumber":"999666", "text":"h9miii99!"}]

how can I receive it in controller?

I try to do something like this:

public HttpResponseMessage Post(JObject[] smspackage)
{
    List<MySMS> smses = smspackage.ToList<MySMS>();
    try
    {
        SMS_Repository.Add(smses);
        return Request.CreateResponse<MySMS>(HttpStatusCode.Creat
ed, smses);
    }
    catch (Exception)
    {

        return Request.CreateErrorResponse(HttpStatusCode.Expecta
tionFailed, "error");
    }
}

but it dont works...

sorry for my bad english

How to receive JSON array?

Tue, 18 Jun 2013 05:44:06 -0700

public HttpResponseMessage Post(JObject[] smspackage)
{
    List<MySMS> smses = smspackage.ToList<MySMS>();
    try
    {
        SMS_Repository.Add(smses);
        return Request.CreateResponse<MySMS>(HttpStatusCode.Creat
ed, smses);
    }
    catch (Exception)
    {

        return Request.CreateErrorResponse(HttpStatusCode.Expecta
tionFailed, "error");
    }
}

but it dont works...

sorry for my bad english

Re: how dose QR Code barcode library for ASP.NET works?

Mon, 17 Jun 2013 19:29:11 -0700

Where did you find the ASP.NET QR Code barcode generator library? There should be tutorial for it.

Re: FREE ASP.NET PDF EBOOKS

Mon, 17 Jun 2013 02:23:23 -0700

Nice sharing.
Many thanks for that.
But I wonder whether the free tools online have as many professional fuctions as the paid ones.
I used to read PDF files with another PDF viewer SDK whose processing way is simple and fast.
But I will try your sharing later and find more.
Thx again.

Best regards,
Arron

Re: FREE ASP.NET PDF EBOOKS

Mon, 17 Jun 2013 02:17:54 -0700

web form

Mon, 27 May 2013 23:14:09 -0700

Hai everyone. Can anyone explain about web form model

web form

Mon, 27 May 2013 23:12:18 -0700

Hai everyone. Can anyone explain about web form model

Re: Watermark an Image with an Image

Mon, 27 May 2013 19:33:05 -0700

According to your description, I think you need load image from .NET graphics in C#.NET.AND you can follow the steps below to Load Image from .NET Graphics.
Run Microsoft Visual Studio (2005 or later version);
Create a project with programming language - Visual C#;
Add RasterEdge.DotNetImaging.dll to your Visual C# applications;
Call RasterEdge .NET Image Namespace.

Re: Watermark an Image with an Image

Mon, 27 May 2013 19:29:26 -0700

According to your description, I think you need load image from .NET graphics in C#.NET.AND you can follow the step below to Load Image from .NET Graphics.
Run Microsoft Visual Studio (2005 or later version);
Create a project with programming language - Visual C#;
Add RasterEdge.DotNetImaging.dll to your Visual C# applications;
Call RasterEdge .NET Image Namespace:

general

Sun, 26 May 2013 06:16:18 -0700

Hai everyone. Is there any information regarding ASPX templates for Kentico 7

dot net training in chennai
lisaedward

<a href="http://www.fita.in/dot-net-training-in-chennai/">Dot

netTraining in Chennai</a>

general

Sun, 26 May 2013 06:13:30 -0700

Problem writing to a XML file

Wed, 15 May 2013 05:40:30 -0700

Hi,
Im using ASP.NET and C#.
Im trying to write to a Xml file but with no success, its just delete the old file and rewrite it with the new values, instead of adding to an exiting file.
this is my code:
http://pastebin.com/6b4tZv4g

Problem writing to a XML file

Wed, 15 May 2013 05:38:40 -0700

How to call Getslides method for ajax slideshow extender on demand( cu

Sun, 12 May 2013 23:55:55 -0700

Hi

I have reg Ajax slideshow extender doubt

I am trying to implement facebook style image slideshow on image click

Here I am using mutiple modalpopup and ajax slideshow extender on every modal popup

1) Please suggest me using mutiple modalpopup and ajax slideshow extender is best solution or I should modify the code.

And using mutiple modalpopup extender and slideshow extnder will affect web application performance?

2)On every page load GetSlides method is executing. i want to stop executing on every page load and should execute on demand

when particuler slideshow is going to popup only that servise method should be executted not others

Your Help will be apritiated, Look forrward for your help and support

<script runat="Server" type="text/C#">

[System.Web.Services.WebMethod]
[System.Web.Script.Services.ScriptMethod]
public static AjaxControlToolkit.Slide[] GetSlides()
{
return new AjaxControlToolkit.Slide[] {
new AjaxControlToolkit.Slide
("Images/Blue hills.jpg", "Blue Hills", "Go Blue"),
new AjaxControlToolkit.Slide("Image/1.jpg", "Sunset", "Setting sun"),
new AjaxControlToolkit.Slide("Image/2.jpg", "Winter", "Wintery..."),
new AjaxControlToolkit.Slide
("Image/3.jpg", "Water lillies", "Lillies in the water"),
new AjaxControlToolkit.Slide
("Image/4.jpg", "Sedona", "Portrait style picture")};
}

</script>

<script type="text/javascript">
function ShowSlider()
{
debugger
var panel =$find('mpslideshow1');

panel.show();

}

<input id="Image1" type="image" runat="server" src="~/Image/Sunset.jpg" onclick='javascript:ShowSlider();'
onmouseover="this.src='Image/Blue hills.jpg'" onmouseout="this.src='Image/Sunset.jpg'"
style="height: 100px; width: 100px" />

<div>
<asp:Panel runat="server" ID="pnlslideshow" BackColor="White" Height="400px" Width="400px"
Style="border: solid 2px red;">
<asp:Image ID="imagefhfd" runat="server" ImageUrl="~/Image/Blue hills.jpg" />
<asp:SlideShowExtender ID="SlideShowExtender1" runat="server" TargetControlID="imagefhfd"
SlideShowServiceMethod="GetSlides" AutoPlay="true" Loop="true" >
</asp:SlideShowExtender>
</asp:Panel>
<input type="button" runat="server" id="prevButton" style="display: none" />
<input type="button" runat="server" id="playButton" style="display: none" />
</div>
<input type="button" runat="server" id="dummybuton" style="display: none" visible="true" />
<asp:ModalPopupExtender runat="server" ID="mpslideshow1" BackgroundCssClass="modalBackground"
BehaviorID="mpslideshow1" TargetControlID="Image1" PopupControlID="pnlslideshow">
</asp:ModalPopupExtender>
In above code I have one image for that image one slideshow and modalpopup.

Like this I have 8 diff images and for every image one album, so I am going to use separte modalpopup, slideshow extender, javascript function, servicemthod for slideshowextender.

Thank you in advance

DevExpress TreeList checkboxe, possibly bind

Sat, 11 May 2013 14:41:10 -0700

Hi,
Trying to get a treeList in DevExpress to have two columns
of checkboxes that can be checked and unchecked, and are populated
in code upon load (from database, but that part of the code I can
do) and maintain their checked and unchecked states upon reloading
the page. In DevEx things can be tricky and it is difficult to
find solutions on google. Anyways, it took me a while to find
out how to check and uncheck boxes and at the same time have them
set to specific states upon load. But the problem is maintaining
those states. If you don't know DevEx, you will not be able
to answer this question correctly, trust me, it's not something
simple like "use ViewState". Anyways, it can be done by binding
a DataTable to the treeList, but the problem is when I bind,
the parent-child relationship is not there, even if the ID
and ParentID columns are defined and properly set.
If you have worked with DevEx and know what the difficulty with
what I'm talking about is, please help, as I have a deadline to meet
and google is getting me nowhere.

If the binding solution will not work, I would accept some other
workaround. I am using a DataCellTemplate in a TreeListCheckColumn
inside a TreeList. The problem is if I call an event from the
CheckBox OnValueChanged, it's not firing, and even previously
when I was able to call an event from either the ASPxCheckBox (DevEx
CheckBox) or from the CheckColumn, the Key of the row is not available.
If you know how to get the even to fire and get the row, and set
the check state, please let me know, the difficulty is not in getting
the event to fire, that's just a simple lack of memory/saving my
code on my part.
If you've used DevEx and tried this problem before, you will know
what the difficulty I'm talking about is. Anyways, if you know
a solution, please help.

DevExpress TreeList checkboxe, possibly bind

Sat, 11 May 2013 14:39:19 -0700

Re: how dose QR Code barcode library for ASP.NET works?

Sat, 06 Apr 2013 21:09:33 -0700

Hi
To generate QR code barcodes in ASP .NET Web Applications, you need to drag and drop a barcode generator control to your ASP .NET Windows Forms. For details, you may refer to the user guide you got.

Re: how dose QR Code barcode library for ASP.NET works?

Sat, 06 Apr 2013 21:05:56 -0700

Hi
To generate QR code barcodes in ASP.NET Web Applications, you need to drag and drop a barcode generator control to your ASP.NET Windows Forms. For details, you may refer to the user guide you got.

Best way to do authentication?

Sun, 17 Feb 2013 10:43:49 -0700

I've designed and built my database containing all user info and such. Should I use ASP.NET Web Site Administration toolkit(login, user database) which would then give me two separate databases that I would have to use when updating user info??? OR should I create my own authentication just using my one database??? If the latter is desired, can someone point me to the right resources in learning authentication and webpage-to-user association???

This is bugging me because I'm thinking I should have set up the administration stuff first, THEN added all my other tables to that database...