abhi1010

SELECT
column_name "Name",
nullable "Null?",
concat(concat(concat(data_type,'('),data_length),')') "Type"
FROM user_tab_columns
WHERE table_name='ASGDLX_TBLBRAND'

where "ASGDLX_TBLBRAND" is the table name.

abhi1010

public IEnumerable<OdbcDataReader> ReadFile(string strExcelPath, string strWorkSheetName)
{
	OdbcConnection connODBC = new OdbcConnection("Driver={Microsoft Excel Driver (*.xls)};DriverId=790;Dbq=" + strExcelPath + ";DefaultDir=c:\\;");
	OdbcDataReader readerODBC = null;
	connODBC.Open();
	OdbcCommand commandODBC = new OdbcCommand("select * from [" + strWorkSheetName + "$]", connODBC);
	readerODBC = commandODBC.ExecuteReader();

	while (readerODBC.Read())
	{

abhi1010

public void Resize(Label label1)
{
    Graphics g = Graphics.FromHwnd(this.Handle); //gets the graphics form the form
    SizeF size = g.MeasureString(label1.Text, label1.Font); //gets the size of the text which will be displayed
    label1.Size = new Size((int)size.Width, label1.Size.Height); //sets the length of the label (same height)            
}

abhi1010

public void Resize(Label label1)
{
    Graphics g = this.CreateGraphics(); //gets the graphics based on the client area
    SizeF size = g.MeasureString(str, label1.Font); //gets the size of the text which will be displayed
    label1.Size = new Size((int)size.Width, label1.Size.Height); //sets the length of the label (same height)
}

abhi1010

private static void Directories(string strFolderPath, string fType)
{
	DirectoryInfo info = new DirectoryInfo(strFolderPath);
	ArrayList fileList = new ArrayList();
	SubDirectories(fType, ref fileList, info.FullName, "");
	return fileList;
}
private static void SubDirectories(string fType, ref ArrayList fileList, string location, string tab)
{
	DirectoryInfo subDir = new DirectoryInfo(location);

abhi1010

<input type="image" name="HoverImageButton2" id="HoverImageButton2" 
    onmouseover="ShowImageHoverButton(this, '/wiz.net/WizLibrary/img/but-backtolisting1.jpg')" 
    onmouseout="ShowImageHoverButton(this, '/wiz.net/WizLibrary/img/but-takeaction1.jpg')" 
    src="../img/but-takeaction1.jpg" style="border-width:0px;" />

abhi1010

protected override void OnPreRender(EventArgs e)
{
    base.OnPreRender(e);
    string resourceName = "ExtendedControls.HoverImageButtonJS.js";

    ClientScriptManager cs = this.Page.ClientScript;
    cs.RegisterClientScriptResource(typeof(WizWerx.Web.UI.ExtendedControls.HoverImageButton), resourceName);
}

abhi1010

<configuration>
<system.web>
        <pages>
            <controls>
                <add tagPrefix="ext" namespace="Company.Web.UI.ExtendedControls" assembly="ExtendedControls"/>
            </controls>
        </pages>
</system.web>
</configuration>

abhi1010

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Text;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Drawing.Design;
 
namespace CodersDigest.Web.UI.ExtendedControls

abhi1010

protected override void OnInit(EventArgs e)
{
    base.OnInit(e);
    this.Attributes.Add("onmouseover", "ShowImageHoverButton(this, '" + this.ResolveUrl(ImageHoverUrl) + "')");
    this.Attributes.Add("onmouseout", "ShowImageHoverButton(this, '" + this.ResolveUrl(ImageUrl) + "')");
}