Student Academic blog

In this Example, I have Create a connecton string and establish a connection between object to database. and Select title from employees table.

string connectionString = "Data Source=.;Initial Catalog=Northwind;Integrated Security=True";
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            using (NorthwindDataContext context = new NorthwindDataContext(connection))
            {
                var query = from c in context.employees
                            select c.Title;

                foreach (var title in query)
                {
                    Response.Write(title);
                }
            }

ALL, asp.net, asp.net 4.0 asp.net, linq

In MS SQL Syntax

SELECT MAX(COLUMN NAME) FROM [TABLE NAME]

In Linq to SQL Syntax

var maxValue = ( from q in [TABLE NAME] SELECT (P.[COLUMN NAME]).Max()

ALL linq, sql functions

In this Example, i will tell you how to delete a duplicate rows from a table.

DELETE FROM [TABLE NAME] 
WHERE ID NOT IN (select MAX(ID) FROM [TABLE NAME] 
GROUP BY [DUPLICATE COLUMN NAME])

ALL, SQL Injection sql,

Another new feature in 4.O FrameWork, Name Parameter,Let see in the Below Sample how to pass the parameter.

protected void Page_Load(object sender, EventArgs e)
   {
   	foreach (int i in Add( n1:20,n2:60))
   	{
   		Response.Write(i.ToString() + " ");
   	}
   }
  

 public static IEnumerable Add(int n1, int n2)
 {
 
 return i*i;
 
 }

ALL, asp.net, asp.net 4.0, CSharp asp.net, framework 4.o

Page.Form.Attributes.Add("enctype", "multipart/form-data");

ALL, asp.net file upload, update panel