I would like to be able to use the ASP.Net Repeater control to create an HTML Table that has three columns and as many rows as necc.For example if the Data were to look like this
"Phil Hughes"
"Andy Petite"
"CC Sabathia"
[code]...
I want to create a temporary table where the columns of that temporary table needs to be dynamic (those columns needs to come from the rows of another table)
View 6 RepliesI would like to be able to format my IList<T> so that the results appear in 3 Column Table, This is similar functionality to ASP.Net Repeater control in Web Forms by using the RepeatColumns Property
For example if the Data were to look like this
"Phil Hughes"
"Andy Petite"
"CC Sabathia"
"AJ Burnett"
"Javier Vazquez"
The Rendered Results would appear as
<table>
<tr>
<td>Phil Hughes</td>
<td>Andy Petite</td>
<td>CC Sabathia</td>
</tr>
<tr>
<td>AJ Burnett</td>
<td>Javier Vazquez</td>
<td></td>
</tr>
</table>
I want to copy data from a table[tblExcel][No.of columns:2] to another table[ev_event] which has 5 columns, 2 columns from the another table, 3 columns from user defined value
[code].....
I have created a web project using asp.net and visual web developer 2008. On my local project I created a new column in one of my MS SQL data tables and populated it with data. How would I create a sql script of the new column and data? I want to insert this into my live database on Godaddy?
View 1 RepliesI'm creating dynamic table which having more than 20 rows and number of columns can be change according to user input. first column is header and other columns need to bind using data returning from web services. And there are few rows which can editable. when user click on submit button need to validate the changed cells and process the data.I have created ASP.net table and added rows and cells one by one. but this is not reusable way of doing, is there any alternative to create editable dynamic table with left column as header?
View 3 Repliesi'm writing an asp.net C# web application; i have an in-memory datatable named 'table1' having three columns 'country', 'productId' and 'productQuantity'; i want to pivot that table in order to obtain a new table (suppose 'table2') having the first column 'country' as a fixed column and a dynamic number and names of columns 'product_1', 'product_2', ..., 'product_n' according to the total number of products existing in 'table1'; the first column 'country' must contain the country name; the dynamic generated columns 'product_1', 'product_2', ..., 'product_n' must contain the productQuantity that has been selled for each specific product in the specified country
i'm using Linq query expressions to write the code; the problem is that i cannot hard-code the names neither the values of the products; i cannot predict how much products exist in the datatable;
for now, i'm testing the results using the following expression :
[Code].....
i'm giving an example on how 'table1' looks like and how 'table2' must look like :
view example image of the two tables table1 and table2
I am quite new to LINQ, and I am stuck with this probably basic problem, but haven't been able to find a solution, so I thought I could ask here.
So, I have this repository where I put my functions for data accessing, and now I need to write a function to get all the applicants that have applied for this particular advertisement, and their values too. Now, the values are stored in a separate M:N table, where every row consists of the applicantID,advertisementID and value. I just wanna append the value to every applicant that I show, so that it would look like a Ranking List.
However, I do not seem to know how to select just the name column from the Applicant table, and just the Value column from the ApplicantValue table.
And there's this Iqueryable interface that further confuses me...
Here's my function to get the Applicants only:
[Code]....
Now, if I try to add to the definition of the type two columns, it says that it only messes with types, i.e. one type should be passed. So I figured I would do a ViewModel and then pass it, like this
[Code]....
and then in the function I have no idea how to pass the values:
I am trying to get the row value/inner text from a table I have inside a repeater list. I am using jquery/tableDnD to drag and drop the row at which time I update the row number with the new position. Ultimately I would like to insert these new values into a table but I am having a problem accessing the client changed data using a c# procedure.
[Code]....
I'm currectly tryin to access a specific value in my database in a specific column. I'm tryin to use the primary key of the table to access the actual value in the row of that ID.
The current code:
[Code]....
Just iterates through the table and looking for any row with the boolean 'checkin' value is True, then it takes the 'id' value of that row and stores it into an array. Is there a way that I can access a another entry, and only that entry, in the table with the 'id' stored in the array?
Like if my data base contained and int, primarykey, `id` value, a boolean, `checkedin` value, and a `time` value, is there a way to access, lets say, the row with `id` equalling 3 and and the checkIn value from that row?
How to handle this error
"An explicit value for the identity column in table 'UserActivation' can only be specified when a column list is used and IDENTITY_INSERT is ON."
i have a table which showing the food data from my Model, including Name, Amount, Storage and Expiry Date. I wish to either:
1. Let user click on the column header and sort the column they want
2. Or default showing the food which almost expired on the top of the table
I am creating dynamic view using two tables.one is emp_Tbl and 2nd table emp_salary which is created dynamically .creating view it gives error 'Create View or Function failed because no column name was specified for column 2.
my code is: create view [dbo].[Emp_Salary_pay] as select dbo.Emp_Tbl.Emp_Status, (select column_name + ', ' from information_schema.columns where table_name = 'Emp_salary' ) FROM dbo.Emp_Tbl INNER JOIN dbo.Emp_Salary ON dbo.Emp_Tbl.Emp_Id = dbo.Emp_Salary.Pay_Emp_Id
how can i use html to create table(<table></table>) in code behind c#?
View 18 RepliesI am working on a web app for an online photo album. It is the last project in Scott Mitchell's book: "ASP.Net 2.0 in 24 hours".
I am creating a page where users can enter new photo images. The functionality for uploading an image will come later. I am working on just inserting a new row into the Pictures table with an optional category, a required title and a required description.
I am getting an error when I try to insert a new row.
Here is a screenshot of the page with a shot of the dropdown list.
The Categories are user-specific. I am getting the correct values retrieved.
[URL]
There are two pretty simple database tables involved here.
NOTE: The CategoryID and PIctureID are both autoincrement integer columns.
[URL]
The page uses a DetailsView that uses a SqlDataSource that uses the Pictures table. (The DetailsView's Default Mode property is set to "Insert". The "Enable Inserting" checkbox is also checked.)
The dropdown list uses a dropdown control that uses a SqlDataSource that uses the Categories table.
When the "Insert" button is clicked the CategoryID value associated with selected (Category) Name on the dropdown list will be used along with the Title and Description values to insert a row in to the Pictures table. (If no Category value is selected, then a null value will be used for the CategoryID. This is OK because the CategoryID column in the Pictures table allows nulls.)
My problem is that I am getting this error:
Cannot insert explicit value for identity column in table 'Pictures' when IDENTITY_INSERT is set to OFF.
(FYI: I have the full version of both Visual Studio and SQL Server.)
Here is my source code for the page:
[Code]....
i have 3 tables which are Table A(a Id,b Id),
Table B(b Id,a Id,c Id),
Table C(c Id,b Id)
How can i select Table C column by using table A?
How would I go about doing this programatically?
I can do this just fine declaratively, using a template column and then using something like this:
[Code]....
I am dynamically creating this grid based on the data, so I'm already added columns with one set of controls. But now I need to figure out how to show multiple images, which expand/contract if the groupImg image control is clicked (i just toggle the ul) ..
I am working on a Repeater that reads from a table with a layout something like:
string Title
string Location
bool Water
bool Sewer
bool Picnic_Table
bool On_Beach
I am creating a list of amenities for each "Title" so I need to loop through the columns and get a list of amenities for each Title (or site). Optimally, I have a loop to go through the list. Something like
for each column if column is not Title or Location Append to StringBuilder "column name"
How do I get that column name to do the comparisons?
I have a column in an asp:repeater control that needs to be a hyperlink in which a user can click on it. By clicking on this link it needs to execute a function (this function creates an HTML letter and displays the letter in the browser) in my VB.Net Code-Behind. I'm not sure what kind of control to use that will allow this kind of functionality. Not sure if a Button or an Anchor would be best or even something else. I'm truly perplexed on this.
View 3 RepliesI have an asp:repeater control on a form. It contains 4 columns. Based on a certain value as a result of a database read, the 4th column, needs to contain a button control else it will contain plain text. How do I this in the code-behind using VB.Net? The code that I have is below but it's not working. I've never worked with a repeater control before.
Code:
<asp:repeater id="dlAppeal" runat="server">
<HeaderTemplate>
<tr id="AppealHeader" runat="server">
<td class="tableHeaderNw" align="center" width="11%">Date</td>
<td class="tableHeaderNw" align="center" width="16%">Type</td>
<td class="tableHeaderNw" align="center" width="53%">Description</td>
<td class="tableHeaderNw" align="center" width="20%">Appellant</td>
[code]....
Look at the below picture I want to count value of last column (cnt) I am using repeater control.
example:
if (last column (cnt) is greater than 5> ) {
response.write ("yes");
}
SQL Query
SELECT id, category, ( SELECT COUNT(id) FROM entry_table WHERE category.id = entry_table.Cat_id) as cnt FROM category
<asp:Repeater ID="CloudTags" runat="server" OnItemDataBound="CloudTags_ItemDataBound">
<ItemTemplate>
<asp:HyperLink ID="HyperLink9" runat="server">
[Code] ....
i am trying to create a temporary table as like an existing table.
create table #tmp AS ( select Table1.* from Table1 where Table1.column name in (select Table2.column name from Table2 where conditions) )
But it is showing Error...
I'm assuming I need to use a pivot table from what I've found so far. However, every one that I've seen has not had the date setup like I have.
I have a Gridview on my page which I need to be populated like so
Date NCMR
1/1/10-1/31/10 #
2/1/10-2/28/10 #
I want to do this for 10 months... bottom record being the current month (or last month). I would also like the Date to format to January 2010 I used the above date format because that is how it is in the table. Basically, I need to know how to create the pivot table to search the table for 1/*/10, 2/*/10, etc
how do create 10 cloumns and 10 rows in the table. The rows will came a1,a2....a10.
View 4 RepliesI have repeater control and price fileds inside it i want to have a sum of all prices row on footer of repeater.
View 1 Replies