TOP

ASP.net Serialization

Figure A
Serialization

Uses for serialization
Serialization is used in many scenarios, but the main purpose is to save the state of an object in order to have the ability to recreate the same object when required. It is an important to let the user save work and then be able to continue from that point at a later time. This is a common need in various tools and applications. Serialization is also used in creating a clone of an object.

Another important need for serialization arises when the object is required to travel electronically over wire. In such cases the objects are serialized and deserialized. In fact, serialization is one of the fundamental requirements for techniques such as .NET Remoting.

Even the hibernation mode in the Windows Operating system can be considered a form of serialization.

Types of serialization
The .NET Framework provides certain built-in mechanisms which can be used to serialize and deserialize objects. This functionality can be found in the System.Runtime.Serialization and the System.Xml.Serialization namespaces of the .NET Framework.

Serialization in .NET can be classified into four types as shown in Figure B:

Figure B
Four types



Read More
TOP

DataBind example

{code type=c#}
using System;
using System.Data;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Alerts;
using System.Drawing;

namespace metest2
{
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
 //           var db = new DB();
 //           var query = from s in db.mytest2s
 //                       orderby s.state, s.city
 //                       select new
 //                       {
 //                           s.state, s.city
 //                       };

 //           DataList1.DataSource = query;
 //           DataList1.DataBind();
        }

        protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
        {
            e.Item.BackColor = Color.Aqua;

            if (e.Item.ItemType == ListItemType.AlternatingItem | e.Item.ItemType == ListItemType.Item)
            {
                String strval = ((Label)(e.Item.FindControl(“stateLabel”))).Text.ToString();
                String title = (String)ViewState["title"];
                if (title == strval)
                {
                    ((Label)(e.Item.FindControl(“stateLabel”))).Text = “”;
                    e.Item.Visible = false;
                }
                else
                {
                    title = strval;
                    ViewState["title"] = title;
                    ((Label)(e.Item.FindControl(“stateLabel”))).Text = title;
                    e.Item.Visible = true;
                }
            }
        }

        protected void btn_add_Click(object sender, EventArgs e)
        {

            if (ListBox1.SelectedIndex > -1)
            {
                string s = ListBox1.SelectedItem.Value;
                ListBox2.Items.Add(s);
                ListBox1.Items.Remove(s);
            }
  
        }
    }

}

{/code}

Read More
TOP

Migrating SQL Server 2000 to SQL Server 2008

http://www.dell.com/downloads/global/solutions/public/white_papers/SQL_2000_SQL_2008_Migration_Guide.pdf

Read More
TOP

How To Get Output Into SQL Server Table

Read More
TOP

SQL Server 2008 FILESTREAM BLOB

http://www.infosys.com/microsoft/resource-center/SQLServer-FILESTREAM-BLOBs.pdf

Good Example!!

Read More
TOP

FILESTREAM Data in SQL Server 2008

File Stream Data in SQL Server 2008 Ado Net

Read More
TOP

FILESTREAM Storage in SQL Server 2008

FILESTREAM Storage in SQL Server 2008

Read More
TOP

MSSql – Full-Text Search Developer InfoCenter

http://msdn.microsoft.com/en-us/library/ms142519.aspx

http://msdn.microsoft.com/en-us/library/cc716724.aspx

FILESTREAM and Full-Text Search

One of the ways SQL Server improves the FILESTREAM developer experience is with improvements to full-text search, which is fully supported for FILESTREAM data. In versions of SQL Server prior to SQL Server 2008, full-text search was implemented using the Windows Search Service, which added complexity to development and deployment. In addition, queries that combined full-text search with standard Transact-SQL predicates suffered performance problems. SQL Server 2008 integrates the full-text engine directly into the SQL core, improving performance while reducing the cost of managing and deploying full-text search applications.

Full-text indexing works with a FILESTREAM column in the same way that it does with a varbinary(max) column. The FILESTREAM table must have a column that contains the file name extension for each FILESTREAM BLOB. For more information, see Full-Text Search Developer InfoCenter in SQL Server 2008 Books Online.

Read More
TOP

Working with FILESTREAM using VB .NET

http://www.databasejournal.com/features/mssql/article.php/3802241/Working-with-FILESTREAM-using-VB-NET.htm

Read More
TOP

FILESTREAM Storage in SQL Server 2008

Designing and Implementing FILESTREAM How-to Topics

Much of the data that is created every day is unstructured data, such as text documents, images, and videos. FILESTREAM integrates the SQL Server Database Engine with an NTFS file system by storing varbinary(max) binary large object (BLOB) data as files on the file system. The topics in this section describe how to enable and set up FILESTREAM.

 In This Section

In This Section

See Also
Concepts

FILESTREAM Overview [ http://technet.microsoft.com/en-us/library/bb933993.aspx ]

Help and Information

Getting SQL Server 2008 Assistance [ http://technet.microsoft.com/en-us/library/ms166016.aspx ]

 

 

Read More

Switch to our mobile site