Selecting dropdown value using javascript

81 down vote accepted

If you have a select element that looks like this: <select id="ddlViewBy"> <option value="1">test1</option> <option value="2" selected="selected">test2</option> <option value="3">test3</option> </select> Running this code: var e = document.getElementById("ddlViewBy"); var strUser = e.options[e.selectedIndex].value; Would make strUser be 2. If what you actually want is test2, then do this: var e = document.getElementById("ddlViewBy"); var strUser = e.options[e.selectedIndex].text;

Searching String or text from "stored procedure" defination

SELECT DISTINCT o.name ,o.xtype
FROM syscomments c
INNER JOIN sysobjects o ON c.id=o.id
WHERE c.TEXT LIKE '%Employee%'
GO


Set new value of radiobutton using javascript

 Use this script to set new value of radiobutton using javascript...

function buttonOnClick()
{
 var elementRef = document.getElementById('<%= RadioButton1.ClientID %>');
 var labelArray = elementRef.parentNode.getElementsByTagName('label');
 if ( labelArray.length > 0 )
  labelArray[0].innerHTML = 'Changed label';
}

MYSQL

Solution for The log file for database 'Database_Name' is full.

Error : "The log file for database 'Database_Name' is full."
After facing this problem , i want to share solution with all of you .

Use these following steps ,
this will shrink database log files and removes this ERROR
Queries  :-

USE Database_Name
GO
SELECT * FROM sysfiles WHERE name LIKE '%LOG%'
GO
USE [Database_Name]
GO
ALTER DATABASE [Database_Name] SET RECOVERY SIMPLE
GO
USE [Database_Name]
GO
CHECKPOINT
GO
USE [Database_Name]
GO
BACKUP LOG [Database_Name] WITH NO_LOG
GO
USE [Database_Name]
GO
SELECT Name FROM sysfiles WHERE name LIKE '%LOG%'
GO
USE [Database_Name]
GO
DBCC SHRINKFILE ([Database_Name_log], 1)
GO
USE [Database_Name]
GO
SELECT * FROM sysfiles WHERE name LIKE '%LOG%'
GO
USE [Database_Name]
GO
ALTER DATABASE [Database_Name] SET RECOVERY Full
GO

Just replace your database name with "Database_Name".
Thanks
Cheers