Asp .Net Solution

How to get google map image of area you want Hi First you need to take one image control and set it Image URL blank. after on code side set it image url as below. ImgMap.ImageUrl = "http://maps.googleapis.com/maps/api/staticmap?sensor=false&key=AIzaSyA4WZ--vZ1qILKrICJg7MdNKZyv1qkiIOw&zoom=14&size=600x512&maptype=roadmap&markers=color:red|label:A|" + "Bapunagar, Ahmedabad, Gujarat"; on Out put  You can get this image in browser. you can use this in contact us page or any searching area related forms.  Thank You for See this.

Use this query to check table is exist or not "select case when exists((select * from information_schema.tables where table_name = 'Table_Name')) then 1 else 0 end " You Get result 1 for if Exist and 0 for Not Exist

How to force div contents to stay in one line? Put this  in style or css  overflow : hidden ; white - space : nowrap ;

 ExecuteScalar is typically used when your query returns a single value. If it returns more, then the result is the first column of the first row. An example might be SELECT @@IDENTITY AS 'Identity'.  ExecuteReader is used for any result set with multiple rows/columns (e.g., SELECT col1, col2 from sometable).  ExecuteNonQuery is typically used for SQL statements without results (e.g., UPDATE, INSERT, etc.).

SELECT   DATENAME ( month , DATEADD ( month , @Your_Month_No -1 , CAST ( '2015-01-01' AS datetime )))

put your format in dataformatstring  < asp : BoundField DataField = "Date" HeaderText = "Date" dataformatstring = "{0:dd-M-yyyy}" />

Put below script in sql Editor and change Database_Name to your Database name IF (NOT EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE ('[' + name + ']' = 'Database_Name' OR name = 'Database_Name'))) Begin CREATE DATABASE [Database_Name] ALTER DATABASE Database_Name MODIFY FILE ( NAME = N'Database_Name' , SIZE = 3048KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) ALTER DATABASE Database_Name MODIFY FILE ( NAME = N'Database_Name' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) End