I get this error at this part// string iDetailID = detail.EventDetail_ID.ToString(); // how do I solve it??

 protected void btnAdd_Click(object sender, EventArgs e)
    {
        string iDetailID = detail.EventDetail_ID.ToString();
        ShoppingCart.Instance.AddItem(iDetailID, detail);

        int ddlAmount, participants, itemNr;
        if (ValidateInput(out ddlAmount, out participants, out itemNr))
        {
            l1.Text = "";
            SetCookie();
            UpdateEventParticipantes(ddlAmount, itemNr);
            Response.Redirect(string.Format("Detail.aspx?id={0}", itemNr));
        }
    }

Select all Open in new window

I have an older website that build the home page by using an .aspx page as a frame, that includes other .aspx pages to make up the entire page. For example it is made up of about 4 different .aspx pages (i.e.: topMenu.aspx, leftPanel.aspx, righPanel.aspx, footer.aspx). These pieces are added by use of an include statement, into the HomePage.aspx.

  <!--leftPan -->
        <!--#include file ="../includes/leftPanel.aspx"-->
  <!--leftPan close -->

This is working but I need to make some changes to one of the included pages and I also need to add some C# code into the page. I've attempted to do this, based on my limited knowledge of this,  but am getting the following error:

Server Error in '/' Application.
Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: BC30205: End of statement expected.

Source Error:


Line 1:  <Script Runat="Server">
Line 2:  		private void ibSearch_Click(object sender, System.Web.UI.ImageClickEventArgs e)
Line 3:  		{
Line 4:  			// Get search terms


Source File: E:\Sites\Intranet\includes\leftPanel2.aspx    Line: 2


Show Detailed Compiler Output:

Show Complete Compilation Source:


Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.6.1087.0 

Select all Open in new window

my code is below:

<Script Runat="Server">
		private void 

Select all Open in new window

…

1 error saying
Feature 'interpolated strings' is not available in C# 5.  Please use language version 6 or greater.
here is the code!!

 protected void SetCookie()
    {
        if (Request.Cookies["aa"] != null)
        {
            Response.Cookies["aa"].Value = Request.Cookies["aa"].Value + "|";
        }

        Response.Cookies["aa"].Value = Request.Cookies["aa"].Value + $"{lblTitle.Text},{lblPrice.Text},{lblDate.Text},{lblLocation.Text},{lblStartTime.Text},{lblEndTime.Text},{lblParticipants.Text},{lblDescription.Text},{lblItemNr.Text},{imgEvent.ToString()}";
        Response.Cookies["aa"].Expires = DateTime.Now.AddDays(1);
    }

Select all Open in new window

Hi,
Further to this
https://www.experts-exchange.com/questions/29045050/Problem-to-delete-record.html?anchor=a42223836¬ificationFollowed=192790883#a42223836

how to adjust the codes to be able to get value of Label, in JS codes.

I have a grid view that when the user select a button on the grid an user control will show on the bottom of the page with the details. As far as I can see the prerender part of the user control is not executing.

<asp:GridView ID="Grid" runat="server" AutoGenerateColumns="False" OnSelectedIndexChanged="Grid_SelectedIndexChanged" OnRowCancelingEdit="Grid_RowCancelingEdit" DataKeyNames="OrderId">

        <Columns>
            <asp:BoundField DataField="OrderId" HeaderText="Order Id" ReadOnly="True" SortExpression="OrderId" />
           
Removed some fields

Button field

            <asp:ButtonField ButtonType="Button" CommandName="Select" Text="Details" />
        </Columns>
    </asp:GridView>

User control called
        <uc2:CustOrderDetail  runat="server" ID="CustOrderDetail" Visible="False" />
When select button is selected Grid_SelectedIndexChanged is called
Session["OrderId"] = Grid.SelectedRow.Cells[0].ToString();
User control prerender code
protected void PreRender(object sender, EventArgs e)
    {
        if (Session["OrderId"] != null)
        {
            Populate();
            this.Visible = true;
     
        }
        else
        {
            this.Visible = false;
        }
    }

There must be some thing there - the following two issues must be related to one reason, I spend two days to understand why

ISSUE 1
        var y2 = 2000;
        alert(y2);   (this line gives alert 2000 which means y2 value is 2000)
        alert(y2 == 2000);   (this line gives alert true which also means y2 value is 2000)

        if (y2 = 2000 ) {
            alert("y2 is equals 2000");    (never get to this alers !!!!!     any Idea?)
            return false;
        }

ISSUE 2
assuming textbox1.text="11-1-2000"
assuming textbox2.text="11-1-2001"

        var T1= document.getElementById("<%=Textbox1.ClientID%>");
        var year1 = T1.value.split("-")[2];
        var T2= document.getElementById("<%=Textbox2.ClientID%>");
        var year2 = T2.value.split("-")[2];
       
        alert(year1);   (this line gives alert 2000 which means T1 value is 2000)
        alert(year2);   (this line gives alert 2001 which means T2 value is 2001)
       
        if (year1 > Year2)
        {
            Alert("Year1 is GT Year2")   (never get to this alers !!!!!     any Idea?)
            return false;
        }

If there is 0 participants available, I want a label saying 'no available participants for this event' so the user cannot select qty from dropdownlist!! But there is this error

   int qty;
    int id;
    protected void Page_Load(object sender, EventArgs e)
    {
        FillPage();
        qty = get_qty(id);
        if (qty == 0)
        {
            lblParticipants.Visible = false;
            ddlAmount.Visible = false;
            btnAdd.Visible = false;
            l2.Text = "no available participants for this event";          
        }
    }
   public int get_qty(int id)
    {
         id = Convert.ToInt32(lblItemNr.Text);
        SqlConnection con = new SqlConnection(_connStr);
        if (con.State == ConnectionState.Open)
        {
            con.Close();
        }
        con.Open();
        SqlCommand cmd = con.CreateCommand();
        cmd.CommandType = CommandType.Text;
        cmd.CommandText = "select * from EventDetail where id=" + id + "";
        cmd.ExecuteNonQuery();
        DataTable dt = new DataTable();
        SqlDataAdapter da = new SqlDataAdapter(cmd);
        da.Fill(dt);
        foreach (DataRow dr in dt.Rows)
        {
            qty = Convert.ToInt32(dr["eventParticipants"].ToString());
        }
        return qty;
    }  

Select all Open in new window

I have the following if statement but need to add else when the case 12,15,18,22 is not I only need to show the OutTracking and InTracking currently now it shows nothing if I have other than case 12,15,18,22.  I need to show without a hyperlink and plain text

[Rule("r100")]
        public void r100Implementation(string OutTracking, string OutTrackingAlias, string InTracking, string InTrackingAlias)
        {
            if (OutTracking != null)
                switch (OutTracking.Length)
                {
                    case 12:
                    case 15:
                    case 22:
                        // fedex
                        UpdateFieldValue("OutTrackingAlias", "<a href=\"https://www.fedex.com/fedextrack/?cntry_code=us&tab=1&tracknums="
                        + OutTracking
                        + "&clienttype=dotcom\" target='_blank'>"
                        + OutTracking
                        + "</a>");
                        break;
                    case 18:
                        // UPS
                        UpdateFieldValue("OutTrackingAlias", "<a href=\"http://wwwapps.ups.com/WebTracking/processInputRequest?sort_by=status&tracknums_displayed=1&TypeOfInquiryNumber=T&loc=en_US&InquiryNumber1="
                        + OutTracking
                        + "&clienttype=dotcom\" target='_blank'>"
                        + OutTracking
                        + "</a>");
                        break;
                }
               

Select all Open in new window

…

Hello,
How can I connect to a stored procedure and display its content on a web page which is desktop/ mobile friendly in a tabular form.
Regards

<asp:GridView ID="gvType" runat="server" AutoGenerateColumns="False" OnRowDeleting="gvType_RowDeleting" DataKeyNames="EventType_ID" >
            <Columns> 
    <asp:TemplateField HeaderText="Select">
   <HeaderTemplate> <asp:CheckBox ID="chkAll" runat="server" onclick="javascript:SelectAllCheckboxes(this);" />  </HeaderTemplate>
   <ItemTemplate> <asp:CheckBox ID="chkSelect" runat="server" AutoPostBack="true" OnSelectedIndexChanged="Type_Selected" /> </ItemTemplate>
   </asp:TemplateField>
                 <asp:CommandField ShowDeleteButton="True" ShowEditButton="True"/>
                <asp:BoundField DataField="EventType_ID" HeaderText="EventType_ID" ReadOnly="True" SortExpression="EventType_ID" />
                <asp:BoundField DataField="EventTypeName" HeaderText="EventTypeName" SortExpression="EventTypeName" />
                </Columns>
        </asp:GridView>

Select all Open in new window

Code behind Codes

 EventType aType = new EventType();
    protected void Page_Load(object sender, EventArgs e)
    {
       /* if (!this.IsPostBack)
        { this.BindGrid(); } */

        if (!IsPostBack)
        {
            bind();
        }
    }
    protected void bind ()
    {
        List<EventType> eveList = new List<EventType>();
        eveList = aType.getAllEventType();
        gvType.DataSource = eveList;
        gvType.DataBind();
    }
  protected void gvType_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        int result = 0;
        EventType type = new EventType();
        string categoryID = gvType.DataKeys[e.RowIndex].Value.ToString();
        result = type.EventTypeDelete(categoryID);
    }

Select all Open in new window

class code

 public int EventTypeDelete(string ID)
    {
        string queryStr = "DELETE FROM EventType WHERE EventType_ID=@ID";
        SqlConnection conn = new SqlConnection(_connStr);
        SqlCommand cmd = new SqlCommand(queryStr, conn);
        cmd.Parameters.AddWithValue("@ID", ID);
        conn.Open();
        int nofRow = 0;
        nofRow = cmd.ExecuteNonQuery();
        conn.Close();
        return nofRow;

    }//end Delete 

Select all Open in new window

Here is my aspx page

 <asp:GridView ID="grdDetails" runat="server" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" BackColor="White" BorderColor="#999999" BorderStyle="Solid" BorderWidth="1px" CellPadding="3" DataKeyNames="EventDetail_ID" ForeColor="Black" GridLines="Vertical" Width="85%" OnPageIndexChanging="grdDetails_PageIndexChanging" OnRowDeleting="grdDetails_RowDeleting">
            <AlternatingRowStyle BackColor="#CCCCCC" />
            <Columns>
                <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
                <asp:BoundField DataField="EventDetail_ID" HeaderText="EventDetail_ID" ReadOnly="True" SortExpression="EventDetail_ID" />
                <asp:BoundField DataField="EventType_ID" HeaderText="EventType_ID" SortExpression="EventType_ID" />
                <asp:BoundField DataField="eventDetailName" HeaderText="eventDetailName" SortExpression="eventDetailName" />
                <asp:BoundField DataField="eventDate" HeaderText="eventDate" SortExpression="eventDate" />
                <asp:BoundField DataField="eventPrice" HeaderText="eventPrice" SortExpression="eventPrice" />
                <asp:BoundField DataField="eventDesc" HeaderText="eventDesc" SortExpression="eventDesc" />
                <asp:BoundField DataField="eventLocation" HeaderText="eventLocation" SortExpression="eventLocation" />
                <asp:BoundField DataField="startTime" HeaderText="startTime" SortExpression="startTime"

Select all Open in new window

…

I'm trying to filter a gridview from a gridview with checkboxes!! I have this error at
' if (chk.Checked)'
Below is part of the code!!

  private void BindGrid()
    {
        string constr = ConfigurationManager.ConnectionStrings["EventContext"].ConnectionString;
        string query = "SELECT EventDetail_ID, EventType_ID, EventDetailName, eventDate, eventPrice, eventDesc, eventLocation, startTime, endTime, eventImage, eventParticipants FROM EventDetail";

        string condition = string.Empty;

        foreach (GridViewRow row in grdDetails.Rows)
        {
            CheckBox chk = (CheckBox)row.FindControl("chkSelect");
            if (chk.Checked)
            {
                string eventtypeid = row.Cells[0].Text;   
                // i am trying to get the bounded field value of eventtype ID field here
                condition += string.Format("'{0}',", eventtypeid);
            }
        }
        if (!string.IsNullOrEmpty(condition))
        {
            condition = string.Format(" WHERE EventType_ID IN ({0})", condition.Substring(0, condition.Length - 1));
        }
        using (SqlConnection con = new SqlConnection(constr))
        {
            using (SqlCommand cmd = new SqlCommand(query + condition))
            {
                using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
                {
                    cmd.Connection = con;
                    using (DataTable dt = new DataTable())
                    {
                        

Select all Open in new window

…

In my .net c# project I have two jason like this

Json1

{"WindowsServices":[{"name":"SNMP","statusID":"1","StatusMsg":"Stopped","FullStatus":"SNMP,1"},{"name":"SNMPTRAP","statusID":"1","StatusMsg":"Stopped","FullStatus":"SNMPTRAP,1"}]}

Select all Open in new window

Json2

{"WindowsServices":[{"name":"SNMP","statusID":"4","StatusMsg":"Running","FullStatus":"SNMP,4"},{"name":"SNMPTRAP","statusID":"1","StatusMsg":"Stopped","FullStatus":"SNMPTRAP,1"}]}

Select all Open in new window

I need to compare this to json and get the result of the modified part oly

{"WindowsServices":[{"name":"SNMP","statusID":"4","StatusMsg":"Running","FullStatus":"SNMP,4"}]}

Select all Open in new window

Thank you for your help!!