here are two options to find the execution time of the stored procedure, First Option: Get the current time before execution. Execute the stored procedure. Get the current time after execution. Manipulate the difference in times which will provide you the exact execution time. declare @startproc datetime declare @endproc datetime declare @time integer select @startproc…
Here we use DataBind method of chart control using System.Web.UI.DataVisualization.Charting; … private void Page_Load(object sender, System.EventArgs e) { // Resolve the address to the Access database string fileNameString = this.MapPath(“.”); fileNameString += “..\\..\\..\\data\\chartdata.mdb”; // Initialize a connection string string myConnectionString = “PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=” + fileNameString; // Define the database query string mySelectQuery=”SELECT * FROM REPS;”;…
Bind data in Chart control using data reader. We use DataBindTable method of chart control. using System.Web.UI.DataVisualization.Charting; … private void Page_Load(object sender, System.EventArgs e) { // Resolve the address to the Access database string fileNameString = this.MapPath(“.”); fileNameString += “..\\..\\..\\data\\chartdata.mdb”; // Initialize a connection string string myConnectionString = “PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source=” + fileNameString; // Define the…
Hello Friends, I am always try to develop my own custom control which help me to develop my application faster. I find some free toolkit which allow to to create desktop application more easier and powerful with great design.. Please check this link http://www.componentfactory.com/
New data type related to date and time in sql server 2008. Follow this link http://blogs.msdn.com/manisblog/archive/2007/08/28/sql-server-2008-enhancements-in-date-and-time-data-types.aspx
Hello Friends, Please folloe this liank and find how you can enable CLR integration in SQL Server 2005. http://www.sqlclr.net/Articles/tabid/54/articleType/ArticleView/articleId/1/Enabling-CLR-in-SQL-Server.aspx
Hello, SQL Server 2005 and 2008 allow user define data type. This data type allow your own rule. Please read below article for more information. http://msdn.microsoft.com/en-us/library/ms190232.aspx
Hello All, SQL 2008 introduce new HIERARCHYID Data Type. Please read below it’a great atricle. http://www.sqlservercentral.com/articles/SQL+Server+2008/67787/
How to override methods in C#
The F method in B hides the virtual F method inherited from A. Because the new F in B has private access, it only includes the class body of B and does not extend to C. The declaration of F in C is therefore permitted to override the F inherited from A. class A {…
Read More