i have a gridview with a upload control in edit template. and a image control in item template bound to page that gets the new uploaded picture.the trouble is it does not return a picture no matter what i try??
View 2 RepliesI had a problem before with GridView displaying picture and it was solve as post [URL] shows. I am trying to apply the same coding to another GridView with a different configuration and I am having a hard time making the adaptation. May someone take a look at it. What I am trying to add to this GridView is code as:
DataImageUrlFormatStringl='<%# IIF(System.IO.File.Exists(Server.MapPath(string.Format("~/UploadedImagesClassifieds/{0}{1}", Eval("AutoNumber"), "Pic1.jpg"))), string.Format("~/UploadedImagesClassifieds/{0}{1}", Eval("AutoNumber"), "Pic1.jpg"), "~/UploadedImagesClassifieds/NoPicture.gif")
%>'
And the GridView code is the following at the present time:
<
asp:GridView
ID="ClassifiedsDisplayGridView"
runat="server"
DataSourceID="srcClassifieds"
AutoGenerateColumns="False"
CellPadding="4"
ForeColor="#333333"
AllowPaging="True"
PageSize="100"
EnableSortingAndPagingCallbacks="true"
>
<Columns>
<asp:ImageField
DataImageUrlField="AutoNumber"
DataImageUrlFormatString="~/UploadedImagesClassifieds/{0}Pic1.jpg"
HeaderText="Picture"
ReadOnly="True"
>
<ControlStyle
Height="50px"
/>
</asp:ImageField>
<asp:BoundField
DataField="Category"
HeaderText="Category"
/>
<asp:HyperLinkField
DataNavigateUrlFields="AutoNumber"
DataNavigateUrlFormatString="~/Classifieds/DetailPage.aspx?AutoNumber={0}&FlagForm=NoSubmitted"
DataTextField="ItemTitle"
HeaderText="Listing
Title" />
<custom:LongTextField
DataField="ListingComment"
Width="400px"
Height="75px"
HeaderText="Listing
Comment" HtmlEncode="false"
/>
<asp:BoundField
DataField="EnterDate"
HeaderText="Listed
on" SortExpression="EnterDate"
/>
<Columns>
<FooterStyle
BackColor="#00693E"
Font-Bold="True"
ForeColor="White"
/>
<RowStyle
BackColor="#FFFBD6"
ForeColor="#333333"
/>
<PagerStyle
BackColor="White"
ForeColor="#333333"
HorizontalAlign="Center"
/>
SelectedRowStyle
BackColor="#FFCC66"
Font-Bold="True"
ForeColor="Navy"
/>
<HeaderStyle
BackColor="#00693E"
Font-Bold="True"
ForeColor="White"
/>
<AlternatingRowStyle
BackColor="White"
/>
<PagerSettings
Mode="NextPreviousFirstLast"
Position="TopAndBottom"
/>
</asp:GridView>
<asp:ObjectDataSource
ID="srcClassifieds"
TypeName="SearchUtility"
SelectMethod="GetClassifiedsSimpleSearch"
runat="server"
OnSelected="srcClassifieds_Selected"
EnableViewState="False">
<SelectParameters>
<asp:QueryStringParameter
Name="Category"
QueryStringField="Category"
Type="String"
/>
<asp:QueryStringParameter
Name="Activity"
QueryStringField="Activity"
Type="String"
/>
<asp:QueryStringParameter
Name="KindOfSearch"
QueryStringField="KindOfSearch"
Type="String"
/>
<asp:CookieParameter
CookieName="Country"
Name="Country"
Type="String"
/>
<asp:CookieParameter
CookieName="CityTown"
Name="CityTown"
Type="String"
/>
<asp:SessionParameter
Name="State"
SessionField="State"
/>
<asp:Parameter
Direction="Output"
Name="SelectRows"
Type="Int64"
/>
</SelectParameters>
</asp:ObjectDataSource>
I do a gridview code that when displaying the information that come from the database is not showing any error at all, but is not displaying the right picture. The problem, I think, is that the (Eval("....") is not reading the values that are coming from the DataKeysNames. Due to this the right pictures are not displayed. But in another column, just for testing purposes I was able to display the values from DataKeysNames with the Eval. So I do not know what is going on and to make worse browser is not giving me any error. So, this is the line that is not processing, reading or executing well:
ImageUrl='<%# IIF( (Eval("TUDTIWasItemUpgraded")) = "Yes", string.Format("~/Images/ItemUpgradedTo.gif"), string.Format("~/Images/ItemNoUpgradedYet.gif") ) %>'
And this is the complete code for the GridView
<
asp:Panel
ID="DownlineUDTIGameClassifiedsViewPanel"
runat="server"
>
<asp:GridView
ID="DownlineUDTIGameClassifiedsViewGridView"
runat="server"
AutoGenerateColumns="False"
DataKeyNames="AutoNumber,TUDTIWasItemUpgraded"
DataSourceID="DownlineUDTIGameClassifiedsViewSqlDataSource"
CellPadding="4"
ForeColor="#333333"
AllowPaging="True"
PageSize="100"
OnDataBound="DownlineUDTIGameClassifiedsViewGridView_DataBound">
<FooterStyle
BackColor="#00693E"
Font-Bold="True"
ForeColor="White"
/>
<RowStyle
BackColor="#FFFBD6"
ForeColor="#333333"
/>
<PagerStyle
BackColor="White"
ForeColor="#333333"
HorizontalAlign="Center"
/>
<SelectedRowStyle
BackColor="#FFCC66"
Font-Bold="True"
ForeColor="Navy"
/>
<HeaderStyle
BackColor="#00693E"
Font-Bold="True"
ForeColor="White"
/>
<AlternatingRowStyle
BackColor="White"
/>
<PagerSettings
Mode="NextPreviousFirstLast"
Position="TopAndBottom"
/>
<Columns>
<asp:BoundField
ItemStyle-HorizontalAlign=Center
DataField="TUDTIGenerationNumber"
HeaderText="Generation"
SortExpression="TUDTIGenerationNumber"
/>
<asp:BoundField
DataField="TEnterDate"
HeaderText="Enter Date"
SortExpression="TEnterDate"
/>
<asp:BoundField
DataField="TItemTitle"
HeaderText="Listing Title"
SortExpression="TItemTitle"
/>
<custom:LongTextField
DataField="TListingComment"
Width="400px"
Height="75px"
HeaderText="Listing Comment"
HtmlEncode="false"
/>
<asp:TemplateField
HeaderText="Picture">
<ItemTemplate>
<asp:ImageButton
ID="ThumbNailImageButton"
runat="server"
Width="75px"
PostBackUrl='<%# string.Concat("~/Classifieds/DetailPage.aspx?AutoNumber=",Convert.ToString(Eval("AutoNumber")),"&FlagForm=NoSubmitted")
%>'
ImageUrl='<%# IIF(System.IO.File.Exists(Server.MapPath(string.Format("~/UploadedImagesClassifieds/{0}{1}",
Eval("AutoNumber"), "Pic1.jpg"))), string.Format("~/UploadedImagesClassifieds/{0}{1}", Eval("AutoNumber"), "Pic1.jpg"), "~/UploadedImagesClassifieds/NoPicture.gif") %>'
/>
</ItemTemplate>
<ItemStyle
HorizontalAlign="Center"
/>
</asp:TemplateField>
<asp:TemplateField
HeaderText="Item Upgraded To">
<ItemTemplate>
<asp:Image
ID="XItemUpgradedToPicture"
ImageUrl='<%# IIF( (Eval("TUDTIWasItemUpgraded")) = "Yes", string.Format("~/Images/ItemUpgradedTo.gif"),
string.Format("~/Images/ItemNoUpgradedYet.gif") ) %>'
runat="server"
Width="150px"/>
</ItemTemplate>
<ItemStyle
HorizontalAlign="Center"
/>
</asp:TemplateField>
<asp:TemplateField
HeaderText="Testing">
<ItemTemplate>
<asp:Label
ID="Label1"
runat="server"
Text='<%# Eval("TUDTIWasItemUpgraded") %>'
>
</asp:Label>
</ItemTemplate>
<ItemStyle
HorizontalAlign="Center"
/>
</asp:TemplateField>
<asp:TemplateField
HeaderText="Item Upgraded To">
<ItemTemplate>
<asp:Image
ID="ItemUpgradedToPicture"
ImageUrl="~/Images/ItemUpgradedTo.gif"
runat="server"
Width="150px"/>
</ItemTemplate>
<ItemStyle
HorizontalAlign="Center"
/>
</asp:TemplateField>
</Columns>
</asp:GridView>
Dear all; I have a gridview as follows below
ID ZONE
A AFRICA
B NORTH AMERICA
now, i would like to add a little picture icon on the leftmost side of the gridview, that would allow a user to click on it...which will indirectly bring up a pop-up screen. In the pop-screen, i would like to add a textbox and a button to it, in which the user will be able to use to make an update to a field ID in the gridview.
I am using VWD 2005 Express and Visual Basic.When my SQLDataSource feed my GridView, it does get the AutoNumber (GUID) of each record as well, to use it as a name for stored pictures. Pictures are not in the database but in a folder. Since I have several pictures, I do manipulate this ID with code and I add to it, pic1, pic2, etc and that is the final name for each picture, for each particular record. Example: The ID for one record in the database may be, 45623sdgd. If I have four pictures for this particular database record, the names will be, 45623sdgdPic1, 45623sdgdPic2, 45623sdgdPic3, and so on after Pic is added. After this I save these pictures in a folder.
Now, when I display the record information with a GridView, I get the AutoNumber of each record using: DataKeyNames="AutoNumber". I want to display a thumbnail picture link as well. But I really do not have many options in term of what control to use for the thumbnail inside the GridView. I tried the following controls unsuscesfully. HyperLinkField, can not add a picture to this one. ImageField, can not add a link to this one. ButtonField does not have a DataImageUrlField="AutoNumber" to get the AutoNumber. So since to be that my only opton is the asp:TemplateField. But it is giving me error with the coding. This is my coding,
Code:
<asp:GridView
ID="PublicClassifiedsSamplesGridView"
runat="server"[code].....
I do have the following code for for a GridViewd that display pictures that are stored in a file. I am using AutoNumber(GUID) from the database to name the pictures before I stored them to the file. I can save up to 4 pictures using the same AutoNumber but adding these ending to it, Pic1, Pic2, Pic3 ,,,,etc.
The problem that I am having is that after I get the AutoNumber from the database, I want to display a standard picture on the GridView field if there is not particular picture associiated to this record in file. The name of the standard picture is located in the same file under the name of NoPicture.gif. How can I do this? So far this is my GridView code and it is working fine:
<
asp:GridView
ID="PublicClassifiedsSamplesGridView"
runat="server"
AutoGenerateColumns="False"
DataKeyNames="AutoNumber"
DataSourceID="PublicClassifiedsSamplesSqlDataSource"
CellPadding="4"
ForeColor="#333333"
OnDataBound="PublicClassifiedsSamplesGridView_DataBound"
>
<Columns>
<asp:TemplateField
HeaderText="Click for information">
<ItemTemplate>
<asp:ImageButton
ID="ThumbNailImageButton"
runat="server" Width="100px"
PostBackUrl='<%# string.Concat("~/Classifieds/DetailPage.aspx?AutoNumber=",Convert.ToString(Eval("AutoNumber")),"&FlagForm=NoSubmitted")
%>'
ImageUrl='<%# string.Concat("~/UploadedImagesClassifieds/",Convert.ToString(Eval("AutoNumber")),"Pic1.jpg")
%>'
/>
</ItemTemplate>
<ItemStyle
HorizontalAlign="Center"
Width="100px"
/>
</asp:TemplateField>
<custom:LongTextField
DataField="TListingComment"
Width="150px"
Height="70px"
HeaderText="Listing Comment"
HtmlEncode="false"
/>
</Columns>
</asp:GridView>
I have year wise Photo now i want insert the photo by year and month and date wise after i want the main page shown the year when i click the year it will be shown the month and i will click the month it will open by date after the photos will be shown .
View 1 RepliesI want to update multiple rows of gridview (only price field. for that i have added textbox) on click of update button which is outside of gridview.I have done following way
<asp:LinkButton ID="lnkUpdate" CssClass="BlueButton" runat="server" OnClick="lnkUpdate_Click">Update</asp:LinkButton>
[Code]....
Up to this its working fine but when no textbox updated then no need to go in for loop so i am looking for confiramtion before updating rows please help me how to do that becausei am less aware with javascript. another problem is textbox value disappear when page index changed how i can retain that values.
[Code]....
When i try to update a row using the update functionality of Gridview it updates all the rows rather then updating that specific row which is in edit mode.
[Code]....
i'm new to c# and i wanted to know how can i allow user to upload a picture from a text box and a button??
after uploading the picture, how can i save the picture in the database??
**note**the picture i allow user to upload need to be in a fixed size.
I have this code to insert a picture from database into an ImageControl on my ASP.NET form:
strConnString = "server=" + Server + ";database=" + DataBase + ";UID=" + UID + ";password=" + PASS + ";";SqlConnection MyConnection = new SqlConnection(strConnString);SqlCommand MyCommand = new SqlCommand("SELECT Pic FROM MEN WHERE ID=5", MyConnection);MyConnection.Open();SqlDataReader MyReader = MyCommand.ExecuteReader();if (MyReader.Read()){ byte[] m_MyImage = (byte[])MyReader["Pic"]; Response.BinaryWrite(m_MyImage);}
And I have this ImageControl on the form:
<asp:Image Width="88" Height="100" Runat="server" ID="m_Image" NAME="m_Image" />
but when I run the code, I see the picture big on the screen and not in my ImageControl.
i also put this in the form_load:
m_Image.ImageUrl = "MyPhoneBook.aspx?m_Image";my control is: m_Imagemy control ID is: m_Imagemy namespace is MyPhoneBook
but still dont work
How to insert picture into DB from formview?
What control I have to use to locate picture and what technique to adopt.
My working enviornment is 2.0.
In database the table is already created with Binaryfield to store pictures.
How can I check the resolution of a remote picture (jpg, gif) using the URL of the picture rather than a locally stored picture?
I attempted this, but get an error.
[Code]....
I have a grid view with some date [URL] I have column 'Zdjecie' with picture url and last column with camera button.
I wish that after clicking on camera button from last column, picture of url from column 'Zdjecie' wil be displayed.
I have atached event like this to clicking on camera button:
protected void grvWojewodztwa_CustomButtonCallback(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewCustomButtonCallbackEventArgs e)
{
if (e.ButtonID != "ShowPicture")
return;
string vrlUrl = grvWojewodztwa.GetRowValues(e.VisibleIndex, "ob_zdjecie_link");
}
and i debugged it and vrlUrl is really picture url, but how to show this picture in new window or popup?
i want to update the data of a database through a gridview update button
how can i attach a dataconvertion like this
[Code]....
I have a parent gridview which has a child gridview in the itemsTemplate. Both are binded to different SqlDataSources. I can successfully update and delete rows in the child gridview. After updating in the child gridview, some related data in the parent gridview are not updated automatically. So i have placed ParentGridview.Databind() in the rowupdated event of child gridview. But it doesnt look working.
How can i accomplish this?
I would like to ask a question on the visual basic codes to loop the gridview to retrieve the values and based on the values, it will be provided as parameters to update to the database table using stored procedure.
Firstly, I have a gridview named grvProduct. The page (ui) will be loaded with data from the database with the use of stored procedures. And only certain values can be edited through the use of template in gridview. So based on those edited values, I'm supposed to pass these values as parameters to the stored procedure which will then update a database table.
Let say, I have 3 records retrieved from the database and displayed in the gridview. And I would like to edit a values in the 3 records, how do I do batch update and pass those parameters to the stored procedure? I went to debug and step through the visual basic codes and realised there were too many arguments specified because I actually loop the gridview.
Below is my visual basic codes:
[Code]....
Below is my Stored Procedure code:
[Code]....
I believe it is the error in the looping of the gridview which results that I could not batch update the data/values.
I have a query . I want to edit the grid view columns in which user click the edit button he will edit the column in the grid and after that i want to add update button so that when he clicks on updates button after editing the row. The row will be updated and the grid will show you the new update row.
Here is my following piece of code.
<asp:GridView ID="noticeDetails" runat="server" BorderWidth="1px" AutoGenerateColumns="false" PageSize="10" Width="100%" CellPadding="10"
AutoGenerateEditButton="true" onrowediting="noticeDetails_RowEditing" >
<Columns> <asp:TemplateField HeaderText="CampaignIDRange">
<ItemTemplate> <%# Eval("CampaignIDRange")%>
[Code] ....
Basically grid is about that when user enter values intothe grid, the values will show in to the grid upon click button.I added edit button it works fine but it will incomplete without update button method ...
- I have a Gridview , when i click button edit of each rows to update database in Gridview . So when in edit mode , i want to update database in Gridview by using a button outside of the gridview instead of using a button inside Gridview .
- Here is my code used for update database by a button inside Gridview :
[Code]....
- So how i can do with a button outside Gridview to update batabase? .
I know this is simple and have already googled it, I know we should use foreach loop on collection of gridviews and have our logic there but I am unable to get the row index , If any one could give me a working example ,
View 16 RepliesI have a set of dataset with different column retrieved from DB. I need to present the datasets in one GridView (or other ListView etc...) without specifying the column_header. It should present automaticly since the GridView is bind to the DataSet.
In additional, I want this GridView to handle multiple rows edit and update the dataset, idealy, show data in textboxs in initially.How could I set the GridView to edit_model without hardcode column_header and textboxs in 'itemtemplate' or filed.
How could I achieve the bulk edit and update, so that I can assign 'mydataview1.table' to the dataset.
I have an .aspx page with a gridview and a details view for looking up products. It is working perfectly. When I select "Details" on the gridview the details view accurately populates.I added an image named TagImageand need that image to display the correct one based upon the product changed when "Details" is hit. I'm using code behind and have checked my image directory string to make sure it is OK but the images do not display. Here is the vb.net code hehind I am using that successfully populates the details and was hoing it to display the picture:
Protected Sub GridView1_SelectedIndexChanged(ByVal sender As Object, ByVal e As EventArgs)
AccessDataSource2.SelectParameters("ProdID").DefaultValue = _
GridView1.SelectedDataKey.Value.ToString()
[code]....
i am using grid view when i define one of my culomns in sql data base as image then i can't put jpg image in that culomn so i can show this in grid view eather.
View 1 Replieshow would i do my Gridview delete command like a update command?
im using a datasource... and my delete command is like my update command... so i can change the status into "INACTIVE"...
DeleteCommand="UPDATE ACCOUNT_MAINTENANCE SET am_status = 'INACTIVE' WHERE (accmain_no = @accmain_no)"
UpdateCommand="UPDATE [ACCOUNT_MAINTENANCE] SET [account_type] = UPPER(@account_type), [min_deposit] = @min_deposit, [min_capital] = @min_capital WHERE [accmain_no] = @accmain_no"
when i press my delete command at gridview... the status changed into "INACTIVE" but when i refresh or press f5... it automatically update the status into "INACTIVE" also...