In the past I have always added rows of data by binding the gridview to a sqldatasource control. Is there a way to manually (by code) add rows myself from the VB code? I need to call a stored procedure by code and wrote the results one at a time to the gridview.
View 3 RepliesI have an ASP.Net project created by a team member on another computer. The project references a virtual directory that exists on my computer but under a different localhost location.Currently, the following error occurs when I try to open the project:
The local IIS URL http://localhost/foo/default.aspx specified for Web project foobar has not been configured. In order to open this project the virtual directory needs to be configured. Would you like to create the virtual directory now?[Yes] [No]
So, there are two options: select yes: It creates the virtual directory that it thinks I need, which I don't want to do. I already have a virtual directory somewhere else.
select no: This isn't an option, as the project opens, but without all the bells and whistles I know and love.
Where is the virtual directory location (in my case http://localhost/foo/default.aspx) specified within the project? Can I change this manually, say in a configuration file within the project, either before or after I open it? A configuration change seems more ideal than manually opening IIS to override a virtual directory path.
EDIT (solution): Buried in the comments below is the following answer (Thanks @Thyamine)This can be configured in the foo.csproj file for the project. Look for the lines:
<ProjectExtensions>
<VisualStudio>
<FlavorProperties GUID="{F00-000-000}"> [code]....
I have a gridview with data. I want a button which is not part of the gridview. Then if I press a button the gridview is sorted by two colums. i.e column1 ascending column2 descending.
I am not looking to work with a Sqldatasource as I use a data access layer. So the sort would have to be from a datatable and databind or directly with the gridview.
I want to insert an extra row in the gridview in the RowDataBound event (or another place if thats possible). How can I do that?
The data in the row to be inserted is not part of the resultset, but rather to split the gridview in logical sections.
I don't want to databind a gridview, I want to be able to add rows myself within c# code. I can see there is a GridViewRow object and wondered if I can use this to add/remove rows as required?
View 5 RepliesI am having a hard time updating from my gridview based the value that I am setting in the datakeynames it is the Ucc field I keep getting and index out of range exception on the e.keys[0]. I have done this before so I am confused what I am missing here.
View 8 RepliesI m having a gridview and Next and Previous button below gridview. If I click on next, I want to highlight the next row.
If i click on Previous, I want to highlight the previous row.
Example. I need to manually call the test_RowDataBound event.
[Code]....
I tried this as I've used with buttons in the past.
button1_click(this, EventArgs())
but it dosen't work
I have a gridview that I am manually binding in my code behind page because I have to pull out information from other sources for the WHERE clause.The issue is that I get an error on the aspx page that one of the columns is not in the dataview, however when I run the SQL statement in SQL all the columns are there and there is not a spelling error.If I remove the column from the gridview then the page loads.I cannot see why the column is a problem.Here is my ASPX gridview code.
[Code...]
This is the line where the error occurs. <asp:Label ID="Label2" runat="server" Text='<%# Bind("date_submitted") %>'></asp:Label> Here is the code behind
[Code...]
Here is the ending SQL statement that works in SQL and does return the date_submitted column. SELECT id, title, date_submitted, (SELECT username FROM users WHERE (id = t.submitted_by_user_id)) AS submitted_by, (SELECT name FROM departments WHERE (id = t.department_id)) AS department FROM tickets AS t WHERE (closed_by_user_id IS NULL) AND (department_id = 48 OR t.department_id = 83) ORDER BY t.date_submitted DESC
Can you add a row of data programatically and bind it to the gridview? If so, how?
I have a grid with 2 columns. One of these columns is a template that runs a function and delivers an output. Within that function I need to manually add data that is not present in the sqldatasource to the grid and use it when performing aggregate functions.
ColumnA - ColumnB
1 - MyFunction(1) - adds new row (1, B)and returns A to column B.
2 - MyFunction(2) - May return just A
Grid should look like
1 - A
1 - B
2 - A
Even though SQLDataSource only returns
1 - AB
2 - A
I'm a new developer here, working in VB. Have a question that is stumping me as well as some others.
I have a gridview control built. I am not using an <sqldatasource> tag, so I can't use it's autoGenerateSelect/Update/Delete functionality. I have built a template field that has an "edit" link button in it, and by clicking it will fire the grdName_SelectedIndexChanged event of the gridview.
Now, it's in this event where I'm having trouble. I have it coded so that when this event fires, it will build a textbox and button control. Code:
Protected Sub grdResults2_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles grdResults2.SelectedIndexChanged
Dim row As GridViewRow = grdResults2.SelectedRow
Dim cell As TableCell = row.Cells(6)
Dim txtSeq As New TextBox
Dim btnUpdate As New Button
'build the textbox in the Search_Seq cell
txtSeq.ID = "txtSeq"
txtSeq.Width = Unit.Pixel(20)
txtSeq.Text = row.Cells(6).Text
cell.Controls.Add(txtSeq)
'build the "update" button in the Search_Seq cell
btnUpdate.ID = "btnUpdate"
btnUpdate.Text = "Update"
cell.Controls.Add(btnUpdate)
End Sub
So the textbox and button populate perfectly. I can run it in the browser and it works fine.
How do I go about setting up the event for this button now? Because it's being manually built here in the gridview event, there is no button for me to "double_click" on in the design view to auto-build this event. There are some properties that need to be set on this button to link it up to a new event....and that's where I'm lost.
Hopefully I don't leave any additional information out.
I've got a GridView control with LinkButtons in different cells. Currently when someone clicks a link, it fires the ItemCommand passing the CommandName and the ID of the item the link is bound to. That all works fine. I need to modify it now to not use links anymore. It now needs to show a popup balloon with a link (styled to look like a button) and when the link is clicked, I want it to do the exact same thing. I'm sure there are several ways of doing this, but for time's and consistency's sake, I'm copying the method used from another page we have that is already doing this. It has a hidden DIV on the page with the link in it. When you hover over a link, javascript repositions the div and makes it visible.
So what I need to do is pass my CommandName and item ID to the javascript so that it can trigger the postback when they click that single link. I know this is not the only way to get to the end result, but what I want to do if possible, is still fire the GridView's ItemCommand and set he DataListCommandEventArgs' CommandName and CommandArgument properties. Can someone explain how, under normal circumstances, clicking the LinkButton in the GridView fires the ItemCommand? I know that the LinkButton's click event is forwarded to the GridView but what gets sent from the client side that let's the server know the link was clicked?
I have a need to call Oracle stored procs to populate a gridview. I'm able to call one stored proc to get the column header text and another one to get the corresponding data. Currently I'm using a datareader, but I want my gridview to have sorting and paging enabled, so likely I'll need to read the data into a datatable and then bind the gridview to it.I've never had to manually configure a gridview - usually just use autoformatting.1. Do I essentially set up the columns manually in the gridview since it has no data to go off of in design mode? I'm guessing most of these will be Bound fields. A few of my columns are going to display date values that need to be formatted a certain way
and one column will be a link that needs to call a second method to populate a different grid. I'm not sure what the syntax for this is.
I have a GridView with bound columns, for which I am manually setting the ItemWidth and HeaderWidth to 500px, and nothing happens. Is there some trick to getting this to work?
This is a column a large amount of text in it, and it keeps sizing to the width of the header text, which is simply "note". I don't want to set Wrap to false, becuase then the colummn could be thousands of px wide in cases.
not quite sure where I'm going wrong here. I'm trying to manually handle sorting in a Gridview that is populated with the following data source:
[Code]....
[Code]....
[Code]....
At the moment, nothing is happening when I click on the column headings. I ran it in debugging mode in Visual Studio and put a breakpoint on the Sorting event handler. I noticed that the variable dtSortTable is empty even after the TryCast(VacanciesGV.DataSource, DataTable). If I hover over this statement in debugging, it shows the data from the file system, so it does appear to be reading it.
I have a SQL table containing a timestamp column. This table is displayed in ASP using GridView control. The timestamp column is indicated in the DataKeyNames property of the GridView. I'm using TemplateFields for all columns and a ItemTemplate HiddenField control connected to the timestamp column using Eval.
<asp:TemplateField
ItemStyle-Wrap="false"
Visible="false"
HeaderText="timestamp"
SortExpression="timestamp">
<ItemTemplate>
<asp:HiddenField
ID="gv_hid_timestamp"
runat="server"
Value='<%#
Eval("timestamp") %>'
></asp:HiddenField>
</ItemTemplate>
</asp:TemplateField>
The data is displayed properly. I'm trying implement the optimistic concurrency in C# using the value of above mentioned timestamp and a stored procedure. The SQL stored procedure expects the @timestamp as varbinary(8). I'm not sure how to pass the value of gv_hid_timestamp back to the stored procedure. I'm using the following:
command.Parameters.Add("@timestamp", SqlDbType.Binary).Value = Byte.Parse(((HiddenField)gv.Rows[row].FindControl("gv_hid_timestamp")).Value);
resulting in the following error: "Input string was not in correct format." (I also tried different data types but with similar result). I want to be able to pass this parameter programmatically from C# and not have to specify it on the UpdateParameters list.
how to edit data in grid view manually without auto generate in gridview + ajax.
View 4 RepliesI have tried a few different ways to add columns of data to a gridview. I have just about got success, except for I am having problems with only getting the last value in my array of data to insert into the gridview column. For example if I return 4 rows from an sql query, with the values of 2, 4, 6, 8. The last value (8) shows in all for rows of the gridview for that particular column.
View 8 RepliesI want to use a radio button selection on a GridView. I can get this working with a regular DS. However, my table is manually DS'd. When the page frame holding the GridView is loaded, I trigger that event to fire off the subroutine that loads a DataTable and adds the DataTable to the DataSource of the Gridview.
The Gridview has a radio button in the first column as the "SELECTED ROW" appearance. Whenever I run the onchange event code for the radio button, I try and fix the radio buttons so only one row is selected with the following code:
[Code]....
This code works fine with the gridview if its got a built in SQLLDataSource. However, with my manual assigning of DataSourcing to the Gridview on Frame Load, I believe the gridview is being reinitialized everytime and I'm loosing the state of the radio button. I don't believe I can use the IsPostBack() because sometimes this frame and gridview will be showing sometimes it won't and yet other times it will need to be "recreated" with new data dynamically within the page. However, I tried to use PostBack and it looks like its working until I try and do a sort...than that crashes.
[Code]....
When I click on Sort, it crashes here
If (mydata.Rows.Count <> 0) Then
(its complaining about it being "null")
[Code]....
I have the gridview inside another gridview, i want to sort that both gridviews, I don't know how to achieve using asp.net 3.5 visual studio 2008 c# code behind. Following are my aspx page,
<div
id="divclm"
runat="server">
<asp:GridView
ID="claimgrid"
runat="server"
AutoGenerateColumns="False" AllowSorting="True"
Width="100%"
AllowPaging="True"
CssClass="gareahead"
EmptyDataText="No Records To Display"
OnRowDataBound="claimgrid_RowDataBound"
OnRowCreated="claimgrid_RowCreated"
GridLines="Both"
OnPageIndexChanging="claimgrid_PageIndexChanging"
OnSorting="claimgrid_Sorting"
CaptionAlign="Right">
<Columns>
<asp:HyperLinkField
Text="<img id='upimg' src='Styles/Images/appschg.gif'/>"
ItemStyle-Width="10px">
<ItemStyle
Width="10px"
/>
</asp:HyperLinkField>
<asp:BoundField
DataField="name"
HeaderText="Name"
SortExpression="name">
<HeaderStyle
HorizontalAlign="Center"
/>
<ItemStyle
HorizontalAlign="Left"
/>
</asp:BoundField>
<asp:BoundField
DataField="code"
HeaderText="Code"
SortExpression="code">
<HeaderStyle
HorizontalAlign="Center"
/>
<ItemStyle
HorizontalAlign="Left"
/>
</asp:BoundField>
<asp:TemplateField>
<ItemTemplate>
</td></tr>
<tr>
<td
colspan="6"><div
id="<%#Eval("code") %>"
style="display:none;position:relative">
<asp:GridView
ID="Gdclmline1"
runat="server"
AllowPaging="True"
AllowSorting="True"
AutoGenerateColumns="False"
OnSorting="Gdclmline1_Sorting" BorderColor="Green"
BorderStyle="Solid"
BorderWidth="1px"
OnRowDataBound="Gdclmline1_RowDataBound"
OnRowEditing="Gdclmline1_RowEditing" Font-Names="Verdana"
Font-Size="8pt"
Font-Strikeout="False"
OnSelectedIndexChanging="Gdclmline1_SelectedIndexChanging"
OnRowUpdating="Gdclmline1_RowUpdating" PageSize="1000"
RowStyle-Wrap="false"
Width="100%"
CssClass="gareahead"
EmptyDataText="No Records To Display"
GridLines="Both">
<PagerSettings
Mode="NextPreviousFirstLast"
NextPageText="Next"
Position="Top"
PreviousPageText="Prev"
/>
<Columns>
<asp:TemplateField
HeaderText="phone"
SortExpression="phone">
<HeaderStyle
HorizontalAlign="Center"
/>
<ItemStyle
HorizontalAlign="Left"
/>
<ItemTemplate>
<asp:Label
ID="lblphone"
runat="server"
Text='<%#Bind("phone") %>'> </asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField
HeaderText="address1"
SortExpression="address2">
<HeaderStyle
HorizontalAlign="Center"
/>
<ItemStyle
HorizontalAlign="Left"
/>
<ItemTemplate>
<asp:Label
ID="lbladdress1
runat="server"
Text='<%#Bind("address1") %>'> </asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<RowStyle
CssClass="gr"
Height="100px"
HorizontalAlign="Left"
Wrap="true"/>
<SelectedRowStyle
CssClass="gr"
/> <PagerStyle
CssClass="gareahead"
HorizontalAlign="Left"
Wrap="False"
/> <HeaderStyle
CssClass="ghead"
ForeColor="White"
Wrap="true"
/> </asp:GridView>
</div>
</td>
</tr>
</ItemTemplate>
</asp:TemplateField>
</Columns>
<PagerSettings
Mode="NextPreviousFirstLast"
NextPageText="Next"
Position="Top"
PreviousPageText="Prev"
/>
<HeaderStyle
HorizontalAlign="Center"
VerticalAlign="Middle"
CssClass="ghead"
ForeColor="White"
/>
<RowStyle
CssClass="gr"
/>
<SelectedRowStyle
CssClass="gs"
/>
</asp:GridView>
</div>
that aspx page contains gridview that contain one more gridview inside in it.Now i want to sort out both the grid i.e)claimgrid and Gdclmline1 i want code in c#.
If VS 2008 and VWD 2008 are both installed on the same machine, will they both use the same Projects folder to keep my projects in?If so, can I open the projects and run them interchangeably with VS2008 and VWD 2008? This is the folder that is located at " User>Documents>Visual Studio 2008>Projects
View 1 RepliesI have a website on the IIS but it has only the aspx file. Now I need to add the code behind for some pages. How do I go about this?
I've been trying to add the attribute "codebehind" and "autoeventwireup" on the top of the aspx file but no luck (the page_load event is not being called). Also, if I double click on the button from the design view in Visual Studio, it creates the javascript handle (not the server code).
I am using web services in my applcation. I know when calling webservices the soap is created.
My requirement is to create soap sub header below like using vb.net code. Is it possible?
<SubHeader>
<username>sasi</username>
<password>infot</password>
</SubHeader>
I have to create a DataGrid with dynamic columns and I want to put an ImageButton in a TemplateColumn. If the DataGrid is NOT DYNAMIC, I put this code on the .aspx page like this : (this first part of code is just to explain, it isn't what I want to do)
[code]...
Using the Entity Framework that I generated. I have a Roles table created during the default system AspNetSqlRoleProvider security set-up.In the Roles table, I have an ApplicationId uniqueidentifier column. Which has a guid populated in it, which doesn't change for my application. I need to add a Role manually through my app using the entity framework. However, when creating my Roles object and setting Roles.ApplicationId. It expects a type of Guid. I have the ApplicationId in my web.config app settings. As it shouldn't change. But it is returned at string. I cannot type cast the value either to use in Roles.ApplicationId. What can I do to use my current ApplicationId value when trying to create a new role manually using the EF?
View 1 Replies