referring to: [URL] v nice it works.. but i have tried this before in my previous app it works but i just try now <%# Container.ItemIndex + 1 %> but not work ..what is the difrence in these
View 3 RepliesI apologize in advance for my poor english:1. I have a dropdownList within my datagrid and its already populated fine (22 rows in my datagrid)2. The select item for the 21 row is the same as the select item of the 22 row3. When trying to do selectedIndexChange for the 22 row, it didn't seem to work.The error:
Dim ddl As DropDownList = CType(sender, DropDownList)
Dim dgi As DataGridItem = CType(ddl.Parent.Parent, DataGridItem)
Dim rowID As Integer = dgi.ItemIndex
The rowID keep staying at 20 even though the selectedIndexChanged is happening in row 22( ie. rowID should be 21)
I have a gridview which i want to update line by line.Its for confirmed users.SO i have a list of users and they are confirmed by clicking the checkbox and updating the value in the database.But how can i find the checkbox on the gridview and get the value. Ive tried the following code but no joy
[Code]....
i use this query as my sql query :
SELECT TOP 5 * FROM MyTableName WHERE ID=@ID ORDER BY NEWID()
As you may know it gets 5 records by random. I use it with dataset and bind the listview to this dataset and in ItemDataBound i want to do some programming (like making some controls visible or invisible) i need itemindex.
but the question is : how can i get the itemindex of a listview when sql query selects records randomly?
I have a TabContainer, and one of its tab panels has a user control with a wide GridView in it. Because of some reason, the GridView goes way beyond the size of the tab panel and the tab container. How can I make the tab panel expand based on the width of the GridView?
View 11 RepliesHow to deal with Null values in GridView Container.DataItem
[Code]....
I have been attempting to find a solution for my phone number formatting problem for 2 hours now and I am not getting any closer. My 10 digit phone number is stored as a varchar(14) without any formatting (just 10 digits).
Here is the code to format the phone number in a gridview:
[Code]....
why the formatting won't work? It just displays the 10 numbers with no formatting.
I experience a strange issue with DropDownList today.
It is bind to SqlDataSource which produce about 1500 item. SqlDataSource working properly and no mistake in SQL.
When i bind it to a DropDownList, first item automatically selected on load. But if i try to select other items, DDL never renders. Width of DDL shrinks to zero. But if i use UP and DOWN arrows, i can go through items which appears on the first line of DDL. Shortly, DDL never render a LIST of data for me as it is supposed to do.
If restrict the data as "SELECT TOP 100 SupplierName blabla..", the DDL works properly. Is there any data limit in DDL? 1500 line is massive for DDL?
With the same SqlDataSource, ListView control is working succesfully.
Here is my ASPX
[Code]....
I am using a textbox to populate mySQL database. My problem is when I recall the text it displays without line brakes or line spacing, inserted in the input textbox. I have tried all the field types i.e. Text, Small, Medium Text and Chars. I have tried gridview, repeater and datalist all displaying continuous text without line brakes.
View 4 RepliesI have a
<%# DataBinder.Eval(Container.DataItem, "starttime") % >
i.e. starttime is field in mysql which i bind to asp:Repeater. and want to print as <span>Start Time:
<%# DataBinder.Eval(Container.DataItem, "starttime") %> </span>
if starttime is not blank ..and if blank, print nothing.. How to do this in asp.net ...
How do you get a Multi line header for a Gridview in Asp.Net. I have tried setting wrap="true". I have tried
HeaderText= "Abnormal /n/r Mild PFT".
<asp:BoundField DataField="SEL_PARAM" HeaderText= "Abnormal Mild PFT" SortExpression="SEL_PARAM">
<HeaderStyle Width="20px" Wrap="true" Height="20px" />
</asp:BoundField>
I want to add multiple header line on each row. I have tried many times but it still doesn't work with my code.
Here is my code:
[Code]....
i have an Grdiview within that two table is there, one is for header another is for body section, now the horizontal line is coming on the gridview but vertical line is not coming, below is my code
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
CellSpacing="1" CellPadding="0" AllowPaging="True" PageSize="200"
CssClass="searchResult" OnRowCommand="GridView1_RowCommand"
OnRowDataBound="GridView1_RowDataBound">
<HeaderStyle CssClass="searchResultHeader" HorizontalAlign="Center"/>
<RowStyle BackColor="#ecf5ff" ForeColor="#333" Font-Size="11px" Height="30px"/>
<AlternatingRowStyle BackColor="white" ForeColor="#333" Height="30px"/>
<Columns>
<table cellspacing="0" width="100%" >
<HeaderTemplate>
<tr>
<td>...some asp controls</td>
<td>...some asp controls</td>
<td>...some asp controls</td>
</tr>
</HeaderTemplate>
<ItemTemplate>
<table cellspacing="0" cellpadding="0" style="width:100%;" >
<tr style="height:30px;" >
<td width="5%" style="font-
size:11px;height:30px;width:5%;" >
<td width="5%" style="font-size:11px;height:30px;width:5%;" > ...........................
so, horizontal line( _ ) is displaying, now i want to show the vertical line(|)
I have a ASP.NET gridview (embedded into a DIV) with several columns. For some columns line wraps are definied and for some not(with ItemStyle.Wrap = true/false). For all columns ItemStyle.Width is set to a specific value. Now I am wondering, that there is a line wrap in a column, where ItemStyle.Wrap = false. What could be the reason for that?
View 1 Repliesany one know why are the following two give me different result? they should both give me no results as the value I give is not available. however, number 1 give me many results, and number 2 works as expected. I'd like the number 1 working as the same as number 2.
1. DECLARE
@SearchMCat nvarchar,
@SearchTitle nvarchar,
@SearchDesc nvarchar
SET @SearchMCat = 'fjiewo;jafoia'
SET @SearchTitle = 'fryere'
SET @SearchDesc = 'fdsfdsafae33'
SELECT ArticleCategory.CategoryDisplayName, Article.AudioPlaybackTargetTabID, Article.VideoPlaybackTargetTabID, Article.StartTime, Article.DateAdded, Article.Body, Article.Synopsis, Article.Title, Article.ArticleHasAudio, Article.ArticleHasVideo, Article.createdBy,
Article.RatingTotal, Article.RatingCount, Article.ArticleID, ArticleCategory.CategoryName
FROM ArticleCategory RIGHT OUTER JOIN Article ON ArticleCategory.ArticleCategoryID = Article.MasterCategory
WHERE (ArticleCategory.CategoryName LIKE '%' + @SearchMCat + '%') or (Article.Title LIKE '%' + @SearchTitle + '%') or (Article.Body LIKE '%' + @SearchDesc + '%')
2.
SELECT ArticleCategory.CategoryDisplayName, Article.AudioPlaybackTargetTabID, Article.VideoPlaybackTargetTabID, Article.StartTime, Article.DateAdded, Article.Body, Article.Synopsis, Article.Title, Article.ArticleHasAudio, Article.ArticleHasVideo, Article.createdBy, Article.RatingTotal, Article.RatingCount, Article.ArticleID, ArticleCategory.CategoryName
FROM ArticleCategory RIGHT OUTER JOIN Article ON ArticleCategory.ArticleCategoryID = Article.MasterCategory
WHERE (ArticleCategory.CategoryName LIKE '%' + 'fdsafdsafdsa' + '%') or (Article.Title LIKE '%' + 'fffaery' + '%') or (Article.Body LIKE '%' + 'fdas3r43ffdsa' + '%')
I had problems with using the gridview. For example I can bind or a a row of data to the gidview but the column data in the details section does not line up appropriately as far as justification with the grid view headers. I have tried different alignment combinations but that does not work.
View 1 RepliesI need convert gridview lines in select button, like a CommandField.
I've one image example, where is the arrow is the location that be convert to select button, right image has the original selected button of dot.net!!
I have a DataTable of datetime objects - starttime and endtimes for 1 to infinite (almost) weeks. I've created a webcontrol of my own because I can't get either a DataGrid, GridView or a Repeater to break line after each week in my DataTable.
But it most be possibly to make it happend.
My data is sorted by asc using my Startdate.
Is there an eventhandler on either of the mentioned controls where I can do my check for every 7th day and then make my control break into a new line for the next week and so on?
Havin quite a bit of trouble with this one. I have a bunch of days that I worked in my database...mostly monday-friday and some saturdays. What I want the gridview to do is add an empty line between each sunday and monday so that it seperates out my work weeks and makes it easier to read in the gridview. I got some help here a few days ago on how to clone the db etc and I have all that working properly but I can't seem to wrap my head around how to do add these empty lines in the proper spots. Here is my code so far:
[Code]....
What ends up happening is since I "seed" a variable with a specific date, the empty space inserts start getting off by a few days after awhile. I know why this happens but I'm not sure how to fix it.
One column in my GridView has the format 1-2345 (one digit followed by a dash followed by four digits. Normally, everything looks OK, but sometimes the other data in my GriView will expand to two or more "lines" in the same row of data. Unfortunately this causes my cell to look like the following:
1-
2345
This looks really really awful and I need to fix it. You know how in HTML there is the non-breaking space symbol? Well I want a non-breaking dash symbol.
I am displaying city name in grid view using hyperlink column. Because of large number of city name i want to display it in two or three line and paging
here is my code
<asp:GridView ID="GridView1" runat="server" AllowPaging="true" PageSize="60" AutoGenerateColumns="False" DataKeyNames="cityid" BorderColor="#0D1719" CssClass="hotelname">
<Columns>
<asp:HyperLinkField DataTextField="cityname" DataNavigateUrlFields="cityname" DataNavigateUrlFormatString="hotelscity.aspx?Hotels={0}" />
</Columns>
</asp:GridView>
i want to display 30 city name in one line next 30 in 2nd line.
I am creating a Data Tabel in code behind and binding it to Gridview. I am trying to format by creating new line in a single column. Here is the code:
row("Employee Name") = empName + ("<br/>" + empTitle
GridView1.DataSource = myDataTable
GridView1.DataBind()
I have a gridview. In that i am displaying links. See belw code
<asp:GridView
ID="grd"
AutoGenerateColumns="False"
[code]...
I need a bit of help with a scenario. I am working on a web application that requires huge amounts of data to be Added, Deleted, and Updated. The data entry forms are divided into logical groups through Multiviews. All the information is saved when the mighty Finish button is pressed. The current setup (previous developer) does not allow me to use transactions. Therefore, if I am to save a new Courier to the database, I need to add his/her Distance and Rate info. In addition, I need to add his/her Banned Areas info (Area Name, Post Code).This is where it gets interesting. Obviously, the DistamceAndRate table and the BannedArea table in my SQL Server will have the CourierID as a foreign key. Since I'm going to save the Courier as well as the Rates and Areas info in one go, I cannot have the newly created CourierID before. Therefore, I cannot bind my Grids for Distance + Rates and Banned Areas directly to database.What I am doing is creating two DataTables and managing them in Viewstate through properties as follow:
[Code]....
So, on page load, the DataTables are initialized with a blank schema. Here are the attempted CRUD implementations (Distance and Rate only):
[Code]....
I am having issues when I am canceling a new entry and when I am editing a new entry. In addition, for Distance and Rates, Rate is acting as unique (cannot be repeated) and attempting to control that is also giving me a headache. I end up creating blank rows.And here's the ASPX cut-out:
[Code]....
Hope to get an answer soon.Also, off-topic, I'm using LINQ here. In order to save a Courier and his/her extra details, I first save his/her address to DB. Then I take the ID of the address and save the courier. now the courier ID is avaliable and i start filling extra tables related with the courier table. If something goes wrong, I have to manually delete created rows. LINQ uses transaction internally but only until a SubmitChanges() call. I'm forced to save each entity so I keep calling SubmitChanges().I tried manual transaction but after saving the address inside a transaction, the Address.OID (Address table's mapped prime-key) had a 0. attempting to use this newly added address while saving Courier in the same transaction threw an exception. If there is a way to get the primary key for entities created in a transaction that is yet to be commited, please mention that'll as well.
I knwo how to capture a line number from en exception error...but I have a need to capture the line number that certain things occur wihtout having excpetion thrown. I guess one way would be to force an exception to occur and then trap the line number but I dont really want to do that because that seems clumsy to me.
What woudl be nice is if there were some way to just say "what line of code is this?" programmatically.
so that regarldess of any code changes when I need that information to be grabbed it alwasy grabs the right value.