I have a gridview connected to my objectdatasource, i wrote a class for the database queries.Now when i do an update of record i get the id form the grid, when i click on delete i don't get the id, its 0.Is there an option to set the id? i can't find it in the gridview.
View 9 Replies
I have a gridview in which I am using a button field where the button type is "Image". The purpose of this button is to delete a row.
This works good. But when I add a confirmation on "RowDataBound", it does not work.
Here is my gridview.
[Code]....
Can't tell what is wrong here . It worked fine and I didn't did anything special in code-behind
I don't see any error just the same data in gridview
[Code]....
In my master page, I defined the css which loads a background image: img_mnusep.gif
<style type="text/css">
.ListHead2
{
background-color: #E0E3E8;
height: 20px;
color: #000000;
font-family: Tahoma, Arial, Verdana, Tahoma, Arial;
font-size: 8.5pt;
font-weight: normal;
[Code].....
Im using File Upload Control in every row of a GridView.... Like tis
Name
UploadFile
textBox FileUpload
TextBox FileUpload
.
.
Submit
On Submit im first uploading all files present in the grid and then saving other values in database....No Problem when uploading Small Set of filesIf i browse more than 10(approx) files(i.e 10 files in 10 rows) and Submit... Internet Explorer-Page Cannot Be displayed Error occurs but no problem when uploading < 10(approx) files....
I'm trying to set paging on my gridview but when i click on a page it doesn't work. It return a blank page. Here's my code:
[Code]....
Behind code:
[Code]....
I am tring to set the selected value of a dropdown inside a gridview like this:
[Code]....
And I get error:
[Code]....
I have a gridview that shows when something is check out. I would like to only show results from todays date and forward. I have done this in Expression Web but when I tried to use the same code in Visual Studios it doesn't work.
asp:AccessDataSource
ID="AccessDataSource1"
runat="server"
DataFile="~/browser.mdb"
DeleteCommand="DELETE FROM [ConferenceRoomCalendar] WHERE [ID] = ?"
InsertCommand="INSERT INTO [ConferenceRoomCalendar] ([ID], [ConferenceRoomName], [DateNeeded], [StartTime], [FinishTime], [RequestedBy], [Purpose]) VALUES
(?, ?, ?, ?, ?, ?, ?)" SelectCommand="SELECT * FROM [ConferenceRoomCalendar] WHERE ([DateNeeded] >= Date())"
UpdateCommand="UPDATE [ConferenceRoomCalendar] SET [ConferenceRoomName] = ?, [DateNeeded] = ?, [StartTime] = ?, [FinishTime] = ?, [RequestedBy] = ?, [Purpose]
= ? WHERE [ID] = ?">
<SelectParameters>
<asp:QueryStringParameter
Name="DateNeeded"
QueryStringField="Date()"
Type="DateTime"
/>
</SelectParameters>
<DeleteParameters>
<asp:Parameter
Name="ID"
Type="Int32"
/>
</DeleteParameters>
<UpdateParameters>
<asp:Parameter
Name="ConferenceRoomName"
Type="String"
/>
<asp:Parameter
Name="DateNeeded"
Type="DateTime"
/>
<asp:Parameter
Name="StartTime"
Type="DateTime"
/>
<asp:Parameter
Name="FinishTime"
Type="DateTime"
/>
<asp:Parameter
Name="RequestedBy"
Type="String"
/>
<asp:Parameter
Name="Purpose"
Type="String"
/>
<asp:Parameter
Name="ID"
Type="Int32"
/>
</UpdateParameters>
<InsertParameters>
<asp:Parameter
Name="ID"
Type="Int32"
/>
<asp:Parameter
Name="ConferenceRoomName"
Type="String"
/>
<asp:Parameter
Name="DateNeeded"
Type="DateTime"
/>
<asp:Parameter
Name="StartTime"
Type="DateTime"
/>
<asp:Parameter
Name="FinishTime"
Type="DateTime"
/>
<asp:Parameter
Name="RequestedBy"
Type="String"
/>
<asp:Parameter
Name="Purpose"
Type="String"
/>
</InsertParameters>
</asp:AccessDataSource>
In expression web I changed this line from this WHERE [ID] = ?"> to this WHERE [ID] = date()"> and I get the right results.
I have a GridView; one of the columns displays concatenated records from a tables. to extract the records that are going to be concatenated and put in this column, i have used: FOR XML path('') and it works just fine for displaying those records. the problem now is the whole gridview can not be sorted anymore and gives me a 404, document not found, error whenever i try to click the columns to sort. here is my select statement for my sql datasource select command:
SqlDataSource2.SelectCommand = "Select a1.*, keyword = substring( ( SELECT DISTINCT ', ' + keywordName FROM keywords JOIN key_mm_articles ON key_mm_articles.keywordID = keywords.keywordID WHERE key_mm_articles.articleID = a1.articleID FOR XML path(''), elements ),2,500) FROM articles a1 WHERE title LIKE '" & titles & "' Order By a1.articleID"
I have a gridview with edit and delete parameters enabled. When I click on the edit link, I can edit the record successfully. However when I click on the delete link, nothing happens (the record does not get deleted).
View 5 RepliesI have a Gridview (VS2008 3.5) which has a Edit Button and a Delete button.he Delete button deletes the row without confirming deletion with the user first. ow can I use the Confirm/Delete Confirm from Ajax Toolkitif possible and if not, is there a way to Confirm/Delete with user firstwhen using Gridview?
View 6 RepliesHow do I reference the delete button to add the delete confirmation box when I have both the Edit and Delete buttons as the last two columns in the Gridview control. The following code works fine without any issues when I have the delete button only:
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType != DataControlRowType.DataRow) return;
int lastCellIndex = e.Row.Cells.Count - 1;
Button db = (Button)e.Row.Cells[lastCellIndex].Controls[0];
db.OnClientClick = "if (!window.confirm('Are you sure you want to delete this record?')) return false;";
}
But, when I have both the Edit and the Delete buttons, I get the following error when I click the edit button while the delete button works fine.
Specified argument was out of the range of valid values. Parameter name: index
How do I reference the delete button so the edit button is not affected in this case?
Using "Enable Delete" from Gridview control, I can delete (besides, update, sort, paging, etc) data from the database (this is done automatically). However, how can I delete the actual image that resides in my image folder (i.e. from "pix" folder )? What is the best way to delete image? If using code behind, how? Please write a full code for me. Here is my source code.
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="photoID"
I am using Sharepoint Designer and trying to insert a Delete button into a gridview. I added this to the top of my ASPX:
<%@ Register Tagprefix="SharePoint" Namespace="Microsoft.SharePoint.WebControls"
Assembly="Microsoft.SharePoint, Version=11.0.0.0, Culture=neutral,
PublicKeyToken=71e9bce111e9429c" %>
and I added this as a Gridview column:
<SharePoint:DeleteItemButton
runat="server"
ID="CustomFormDeleteItemButton"
ControlMode="Edit"
/>
and this is the error I get:
An error occurred during the processing of . System.Web.UI.WebControls.DataControlFieldCollection must have items of type 'System.Web.UI.WebControls.DataControlField'. 'SharePoint:DeleteItemButton' is of type 'Microsoft.SharePoint.WebControls.DeleteItemButton'.
I have added AllowSorting to my Gridview but it does not work. Is it because I am explicitly creating my columns.....not autogenerating them?
<asp:GridView ID="grdEvents" runat="server" EnableTheming="False"
Height="385px" Width="1175px" HeaderStyle-CssClass="GridTitle" RowStyle-CssClass="GridOddText"
AlternatingRowStyle-CssClass="GridEvenText" AllowSorting="true" autogeneratecolumns="false" datakeynames="SERIAL,JOURNAL" >
<AlternatingRowStyle CssClass="GridEvenText"></AlternatingRowStyle>
<Columns>
<asp:BoundField HeaderText = "SERIAL" DataField="SERIAL" Visible="false" />
<asp:CommandField AccessibleHeaderText="LOG" CausesValidation="False"
HeaderText="LOG" SelectText="View" ShowSelectButton="True" />
<asp:BoundField HeaderText = "FIRSTOCCURRENCE" DataField="FIRSTOCCURRENCE" />
<asp:BoundField HeaderText = "HOSTNAME" DataField="HOSTNAME" />
<asp:BoundField HeaderText = "SUMMARY" DataField="SUMMARY" />
<asp:BoundField HeaderText = "HDC" DataField="HDC" />
<asp:BoundField HeaderText = "CATEGORY" DataField="CATEGORY" />
<asp:BoundField HeaderText = "TYPE" DataField="TYPE" />
<asp:BoundField HeaderText = "ITEM" DataField="ITEM" />
<asp:BoundField HeaderText = "JOURNAL" DataField="JOURNAL" visible="false"/>
</Columns>
<HeaderStyle CssClass="GridTitle"></HeaderStyle>
<RowStyle CssClass="GridOddText"></RowStyle>
</asp:GridView>
TXTARIZATIP.Text=DropDownList3.SelectedItem.ToString(); i think it should be worked but it does not.
View 5 RepliesDim
sss As
String = thread.SelectedRow.Cells(1).Text
it gives me null refrence when i calling it in gridview's rowdeleting.
i cant get the value!
I've got in a gridview with two EditItemTemplate, which are dropdownlist. for the fisrt one I need autopostback because it's used in the second.So to bind the second dropdownlist, I'm useing the GridView1_ItemUpdating, but it doesn't work. It never goes into this funktion and so on updating the column with the second dropdownlist has Null values.What's wrong?That's my code:
[Code]....
and the c# code behind:
[Code]....
[Code]....
I need a Listview that will show info from several database tables. My delete button, will not delete the record from the database. I cannot get DeleteOnSubmit() to work at all. I am in the very beginner stage. This is my first project. I thought this would be a good project for learning purposes.
Here is my code:
[Code]....
i have a gridview that binds data after changes were made (delete,update..) and it's all done with the c# method DataBind() and i don't know why FF shows the changes but in IE8 the grid remains the same and only if i navigate back and refresh, then i see the changes.
View 1 RepliesI am making checkbox in datagrid, no matter what I try, I cannot get the right result from checkbox. Even I check or not check the checkbox, the result is false. It is like somehow the result is always the default value of the checkbox.
Here is code:
private void OrderButton_Click(object sender, System.EventArgs e)
{
CheckBox x;
foreach ( DataGridItem dgItem in DataGrid1.Items)
{
x = (CheckBox)dgItem.FindControl("OrderCheckBox");
this.ALERT(x.Checked.ToString());
}
}
And here is my html:
[Code]....
I have a radiobutton list, a repeater, and a literal in a grid template. The following code works fine:
<EditItemTemplate>
<asp:Label ID="lblQuestionId" runat="server" Text='<%# Eval( "QuestionId") %>' Visible="False"></asp:Label>
<asp:ObjectDataSource ID="dsQuestionChoice" runat="server" OldValuesParameterFormatString="original_{0}"
SelectMethod="GetData" TypeName="ADNSurveyData.QuestionChoiceTableAdapters.Question ChoiceListTableAdapter">
<SelectParameters>
<asp:ControlParameter ControlID="lblQuestionId" DefaultValue="" Name="QuestionId"
PropertyName="Text" Type="Int32" />
</SelectParameters>
</asp:ObjectDataSource>
<table cellpadding="0" cellspacing="0" border="0">
<tr>
<td>
I got a gridview to display the data from the database properly but when I go edit. it give me an error. I searched and change ConflictDetection=CompareAllValues to OverwriteChanges
The error goes away. However the database is still doesn't update. Does anyone had to tweak the gridview function to make it works. Maybe I did something wrong.
by default, my formview loads up to Editmode and it looks like this:
[Code]....
My Page_load looks like this:
[Code]....
Problem is if binding is not ran during postback here, buttons on the ItemInsert mode DO work, but the button on the ItemEdit mode DON'T work. However, if I don't bind the fv1 here during postback, controls will not load on the formview ItemEdit mode and databinding will not occur.
I thought that the "PageIndexChanged" is fired after the index has changed?
In other words when I'm at page 1 with a labelnumber 11 and I click on page 2, where the labelnumber =
22 and I do
the event "PageIndexChanged" I got the number "22" if I do the following code:
[Code]....
But that is not what happens I still got the labelnumber from page 1.
Did I understand the "PageIndexChanged" event wrong or is this a bug?
Because this is not working does somebody know how to solve this problem?
