----------------------------------------------------------- New Message on MumbaiUserGroup
----------------------------------------------------------- From: Ziaul Message 3 in Discussion Hi Arun, Use Datagridview as databound control. Take your datasource as Datatable instead of dataset. May be it will help you. let me know the complete architecture ...featch logic..assign it to gridviewdatasource.then i can help u more. Regards, Ziaul, Pune To: [email protected] From: [email protected] Subject: Re: Performance issue in dataset displaying millons of records....... Date: Sun, 14 Dec 2008 07:39:36 -0800 <STYLE> ExternalClass EC_ThmFgColumnHeader, .ExternalClass A.EC_FrameLink, ExternalClass A.EC_HeaderLink, .ExternalClass A.EC_FooterLink, ExternalClass A.EC_LgtCmd, .ExternalClass A.EC_MSNLink {color:#FFFFFF;} ExternalClass EC_ThmFgTitleLightBk {color:#FF6600;} ExternalClass EC_ThmFgSmallLight {color:#ff0000;} ExternalClass EC_ThmFgNavLink, .ExternalClass A.EC_NavLink, ExternalClass A.EC_ChildLink:hover {color:#666699;} ExternalClass EC_ThmFgInactiveText, .ExternalClass A.EC_SystemLink {color:#666666;} ExternalClass EC_ThmFgFrameTitle {color:#FFFFCC;} ExternalClass EC_ThmFgTitleDarkBk, .ExternalClass A.EC_NavLink:hover, ExternalClass A.EC_TitleLink {color:#CC6600;} ExternalClass EC_ThmFgMiscText, .ExternalClass A.EC_Cat, .ExternalClass A.EC_SubCat {color:#336699;} ExternalClass EC_ThmFgCommand, .ExternalClass A.EC_Command, ExternalClass A.EC_LargeCommand, .ExternalClass A.EC_MsgLink {color:#003366;} ExternalClass EC_ThmFgHeader {color:#333333;} ExternalClass EC_ThmFgStandard, .ExternalClass A.EC_SystemLink:hover, ExternalClass A.EC_SubLink, .ExternalClass A.EC_ChildLink, ExternalClass A.EC_StdLink, .ExternalClass SELECT.EC_Standard {color:#000000;} ExternalClass EC_ThmFgDivider {color:#CCCCCC;} ExternalClass EC_ThmBgStandard {background-color:#FFFFFF;} ExternalClass EC_ThmBgUnknown1 {background-color:#FF6600;} ExternalClass EC_ThmBgFraming {background-color:#666699;} ExternalClass EC_ThmBgUnknown2 {background-color:#666666;} ExternalClass EC_ThmBgHighlightDark {background-color:#FFFFCC;} ExternalClass EC_ThmBgHighlightLight, .ExternalClass #EC_idToolbar, ExternalClass #EC_tbContents {background-color:#FFFFE8;} ExternalClass EC_ThmBgTitleDarkBk {background-color:#F1F1F1;} ExternalClass EC_ThmBgAlternate {background-color:#ECF1F6;} ExternalClass EC_ThmBgUnknown3 {background-color:#CCCCFF;} ExternalClass EC_ThmBgDivider {background-color:#CCCCCC;} ExternalClass EC_ThmBgHeader {background-color:#9999CC;} ExternalClass EC_ThmBgLinks {background-color:#8696C9;} ExternalClass EC_ThmBgSharkBar {background-color:#8696C9;} ExternalClass EC_ThmBgGlobalNick {background-color:#9394A9;} ExternalClass EC_calfgndcolor {color:#E00505;} ExternalClass EC_calbgndcolor {color:#E00505;} </STYLE> New Message on MumbaiUserGroup Performance issue in dataset displaying millons of records....... Reply Reply to Sender Recommend Message 2 in Discussion From: Aarun_Awasthi HI , I am getting one performance issue in my current projects. My problem is i m binding 100000 records from database with datagridview using data set in my windows application in c# but its taking soo much of time. Please help me if u guys have some knowledge about this issue. Thanks & Regards Arun Awasthi [email protected] From: MumbaiUserGroup <[email protected]> To: MumbaiUserGroup <[email protected]> Sent: Monday, 4 August, 2008 10:45:58 PM Subject: Article: Working with Binary Large Objects (BLOBs) Using SQL Server and ADO.NET <style type="text/css"> ThmFgColumnHeader, A.FrameLink, A..HeaderLink, A.FooterLink, A.LgtCmd, A.MSNLink {color:#FFFFFF;} ThmFgTitleLightBk {color:#FF6600;} ThmFgSmallLight {color:#ff0000;} ThmFgNavLink, A.NavLink, A.ChildLink:hover {color:#666699;} ThmFgInactiveText, A.SystemLink {color:#666666;} ThmFgFrameTitle {color:#FFFFCC;} ThmFgTitleDarkBk, A.NavLink:hover, A.TitleLink {color:#CC6600;} ThmFgMiscText, A.Cat, A..SubCat {color:#336699;} ThmFgCommand, A.Command, A.LargeCommand, A.MsgLink {color:#003366;} ThmFgHeader {color:#333333;} ThmFgStandard, A.SystemLink:hover, A.SubLink, A.ChildLink, A.StdLink, SELECT.Standard {color:#000000;} ThmFgDivider {color:#CCCCCC;} ThmBgStandard {background-color:#FFFFFF;} ThmBgUnknown1 {background-color:#FF6600;} ThmBgFraming {background-color:#666699;} ThmBgUnknown2 {background-color:#666666;} ThmBgHighlightDark {background-color:#FFFFCC;} ThmBgHighlightLight, #idToolbar, #tbContents {background-color:#FFFFE8;} ThmBgTitleDarkBk {background-color:#F1F1F1;} ThmBgAlternate {background-color:#ECF1F6;} ThmBgUnknown3 {background-color:#CCCCFF;} ThmBgDivider {background-color:#CCCCCC;} ThmBgHeader {background-color:#9999CC;} ThmBgLinks {background-color:#8696C9;} ThmBgSharkBar {background-color:#8696C9;} ThmBgGlobalNick {background-color:#9394A9;} calfgndcolor {color:#E00505;} calbgndcolor {color:#E00505;} </style> New Message on MumbaiUserGroup Article: Working with Binary Large Objects (BLOBs) Using SQL Server and ADO.NET Reply Recommend Message 1 in Discussion From: DotNet-Shyam Working with Binary Large Objects (BLOBs) Using SQL Server and ADO.NET Sometimes, your data is not limited to strings and numbers. You need to store a large amount of data in a SQL server table. Documents, raw files, XML documents and photos are some examples. SQL sever provides special data types for such large volumes of data. In this article, I will discuss how to read and write Binary Large Objects (BLOBs) using SQL Server 2005 and ADO.NET. http://www.dotnetbips.com/articles/c7f854b4-b213-4216-ba30-67c6584dc376.aspx Author: Bipin Joshi -- Regards, Shyam Course Coordinator BinaryIntellect Consulting www.binaryintellect.com View other groups in this category. To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. Need help? If you've forgotten your password, please go to Passport Member Services. For other questions or feedback, go to our Contact Us page. If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. Remove my e-mail address from MumbaiUserGroup. Add more friends to your messenger and enjoy! Invite them now. View other groups in this category. To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. Need help? If you've forgotten your password, please go to Passport Member Services. For other questions or feedback, go to our Contact Us page. If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. Remove my e-mail address from MumbaiUserGroup. Some big movies will hit the screen this Christmas. Catch all the previews and promos on MSN Entertainment Try it! ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/mumbaiusergroup/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[email protected]
