If you going to use treeview control for this much data,the page hangs!!!
Instead try with GridView..
If treeview is ur preference,add filters for certain columns (name..etc),so the user can enter and see only the data they need...
Vidhura
Last Activity: Jan 30 '08, 12:23 PM
Joined: May 14 '07
Location: Chennai
-
May be you can add filter criteria .When the user enters the required filter value,just only get those records (partially load the data) and show in screen....Leave a comment:
-
To maximize,set Windowstate property of the form
this.WindowStat e = System.Windows. Forms.FormWindo wState.Maximize d;
For arranging according to the screen use controls dock and anchorstyle properties...Leave a comment:
-
These are the datagridview events.
this.dataGridVi ew1.RowHeightCh anged += new System.Windows. Forms.DataGridV iewRowEventHand ler(this.dataGr idView1_RowHeig htChanged);
this.dataGridVi ew1.RowPostPain t += new System.Windows. Forms.DataGridV iewRowPostPaint EventHandler(da taGridView1_Row PostPaint);Leave a comment:
-
//If the node contains child nodes
TreeNode trChild1=new TreeNode("Child 1");
TreeNode trChild2 = new TreeNode("Child 2");
TreeNode trParent = new TreeNode("Test" ,new TreeNode[]{trChild1,trChi ld2});
treeView1.Nodes .Add(trParent);
//If only nodes
treeView1.Nodes .Add("Test");...Leave a comment:
-
Is your application is WEb or windows?
If windows,it automatically show the scrollbar when data exceeds in datagridview...Leave a comment:
-
Y u want to open anther datagridview?.. .instead cant u open anther form and show all those rows right?...Leave a comment:
-
In MouseHover Check the row index if it is -1 then it will be a columnheader row and write condition to show the tooltip only when rowindex = -1...Leave a comment:
-
select datediff(year,D OB,getdate()) from table...Leave a comment:
-
string Val=this.datgri dview1.Rows[rowIndex].Cells[index].Value.ToString ();...Leave a comment:
-
The data types text are incompatible in the equal to operator.(
tblemp.fname = beginning_balan ces.fname)
The problem is a datatype of fname and lname.
Can't use varchar instead of text.? Refer the following link
Text datatype...Leave a comment:
-
Use UNION
Select * from YARN_FPDT_IN
UNION
Select * from YARN_FPDT_out...Leave a comment:
-
You have to use Exec dbo.sp_StaffDet ails @ID
Refer the following
http://www.aspfree.com/c/a/ASP.NET-C...return-values/
You can use SQL function instead for first stored procedure
CREATE FUNCTION dbo.UDFStaffDet ails
(@ID int)
-- Procedure B
RETURNS TABLE
AS
RETURN(SELECT
tblStaff.Staff_ Code,tblStaff.S taff_Name,tblSt aff.Staff_Surna me,tblStaff.Bus iness_Unit,tblS taff.Line_Manag er...Leave a comment:
-
Make the Column.Width=0...Leave a comment:
-
Sample:
Declare @val Varchar(2000)
select @val=Coalesce(@ val , '') + convert(varchar ,ID) + ',' from tEmployee
print @val...Leave a comment:
-
Use bindingsource
BindingSource bs= new BindingSource(d ataset, "table");
dataGridview1.d atasource=bs;
To filter the records
bindingSourceRo ute.Filter ="ID=20";
Bind it again with datagridView
dataGridview1.d atasource=bs;
this.dataGridvi ew1.Update();...Leave a comment:
-
Dim myselectquerya As String = "SELECT sta_category_id _fk FROM tbl_staff_assig nments WHERE tbl_staff_assig nments.sta_proj ect_id_fk =(SELECT pr_project_id_p k FROM tbl_projects WHERE tbl_projects.pr _project_locati on = ?PName ) and tbl_projects.pr _project_id_pk = ?CID "...Leave a comment:
-
SELECT *
FROM tbldata
WHERE datee BETWEEN startdate AND enddate
before giving the value from form,convert the startdate and endate to datetime type...Leave a comment:
-
No..You cannot undo it...Leave a comment:
No activity results to display
Leave a comment: