Surrogate Key in SQL Server?
IntroductionA Surrogate Key in SQL Server is a unique identifier for each row in the table. It is just a key. Using this key we can identify a unique row....
Store Procedure?
Example: CREATE PROCEDURE dbo.QSPStudent ( @option int, @id int, @name varchar(50)=null, @mobile bigint=null, @email varchar(50)=null, @password varchar(50)=null, @confirm_password varchar(50)=null ) AS BEGIN begin if @option =1 select name, mobile from...
DataManger?
public class DataManager { string connectionString = "Data Source=(local);Initial Catalog=CompanyDb;Persist Security Info=True;User ID=sa;Password=123"; public int SqlExecuteQuery(string strQuery, int timeOut) ...
What is ViewState?
It is a state management technique in asp.net. ASP.NET Viewstate is preserving the data between the requests or postbacks and stored in hidden fields on the page. if you open...
