The query I used here is
SELECT top '"+lblCount.text+"' Company_Id, CompanyName, All_Countries,All_Industries,Employees,Revenue, Status FROM SN001CompanyTable where Client_Id=100 ORDER BY [Company_Id] DESC
but its not showing proper results..
In this lblCount contains the no of row to be displayed..
how to disabled the word label in my aspx page if my query is null... i dont like to show the word label in my aspx page.
im using c# .net
I'm working on a job seeking website where the job seeker can search for a job , the search box is located in the master page, that's why i passed the keywords as a query string, and then the matching jobs will be displayed in a listview.
the keywords will be taken from two controls: a drop down list which the user can choose the location of the job, and a text box where he can type a keyword.
the select command of the sqlDataSource of the data list is as the following:
[code]....
I have an entry page that contains a datalist. I also have an ascx user control page that when it runs on page load, renders an html table template which contains category information from an SQL self referencing table. When the SQL query run on page load, it bind the results to a datalist called dlCategory, and repeats for all rows that have no value in a field in this SQL table called ParentCategoryCode. The SQL table is called ServiceRequestCategories and basically consists of CategoryCode, CategoryTitle, and CategoryDescription, and may or may not have a ParentCategoryCode associated with it.
Records without a ParentCategoryCode are top level categories, and anything that has a ParentCategoryCode are second or third level categories. The way I have the data set up, it ends up being 4 rows that are returned and rendered as 4 html tables. Each one of these is tied to the user control, and each user control runs another datalist, and shows all CategoryTitle values for each Category that has a ParentCategoryCode (second level categories). This works when you click on a LinkButton for any CategoryTitle. This all works fine.
My question is, how can I use an SQL select query to plug the value of the CategoryTitle into a label called lblCategoryBreadCrumb on my main entry page? Here is my code, but it does not seem to work.
Protected Sub ShowBreadcrumbLabel()
Dim strSQL As String
Dim dsData As DataSet
Dim dtData As DataTable
[Code] .....
I HAVE A GRID VIEW IN asp.net + VB Code. There is a drop down list and the selected data is displayed in web page. I placed a label in web page and code behind i used following code.
Protected Sub GridView1_DataBound(ByVal sender As Object, ByVal e As System.EventArgs) Handles GridView1.DataBound
Label1.Text = GridView1.Rows.Count.ToString()
Dim ONYO As Integer = 0
Dim DONE As Integer = 0
For i As Integer = 0 To GridView1.Rows.Count - 1
If GridView1.Rows(i).Cells(0).Text = "ON YO" Then
[Code] .....
I want to display no. of rows a table contain from database on label, how can i do that..
View 1 RepliesI have created a stackedbar chart that has the points populated in code behind. Each stacked group consists of 2 series. When I run the chart everything displays correctly except there is only one label on the xaxis. I have tried setting the xaxis label text to the name for each series but all this does is change it to the first series name, and not even under the correct position. Setting the series labels to enabled shows the correct data on the correct bars, but I would like it on the xaxis!
Tried changing the xaxis interval to 1 which seems to be a common issue for people but to no avail. Is it because I'm using a new series for each bar? Is there a way to label stack groups on the xaxis instead of one of the series?
I am using a treeview control and just want to add nodes dynamically. On selecting a node the results based on that node must be shown below.
View 1 RepliesI have a query that returns one row so I want to display it in the Label, but I can't find the property DataSource on it. How can I do this ?
View 2 RepliesCan i customize gridview to show Reuslt summary in the footer or pager like
[Results: 1- 10 of 2000]
I am trying to change the Impage at certain time interval(5 images),its working fine in my system when i launched in windows server2008-IIS7.5 it is showing only one image other 4 are not displaying, i have navigated the images in root site folder but it is showing only one image other images are not.
[Code]....
Protected Sub gettickvalue(ByVal sender As Object, ByVal e As EventArgs)
Dim RandomNumber As New Random()
Dim n As Integer = RandomNumber.[Next](1, 5)
imgBanner.ImageUrl = System.[String].Concat("/images/pcb", n.ToString(), ".jpg")
End Sub
I have web.sitemap file that is setup properly.I have a menu that is displaying the parent but popouts are not displaying the sublevel menu items, the popup appears but there are no links.The sitemappath does not even show up on the screen.web.sitemap
[Code]....
masterpage menu & sitemappath controls
[Code]....
i added an independent sql count statement in the code behind and want to display the results of the count in a datalist. the query needs a the parameter value of "courseID" to work except i am having difficulty getting the value to string.
the error i'm getting is "Object reference not set to an instance of an object." referencing:
int index = Convert.ToInt32((sender as DataListItem).ToString());
here is the statement under DataList Load
[Code]....
I am new to Chart controls and I'm trying to display a label (text) for a datapoint in a chart instead of a value.
I'm using the following code to load the datapoints and to add label information for each point (each label will be different).
But when the chart is displayed all datapoint labels are blank (if I use the first line of code) or the labels are all the same, containing the last rows value (if I use the 2nd line of code).
Can someone tell me what I am doing wrong? Is there something in the .aspx that I need to set?
[Code]....
For example:
I have 3 rows in my grid with the label data: "Cat", "Dog", "Mouse". But the label in my chart is blank for all points when I use the first line of code and when I use the second line of code the label is "Mouse" for all points.
I am working on a project, and I wish to use a master page. I want to experiment with it first. I add a master page; then, I add a default page. I copy some text and paste it in the default page, and I type this is the master page on the master page. When I run the project, the text in the default page always appear on top. How do I get the data on the default page to display to the right of the page, and the text on the master page to appear to the left.
Also, I tried it using menu. I got the same result. The menu was on the master page, but it was displayed at the bottom of the default's page text. I added three pages and was able to naviage between the pages. When I navigated to the second page without text, the menu appeared on the left. I added some text to the second page, and it does the same.
I am building a website that isnt displaying properly accros browsers. It displays fine in FireFox and IE but does not display correctly in IE compatibility view or Safari. The problem is that I have a background header image that is different on the left and right so I cant do a repeat and center the content div. I was able to acheif the effect by building a table with three columns. But on safari, the backround of the outside columns does not show because there is no content in those columns. In IE compatibiliy mode, the columns disappear and the center column is shifted to the left. Anyone have any ideas? HEre is my code.
<body>
<form id="form1" runat="server">
<table cellpadding="0" cellspacing="0" style="width: 100%">
<tr>
<td style="background-image: url(Images/MasterPage/BKGbodyLeft.png); background-repeat: repeat-x;
background-position: left top">
</td>
<td style="width: 1020px">
<div>
<div id="Header">
</div>
<div id="Content" style="padding-top: 20px; height: 630px">
<asp:ContentPlaceHolder ID="ContentPlaceHolder1" runat="server">
</asp:ContentPlaceHolder>
</div>
<div id="Footer">
</div>
</div>
</td>
<td style="background-image: url(Images/MasterPage/BKGbodyRight.png); background-repeat: repeat-x;
background-position: left top">
</td>
</tr>
</table>
</form>
</body>
I have a model called 'BusinessPage' which can be associated with 1 or more 'BusinessPageCategories'. So I've got a 3rd table called 'BusinessPagesInCategories' that links these two.I am trying to get a paged recordset of BusinessPages, along with the total number of records (I may have 100 rows in total but only return 20 at a time, but I pass back an int containing that total number in addition to the 20 rows).The problem I have is that, since I implemented the Many-To-Many relationship, it was bringing back the same BusinessPage row x times (where x is the number of categories that BusinessPage is associated with). I only want a single instance of each business page to be returned. So I added the following to my NHibernate Criteria to give Distinct BusinessPage results..SetResultTransformer(CriteriaSpecification.DistinctRootEntity);
Whilst this works for me, in that I'm now correctly getting a single row per BusinessPage (and my Categories property within each BusinessPage contains the correct x categories that it's assigned to), my row count is not reflecting that 'distinct' count - instead, if I have just 1 BusinessPage record which is associated with 3 categories, the row count is 3!?!
public virtual int BusinessPageId { get; private set; }
public virtual IList<BusinessPageCategory> Categories { get; set; }
public virtual string BusinessName { get; set; }
[code]...
ASP.Net Page layout is not displaying properly in QA machine but is displaying correctly in Dev Machine. What could be the issue? We are using ASP.Net 2.0
View 1 RepliesI want to count the number of results results returned by my query and print the number to a literal on the page.How would I do that?
View 2 RepliesI have code that's working beautifully on my development machine,but when deployed to the server is throwing null reference exception.So,I can't step through the code,but I've pinned down the culprit.But now I am puzzled.Here's the code.The question is below.
Dim certs = From p In persons _
Select New Certificate( _
p.Value, _
New CertificateData.Seminar(thisEvent.Seminar.Name, _
[code]...
In the code above persons is a dictionary of custom class,and certs is of IEnumerable type.Now here's the quandary.The first line that sets the label returns False,so certs is not null.But the second line throws an null reference exception.
see the below code. just sample page.
<body>
<form
id="form1"
runat="server">
<div>
<asp:GridView
ID="press_dl"
runat="server"
AutoGenerateColumns="False"
PageSize="1"
ShowHeader="False">
<Columns><asp:TemplateField><ItemTemplate>
test head
test shortnews
</ItemTemplate>
<HeaderTemplate>
</HeaderTemplate>
</asp:TemplateField></Columns>
</asp:GridView>
</div>
</form>
</body>
Protected
Sub Page_Load(ByVal
sender As
Object,
ByVal e
As System.EventArgs)
Handles
Me.Load
If
Not Page.IsPostBack()
Then
bind_press()
' bind_events()
End
If
End
Sub
Sub bind_press()
ds = Nothing
ds = New DataSet
Dim query
As
String
query = "select top 1 * from tbl_press order by press_id desc"
myConnection.Open()
da = New OleDbDataAdapter(query, myConnection)
da.Fill(ds, "Press")
myConnection.Close()
press_dl.DataSource = ds.Tables("Press")
press_dl.DataBind()
End
Sub
its dislpayes like this
test head test shortnews
test head test shortnews
this gridview displaying twice. i dont know why.
I have 36 Separate Checkboxes [ 1-36] ... if user selects 9,12,15th checkboxes the count must be displayed as 3 ... I want to display the count of checked checkboxes..
Platform: Web
Language: VB
Tool : Checkbox
i have an html editor where a user can put in some text.the thing is that when trying to display this text on a different page results in displaying the html that was saved by the editor.i want to display the text in a text box (if possible), with the special attributes(bold, itali etc.i currently get the text with the html tags.
View 5 Replies[URL] - Internet explorer is not displaying the webpage instead it is searching the results related to localhost.
If i browse the virtual directory then the webapplication is working absolutely fine. everything is being configured properly and i also checked the services which are also running.
I have a set of controls that enable the user to search one of two fields in a given SQL Server table. The ddlSearch dropdownlist specifies the field to search. The txtSearch textbox contains the search string. I have the following code working fine, except search string isn't being passed to my listview:
[Code]....
I tried adding a DataBind after End Using, but the listview still won't provide the search results. Note that I also have an EntityDataSource on page.
Am I adding this to the wrong event? Should this code be added to PageLoad instead of click event of Submit button? What other issues should I address? Is it possible for ListView to handle the search by itself? That is, do I even need other dropdownlist and textbox controls, or is there functionality builit into the listview control to search? Finally, can I enable a checkbox for each returned item? I will need this so that the user can select items to add to their order.