I have a .Net 4 Chart Control bound to stored proc. For some customer selected queries the chart will be empty. I would like to display a "No data" message in the empty charting area so customers understand why the chart is empty. I haven't been able to find any information about how to do this.
View 1 RepliesI inherited some C# code behind that queries a database table and need to add something that displays a "No results" message (using a Label web control, perhaps) if the query doesn't return any records. I'm just learning C# but am coming up short on how to do this. Would anyone be kind enough to point me to an example, or demonstrate? Here's the code I inherited (the programmer who wrote this is no longer available). This is the code behind from the search results page:
[Code]....
I have this code:
Dim Result As New DataTable
DataAdapter.Fill(Result)
'bind data to visible surname/name grid
If Result.Rows.Count = 0 Then
NoInputBottom.Text = "No Results. Please widen your search criteria and try again"
NoInputTop.Text = "No Results. Please widen your search criteria and try again"
Else
GV.DataSource = Result
GV.DataBind()
End If
I have also tried moving the check to the gridview like so:
If GV.Columns.Count = 0 Then
NoInputBottom.Text = "No Options Selected: Please select your search criteria and try again" NoInputTop.Text = "No Options Selected: Please select your search criteria and try again" End If
When I run the code. the noinput labels do not have value, the null check seems to be failing? how to display a message if the search returned no reults.
Is there a way to display a "default" message on a MS Chart Control if there is no data to chart?
I have a chart, with some controls that allow the user to pick various date ranges. If there is no data to be charted in that date range, it currently just displays nothing (or at least it shows the legend, and background, but that's it.)
I want there to be a message saying "no data for this period" or something instead.
I want to display sql query results in my web application (asp.net webpage) dynamically at the run time. But I don't know how to do that. Is there any control to do that? Or is there any code? Could you give some examples?
View 4 RepliesI am developing a web form for search capability. The search query should return records from three different tables. How to display these three table records in three different rows. The search query should get the results from Table 1 and Table 2. Table 2 and Table 3 has a parent child relation ship. Which controls can I use for this purpose?
View 5 Repliesi want if i search UserName 'xdeeeee' that is not exist in database then a label should display saying "Sorry ‘USER NAME’ not found".
have a look below picture.
<asp:TextBox ID="SearchByUserName" runat="server"></asp:TextBox>
<asp:Button ID="SearchByTagButton" runat="server" Text="SEARCH" OnClick="SearchByTagButton_Click" /><br />
[Code].....
I am displaying some query results in a div (table format). Is it possible to do pagination in vb.net in a div . Because i am not using any list view or data repeater or data grid control.
BID StartDate EndDate BidAmount Status
1 10/12/2010 14/12/2010 100000 Approved
2 05/07/2010 07/07/2010 500000 Pending for DAC
I want to display only 10 records per page.
I'm trying to add a vertical line to an area chart like the following...
<asp:Chart id="chtTriage" Width="545" BackColor="#f2f2f2" runat="server">
<Series>
<asp:Series Name="srs" ChartType="Area" Color="LightGray">
<Points>
<asp:DataPoint XValue="0" YValues="1000" />
<asp:DataPoint XValue="5" YValues="2500" />
<asp:DataPoint XValue="10" YValues="6000" />
<asp:DataPoint XValue="15" YValues="4000" />
<asp:DataPoint XValue="20" YValues="2500" />
<asp:DataPoint XValue="25" YValues="2000" />
<asp:DataPoint XValue="30" YValues="1500" />
<asp:DataPoint XValue="35" YValues="1200" />
<asp:DataPoint XValue="40" YValues="1000" />
<asp:DataPoint XValue="45" YValues="500" />
<asp:DataPoint XValue="50" YValues="0" />
</Points>
</asp:Series>
</Series>
<ChartAreas>
<asp:ChartArea Name="chaTriage" BackColor="#f2f2f2">
<AxisY Title="Number of Dogs" Interval="1000" IntervalType="Number" IsMarginVisible="false">
<LabelStyle Font="Aerial, 8.25pt" />
<MajorGrid Enabled="false" />
</AxisY>
<AxisX Title="Triage Points" Interval="10" IntervalType="Number" IsStartedFromZero="true" Minimum="0" IsMarginVisible="false">
<LabelStyle Font="Aerial, 8.25pt" />
<MajorGrid Enabled="false" />
</AxisX>
</asp:ChartArea>
</ChartAreas>
</asp:Chart>
i need to be able to reset a HiddenField's value if my AutoCompleteExtender returns no results (specifically, if the user searches for something that's not in the list/database). I have this JS code now:
[Code]....
How would I modify this to check if the list is null? Currently it seems to just leave the value as it was previously.
How can I SELECT second if first SELECT returns nothing?
View 8 RepliesI am actually using 2 type of queries in my website e.g
These Queries are from my stored procedures
SELECT * FROM TblName WHERE FREETEXT(ColumnName, @parameter)
AND
SELECT * FROM TblName WHERE CONTAINS((Column1, Column2), @parameter))
I have enabled Full Text Indexing on my tables both local and on my hosting company MS SQL Server.
The above queries are working fine on my local database and return results but these queries return nothing when i try to run them on hosting company MS SQL Server.
I have identical data on both MS SQL Servers and both servers are 2008.
I have a routine that submits a SOAP request using HttpWebRequest and WebResponse. If the SOAP Request fails the server sends back HTTP/1.1 500 Internal Server Error. When I trap the error I have yet to find a way to view the body of the reply which contains the fault code. Is there a way to retrieve the message body when the server returns a 500 internal Server Error? In body of the reply which I am not able to retrieve.
faultstring xml:lang="en-US" Specified argument was out of the range of valid values.
I have a WCF client test harness where I'm using a "client message inspector" endpoint behavior to "pick off" raw requests and response messages going to and from a service and save them for later display in the UI.
This works great, except for the use case where invalid credentials are passed (Basic Authentication). The server returns an HTTP 401 along with a SOAP fault in the body containing details of what happened. I have no control over the service, so this behavior cannot be changed.
Because the HTTP 401 is returned as a WebException, my message inspector never fires and I can't get to the raw response. This exception eventually gets to the UI in the form a MessageSecurityException.
Is there any way to suppress this so the message inspector's AfterReceiveReply still fires? or is there somewhere else I can access the entire raw response?
I have a function which returns dataset after execution of sql statements
If the dataset retruns rows than he data shld be dislayed in reporting services
Else display no rows avaliable
But currently even if there are no rows as per the given condition, the earlier data gets displayed
When stepping through my LINQ query it returns dataq,but when I try to return it as Json Result,I get the error 'The query results cannot be enumerated more than once'.
Here is my LINQ and stored proc,
[Code]...
i developed one simple xml program in asp.net i ll display the xml content in the webpage specific area of the page but i am trying to use this code
string strPath = Server.MapPath(@"App_Datamain_page.xml");
XmlTextReader textReader = new XmlTextReader(strPath);
textReader.Read();
// If the node has value
while (textReader.Read())
{
// Move to fist element
textReader.MoveToElement();
Response.Write(textReader.Value.ToString());
}
this code ll print the xml output in top of page . how to avoid this and to display the outpur some specific area of the page.
I have implemented multilingual in my application. The text display is not proper for different language. For example in Spanish the label text is fully visible but if it will display in french then the text width is getting increased so it is not fully visible and for some other langauge it comes in second line, how to set the width and height according to langaue or is there any generic format to set?
View 3 Repliesno Massagebox not working in the web
at catch I want appear windows and retuen to....
try
{
}
catch (Exception ex) {Console.WriteLine("Error reading from", ex); }
I used ModalPopup Control on this link, [URL]How should I write the code that to close pop up by click the area outside the pop up panel?I use AjaxControlToolkit-Framework3.5SP1
View 7 RepliesI've created a script that adds user data to a database, however, I'd like to check the email entered is unique within the database.
I've already started the query at comm2 but not sure how to progress the script so it tells the user if the email address is already taken.
[code]....
How come my query returns 0 records?
SELECT WebSiteID, BanDate
FROM tblWebSite
WHERE (BanDate <> NULL)
The BanDate is a date column. There are date times through the table in this column. I just want the ones with a date and ignore the rest.
I am trying to figure out why this service does not return any data. The service does not error out is just doesn't return any data. When I take the Linq into LinqPad the query returns exactly as I expect. So I am wondering if the problem is getting my return data into a List<string>??
[Code]....
I don't know what else to say to help. When I set a break point on the "return LoanStats" line a quick watch shows an empty results view.
datacontextclass dc=new datacontextclass ();
var news= dc.GetNewsCompany(Int64.Parse ( _idCompany));
if (news.GetEnumerator().MoveNext())
{
foreach (var item in news)
{
drpListNews.Items.Add(item.Title);
}
}
return error:{"The query results cannot be enumerated more than once."}
how can check result != null in LINQ;
I created a website. I would like to include a search box that searches the whole website and returns the results.
View 2 Replies