I am inserting a new record in a form that has two textboxes txtName, txtAge and I am using an ajax calender extender txtDOB and a gridview control gdvDisplayRecords with 3 fields name, dob and age. So when i select any date from ajax calender extender, the gridview must display only those records from the database which have same DOB before i try to add this new record.
View 1 Replies
I have to add the total no of present in grid view.
E.g.
id name status1 s Present1 s Present1 s Present total 3
I need to show the present days as total.
I have a gridview bound to object data source & in its item template i have some labels and one image control and I have a [Status] column in database that store either true or false in bit format . now what i want is if value in status column is true then image control's ImageUrl property should use image ~/images/Show.jpg and if it have false value then it should show ~/images/Hide.jpg.
currently i am using this code it works fine but i think there must be some good better way to achieve this goal. here is the code that i m using
if (e.Row.RowType == DataControlRowType.DataRow)
{
Image img = (Image)e.Row.FindControl("ImgCatStatus");
if (img.AlternateText == "True")
{
img.ImageUrl = "~/images/Show.jpg";
}
else
{
img.ImageUrl = "~/images/Hide.jpg";
}
i have bound the alertenateurl to <%#Bind('Status')%> and performing evaluation based on value it contain
how to display row values based on condition in grid view control and how to display different row colors based on condition in grid view.
View 1 Repliesif i give the 10 number,10 number of same images should be diplayd in the Grid View.
how can i do that.
i m displaying an image in gridview based on condition from sql table. That is if the colum named "availabillity" is A the image will be red n if the value is "NA" the image will be green. i am using RowDataBound event.
but i am getting error as "Cannot implicitly convert type 'System.Web.UI.WebControls.DataControlRowType' to 'bool'".
In my database having 50 records,i wnt to display the first 10 record on first page of gridview and next 20 record on second page and so on..
View 1 RepliesI want to delete recodrs from based on some join condition between two tables.
One table belongs to my DB ( table name : FeeDetails)
and second table ( TargetTable) is on different server.
I have delete records from TargetTable table based on join condition between two tables.
I am able to select records
[Code]....
How to display whole records from database in Gridview and also do filteration using textbox ?
View 1 RepliesI am santhosha, actually am developing a sample web application using asp.net and c# which includes a sample CRUD operation, here i want to display updated record to first row of the gridview.
View 2 RepliesI have a function or binding grid where i pass the flag for query to be displayed for page load i have below query
if (flag=="pageload){sql= "select "; sql= sql * " from (select top 50 * " from ";
sql= sql+ "(select top 50 * from EMPLOYEE order by NAME )";
sql= sql+ " as T1 order by T1.NAME DESC) as T2 order by NAME ASC ";
} else if flag=="filteration select * from EMPLOYEE
In the above query i get 50 records per page & the next prev navigation works fine but when i filter out the records i cant use the above query to get the filtered records as I need to filter from the whole recordset say I have total 1000 records after filtering i get 500 records after filtration i am not able to navigate across the records correctly...
I want to display all records from database in gridview when pageload and also i wanna search for particular record using textbox appear in my webform .
Means by default all records from the table will appear in gridview using sqldatasource and i also wanna search for a particular record by enter ID in text box ...
how to display records using tooltip?when user mouseover in his id or any unique things, all the records from the database display.
View 1 RepliesSub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs)
Label3.Text = GridView1.Rows.Count.ToString()
End Sub
Is there any settings in gridview properties....
I have a dropdownlist which contains TEACHERS and STUDENTS, and I'm using gridview to show their information. But I don't know how to display records that depends in dropdownlist.
View 1 RepliesActually I am developing one web application,in that application I used a gridview to display all the database records in a page. I provide hyperlink print for every row, if I click the print option, the particular record will be print in the crystal report..
View 1 RepliesMy requirement is i have to display column wise records in GridView control.
I am thinking to create a user control for this.
See the attachment of sample screen.
Sandeep
My requirement is i have to display column wise records in GridView control.
I am thinking to create a user control for this.
See the attachment of sample screen.
Sandeep
Is there a way to select the number of records/rows to display in the gridview by a drop down list
View 2 RepliesHow to set letter NO in gridview is empty record...
View 1 RepliesI have datatable like
Name Sub
abc x
dfe y
abc z
I need the out put as
Name sub
abc x
abc z
and
Name Sub
dfe y
I have a datagrid control which is bound to a table which containing more than 1000 records. And i want to show only 25 records once a time. I have used paging in datagrid. But each time the next page index is set, query is fired again. This takes lots of time. So what is the easiest way to bound data in this case to improve performance.
View 3 Repliesi am having table in which date, company name and amount is stored
i have one dropdown in which i kept year
now i want to show data in gridview according to year selected from dropdownlist but how i can seperate date from year in date field
protected void ddlYear_SelectedIndexChanged(object sender, EventArgs e)
{
conn.Open();
[Code].....
I have a requirement like need to display 5000+ records in gridview. So, I created scrollable div with gridview init and displaying 200 records per page. The website is running very slow because eveytime when user click on paging, it retrieving all the records from the database. I need to increase the website performance. I heard about a concept Girdview lazy loading but i don't know how to implement. I am looking for a solution like records should display in gridview when ever user scroll the bar down. How to do the gridview lazy loading.
View 1 Replieshow to use a multiline text box that i could copy data into. Lets say addresses one on each line and then click submit and have it display those records in the database (SQL) in a gridview?
View 7 RepliesIn my asp.net gridview i want to count how much peoples are qualified in MCA and display the value in a lbel in same page. The qualifications are in COURSE field in my table anme persadata
table name is PERSDATA
PNO NAME COURSE COMPANY
121 RAJU BCA TCS
234 RK SINGH MCA TECHNO
525 P RAJ MCA KELTRON
325 ANIL BBA BPL
235 KUMAR MCA TATA
