Using Web Dev 2010 Express. .NET 3.50
I have an aspx page with a div containing an asp:Table with 1 row, 1 cell. From the codebehind, I read a user supplied text file and add rows/cells (vb). I would like my output to have indented text in certain rows. Example follows:
[code]....
how to do this?
My mission is to figure out how to hide a dropdown box, and I hope I will be able to receive some . My web form is set up like kind of a questionare, mostly yes/no, some N/A's for the answers in the dropboxes. I would like to make an entire question vanish based on the previous question being answered N/A. I have the web form setup using tables, each question occupying a cell.
View 2 RepliesI recently built a table dynamically on a page.
this is how I pulled the value back to fill in the text box in the table. With no master page.
TextBox tb = (TextBox)table.Rows[i].Cells[j].FindControl("TextBoxRow_" + i + "Col_" + j);
tb.Text = Request.Form["TextBoxRow_" + i + "Col_" + j];
Now that I've added a master page to this things apparently have gotten more complicated. This won't fill the value for the textbox in the table cell that I want. I know the value still exists because if I do this
Request.Form.GetValues("ctl00$MainContent$TextBoxRow_" + i + "Col_1")[0]
Has the value that I want to put into that text box. I know the text box gets created because it's there when the page refreshes. But I can't seem to find that text box so i can put a value in it.
I found a good article online and am able to read data from an excel file. The excel file I created has two columns which I am populating column A as the dropdownlist text value and column B is the dropdownlist value Here is my code:
page.aspx
HTML Code:
<form id="form1" runat="server">
<div>
<asp:DropDownList ID="ddlFund" runat="server" />
</div>
</form>
page.aspx.vb
Code:
Imports System.Data
Imports System.Data.OleDb
Partial Class read_excel
Inherits System.Web.UI.Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim myDataSet As New DataSet()
Dim sXLSfile As String = Server.MapPath("/xls/class-list.xls")
Dim strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & sXLSfile & ";" & _
"Extended Properties=""Excel 8.0;"""
''You must use the $ after the object you reference in the spreadsheet
Dim myData As New OleDbDataAdapter("SELECT * FROM [Fund Project List$]", strConn)
myData.TableMappings.Add("Table", "ExcelFile")
myData.Fill(myDataSet)
ddlFund.DataSource = myDataSet.Tables(0).DefaultView
ddlFund.DataTextField = "group"
ddlFund.DataValueField = "groupval"
ddlFund.DataBind()
End Sub
End Class
the excel file looks something like so (<blank> means no data in cell):
Row 1: group | groupval
Row 2: ITEMS | <blank>
Row 3: Blankets | Blankets
Row 4: Beds | Beds
Row 5: STAFF | <blank>
Row 6: John Doe | John Doe
Currently my dropdown gets populated and it's text listing shows up but I want all the items that do not have a value that is blank to be indented. Anyone know if this can be done? How about if I bold just the text that has a blank value?
I'm doing a report that includes blocks of text. The block of text that is inserted into the report is determined using a formula.
I want to indent the first line (similar to writing a letter) of the text. Can anyone let me know how to program this into the formula. I'm looking for something similar to the Bold (<b>), underline (<u>), or hard return (<BR>) codes that are used with HTML format.
I have a dynamic Gridview that I build on the fly. It works great. Now, I want to put paging on it. I have put the following code as an event on Pageindexchanging. When I do, the system tells me that the BindGridControl is not declared. The other lines have no error on them. What am I doing wrong? The name of the Datagrid is MyGridview. If I comment out the BindGridControl the system does not get an error but it of course does not show the second page when I click on it.
[Code]....
I did it with DIV tags rather than trying dynamic page building
I've a GridView with check box and when bind data from database, data is binded correctly as shown below.
106 - Joan Fabregat
107 - Jose Antonio Pons
108 - Enrique Moreno
109 - Miguel Navasa
110 - Ramón Charco
111 - Evaristo Varo Perez
114 - Alejandra Otero
But, when i try to retrive data from datagrid for selected row (gvrow.Cells[2].Text;), then text format changes as shown below:
106 - Joan Fabregat
107 - Jose Antonio Pons
108 - Enrique Moreno
109 - Miguel Navasa
110 - Ramón Charco
111 - Evaristo Varo Perez
Gridview 's displaying T_ID Field but when I 'll try to get T_ID value in code behind
My variable lineId is empty.....
Here the code
[Code]....
I have a column in datagridview which is display the vendor services. It is a textbox type when display. However, when I want to edit the service. I would like to click on the cell, and the cell change to combobox for me to choose. How can I do that?
View 6 RepliesI have the following piece of code which I was hoping would result in an error message being displayed if an incorrect date format was input rather than an website error page saying "The string was not recognized as a valid DateTime."
<asp:TemplateField HeaderText="DateCompleted" SortExpression="DateCompleted"> <EditItemTemplate> <asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("DateCompleted") %>'> </asp:TextBox> <asp:CompareValidator ID="CompareValidator" ValidationGroup="GridView1" ControlToValidate="TextBox2" errormessage="Invalid Date" Display="Dynamic" Operator="DataTypeCheck" Type="Date" runat="Server" /> </EditItemTemplate> <ItemTemplate> <asp:Label ID="Label2" runat="server" Text='<%# Bind("DateCompleted") %>'></asp:Label> </ItemTemplate> </asp:TemplateField>
i want to take gridviews cell text with javascript on firefox and ie how can we do it?
View 6 RepliesI have a GridView where one of the colums has lots of text. Too much text to display because each rows then is almost half screensize each. Is there a way to just display the first words, and then have a function, perhaps mouse over to wiew the whole text? Tooltip maybe?
View 5 RepliesI have a gridview that is being databound by an SQLdatasource and on RowDataBound i am doing a calculation and then setting
e.Row.cells(17).text = Result
However, when I go to sort it on the website it sorts it based off the previous values.Cell(17) from the datasource reads in all 1's. The numbers I change it to range from 0 to 15. So when I click sort nothing changes because it sees it as all 1's.How can i make the gridivew sort off the changed text values?
I am using VB and trying to get the first value of the cell of a gridview. The gridview is returning a header and 1 value.
In the code behind I have used the below, but the textbox is showing " ". It is not populating the first cell of the gridview databind.
Protected
Sub GridView3_RowDataBound(ByVal
sender As
Object,
ByVal e
As
GridViewRowEventArgs)If
(Not (e.Row.DataItem)
Is
Nothing)
Then
' Set the capacity label text
TextBoxTest.Text = e.Row.Cells(1).Text
End
If
End
Sub
A DropDownList is put in a GridView's TemplateField. Its corresponding table cell at runtime shows three controls (verified by checking gv.Rows[iSelected].Cells[iColumn].Controls). The three controls are: 1. Literal; 2. DropDownList; 3. Literal. It is not the case for other controls, at least not for TextBox which I usually access by something like gv.Rows[iSelected].Cells[iColumn].Controls[0]. This is not a big problem because I can always access it by its static ClientID, but I am curious why so and whether other controls have the behavior.
View 2 RepliesTo start with - I'm using VS 2008/.NET 3.5 and working in a company-provided template that leaves me restricted to some/many settings that go beyond the body of the page itself. That said, I need to create a page that will display data from individual cells in a database table that, when lined up would look like a normal sentence. Based on certain criteria I would have certain sections of the sentences hide (ex. if it contains a key phrase or if it's empty).
I've seen a method in which Labels could be used to achieve this effect, where I would assign it the grid coordinates of the cell in a table, but I could never get it to work. I've been successfully connected to the table (LINQDataSource) but still have a blank canvas without this fundamental display technique as that will be all that's in it.
I'm used to Dreamweaver where this is possible. I find it hard to believe that I would need to use a 1 column gridView control.
Is there a way to drag one field from the db Explorer window onto my page and NOT get a grid view?
Or alternatively, I used to be able to put something like this in ASP classic (years ago!) <%= Eval("User") %>
I am trying to highlight a cell in a DetailsView if the value displayed is either "Desktop Computer" or "Laptop Computer" say red, I seem to be able to find examples for gridview but I don't seem to be able to apply this to a DetailsView.
View 4 RepliesUsing Visual Studio 2008 (but have VWD 2010 available). Desire is populate a cell from a number of database items that have been concatenated together. Exampler would be Smith, John, 2010, Going After an Ideal Solution, 500 pages. Gridview allows me to set the cell format, but for the entire cell. I would like to present this as a mixture.
View 6 Repliesi we click a table cell than color is blue and we again click a different cell the first color is remove and second is bule
[Code]....
I have a gridview which i bind to DataView. I need to manipulate text on cell[2] of each row. I was wondering if i could do it in the OnRowCreated event? cell[0] in asp looks like this
<asp:ButtonField DataTextField = "header" CommandName="select" HeaderText="Overskrift"/>
This doesnt work. test = null
protected void onrowcreated(object sender, GridViewRowEventArgs e)
{
TableCellCollection cells = e.Row.Cells;
string test = cells[2].Text;
}
I have a description field on my gridview that gets really lenghty, I want to be able to limit it to about 40 characters and then it they mouse over it show a popup or maybe tooltip with the rest of the data.
[Code]....
I have the following function that translates the header row in a gridview:
[Code]....
When I added sorting to the gridview cell.Text does not work anymore. How can I access the header text in the cell?
I am working on a project where i want to update a cell in a gridview. that is, if i click on a select button in a row, a program in a click event of a button should update a particular cell in the row. in my case, i want to change "open" to "close" when that button is clicked. Am still new but not entirely to ASP.NET ...
View 1 RepliesI have a grid view populated with some data included bit fields and I made an export to excel function For each row i need to check the cell with the bit value to change the cell color, but the cell is always empty, even if is the field is set to False or True. foreach (GridViewRow row in gv.Rows)
View 2 Replies
