Morning stackoverflow,I have a repeater, with the following code in my aspx page;
<asp:Repeater ID="Contactinforepeater" runat="server">
<HeaderTemplate>
<h1>Contact Information</h1>
[code]...
I have a repeater control on a web page getting filled with data from a datatable in the vb.net code behind. I know the datatable contains 2 rows but for some reason only 1 row is being displayed in the repeater.
VB.Net
[Code]....
HTML
[Code]...
I'm having problem in inserting text from a textbox in which user write or copy some text which may contain special characters ( " , . ) etc. If there is any special character it get conflict with CommandText Syntax and generates error in inserting. I want to insert all these characters. How could i do it?
Code:
[code]....
The following CLR syntax works fine in my aspx page:
<%@ Page Language="C#" MasterPageFile="~/Views/Shared/Site.Master" Inherits="Website.MyBasePage`1[HomePageViewModel]" %>
But this C# syntax does not:
<%@ Page Language="C#" MasterPageFile="~/Views/Shared/Site.Master" Inherits="Website.MyBasePage<HomePageViewModel>" %>
Note, I am not using ASP.NET MVC, but this works fine if using System.Web.Mvc.ViewPage<> from ASP.NET MVC.
My MyBasePage looks like this:
public class MyBasePage<TModel> : Page where TModel : class {
public TModel Model
{
get { return (TModel)HttpContext.Current.Items["model"]; }
}
}
For reporting we used report RDLCs and displayed using an ASPX form. We implemented using the route as shown below. This resulted in forcing us to use the page route below and also to use the hyperlink instead of the normal Action Link. The question is how do we convert the asp:hyperlink ASPX syntax to Razor syntax.
//Custom route for reports routes.MapPageRoute( "ReportRoute", // Route name "Reports/{reportname}", // URL "~/Reports/{reportname}.aspx" // File );
<li><asp:HyperLink ID="hypReport" runat="server" NavigateUrl="<%$RouteUrl:routename=ReportRoute,reportname=StaffRpt%>">Staff Report</asp:HyperLink></li>
I am working with a sql server database with about 50 stored procedures. The database and stored procedureswere not created by me. The stored procedures all begin with a number in their name.
Example: 17P_Comsetter
The problem I am having is that if I try and execute the stored procedure at the command line in Query Analyzer,the query analyzer appears not to like that the stored procedure begins with a number. For example:
If I try an run the stored procedure as follows:
EXEC 17P_Comsetter
Then I get the following error message:
Msg 102, ..... Incorrect Syntax near '17'
I am using SQL server 2005. Does anyone know why I am getting this error message?
Is that possible to write namespace into some other file commonly.which should be automatically includes my page. namespace like:using System;
View 1 RepliesI need to count number of repeating and position where they repeat of all number in multidimensional array like this:nd result need to be:Number 1- two times on position 1, one time on position 2, two times on position 3Number 2- one time on position 1, two times on position 2, one times on position 3Number 3- 0 on position 1, one time on position 2, 0 on position 3
View 2 RepliesI would like to show number of successful orders made by each customer. Number of orders will be represented by number of smiley faces. Upon clicking on the smiley face, it will link to other web page showing full order histories made by this customer. Basically all smiley faces will link to the same page. How this can be done in ASP.NET? What control should I use?
View 2 RepliesI am building a ASP Menu Control with back ground images using CSS. Problem: Images repeat even though, I have image specified only on td. I have seen several threads, but could not help me. don't recommend CSS Control toolkit. I have tried many different variations.. hard luck! let me know if I can tweak some CSS to control this behavior. Here is the code.
<div id="menu">
I have an SQL 2005 db with a table named "industry_suppliers."
I've created a query to enable someone to search this table using 3 parameters.
The results need to be grouped by "product_description" (which is essentially a category). When displayed on an .aspx page, for example, the results need to look like this:
Apples
Acme Apple Company
Bradbury Orchards
Oranges
A1 Citrus Company
Belfast Growers, Inc
Bradbury Orchards
Notice how "Bradbury Orchards" is repeated under both categories. This is the result I want, EXCEPT in cases where someone wants to filter the search results by category. Let's say someone wants to search just for apple suppliers. The problem I'm having is that any record that appears under apples will also get listed again under any other categories associated with that record. So, searching for apple suppliers, the results are this:
Apples
Acme Apple Company
Bradbury Orchards
Oranges
Bradbury Orchards
I'm having trouble figuring out how to revise my query to avoid this problem.
[Code]....
I am trying to display a rdl file multiple times on a single reportviewer control in asp.net.Actually I have an rdl stub which displays monthly data and I want to repeat same rdl for each selected month. Suppose If I select month January to March then I want to display 3 reports for each month on same reportviewer asp.net control.I need this solution urgently.
View 6 RepliesDataRow[] filterRows = ds.Tables[0].Select("Running Status= case State when 'True' then 'Running' When 'False' Then 'Stoped' end Where Active='1' and State='1'");
this is not working showing syntax error syntax error:operand is missing
I'm making a website that requires ads being repeated down the length of a page with dynamic length. I want the ads to be displayed down the entire length of the page, but I won't know that length until after the data has been displayed. Is there built in functionality for this in .NET? If not, does anyone see any workarounds I could employ to do this for me?
View 1 RepliesI am consuming a web service in .aspx with a added web reference that links to http://www.webservicex.net/stockquote.asmx After this, I can get the result from
ebServiceX.StockQuote ws = new WebServiceX.StockQuote();String xmlString = s.GetQuote("XOM"); I am wondering how I can call the web service like GET, http://www.webservicex.net/stockquote.asmx/GetQuote?symbol=XOM+BAC
I put back ground image for a table and it is repeating.
How can i set no repeat
My code:
HtmlTable htmlTable = FindControl("TableTemplates") as HtmlTable;
sshtmlTable.Style.Add(HtmlTextWriterStyle.BackgroundImage, Backurl);
This is my table
<table align="left" width="396" border="0" cellpadding="0" cellspacing="0"
style="border: solid 1px #000000;" id="TableTemplates" runat="server">
<tr id="rowHeader" runat="server" height="100">
[Code]....
I have a Reportviewer displaying a matrix table. It has a column field called Country and 2nd/sub Col called City and with drill down activitied
On the report, when I expand Country, the Cities are exposed/expanded which is great but the problem is the header for columns now look like this:-
USA
================
Seattle, Washington DC, etc
================
USA, USA, USA, USA
================
So the "USA" is repeating on the header. I dunno how to remove the bottommost row of the header which is undesirable.
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
[Code] ....
Whenever I refresh the page the value from database update automatically even when i am not inserting
Database table
Id in primary key
Name nvarchar max
Message nvarchar max
I am trying to what i think is an easy task, but so far i have came up empty.
What i want to do is take a repeating table on a form i have and submit the employee IDs to a database using a web service.
I know how to submit them one by one, but i am thinking there is an easier way to do this instead of send the value to the web service, submit thee data, and then go till the last record.
I am currently using this:
<WebMethod(Description:="sends employee id to database")> _
Public Function SendMultiple(ByVal strEmployeeID as string) As String
Dim sqlCon As New SqlConnection()
Dim sqlCmd As New SqlCommand()
sqlCon.ConnectionString = "connection string information"
If sqlCon.State = ConnectionState.Closed Then
sqlCon.Open()
End If
sqlCmd.CommandText = "spInsertMultiple"
sqlCmd.Connection = sqlCon
sqlCmd.CommandType = CommandType.StoredProcedure
Dim Parameter0 As SqlParameter = New SqlParameter("@EmployeeID", strEmployeeID)
Parameter0.Direction = ParameterDirection.Input
sqlCmd.Parameters.Add(Parameter0)
Dim dr As SqlDataReader
dr = sqlCmd.ExecuteScalar
Dim strReturnedValue As String = "hello"
Return strReturnedValue
End Function
What is the best way to include repeating content on every page of a website such as a navigation menu?
View 2 RepliesI am bulding a dvd catalog and have a table called DVD which holds all my details about each dvd except Genre, Director and Actor as I want more than 1 Genre, Director, Actor per DVD so put these in seperate tables to avoid repeating the data and used a joining tabe to join the tables so the tables I have are
DVD, Genre, Director, Actor, DVDGenre, DVDDirector and DVDActor
I have now written a stored procedure to pull the info about 1 DVD out of all the tables to display on the webpage I have now got the info I want out of the tables but as the data is now in 1 table I have repeating data is there a way to stop the data repeating the stored procedure i have written is
[code]....
I'm trying to design a page that displays all suppliers by their location. I'd quite like this to work from a query that will automatically include new locations added in the future.
At the moment my design has a table that holds 'locations' with locationID and locationName fields. In my 'suppliers' table I also have a locationID to join them.
I'm not sure how to query the database to return all the suppliers in location 1, then all in location 2. (Or even sure of the terms I need to Google to get some examples!) For example:
Location 1
Supplier 1
Supplier 2
Location 2
Supplier 3
Supplier 4
I have a listview control on the page.. when the page binds and the listview is presented, there should be only 6 records.. well those 6 are displayed corrected at the top, but then below that is the same 6 records.. and below that is the same 6 records.. this goes on 6 times for the page.
If only 1 record is returned by the query. the page lays out ok and functions as expected.. is there a configuration i need to make to the listview to prevent it from repeating itself the number of records it returns?
I am using SSRS 2005.
I have a problem when I am exporting my report to Excel.
When exported to excel, I could see the table header on only the first page but not on all the pages. I have also checked the option "Repeat Header rows on New Page", but that didnt work.
I am new to using ASP.NET and I am using a datalist to represent the data obtained from querying a database.However,I am facing 2 issues:
1) If the string returned after querying the database is too long,the datalist is displaying the long string as it is which is not looking good.I am using Eval to fetch the data from the database for the sake of displaying.I need to have some page breaks so that the information fetched is presentable.
2) While repeating the datalist I want to hide all the columns except for 1 column whose value are unique.Upon searching I found this link: http://www.programmingknowledge.com/DataList.aspx but the code is in VB and I am not familiar with it.I am familiar with C#.
I am inserting the front end code for my datalist.I also want to know if datalist is the best control to present the data from the database.
[Code]....