Anand

Sub ConnectSqlServer() Dim conn As ADODB.Connection Dim rs As ADODB.Recordset Dim sConnString As String Dim squery As String ' Create the connection string. sConnString = "Provider=SQLOLEDB;Data Source=RCHNLPT136\SQLEXPRESS2014;" & _ "Initial Catalog=ExpenseMgmt;" & _ "user id=sa;password=Welcome@123;" & _ "Integrated Security=SSPI;" ' Create the Connection and Recordset objects. Set conn = New ADODB.Connection Set rs = New ADODB.Recordset ' Open the connection and execute. conn.Open sConnString squery = "select " & _ " tb.TABLE_SCHEMA as TableSchema, tb.TABLE_NAME as TableName," & _ " sum(Case When DATA_TYPE = 'int' then 4 else 0 end + Case When DATA_TYPE = 'nvarchar' and CHARACTER_MAXIMUM_LENGTH > 0 then CHARACTER_MAXIMUM_LENGTH * 2 When DATA_TYPE = ...

select tb.TABLE_SCHEMA as TableSchema, tb.TABLE_NAME as TableName, sum( Case When DATA_TYPE = 'int' then 4 else 0 end + Case When DATA_TYPE = 'nvarchar' and CHARACTER_MAXIMUM_LENGTH > 0 then CHARACTER_MAXIMUM_LENGTH * 2 When DATA_TYPE = 'nvarchar' and CHARACTER_MAXIMUM_LENGTH 18 then 16 else 0 end + Case When DATA_TYPE = 'Numeric' and Numeric_Precision

ABBYY FlexiCapture - The most comprehensive OCR SDK for software developers ABBYY FlexiCapture is the right choice for organizations seeking a client-side document processing software solution. This next-generation of intelligent, accurate and highly scalable data capture and document processing software provides a single entry point to automatically transform streams of different forms and documents of any structure and complexity into business-ready searchable data. With impressive automatic document classification and data capture features, ABBYY FlexiCapture helps organizations of any kind significantly increase efficiency by automating paper-based business processes. Click here for more

Sulekha search

Atho or Athouk . These consist of boiled noodles cooked with spices, shredded cabbage, onions, chili flakes, roasted channa dal powder, tamarind juice, bejo, garlic oil, coriander leaves and etc are the ingredients of Athouk. To give the dish a crunchy feel. This food also eaten with the accompaniment of Mohinga,a soup made with fish broth & plantain stem, onion, ginger, garlic, chili, turmeric and rice flour. It is an awesome combination. Mohinga , which is considered the unofficial Burmese national food. It is essentially rice noodles served in fish broth with fried onions, garlic, ginger and sliced tender core of plantain stem. If you ask for it, it will also be served with boiled eggs. It is essentially a soup meal and a delightful one at that. History: Many Tamils were settled in Burma then and slowly emigrated back here after Independence.Burmese people started migrating to India. Most of them arrived at the Chennai Port and used to leave for other smaller cities by ...

 TEDx Pune is an independently organized TED event scheduled to happen on October 10th 2010 in Pune. TEDx Pune will take ideas worth sharing from Pune to the world, bring the city together through a simultaneously shared TED-like experience using live webcasting at 50+ educational institutions and spread ideas worth sharing to inspire better cities and citizenship . TEDx Pune is brought to the world by the Curator TEDx Pune along with Thought leaders and Philanthropists of Pune, Boards and CEO’s of Pune’s Companies, Educational Institutions, the TEDx Pune Team and the CIO Pune City. Ideas worth spreading to inspire better cities and citizenship will be nominated and then voted on this site for fit to inspire citizenship, novelty and ability to go viral. Short listed speakers will present ideas at a pre-TEDx event. The most effective TEDx ideas will repeat at the TEDx Pune event in front of a live audience of the winners of the Inspire Pune Challenge . You can participa...

TED is a nonprofit devoted to Ideas Worth Spreading. It began in 1984 as an annual conference devoted to Technology, Entertainment and Design -- hence TED -- but TED's reach, and its scope, have become ever broader since then. TEDTalks cover science, arts, politics, global issues, architecture, music and more. Speakers come from a wide variety of communities and disciplines -- people like Bill Clinton, Nobel laureate Murray Gell-Mann, Wikipedia co-founder Jimmy Wales, and Google co-founders Sergey Brin and Larry Page. The TED Conference itself takes place in Long Beach each spring, with a simulcast event in Palm Springs. In 2009, we'll also host a summer conference in Oxford, UK, called TEDGlobal, as well as a conference in fall 2009 called TEDIndia, in Mysore, India. Anyone can apply to attend a TED Conference! If you want to come, apply for an invitation. More info here: http://www.ted.com/conferences

Yugatech/Western Digital Contest Entry

This entry is in response to the Conserve, Recycle and Discover contest organised by blogadda.com in association with Pringoo ! World Environment Day, commemorated on 5 June since 1972, is one of the ways focuses world attention on the environment and encourages political action. People from countries all over the world have mobilized for individual and organized environmental action. Activities involve all sectors of society, governments, non- and inter-governmental organizations, businesses, industries, civil society, media and schools. Please take the following Pledge to save our environment. 1, I pledge to Recycle more, use less water and electricity. 2, I pledge to smoke less in 2010. 3, I pledge to send more electronic documents instead of using paper. 4, I pledge to continue using my bicycle to go to work (instead of my motorbike). 5, wash with full loads it is more energy efficient than doing several smaller ones. 6, Incite of dryer I will use hang dry for energy sav...

Free T-shirt from Tradus

Just Got the KKR Goodie Bag with Cool Jersey From Nokia Mein Bhi coach Contest. 1. Reebok Bag  2. Reebok Deodorant 3. Reebok Sipper 4. KKR Jersey(Tshirt)

Finally stumbled upon the way to create email messages with embedded images in ASP.NET 2.0. (Note that this doesn't work for ASP.NET 1.1, sorry to say.) For review ... you can add an image to an email message in these ways: * Attach it. Works ok, but it's ... attached. Illustrated earlier. * In an HTML-formatted message, create an tag that points to an absolute URL. * In an HTML-formatted message, create an tag that points to an embedded image and then (duh) embed the image. In that case, the image shows up inline with the message's text. Pointing to an absolute URL keeps the message size down, but you have no control over the image on the server, and it could go away or change. Attaching and embedding keep a copy of the image with the message, but bloat the message size. So, embedding. The trick, such as it is, is to create an alternative view and to add a linked resource to the alternative view. Alternative views enable you to create different versions of th...

Introduction: GridView paging feature allow us to display fixed number of records on the page and browse to the next page of records. Although paging is a great feature but sometimes we need to view all the items alphabetically. The idea behind this article is to provide a user with a list of all the alphabets and when the user clicks on a certain alphabet then all the records starting with that alphabet will be populated in the GridView control. Populating the GridView Control: The first task is to populate the GridView control. I will be using the Northwind database in my article which, is installed by default for SQL SERVER 2000 and SQL SERVER 7 databases. The code below is used to populate the GridView control. private void BindData() { string connectionString = "Server=localhost;Database=Northwind;Trusted_Connection=true"; SqlConnection myConnection = new SqlConnection(connectionString); SqlDataAdapter ad = new SqlDataAdapter("SELECT P...

Introduction: In one of my previous articles I talked about how you can effectively use DHTML with Asp.net to make cool tooltip. In this article I will show how you can use the same DHTML tooltip with the calendar control. Getting Started: The first thing you need to do is to download the DHTML script from www.dynamicdrive.com. You can download the script from this url http://www.dynamicdrive.com/dynamicindex5/dhtmltooltip.htm. After download the script just place the required css in the head section of the page and the script in the body of the page. Screen shot of what we are going to do: Here is a screen shot of what we are going to do in this article. As you can see that when you place your cursor over any date in the calendar it pops out the description in the DHTML box. The Code: The code is pretty simple. First you need to pull all the information from the database to your dataset or any other collection. private DataSet GetArticles() { s...

Introduction : According to wikipedia , CAPTCHA ( "Completely Automated Public Turing test to tell Computers and Humans Apart") is a challenge response test which is used to check that if the user is human or not. CAPTCHA is used exclusively in applications where the user input is required. These applications include Blogs, Forums and Portals. In this article I will demonstrate how to create a simple webpage that uses CAPTCHA functionality. The CreateImage Method : The first task is to create an image and put it on the screen. For that I have created an ASP.NET page named CaptchaControl.aspx . The CaptchaControl.aspx page will be responsible for displaying the image to the user. Let’s take a look at the following code which generates the image. private void CreateImage() { string code = GetRandomText(); Bitmap bitmap = new Bitmap (200,150,System.Drawing.Imaging. PixelFormat .Format32bppArgb); Graphics g = Graphics .FromImage(bitmap); Pen pen = new...

Introduction : Most of the web applications display hierarchical data. There are numerous ways for presenting the hierarchical data in which, most common is to use the Tree control. Although, the Tree control serves a good purpose for displaying the hierarchical data but in some scenarios we have to find an alternative solution. In this article I will demonstrate how you can use a simple ASP.NET DropDownList control to display hierarchical data. Database and Stored Procedure: In this article I will be using the Northwind database which, is installed by default for SQL SERVER 7 and SQL SERVER 2000 databases. I have added a new stored procedure which returns multiple record sets. The first record set contains the categories and the second one contains the products. Populating the DropDownList: The next step is to populate the DropDownList with the data from the Northwind database. For, this purpose I have created a BindData ...