Swapnilbarde007, on 24 September 2012 - 05:07 PM, said:

Imports System.Data
Imports System.Data.SqlClient

        Public  Class Form1

                Private Sub Form1_load(sender As Object, e As EventArgs)
                        Dim connetionString As String
                        Dim connection As SqlConnection
                        Dim command As SqlCommand
                        Dim adapter As New SqlDataAdapter()
                        Dim ds As New DataSet()
                        Dim sql As String

                        connetionString = "Data Source=SWAPNIL;Initial Catalog=MyTestDb;User ID=sa;Password="
                        sql = "SELECT * FROM tblTEST"

                        connection = New SqlConnection(connetionString)

                        Try
                                connection.Open()
                                command = New SqlCommand(sql, connection)
                                adapter.SelectCommand = command
                                adapter.Fill(ds)
              
                                connection.Close()

                                DataGridView1.DataSource=Ds.Tables(0)
                        Catch ex As Exception
                                MessageBox.Show("Can not open connection ! ")
                        End Try
                End Sub
        End Class
End Namespace

if(!String.IsNullOrEmpty(Request.QueryString["CustomID"]))
{
//1)
int custID = int.Parse(Request.QueryString["CustomID"]);

//2)
string custID = Request.QueryString["CustomID"];
int intCustID = Convert.ToInt32(custID);
RemoveItem(intCustID);

//3
int custID = 0;
int.TryParse(Request.QueryString["CustomID"], out custID);
RemoveItem(custID);  //this one only returned the value of 0.
} 

using(SqlConnection con=new SqlConnection(ConfigurationManager.ConnectionString["TestCon"].ConnectionString))
{
//Code 
}

protected void Page_Load(object sender, EventArgs e) 
{ 
    if (!Page.IsPostBack) 
    { 
        var pages = GetPagesByParent(Page); 
        if (pages.Count() > 0) 
        { 
            var roots = pages.Where(p => p.Parent == null); 
            foreach (var root in roots) 
            { 
                //add the root nodes to the tree 
                var rootNode = new TreeNode(root.Title); 
                tree.Nodes.Add(rootNode); 
 
                //kick off the recursive population 
                PopulateChildNodes(pages, root, rootNode); 
            } 
        } 
    } 
} 
 
protected void PopulateChildNodes(IEnumerable<Page> pages, Page parent, TreeNode parentNode) 
{ 
    var childPages = pages.Where(p => p.Parent == parent); 
    foreach (var page in pages) 
    { 
        var pageNode = new TreeNode(page.Title); 
        parentNode.Nodes.Add(pageNode); 
 
        //populate the children of the pageNode 
        PopulateChildNodes(pages, page, pageNode); 
    } 
}