Display an Image when the GridView has no data

Hi,

Display an image when their is no data in the gridview.

demo

code

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
    DataSourceID="SqlDataSource1"
    ShowFooter="true" AllowPaging="True" AllowSorting="True">

<EmptyDataTemplate>
  <asp:Image id="imgOne"
    ImageUrl="~/images/Emptydata.jpg"
    AlternateText="No results"
    runat="server"/>
</EmptyDataTemplate>

sample code 

i created a demo, u can download from here

 

Have a nice day... 'N happy Coding :)

Search a string in a table

 Hi friends,
In my last post i shown how to search a string in database 2day i'm showing how to search a string in a table


 CREATE PROCEDURE uspSearchWord @searchstring VARCHAR(100) AS
SELECT * FROM mst_country
 WHERE
    strcountry LIKE '%'+ @searchstring + '%'
    OR
    strstatus LIKE '%'+ @searchstring+'%'
ORDER BY id

where

uspSearchWord  is my Store procedure Name
searchstring is word to search
mst_country Table Name
strcountry,strstatus



Have a nice day... 'N happy Coding :)

 

Searching Any String From A Database

 Following stored procedure work as a search engine for database,i.e it will find any string from all of the table of SQL Server & returns the column names & corresponding table names where that input string/search string can be found.


USE /* Database Name*/
GO

CREATE TABLE myTable99 (TABLE_NAME sysname, COLUMN_NAME sysname, Occurs int)
GO

SET NOCOUNT ON

DECLARE @SQL varchar(8000), @TABLE_NAME sysname, @COLUMN_NAME sysname, @Sargable varchar(80), @Count int

SELECT @Sargable =/* word to be searched*/

DECLARE insaneCursor CURSOR FOR
SELECT c.TABLE_NAME, c.COLUMN_NAME
 FROM INFORMATION_SCHEMA.Columns c INNER JOIN INFORMATION_SCHEMA.Tables t
   ON t.TABLE_SCHEMA = c.TABLE_SCHEMA AND t.TABLE_NAME = c.TABLE_NAME
WHERE c.DATA_TYPE IN ('char','nchar','varchar','nvarchar','text','ntext')
  AND t.TABLE_TYPE = 'BASE TABLE'

OPEN insaneCursor

FETCH NEXT FROM insaneCursor INTO @TABLE_NAME, @COLUMN_NAME

WHILE @@FETCH_STATUS = 0
BEGIN
SELECT @SQL = 'INSERT INTO myTable99 (TABLE_NAME, COLUMN_NAME, Occurs) SELECT '
+ '''' +  @TABLE_NAME + '''' + ','
+ '''' + @COLUMN_NAME + '''' + ','
+ 'COUNT(*) FROM [' + @TABLE_NAME
+ '] WHERE [' + @COLUMN_NAME + '] Like '
+ ''''+ '%' + @Sargable + '%' + ''''
--SELECT @SQL
EXEC(@SQL)
IF @@ERROR <> 0
BEGIN
SELECT @SQL
SELECT * FROM INFORMATION_SCHEMA.Columns WHERE TABLE_NAME = @TABLE_NAME
GOTO Error
END
FETCH NEXT FROM insaneCursor INTO @TABLE_NAME, @COLUMN_NAME
END

SELECT * FROM myTable99 WHERE Occurs <> 0


Error:
CLOSE insaneCursor
DEALLOCATE insaneCursor

#### to drop the Table and  NOCOUNT  off #####


GO

DROP TABLE myTable99
GO

SET NOCOUNT OFF


Have a nice day... 'N happy Coding :)