A Simple ASP.Net Form in C#. Payment Information Collection Form.

Such form can be used in test operation while implementing online payment processing . The input fileds are to send data to the payment gateway. The response fields are to display response from payment gateway. Here, the output fields represent the response fields as sent by Paymentech gateway.

The FormThe CSSFront end form code From: http://sitestree.com/?p=5329
Categories:19
Tags:
Post Data:2011-10-02 13:31:36

    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>

Creating your own Class in C# in ASP.net

• It is kind of simple. You need to create a class library. The class library will create a dll file. From your project, you need to add reference to the dll file. Then you will be able to use the classes and methods of the class library.
• Check the following codes. One is a sample class library and another one is how to use the class. The class library implements two methods such as add and subtract to add or subtract two numbers. The project uses the namespace [class library] and calls these methods
• You can get the dll file in the bin/debug or bin/release folder under your class library project
• You can right click on your project/website [in solution explorer], and click Add Reference, then click browse and select the dll file created
• Check the class library below
• Check the Form in picture. This form uses the class library.
• Check the Form Code to use the Library
• Check the Backend Form Code to use the Library

From: http://sitestree.com/?p=5327
Categories:19
Tags:
Post Data:2009-03-26 09:27:06

    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>

Simple Ajax Applications in C# (ASP.Net)

• If you are coming from PHP or Java Platform where you use JavaScript or JQuery to provide Ajax functionality, you still can use those strategies in ASP.net to provide Ajax functionality
• Check our short note on Ajax using JavaScript. In .Net, you just have to call the JavaScript function (that implements Ajax functionality) on the event you want the Ajax functionality. However, you do not use runat=”server”.
• Another approach is Using Ajax Server Controls such as ScriptManager, ScriptManagerProxy, UpdatePanel, ContentPanel, UpdateProxy
• You can find these Ajax controls at the Toolbox under Ajax Extensions
• You can grab them and place on your form, you can grab and place on the code, or you can write them in your code [whatever you are used to]
• And yes, you could use JQuery as well. JQuery uses an wrapper on JavaScript functionality and makes the life of the developer little easier
• In this short note, I will show a simple example of using Ajax Server Controls, also show you the code to invoke Ajax functionality using JavaScript
• Now take a look at the simple application interface below. The application will calculate sum, difference, and multiplication of two numbers without refreshing the page. We will calculate immediately, also will show the situation when the calculation may take a little more time
• The idea is simple, you need to add a ScriptManager control. If you use master pages, and the situation becomes that you need to place two ScriptManagers, just place one ScriptManager in the Master and use ScriptManagerProxy in the content page
• use UpdatePanel around the controls that will be refreshed without the page being refreshed
• Use UpdateProgress control, when you know that the operation will take some time. Use this control to inform the user that the operation is under progress
• Now the sample application interface
• Now the Form code
• Now the backend code
• Now an example on how to implement Ajax functionality in C# in ASP.net using JavaScript. It just displays current date time but using Ajax and without refreshing the page. Just go through the code

From: http://sitestree.com/?p=5326
Categories:19
Tags:
Post Data:2010-04-01 05:09:58

    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>

ASP.Net Validation Control Examples. Just check the code below

Some note

• RequiredFieldValidator: is used to check that a field is filled up
• CompareValidator: Compare the value of a field with another field or data
• RangeValidator: Compares the data is within a given range
• RegularExpressionValidator: Domain name syntax, email addtress syntax
• ValidationSummary: Display all validation errors in a summary box
• CompareValidator: Write your own custom validation rules and display the outcome
• Remember
  • You can display error on the side of the control
  • You can display error under the control
  • The example used both just for example
  • The Text property is the output that comes just where the validation control is placed. ErrorMessage propert is for the ValidationSummary
  • If you just want the Validation Summary output, use Display=”none” for the validation control (not the summarycontrol) itself
• the code can be seen at http://salearningschool.com/samples/validate.txt as well

From: http://sitestree.com/?p=5304
Categories:19
Tags:
Post Data:2009-06-06 19:26:04

    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>

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=5300
Categories:19
Tags:
Post Data:2007-02-11 12:57:35

    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>