
dotnetstation.wordpress.com
KnowledgeBase | Get Your Knowledge RefreshedGet Your Knowledge Refreshed
http://dotnetstation.wordpress.com/
Get Your Knowledge Refreshed
http://dotnetstation.wordpress.com/
TODAY'S RATING
>1,000,000
Date Range
HIGHEST TRAFFIC ON
Friday
LOAD TIME
0.3 seconds
16x16
32x32
PAGES IN
THIS WEBSITE
19
SSL
EXTERNAL LINKS
20
SITE IP
192.0.78.12
LOAD TIME
0.283 sec
SCORE
6.2
KnowledgeBase | Get Your Knowledge Refreshed | dotnetstation.wordpress.com Reviews
https://dotnetstation.wordpress.com
Get Your Knowledge Refreshed
Adding Date ,Year and Month in DropDownlist using ASP.NET,C# | KnowledgeBase
https://dotnetstation.wordpress.com/adding-date-year-and-month-in-dropdownlist-using-aspnetc
Get Your Knowledge Refreshed. Adding Date ,Year and Month in DropDownlist using ASP.NET,C#. Adding Date ,Year and Month in DropDownlist using ASP.NET,C#. Open New WebSite and Add a Form Naming it as. Copy and paste this code between. Opening and closing tags. 8221;DropDownList1 SelectedIndexChanged”. 8221;DropDownList2 SelectedIndexChanged”. 8221;server” /. System.Web.Security;. System.Web.UI;. System.Web.UI.WebControls;. System.Web.UI.WebControls.WebParts;. System.Web.UI.HtmlControls;. Year, month;.
Asp.net foreach loop example: using foreach loop with Checkbox List | KnowledgeBase
https://dotnetstation.wordpress.com/aspnet-foreach-loop-example-using-foreach-loop-with-checkbox-list
Get Your Knowledge Refreshed. Aspnet foreach loop example: using foreach loop with Checkbox List. Aspnet foreach loop example: using foreach loop with Checkbox List. 8221;LooptoCheckBoxList.aspx.cs”. 8221;CheckBoxList LooptoCheckBoxList”. 8220;-/ W3C/ DTD XHTML 1.0 Transitional/ EN”. 8220; http:/ www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>. 8221; http:/ www.w3.org/1999/xhtml”. 8221;LightSlateGray” /. 8221;Submit favorite”. 8221;Button1 Click”. System.Web.Security;. System.Web.UI;. Checkbox ...
CompareValidator example: how to validate Data Type in asp.net | KnowledgeBase
https://dotnetstation.wordpress.com/comparevalidator-example-how-to-validate-data-type-in-aspnet
Get Your Knowledge Refreshed. CompareValidator example: how to validate Data Type in asp.net. CompareValidator example: how to validate Data Type in asp.net. 8221;Default.aspx.cs”. 8221;CompareValidator Default”. 8220;-/ W3C/ DTD XHTML 1.0 Transitional/ EN”. 8220; http:/ www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>. 8221; http:/ www.w3.org/1999/xhtml”>. 8221;DarkCyan” /. 8221;TextBox1″ /. 8221;server” /. 8221;*” /. 8221;Only Numerics”. 8221;Validate DataType”. 8221;Button1 Click”. Aspnet foreac...
Storing and Retrieving Image from Database | KnowledgeBase
https://dotnetstation.wordpress.com/storing-and-retrieving-image-from-database
Get Your Knowledge Refreshed. Storing and Retrieving Image from Database. PhotoID int IDENTITY(1,1) NOT NULL,. Caption nvarchar(50) NOT NULL,. Photo image NOT NULL,. CONSTRAINT [PK Photos] PRIMARY KEY CLUSTERED. PAD INDEX = OFF, STATISTICS NORECOMPUTE = OFF, IGNORE DUP KEY = OFF,. ALLOW ROW LOCKS = ON, ALLOW PAGE LOCKS = ON) ON [PRIMARY]. ON [PRIMARY] TEXTIMAGE ON [PRIMARY]. Procedure sp imageretrival (@PhotoID int = null). Select Photo from Photos where PhotoID=@PhotoID. 8221;width: 150px”. Cd1Parameter...
Asp.net Checkbox List example: populate from XmlDataSource | KnowledgeBase
https://dotnetstation.wordpress.com/aspnet-checkbox-list-example-populate-from-xmldatasource
Get Your Knowledge Refreshed. Aspnet Checkbox List example: populate from XmlDataSource. Aspnet Checkbox List example: populate from XmlDataSource. 8221;XMLtoCheckBoxList.aspx.cs”. 8221;CheckBoxList XMLtoCheckBoxList”. 8220;-/ W3C/ DTD XHTML 1.0 Transitional/ EN”. 8220; http:/ www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>. 8221; http:/ www.w3.org/1999/xhtml”. Example: Populate CheckBoxList From XmlDataSource. Leave a Reply Cancel reply. Enter your comment here. Address never made public).
TOTAL PAGES IN THIS WEBSITE
19
SQL Functions | KnowledgeBase
https://sqlbase.wordpress.com/sql-functions
Get Your Knowledge Refreshed. To return a single value. To return a table of results. However, you can’t have more than one SQL statement in the function. If your SQL is more complicated, you can use a. Table-valued function by defining the table that will be returned. UDF’s aren’t allowed to modify the physical state of a database using INSERT, UPDATE or DELETE statements. They can only work with local data. Creating User Defined Functions In SQL Server 2000. Creating a scalar UDF. SET @myInt = 1. Our n...
SQL-CURSORS | KnowledgeBase
https://sqlbase.wordpress.com/sql-cursors
Get Your Knowledge Refreshed. Please note that cursors are the. Way to access data inside SQL Server. The should only be used when you truly need to access one row at a time. The only reason I can think of for that is to call a stored procedure on each row. In the Cursor Performance. Article I discovered that cursors are over. Than set based alternatives. Sample creation of a table */. 8216;,’. 8216;,’. Execute Cursor Output will be like */. Leave a Reply Cancel reply. Enter your comment here.
Sample Stored Procedures | KnowledgeBase
https://sqlbase.wordpress.com/sample-stored-procedures
Get Your Knowledge Refreshed. Where are stored procedures actually stored? Stored procedures are stored in the system table called. You can view an existing stored procedure by typing:. Exec dbo.sp helptext ‘. Lists all stored procedures that are currently defined. 8212;——————————-BASIC STORED PROCEDURES——————————-. A normal creation of a table */. Stored procedure to select the table */. 8212;———/* Stored procedure to inserting */———————–. Sp sample insert ‘kamal’. Sp sample update ‘kamal’. MachineName ...
Commit and Rollback Transaction in SQL SERVER | KnowledgeBase
https://sqlbase.wordpress.com/commit-and-rollback-transaction-in-sql-server
Get Your Knowledge Refreshed. Commit and Rollback Transaction in SQL SERVER. Commit and Rollback Transaction in SQL SERVER. Create table sample1 ( firstname varchar(10), lastname varchar(10). Sample Example of Commit and Rollback in Stored Procedure. Create procedure delete sample1(@firstname varchar(10), @lastname varchar(10). Delete from sample1 where firstname = @firstname and lastname= @lastname. If @ error = 0. 2create procedure insert sample1 ( @firstname varchar(10), @lastname varchar(10). Command...
Grouping in SQL Server | KnowledgeBase
https://sqlbase.wordpress.com/grouping-in-sql-server
Get Your Knowledge Refreshed. Grouping in SQL Server. Grouping in SQL Server. Basic Examples of Group By. SELECT DISTINCT Employee, Rank. 2Example of GROUP BY:. SELECT Employee, Rank. GROUP BY Employee, Rank. 3Example of GROUP BY with aggregate function:. SELECT Employee, Rank, COUNT(*) EmployeeCount. GROUP BY Employee, Rank. 8212;———————————–. OrderID int primary key,. DetailID int primary key,. OrderID int references Orders(OrderID),. Select 1,’ABC’, ‘2007-01-01′, 40 union all. Group by o.customer.
Color Codes | KnowledgeBase
https://sqlbase.wordpress.com/color-codes-2
Get Your Knowledge Refreshed. Major hexadecimal color codes. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out. You are commenting using your Twitter account. ( Log Out. You are commenting using your Facebook account. ( Log Out. You are commenting using your Google account. ( Log Out. Notify me of new comments via email. Grouping in SQL Server.
Using Check Constraint in SQL | KnowledgeBase
https://sqlbase.wordpress.com/2008/12/26/using-check-constraint-in-sql
Get Your Knowledge Refreshed. Using Check Constraint in SQL. To protect adding duplicate values and to allow the user to enter only specified value we will use check constraint , its usage and functionality is explained below. Normal creation of a table. I want designation to be (staff or admin) , no other values so im writing check constraint . Ck sample1 (sample name , u can use ur own name here). Clear coding for the above. And then do this. Now try to insert duplicate value and check.
Encrypting Stored Procedure | KnowledgeBase
https://sqlbase.wordpress.com/encrypting-stored-procedure
Get Your Knowledge Refreshed. Normal creation of a table */. Creating stored procedure */. This is show u how u have created are designed your stored procedure */. Encrypting stored procedure */. Now if u execute it it will display a msg like procedure is encrypted */. After execution u can see a msg lke this. The text for object ‘sp selecttblcustomer’ is encrypted. After encrypting your stored procedure , u can see the modify option will be disabled. When u right click and check in the procedure name in.
SQL SubQuries | KnowledgeBase
https://sqlbase.wordpress.com/sql-subquries
Get Your Knowledge Refreshed. 1,1) primary key. 8216;vanitha’,2000,’EEE’). Statement find the employees whose salary is. The minimum salary of. The employees in some. Select empname,empsal from. Statement find the employees whose salary is. The employees in any. Select empname,empsal from. Empname, empsal,dept from. Empname, empsal) in. Dept=’ECE’) and. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public).
TOTAL LINKS TO THIS WEBSITE
20
DotNET Security Solutions, LLC - Home
FAIL (the browser should render some flash content, not this). SANS Top Security Risks. US CERT Security Bulletins. NIST Computer Security Portal. Any breach of security of an organization's information could lead to lost business and consumer confidence, law suits and/or bankruptcy . With the increasingly interconnected nature of business networks and continued growth of threats and vulnerabilities, comes the necessity for highly trained and experienced security professionals.
Dotnetstack
Economy, business and finance. Crime, law and justice. Sign in / Join. Login in to your account. Finland: the outgoing Niinistö in pole position to win the presidential. January 28, 2018. Lula, touched but not sunk. January 25, 2018. United States: temporary compromise on the budget, Trump shouts victory. January 23, 2018. Budget compromise in the US Senate, towards the reopening of the government. January 22, 2018. Frontex predicts an increase in illegal immigration in Spain. January 19, 2018. Inflation...
Discussions on Microsoft technologies
Discussions on Microsoft technologies. Ideal platform to share Tips and Tricks on MS Technologies. Monday, August 15, 2011. When a custom webpart gives the runtime exception while loading. When a custom webpart gives the runtime exception while loading , you can slove by two ways. 1) standard way ( retracting the solution). In the url and later delete the custom webpart. Posted by Dotnet Stars. Location: Bengaluru, Karnataka, India. Wednesday, May 18, 2011. Getting the User profile. Posted by Dotnet Stars.
.NET Starter
Exercises, notes and resources for the IT311 course. Thursday, October 18, 2007. Presentation for the final project will be on October 19, Friday at Rm 308, DR2 and will start at 8:30AM. Each group will be given 20 minutes starting with the first group from IT3A. The order of the presentation is arranged alphabetically based on the first member of the group as follows:. 1 Alcoberes, et. al. 2 Arinto, et. al. 3 Barriga, et. al. 4 Basas, et. al. 5 Claro, et. al. 6 Gaanan, et. al. 7 Gio, et. al. Thursday, S...
KnowledgeBase | Get Your Knowledge Refreshed
Get Your Knowledge Refreshed. December 29, 2008. 1Binding Datalist with array. ASPX Page (Copy and Paste this Code inside Form Tag). GridLines =”Both”. 1Binding Datalist with array. Copy and paste this code inside Page Load or as U Want). S ={ “Learn .Net”. 8220;Learn C#”. 8220;Learn VB”. DataList1.DataSource = s;. 2Binding Datalist with XML. XML Page (Copy and Paste this Code). 8220; 1.0. Copy and Paste this Code inside Form Tag). 2Binding Datalist with XML. Container.DataItem, “version”. Webconfig file...
dotnetstep
Think Better To Build Best. Blog by Jinal Patel. Microsoft .NET Technology,SharePoint 2007,SharePoint 2010,ASP.net MVC. Wednesday, November 6, 2013. SQL Server : Context Info. While working one of my project, need for connection specific setting required to enable and disable functionality. Project has very large database in terms of entities and many of entities have triggers that affect other entity and also done task for sending notification. You can use it following way. Var conn = new SqlConnection(...
DotNetster
Welcome to DotNetster.com. This site is currently under development. Please send any questions to ken@dotnetster.com.
DotnetStock ! - Dotnet,IIS,MVC,Javascript and many more .
Update web.config custom values in asp.net. December 14, 2017. Here I am describing about a solution for how to update web.config custom values in asp.net? Couple of days back I was looking for update some values in the web,config through […]. How to convert Byte Array to Hexadecimal String, and Hexadecimal String to Byte Array? April 30, 2017. Object reference not set to an instance of an object? What is a NullReferenceException. April 30, 2017. What is a NullReferenceException? Let us see here. Google ...
dotnetstockage | Stockage of Dot Net Fundas
Stockage of Dot Net Fundas. File Upload in MVC application. This post helps you to make File Upload. Application. Let’s get started. Make controller class named Uploader. When you create this uploader controller class then you will have one action method called Index. By default. Do right click on Action method and create empty view named Index. Do copy and paste File Upload code in view. If you are using master page then it comes in content place holder. Posted in ASP.NET. Reason: Data table allocated m...