I have a probelm with my SQL select statment..text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.In my case its image.. When my select statment does not include images columns its working fineWhen I select 2 images then SQL query erro show up..
View 3 Replies
I used a query which returns some rows as result.. Querys is
var UserActivity = (from x in entity.user_activities
oin p in entity.team_group_friends on x.activity_doer equals p.userid
where p.userid == teamORGroupID
select x).ToList().Take(5);
There is no error in query...But when i assisg the UserActivity to a view model ..
i have the following scenario, i have a column of a gridview that shows me a text telling me is the user is allowed or not to access to some page, but now i just showing allow and deny, but i wanna show images that represent me the action, how can i do that?
View 3 RepliesI want to show on one of my pages a slideshow type page. Basically I want it to show a selection of images from a folder and have the images scroll from right to left.
View 8 RepliesI have a SQL Data Source that displays records after going through the Query Builder and select "Test Query" yet when I save it, go back to the design mode and select View in Browser I get nothing but a blank screen.
View 3 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
What is difference between select { } and select new {} In Linq Query
View 3 RepliesI am writing a linq query to select a blogpost,
[code]....
The blogpost i am testing got 3 tags attached to it. The table structure is:
(table)BlogPost -> (table)BlogPostTags <- (table)Tags
So the BlogPostTags table only contains 2 fields, BlogPostID and TagID.
When i run the query above i get 3 results back. Same blogpost 3 times but with 1 tag in each. It should return 1 post with 3 tags. The problem lies in the Tags query above.
How can I SELECT second if first SELECT returns nothing?
View 8 RepliesIn the below code it does not show the images in the ouput though the img is in the specified location is there any other way to specify the location?
<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="CreditCardList.ascx.cs" Inherits="ResortManagement.Component.CreditCardList" %>
<%@ Register TagPrefix="exact" Namespace="Exact.Hospitality.Core.Web" Assembly="Exact.Hospitality.Core"%>
<%-- Credit Card --%>
<table>
<tbody>
<asp:Repeater ID="rptCreditCards" runat="server" OnItemDataBound="rptCreditCards_ItemDataBound" OnItemCommand="rptCreditCards_ItemCommand" >
<ItemTemplate>
[Code....]
I have two tables --- Table1 has an identity column ID and a team name column and Table2 has columns where one column is one team's ID# and another column with the second teams ID# and other columns with scores for each team for that week.want to do a query to show that week's result but instead of the ID#, show the teams' names.
View 4 RepliesCannot open backup device 'C:Program FilesMicrosoft SQL ServerMSSQLBACKUPdatabasename.bak'. Device error or device off-line. See the SQL Server error log for more details.RESTORE DATABASE is terminating abnormally.
View 1 Replies[Code]....
WebSecurity.Login Operator '==' erro?
I am trying to load every image *.png in a folder on my site. I simply want every image to be shown. One after the other, all on one page. Displaying a single image seems simple enough, but going through the entire directory is tough. How could I do this with minimum code using asp.net with vb as the language?
View 2 RepliesI have form where I am displaying States and related cities. it is displaying properly. I also used MaintainScrollPositionOnPostBack="true" too. But the problem is when I select some state then my scroller goes top of the position first and loading some images. [it shows me on status bar] and after this it it maintained the position. During image loading it takes 4 - 5 seconds and it's too much for me.
View 2 RepliesHow to make the folders (css, images) to show not found 404 instead of not authorized 403 when accessing it.
View 6 Replies[Code]....
Why does'nt query.CopyToDataTable(); not work for me on Vs 2008. Since I use the "select new" in my linq query above.
I am working on List View to show Images dynamically. But my image folder is out side my Application folder(means on other drive or in same drive but not included in project ). Now if folder is inside project I know how to give Path , but outside Project it gives me problem in showing images.How to do that.in aspx
<asp:Image ID="ImgPic" runat="server" AlternateText='<%# Eval("CRGIMG_CARGO_IMAGE_PATH") %>'
I apologize if this is the wrong sub-forum for this question, if it is please let me know a better sub-forum to ask this.Anyway, I have a table in my database with a photo column that points to the location of images all under the same root, like this: Y:playerPhotosplayerName.jpg
When I select a specific photo using a stored procedure in my aspx.cs, then read the image path using a sqldatareader like this
while (sdr.Read())
{
string filepath = sdr.GetString(0);[code]....
it works fine and the image shows in Internet Explorer (version 8), but doesn't show in Firefox (version 3.6.4) I think it has to do with the direction of the slash, but I'm not sure. Is there anyone out there that has run into this broswer problem?Basically is there a solution to changing the value of the image's filepath string if the browser is Firefox?
I have a GridView bound to a datasource with an image column in a template field. I use a handler to get the images from the datasource and display them. The problem is the GridView will display the second image, but not the first.
[Code]....
and
[Code]....
I am unsure on how to perform this task, what i need to do is make a gallery with tagging. I need this as it is a requirement for the project. Each user will have there own gallery and be able to upload and delete images from there gallery. I already know how to insert and select images from a database. I will then display the gallery using a data repeator with paging, I am sure i can google an article for data repeator with paging.
My challenge is, when the user wants to save a image to there gallery, he must 1st upload the image and then i must some how display the image, when the image is displayed, i will have a text box where they can add tags, this textbox will save in the tag table for that user_id, picture_id and the tag will have an id also. I am unsure on how to do this When he clicks save, i wanna insert the image into the table, and the tag. If he does not click save, then nothing should be saved. Now the 2nd part.
In the data repeator, i want a modal window to popup when they click an image, this modal will have the image and the respective tags that where saved for this image, I am unsure how to this.
I have a gridview that has a sqldatasource for it's data and it works well. I also have four dropdown lists that I need to have filter the data in the grid if they have a value selected. Here's my query:
[Code]....
What I need is if a user selects an Asset_Tag from a dropdown list the gridview should requery with the Asset_Tag as a parameter so only that record gets called up. Is there a way to do this in the selected indexchanged event? The same would hold true for the other DDLs. It seems like if I assigne the datasourse programmatically I lose the builtin sorting ability which isn't acceptible for this application.
I have a TableAdapter that consists of an SQL SELECT query.
Need to create an "if" statement that checks to see if the query returned any records.
Tried "HasRows" but Visual Studio 2010 says: Error 2 'Maine_Innkeeper_Site_2010.App_Code.DataAccessLayer.MaineInnsDataset.membersDataTable' does not contain a definition for 'HasRows' and no extension method 'HasRows' accepting a first argument of type 'Maine_Innkeeper_Site_2010.App_Code.DataAccessLayer.MaineInnsDataset.membersDataTable'
could be found (are you missing a using directive or an assembly reference?) E:Ed dataclientsMaine InnkeepersMIA website 2010Maine Innkeeper Site 2010lodging-search-output.aspx.cs 49 83 Maine Innkeeper Site 2010
What's the proper way to check if HasRows is wrong?
[Code]....
I am working on a web application in which i was showing images with .jpg format initially. Now requirement changed and i have to show images with .tif format. I tried this but it is not showing images on my data list view.
View 1 RepliesI need to display a slide show of 5 images on my home page
also.. I dont use Database.. Will direct it from File location.
* Which image format is best ? which format loads faster..
* every 5 secs, inages should change... any sample C# code??
* how to create nice border effect for that image slide.... control??
