Brought from: http://salearningschool.com/displayArticle.php?table=Articles&articleID=1321&title=Random%20C#%20and%20MS%20SQl%20Server

Foreign Key in Table Declaration

CREATE TABLE ORDERS (
   ID integer primary key, 
   Order_Date datetime, 
   Customer_ID integer references CUSTOMER(ID), 
   Amount double
); 

ALTER TABLE ORDERS ADD FOREIGN KEY (customer_id) REFERENCES CUSTOMER(ID);

Stored Procedure Example

    CREATE PROCEDURE [dbo].[procedure_name]
      @param1 VARCHAR(100)
     ,@param2 VARCHAR(200) OUTPUT
    AS
    BEGIN
       DECLARE @param3 VARCHAR(100)
       SET @param3 = ' '
       IF @param1 IS NOT NULL AND LEN(@param1) > 1
            SELECT @param2 = 'The ' + @param1  + @param3
        ELSE 
            SELECT  @param2 = '...is cool!'
        RETURN
    
    END
    GO

C# and Prepared Statements

     
     int  id = 20;
     string  desc = "...." ;
     SqlConnection rConn = new SqlConnection("Persist Security Info=False;Integrated Security=SSPI;
        database=northwind;server=mySQLServer");
     rConn.Open();
     SqlCommand command = new SqlCommand(null, rConn);

     // Create and prepare an SQL statement.
     command.CommandText = "insert into Region (ID, Description) values (@id, @desc)" ;
     command.Parameters.Add ( "@id", id) ;
     command.Parameters.Add ( "@desc", desc) ;
     command.Prepare() ;  // Calling Prepare after having set the Commandtext and parameters.
     command.ExecuteNonQuery();

     // Change parameter values and call ExecuteNonQuery.
     command.Parameters[0].Value = 21;
     command.Parameters[1].Value = "mySecondRegion";
     command.ExecuteNonQuery();

   conn = new SqlConnection(strConnectionString);
   SqlCommand cmd = new SqlCommand();
   cmd.CommandText ="insert into Profile values(@Name,@Age)";
   cmd.Connection = conn;
   cmd.CommandType = CommandType.Text;

   SqlParameter nameP = new SqlParameter();
   nameP.SqlDbType =SqlDbType.NVarChar;
   nameP.ParameterName = "@Name";
   nameP.Size = 50;
   nameP.Value = model.Name;

   SqlParameter ageP = new SqlParameter();
   ageP.SqlDbType =SqlDbType.Int;
   ageP.ParameterName = "@Age";
   ageP.Value = model.Age;

   cmd.Parameters.Add(nameP);
   cmd.Parameters.Add(ageP);

   conn.Open();
   cmd.Prepare(); 

   cmd.ExecuteNonQuery();

C# and Stored Procedure

       conn = new SqlConnection("Server=(local);DataBase=Northwind;Integrated Security=SSPI");
       conn.Open();

       SqlCommand cmd  = new SqlCommand("sp_name", conn);

       cmd.CommandType = CommandType.StoredProcedure;
       cmd.Parameters.Add(new SqlParameter("@CustomerID", custId));

       // execute the command
       rdr = cmd.ExecuteReader();

       // iterate through results, printing each to console
       while (rdr.Read())
       {
          Console.WriteLine("" + rdr["Total"] );
       }

From: http://sitestree.com/?p=3724
Categories:.Net Web Applications
Tags:
Post Data:2016-07-16 11:01:19

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Brought from: http://salearningschool.com/displayArticle.php?table=Articles&articleID=1320&title=Razor,%20Web-page%20Model,%20Web-Application%20Development%20in%20C# (written long back)

Razor, Web-page Model, Web-Application Development in C#

• Razor:a markup syntax to add server side code into ASP.net pages
• Razor example: Current time is @DateTime.Now
• Razor Code Syntax

             
           Single statement block
       @{ var message = "Hello World"; }
  
      Inline expression or variable
      The message: @message
  
      Multi-statement block
      @{
          var greeting = "Hello";
          var currentTime = DateTime.Now;
          var greetMessage = greeting + " Current time is: " + currentTime;
      }
      The greeting is: @greetMessage
      

• Some Razor functions mainly used in the Layout file [can be used in other files based on the function]: RenderPage() – render the content of a page, RenderBody(), RenderSection(section) – render the content of a section named section
• using _ at the beginning of a web-page name prevents it from being browsed from browser such as _header.cshtml, _Layout.cshtml
• In ASP.net, you can hide sensitive information by using the _AppStart.cshtml file. Here, you can keep database passwords, and email passwords. You can also keep your webmail server configuration.
• _AppStart.cshtm example

        
                    @{
              WebMail.SmtpServer = "smtp.bizmail.yahoo.com";
              WebMail.EnableSsl = true;
              WebMail.UserName = "sayed@justetc.net";
              WebMail.Password = "password";
              WebMail.From = "sayed@justetc.net";
          }
              

• Some folders as used in ASP.net web applications: App_Data – to keep database files, Images – image files, Scripts – JavaScript files for example, Shared – common files such as CSS files
• In a file path, ~ is used to indicate the virtual root folder.
• Server.MapPath, can convert a virtual path to a physical path
• @Href(cssPath), here cssPath is a variable for a path. You can use Href(cssPath) for the value of href attributes
• Page object methods: href (builds a url), RenderBody(), RenderPage(page), RenderSection(section), Write (object) – HTML Encoded string, WriteLiteral – No HTML encoding
• Page object properties: isPost, Layout, Page, Request, Server
• You can add properties to the Page object such as Page.Title; here Title is your own variable [not built in]
• Read from a physical file: File.ReadAllLines(filePath). You may want to use var filePath = Server.MapPath(“~/file.txt”);, to get the physical path from a virtual path
• File.ReadAllLines(filePath), can also be used to read excel csv files [comma delimited]
• Some ASP.net helpers: Helpers are just components. WebGrid, Chart, WebMail, and WebImage are some common helpers
• WebGrid helper example: webGrid = new WebGrid (data); grid.getHtml(); data for example can be the rows of a database table, GetHtml () – will render the data as a HTML table.
• Chart example

                  @{
                      var db = Database.Open("dbName");
                      var dbdata = db.Query("SELECT Name, Price FROM Product");
                      var myChart = new Chart(width: 600, height: 400)
                         .AddTitle("Product Sales")
                         .DataBindTable(dataSource: dbdata, xField: "Name")
                         .Write();
              }
  
              

• The above example will create bar chart [column chart]
• if you want a pie chart as output, use .AddSeries(chartType:”Pie” in the above example
• You can use an Array, or XML data as the data feed for the Chartff
• Sending emails: WebMail.Send(to:”xyz@xyz.com”, subject: “Email from – ” + customerEmail, body: request
• Publish your web-site: Use the publish option from your IDE (Webmatrix, Visual Studio for Web)
• Manual publish: Make sure that the server side has the compatible ASP.net framework, copy all of your folders and files, copy the DLL files into the bin folder, copy SQL server DLL files, copy the database if appropriate

From: http://sitestree.com/?p=3720
Categories:.Net Web Applications
Tags:
Post Data:2016-07-16 10:49:27

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>

Brought from: http://salearningschool.com/displayArticle.php?table=Articles&articleID=1319&title=Random%20Notes%20and%20simple%20code%20on%20Developing%20Web%20Sites%20(Applications)%20in%20ASP.net%20using%20C#

And sure, pretty old article..

Random Notes and simple code on Developing Web Sites (Applications) in ASP.net using C#

• The information below primarily apply to the web page model of web-development in C#
• _PageStart.cshtml runs at each page start/open
• _AppStart.cshtml runs at the beginning of the application
• Syntax to use the Layout file: @{Layout = “/Shared/Layout.cshtml”;}
• if you use this – @{Layout = /Shared/Layout.cshtml”;} in the _PageStart.cshtml file, you will not need to use it at the top of each file
• You can use Microsoft Webmatrix, Visual Web Developer, or Visual Studio for web development
• Webmatrix, includes IIS Express, and also a database workspace where you can create and use compact SQL Server Databases
• DateTime.Now : will display current date and time
• You can connect to a database using var db = Database.Open(“db_name”);
• db = Database.Open(“db_name”); will look for the database in the same workspace; if not found will use the connection parameter as defined in the web.config file to find and connect to database
• Executing a query: var queryString = “SELECT * FROM Product ORDER BY Name”; db.Query(queryString)
• Accessing each row from a rowset of data as returned from database:

                 
  foreach(var entry in db.Query((queryString))) {
     @entry.Id, @entry.Name
  }
  

• if (IsPost) : will check if a form is submitted by POST or not
• username = Request.Form[“username”]; Will retrieve username from the Request object [submitted form with control named username]
• A basic login authentication code can be as follows

     
          var username = "";
          var password = "";
          var ErrorMessage = "";
          
          // If this is a POST request, validate and process data
          if (IsPost){
              
              username = Request.Form["username"];
              password = Request.Form["password"];
              
              if (username.IsEmpty() || password.IsEmpty()){
                  ErrorMessage = "You must specify a username and password.";
              }else{
                  // Login, Navigate back to the homepage and exit
                  if (WebSecurity.Login(username, password, false)){
                      Response.Redirect("~/");
                  }
                  else{
                      ErrorMessage = "Login failed";
                  }
              }
          }
                          
          @if (ErrorMessage!="") {
              @ErrorMessage, Please correct the errors and try again.
          }
  
      

• Execute an Insert Statement: db.Execute(“INSERT INTO UserProfile (Email) VALUES (@0)”, email);
• WebSecurity object can be used for the security of your web-site (application) such as user authentication, block a page until a user is authenticated
• Block user if he is not logged in [can be added at the top of the page to be blocked]

             
                        @{
              if (!WebSecurity.IsAuthenticated) Response.Redirect("~/Login"); //redirect to login page
              }
          

• WebSecurity.InitializeDatabaseConnection(“db_name”, “profile_of_the_users_table”, “UserId”, “Email”, true);
• WebSecurity.CreateAccount(email, password, false);

From: http://sitestree.com/?p=3718
Categories:.Net Web Applications
Tags:
Post Data:2016-07-16 10:38:29

    Shop Online: <a href='https://www.ShopForSoul.com/' target='new' rel="noopener">https://www.ShopForSoul.com/</a>
    (Big Data, Cloud, Security, Machine Learning): Courses: <a href='http://Training.SitesTree.com' target='new' rel="noopener"> http://Training.SitesTree.com</a> 
    In Bengali: <a href='http://Bangla.SaLearningSchool.com' target='new' rel="noopener">http://Bangla.SaLearningSchool.com</a>
    <a href='http://SitesTree.com' target='new' rel="noopener">http://SitesTree.com</a>
    8112223 Canada Inc./JustEtc: <a href='http://JustEtc.net' target='new' rel="noopener">http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) </a>
    Shop Online: <a href='https://www.ShopForSoul.com'> https://www.ShopForSoul.com/</a>
    Medium: <a href='https://medium.com/@SayedAhmedCanada' target='new' rel="noopener"> https://medium.com/@SayedAhmedCanada </a>