<table id ="Table2 " border ="1px" style ="height :200px ; width :690px; visibility :hidden; " runat ="server" >
my Table id is "Table2"
protected void Button3_Click1(object sender, EventArgs e)
{
Table2.visible=True;
int Student_id = 0;.....
How to hide a table row in repeater control in ASP.NET?
View 1 RepliesData tables. I have been using in my project for Pagenation as well as sorting. My problem is that i could not be able to hide the rows of the table. Here is my code
Code:
<%
sql = " select attend from STD_Student_02 where STUDENT_ID ='Ramesh1987' "
cmd1 = New System.Data.SqlClient.SqlCommand(sql, conn)
reader1 = cmd1.ExecuteReader()
If reader1.HasRows Then
Do While reader1.Read()
[code]....
How to dynamicaly hide and show table in rdlc file with the help of parameters.
View 2 RepliesI want to make a table visible when a checkbox is ticked and invisible when unchecked, any suggestions?At the moment I have a webform with 1 checkbox and my table which I would like to show/hide.
View 13 RepliesI want to hide a column of ListView based on the role from the code behind. Here's the mark-up and the code:
<asp:ListView ID="lvTimeSheet" runat="server">
<LayoutTemplate>
<table id="TimeSheet">
<thead>
<tr>.....
But that column id="thDelete" is visible all the time. How do I go about hiding the column based on some condition from the code behind?
So I have an <asp:Gridview> and in my C# file, I am setting the datasource to some database table, and doing .DataBind().
However, I want to hide a column in the table based on a Boolean variable.
Something like this:
gridview.Columns['Field5'].Visible = false;
Or perhaps:
int c = gridview.Rows.Count();
for(int i = 0; i < c; i++){
gridview.Rows['Field5'].Remove();
}
Perhaps I cannot make it invisible, but I'm sure I can at least loop through and remove all rows related to the column "field5". I don't know how to go about doing this.
Does anyone perhaps have a proper link to using the GridView Class and how all the methods are suppose to be used because it's not clear, perhaps not written by microsoft?
the internet seems to lack a lot of C# documentation (or maybe it's just cluttered with too much useless ASP.net information).
I have a table for which I'd like to filter rows based on whether or not they contain a hidden field matching a value.
I understand that the technique tends to be "show all rows", "filter the set", "show/hide that filtered set"
I have the following jquery but I'm aweful with filter and my filtered set seems to always contain no elements.
my table is the usual
<table>
<tr><td>header></td><td> </tr>
<tr>
<td>a visible cell</td><td><input type='hidden' id='big-asp.net-id' value='what-im-filtering-on' />
</td>
</tr>
</table>
My goal is to be able to match on tr who's descendent contains a hidden input containing either true or false.
this is how I've tried the selector (variations of this) and I'm not even testing for the value yet.
function OnFilterChanged(e){
//debugger;
var checkedVal = $("#filters input[type='radio']:checked").val();
var allRows = $("#match-grid-container .tabular-data tr");
if(checkedVal=="all"){......
i have two Table in ZoneTemplate i need to hide whole Table(dpPatientInfo ,dpAppDetail) according to (rights) Status = "N" when webpatrManager.DisplayMode = WebPartManager.DesignDisplayMode How can i do it?
<asp:WebPartZone BorderWidth="0" ID="wpZoneLeft" runat="server">
<CloseVerb Description="Close" Visible="False" />
<MinimizeVerb Description="Minimize" />
<RestoreVerb Description="Restore" />
[Code]....
I would like to store some business flags (like: isFavorite, isOnLive etc.) per an html table row that won't be visible to user.
In practice, I have a simple ADO.Net DataTable on my code-behind which is used as a data-source for a asp.Net GridView control.
This table contains some business flags on its 0th, 1st, 2nd columns.
I need to store those columns on the rendered HTML of the grid-view -so that I can reach them via JavaScript- but I do not want them to be visible.
I have one master page that is used to gather information from a user. It contains asp.net labels and textboxes within a table. For example, the master page contains fields for Name , Phone, Address, etc.
There are content pages that are created to add to the information that needs to be gathered. For example, the content page, Loan Application, could ask for Loan Amount, LTV, etc.
In addition to this, certain content page forms do not need to show a particular master page field. For example, the content page may not need to ask for Phone.
The table rows are stored as public properties in the master page so I can hide them in the content page code behind.
public bool HomePhoneRow
{
set { trHomePhone.Visible = value; }
get { return trHomePhone.Visible; }
}
So, in the content page code behind, I have this:
Master.HomePhoneRow = false;
The functionality works perfect, but I don't like how the space is reserved on the page. You can tell that a row was removed. I've tried style="border-collapse:collapse" on both the <table> and <tr> elements. I've also tried to set the row height as a public property and alter that.
I have a label and button on label in my asp.net webform ....i want when i click on button then label1 will be visible with text "Success" and then it will hide automatically after some time say 10 seconds ,,,I M using asp.net (VB)How to auto hide label after 10 sec and after label hide redirect to the ~/Default.aspx ?
View 1 Repliesmy main intention is that, the exsisting table of sql server database(.dbo) with 1000's of records, that should be import to a new access database table(.mdb).for example if we want to had a new table in db2, of exsisting table in db1 with some conditions by using "select * into New_Tabel from (select * from Exsisting_Table where <Condition>) as objectName". Here the new table is created and records inserted in one execution in db2. The same work should be done for access(sqlserver db --> Access db).Here the new access database table with given name (as string_sysdate) must be created dynamically by clicking a button (multiples time creating new table).Is there any query or c# code for sql server database to access database.
View 2 Replieshow can i use html to create table(<table></table>) in code behind c#?
View 18 RepliesI have 2 tables:
- Salesmen with Pk.SalesmenID
- Appointments with Fk.SalesmenID and busy(bit)
How can I check if every salesmen has at least one appointment
Am I on the right way with statement below, though I got syntax problems
[Code]....
If I am going to use the asp.net membership and roles, the asp.net database includes an aspnet_Users table that has the userid and email address. If I have custom fields is it best practice to maintain a separate usert table and link on user id or to add fields to the aspnet_Users table?
View 1 Repliesi 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...
how can i select a record from A table and insert into B table using linq?
View 2 RepliesBasically i deal with two tables.i have a table T1 of the following format:id company_name i need to read this data and create a table T2 as followsi wrote the following code. it worked fine for retrieving data and modification but fails to insert the modified data into the 2nd table.the error is, it does not recognise the value for @token
ArrayList dynarr=new ArrayList(); // global variable
protected void Button2_Click(object sender, EventArgs e)
{
int row = 1; int i;
string strcmd = null;
string Connection = "Data Source=....";
SqlConnection conn = new SqlConnection(Connection);
string str = "select company_name from T1 where ID=@ID";
[code]...
I'm currently stuck settings border in a html table. (I use inline stiles for a better rendering in e-mail-clients) I have this piece of code:
[code]....
That will be rendered as this:
I want the table to be rendered like Excel would render a table with inner and outer border.
I have an Access 2010 DB that I have a table of RAW data in. In my scenero when table 'a' has been populated all the rows with the updatedate of Now() get moved to another table... the SQL is like this...
[Code]....
As you can see it is a very simple query but it does NOT return any rows. There are actually 404 rows with todays date in teh Append_Date column.
I am stumped as to why it does not return rows?
I am fairly new to ASP.Net and web programming in general and I am having issues trying to add values from a dropdown list in my gridview to another table.
Here is my scenario. I have 2 tables in my SQL Express DB. When editing the values of table2 in a gridview, I would like to show some data from table1 in a dropdown so users can select a value from table 1 and enter that value in table 2.
I have the Gridview setup to show table2 data.
I created a field template and inserted my dropdown list and linked it to my table1 data source.
When I run my web form, I can click to edit one of the fields in the gridview, and my dropdown list correctly displays the data from table 1, but when I try to update the table2 with the dropdown value, it doesn't correctly update. The row in table2 never updates.
posting the dropdown value from table 1 into the appropriate field in table2..
Again, I am new to this and have been following the tutorials etc on this site, but can't find one pertaining to this topic.
I have two tables for storing language translations - tblEN and tblES. They have the same structure which is nvcEnglish and nvcLocal - both nVarChar fields.
In nvcLocal of the Spanish table, I enter the Spanish translations of words and phrases used within my app. Problem is, when I add a bunch of new records to the English table I also have to go in and repeat the data entry into the Spanish table. I am wondering if there is a way to import the newly added records into the Spanish table using Transact SQL?The plain language query would be something like:
If the data in tblEN.nvcEnglish does not exist in tblES.nvcEnglish then insert a new row into tblES with the values from tblEN
I 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 need to write a query to populate a gridview with minimum rates in ascending order for a month from three tables.For example i have three tables A,B,C as follows
TABLE A TABLE B
TABLE C
Id id id
Quote_no Quote_no Quote_ no
Name Rate1 Equip_name
Rate2 E_rate
Date R1_rate
R2_rate
Date
Now if the data is as follows
I need to get the Name from Table A ,minimum Rate1 and Rate2 values for a month in a dropdownlist from date field from Table B and the corresponding minimum rate(E_rate) for Equipment E1 and E2 only from Table C for the month in ascending order group by Name.
TABLE A
id
Quote_no
Name
1
101
XYZ
2
102
ABC
TABLE B
id
Quote_no
Rate1
Rate2
Date
1
101
105
200
12/11/2010
2
102
90
210
15/11/2010
TABLE C
id
Quote_no
Equip_name
E_rate
R1_rate
R2_Rate
Date
1
101
E1
60
0
0
12/11/2010
1
101
R1
0
110
0
12/11/2010
1
101
E2
80
0
0
12/11/2010
2
102
R2
0
0
300
15/11/2010
2
102
E2
100
0
0
15/11/2010
2
102
R1
0
60
0
15/11/2010
2
102
E1
230
0
0
15/11/2010