I have the following simple linq to sql statement:
[Code]....
Instead of showing me the UserName from the aspnet_Users table, it showed me the SQL select statement.
I have a SQL statement as below
SELECT [Motor]
,[Time]
FROM [logger].[dbo].[motor]
WHERE day([Time]) = day(getdate())
ORDER BY [TIME]
This is a very basic table that gives me the status of a motor at a given time. All i want is a select statement that will give me the latest result if possible. I can get it so it gives all of todays results but if i could get it that it only displays the latest result that would be great.
Im using SQL Server 2005 and im using stored procedures. Is this possible? i need to get a number of results and do it in one SELECT statement or just one result set. Im using MS Chart Controls for reporting and they cant seem to process multiple result sets this is my problem, so basically to run a barchart i need to assign a column to the X axis and a column to the Y axis and it will then display my results.
My stored procedure below returns a result set with columns subpolicy_name, building_name, floor_name, room_name and total_savings. Im just wondering is it possible to split my total_savings column into 4 columns, for example subpolicy_savings, building_savings, floor_savings and room_savings, i need everything in a separate column. If you run this stored procedure you will see the result set.
[Code]....
i am trying to see the datasource that was added previously. but while trying to see..there is not any configure data source option..how to get it.
View 1 RepliesI have to display the contacts in gridview.I'm using objectdatasource. I have given the select method of objdatasource below:
Code:
Imports Microsoft.VisualBasic
Imports system.Data
Imports System.Data.SqlClient
Imports System.Collections
Imports System.Collections.Generic
Public Class Contactmanager
Dim conn As New SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings("localConnectionString").ToString)......
I have a drop down, the drop down select values looks fine in mozilla but it doesnot show the full content in IE6 and 7,8.My Code
<td >
<asp:DropDownList id="drpttrainer" runat="server" Width="150px" OnSelectedIndexChanged="drpttrainer_SelectedIndexChanged" AutoPostBack="True">
[code]...
I have a listview that is showing its result by using a linq query. The linq query goes like this.
[Code]....
* db.Varer: Varer is a table that contains basic product information like proudct name, product nr. etc. ** a.fk_kategori_id == CatParamId : I'm just saying limit the result according to the Category ID (a.fk_kategori_id). The category id is coming from a dropdownlist (CatParamID) *** Join: Besides the Varer (Product) table I also have another table, Sizes. This Sizes table contains 6 columns (ID_Sizes (int) primary key and the columns: OneSize, S, M, L, XL, XXL all are bit (true or false)). There is a relationship between Varer table and Sizes table. It says that I can only insert a value into the "fk_sizes_id - column" of varer table if that value already exists as primary key within the Sizes table. **** I'm starting by picking basic product values like productId, ProductName etc from the Varer (a) table ***** Then I'm picking the corresponding Sizes values (onesize, s, m, ...) from the Sizes table. Now within my ListView I'm showing the above result by using Eval, like this.
[Code]....
And this works perfectly, but now comes the thing that is causing me trouble. I have the below drop down list (still within the ListView ItemTemplate):
[Code]....
I want this drop down list to be populated with only those of the "linq query's Sizes table result" that are true. By "Sizes table result" I mean these
[Code]....
I have written some vb code that inserts whatever has been written on my page into an Access database. Only problem is VWD throws up an error saying that the syntax of my SQL statement is wrong. I am 95% sure that this statement is correct because when I saw the statement in Text Visualizer and tried that statement in MYSQL the data went in perfectly.
I have pasted the code below:
strSQL = "INSERT INTO User (UserID, FirstName, LastName, Password) VALUES "
am developing an application using asp.net+ajax.i used calender extender control to select date and showing that date in a text box.my requirement is when select date from the previous year (i.e 2009) from the calender extender control...then a message should show like"you should not select the previous year date" and immediately current day date should fill in textbox.
View 4 Repliesi'm trying to to create a simple string array with data retrieved from a select statement(SELECT firstname FROM customers , for ex.)
View 6 RepliesHow would i make a select statement select the row with the nearest values? e.g.: I have 3 labels, labels1 2 and 3, with values of 1.2, 2 and 5.8 In my table i have 4 columns, first is the data im after, and the next 3 relate to the three labels. I want to select one row, where the values of labels match it the closest.......
View 8 Repliesi have two tables named
1.LookupPageInfo and (LookupPageInfoId,pathmessageID,pagemessageID)
2.Messages (MessageId,MessageText,ChannelID)
Now i need to write a query something like this........in the query i need to pass the pathmessageid and needs to get messagetext from Messages Table,i am not sure how i need to write the below query..can someone guide me how can i write a query......as below..
select LookupPageInfoId,
PathMessageID,
pagemessageID,
(select messagetext from Messages where MessageID=PathmessageId) as TEXT from LookupPageInfo
i just want know about my sql server name not showing..
View 11 Replieshave gridview in my asp.net webform, and if i select rowafter the database is refreshed i see the ID correct.but when i run any query on the data and i see for example 4 rowsand i select one row i see wrong IDi use this for select row: ID = GridView1.SelectedRow.Cells[1].Text;
View 1 RepliesI have a command button on a page, that when selected will save details to a database and produce a letter in a word document. Using VS2005 and Asp.net 2.0 The problem I have is that when the button is selected, the word document opens fine, the data is saved to the database fine, but certain fields that should be populated after the button click are not.
Code:
protected void cmdGenerateLetter_Click(object sender, EventArgs e)
{
if (ValidateReviewLetter())
{
//Retrieve Application Reference
string strApplicRef = Session["ApplicationDetails"].ToString();
strApplicRef = strApplicRef.Substring(11, 9);
ddlLetterGeneratedBy.SelectedIndex = ddlLetterGeneratedBy.Items.IndexOf(ddlLetterGeneratedBy.Items.FindByText(_userProfile.FullName.ToString()));
txtGeneratedBy.Text = ddlLetterGeneratedBy.SelectedItem.Text;
cldDateGenerated.Value = UtilityFunctions.GetFormattedDate(DateTime.Now.Date.ToString());
objDeclarationLetter.Enabled = true;
Code to save data
ProduceLetter();
}
}
The values at the top of the procedure - txtGeneratedBy and cldDateGenerated are the fields not being populated event though I set values to them.
In one page I have image controls that are showing pics from the web site. This works fine but sometimes, and randomly some pics are not shown. I guess this issue could happen because Im using the IIS 5.1 in my development enviroment and it could be denying some requests. Anyway, I dont know exactly what is happening, so i request help of those who have workaround this fixture.
View 1 RepliesI have a masterpage. And i got 2 pages. Anyhow one is displaying all the contents. Other doesn't. Even though I can do everything in source It really drives me crazy not to see what i'm doing. Website is working as a charm. Everything is cool except development environment of single page.
View 1 RepliesI know browser compatability isn't fun, but this one is odd. I have the following code:
[code].....
When the user clicks on a link in any version of IE, Chrome, or Safari, the scrollbar on the right side is there, no problem. But when they do it in Firefox, the scrollbar is missing. They can hit page down to scroll through the info, but why wouldn't the scrollbar be there as well?
On an action I have the following:
[Code]....
The days list shows fine but the selected value is not 2 but "---". Why?
I am having a problem with IE 7.0 and my sub-menus. When I access my site, the top level menu items show; however, when I hoover over the top level menu items the sub-menus do not appear.
When I use IE 8.0 and Firefox everything is fine.
In my Development Environment, I can see my Image on my web form, but when I build my application and copy to Local Host,
Images are not showing on both browser Internet Explorer and FireFox.
Is there setting for this?
I have created a asp:TextBox. its disabled. but its values is changed via javascript. When i click a button to get the updated value in that textbox it always show me empty ("").In my Page_Load i am doing everything in if(!Page.IsPostBack) so there is no chance of updating TextBox value on postback in Page_Load.Where i could be wrong? how can i get updated value?
View 3 RepliesI have a label is in a table, but is not showing up after validation. I have try if else method, but it's not working too.
My code goes like this in the button_click
If Not Page.IsValid Then
lblErrorMsg.text = "text"
lblErrorMsg.visible =true
End If
If Page.IsValid Then
{My execution code and refresh code"}
End If
I have a small websolution that needs the user to input a password. I have two input boxes
<input type="password" runat="server" id="m_txtPassword1"/>
If I set some chars to the Value-property of the control like this:
m_txtPassword1.Value="someChars";
The password box is rendered empty. No bullets are shown. If I look into the rendered html-source, also no value-tag has been rendered. If I change the type to
<input type="text" runat="server" id="m_txtPassword1"/>
the chars are shown. Is this by design? How can I disable this feature? I don't want to put a real password into the value-property, I only want to show the user that there is already a password set, and this is IMO done best with some 8 bullets in the input-control. But for this, I need the possibility to set the value-property of the control.
Update
For all, having the same problem: I have tried to declare <asp:textbox id="m_txtPassword1" runat="server" TextMode="Password" /> with the same result. Also m_txtPassword1.Attributes["value"]="someChars" has not helped.
As a workaround, I declared the password-boxes as plain html without the runat="server" and have set the value-property in markup (via two properties from the code-behind). Not nice but I really want to show the user that he has already entered a password.Another workaround would be to set the value through javascript on load.
I have a server 2003 which I use to host my own small website. on the server is a whole series of pictures, What I'd like to do is show a series of pictures one after the other. I created an image control on the page and I load that with the picture I want to display. The problem I have is, as it updates itself I get an blank page for a second or two. I'd like to make the change instantly, how can I do this?
View 14 Replies
