Dheeraj's Tech Wiki

I was working on a SQL Server database table which had around 100 columns and I wanted to insert a new row into that table. But in order to do that I had to know all the non-nullable column names, types and lengths in that table and below is the query I have used to achieve that:

select COLUMN_NAME, DATA_TYPE, CHARACTER_MAXIMUM_LENGTH 
from information_schema.columns
where table_name = 'TABLE_NAME'
AND IS_NULLABLE = 'NO'

I wanted to add some Tab Panels to my ASP.NET AJAX Tab container from my code behind file. Below is the code on my .aspx page:

Blow is my code in the aspx.cs file to add two new tab panels to the tab container:

TabPanel t1 = new TabPanel();
            t1.ID = "Tab1";
            t1.HeaderText = "Tab:1";

            TabPanel t2 = new TabPanel();
            t2.ID = "Tab2";
            t2.HeaderText = "Tab:2";

            TabContainer1.Tabs.Add(t1);
            TabContainer1.Tabs.Add(t2);

Pretty straight forward stuff. But to my astonishment when I ran the page I couldn't see my tab control in the browser. Below is the HTML generated for my two tab panels:

<div id="TabContainer1_Tab1" class="ajax__tab_panel" style="display:none;visibility:hidden;">
</div>
<div id="TabContainer1_Tab2"; class="ajax__tab_panel" style="display:none;visibility:hidden;">
</div>

As you can see from the above HTML that my two tab panels visibility is set to hidden by default. In order make the tab control visible we have to set the ActiveTabIndex for thr tab container as follows:

TabContainer1.ActiveTabIndex = 0;

I have a 64-bit PC with Windows 7 and Visual Studio 2008 with SP1 installed on it. When I tried to add new a SQL Server 2008 express database into the App_Data folder of my Website project I got the following error:

"Connections to SQL Server files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component of download from the URL:
http://go.microsoft.com/fwlink/?LinkId=49251"

This problem occurs because Visual Studio 2008 SP1 incorrectly detects some registry keys for a 64-bit installation of SQL Server Express 2008. To fix this issue I had to download a hotfix for Visual Studio 2008 which is available HERE.

LINQ can be used to perform query operations on objects which implement the IEnumerable<T>. Since the String class implements the IEnumerable<char> interface we can perform various string operations using LINQ. In the below example I have used LINQ to extract the common characters in two strings.

Note: For some weired reason Visual Studio doesn't show the LINQ extension methods in the intellisense for string objects.

string str1 = "abc";
 string str2 = "bcd";

Func match = (s,c) => s.Contains(c);

 var chars = from c in str1
             where match(str2, c)
             select c;

 foreach (var c in chars)
  {
    Console.WriteLine(c);
  }
 Console.Read();

Here is the Output: