ASP.NET

Karthick_gc wrote:

data source connection in Web config file?

<connectionstrings>
  <add>
    name="NorthwindConnectionString" 
    connectionString="Data Source=serverName;Initial 
    Catalog=Northwind;Persist Security Info=True;User 
    ID=userName;Password=password"
    providerName="System.Data.SqlClient"
  />
</add></connectionstrings>

System.Configuration.Configuration rootWebConfig =
               System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("/MyWebSiteRoot");
           System.Configuration.ConnectionStringSettings connString;
           if (0 < rootWebConfig.ConnectionStrings.ConnectionStrings.Count)
           {
               connString =
                   rootWebConfig.ConnectionStrings.ConnectionStrings["NorthwindConnectionString"];
               if (null != connString)
                   Console.WriteLine("Northwind connection string = \"{0}\"",
                       connString.ConnectionString);
               else
                   Console.WriteLine("No Northwind connection string");
           }

protected override void Render(HtmlTextWriter output)		
{		
	base.Render(output);		
	string printHTML = "";	
	output.AddAttribute(HtmlTextWriterAttribute.Id,this.ClientID);
	output.RenderBeginTag(HtmlTextWriterTag.Div);	
	for(int i=iStartPage;i<iStartPage+10;i++)		
	{		
		printHTML += "<a href=\"" + Page.ClientScript.GetPostBackClientHyperlink(this, i.ToString()) + "\">" + i + "</a>";		}		
	output.Write(printHTML);
	output.RenderEndTag();	
}