Hagrin.com

using System;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Microsoft.SharePoint;
using Microsoft.SharePoint.Administration;
using Microsoft.SharePoint.Navigation;

namespace InfoViewer
{
public class SQLQuickLaunch : System.Web.UI.WebControls.WebParts.WebPart
{
protected override void RenderContents(System.Web.UI.HtmlTextWriter output)
{

base.RenderContents(output);
try
{
string strURL = Page.Request.Url.AbsoluteUri;
string[] arrURL = strURL.Split("/".ToCharArray());
SqlConnection SQLConnection = new SqlConnection();
DataSet DataSet1 = new DataSet();
DataSet DataSet2 = new DataSet();
DataSet DataSet3 = new DataSet();

string strGUID = "";
string strRootGUID = "<";
string strListGUID = "";
string strRootURL = "<";
SQLConnection.ConnectionString = "Data Source=RMSSERVER\\OFFICESERVERS;Initial Catalog=WSS_Content;Integrated Security=SSPI;";
SQLConnection.Open();
string SQLQuery = "select id, fullurl from webs where siteid = '" + strRootGUID + "' and fullurl = '" + arrURL[3] + "'";
SqlDataAdapter DataAdapter = new SqlDataAdapter(SQLQuery, SQLConnection);
DataAdapter.Fill(DataSet1);
if (DataSet1.Tables[0].Rows.Count > 0)
{
strGUID = DataSet1.Tables[0].Rows[0][0].ToString();
arrURL[3] = arrURL[3];
}
else
{
strGUID = "";
arrURL[3] = "";
}
DataSet1 = new DataSet();
SQLQuery = "select eid, numchildren, rankchild, url, name, siteid from navnodes where eidparent in (select eid from navnodes where webid = '" + strGUID + "' and siteid = '" + strRootGUID + "' and name = 'Quick Launch') and webid = '" + strGUID + "' and siteid = '" + strRootGUID + "' order by rankchild";
DataAdapter = new SqlDataAdapter(SQLQuery, SQLConnection);
DataAdapter.Fill(DataSet1);
if (DataSet1.Tables[0].Rows.Count > 0)
{
output.RenderBeginTag("div class=ms-quicklaunchouter");
output.RenderBeginTag("div class=ms-quicklaunch style=\"width:100%; border: none;\"");
output.RenderBeginTag("table cellpadding=0 cellspacing=0 class=ms-quicklaunch width=100%");
output.RenderBeginTag("tr");
output.RenderBeginTag("td class=ms-quicklaunchheader style=\"border: none;\"");
output.Write("Navigation");
output.RenderEndTag();
output.RenderEndTag();
for (int i = 0; i <= DataSet1.Tables[0].Rows.Count - 1; i++)
{
output.RenderBeginTag("tr");
output.RenderBeginTag("td");
strListGUID = DataSet1.Tables[0].Rows[i][5].ToString();
output.RenderBeginTag("table class=ms-navheader cellpadding=0 cellspacing=0 border=0 width=100%");
output.RenderBeginTag("tr");
output.RenderBeginTag("td style=width:100%;");
string strTD = "a class=ms-navheader style=\"border-style:none;font-size:1em;\" href=";
if (DataSet1.Tables[0].Rows[i][3].ToString().Substring(0, 7) == "http://")
{
output.RenderBeginTag(strTD + System.Web.HttpUtility.UrlPathEncode(DataSet1.Tables[0].Rows[i][3].ToString()));
}
else
{
output.RenderBeginTag(strTD + "http://" + strRootURL + System.Web.HttpUtility.UrlPathEncode(DataSet1.Tables[0].Rows[i][3].ToString()));
}
output.RenderBeginTag("b");
output.Write(DataSet1.Tables[0].Rows[i][4]);
output.RenderEndTag();
output.RenderEndTag();
output.RenderEndTag();
output.RenderEndTag();
output.RenderEndTag();
output.RenderEndTag();
output.RenderEndTag();
if (int.Parse(DataSet1.Tables[0].Rows[i][1].ToString()) > 0)
{
DataSet2 = new DataSet();
SQLQuery = "select eid, numchildren, rankchild, url, name, DocID from navnodes where eidparent in (select eid from navnodes where eid = '" + DataSet1.Tables[0].Rows[i][0].ToString() + "' and webid = '" + strGUID + "' and siteid = '" + strRootGUID + "') and webid = '" + strGUID + "' and siteid = '" + strRootGUID + "' order by rankchild";
DataAdapter = new SqlDataAdapter(SQLQuery, SQLConnection);
DataAdapter.Fill(DataSet2);
for (int x = 0; x <= DataSet2.Tables[0].Rows.Count - 1; x++)
{
output.RenderBeginTag("tr");
output.RenderBeginTag("td");
output.RenderBeginTag("table class=ms-navitem width=100% border=0 cellpadding=0 cellspacing=0");
output.RenderBeginTag("tr");
output.RenderBeginTag("td style=\"width:100%;\"");
if ((DataSet2.Tables[0].Rows[x][3]) != DBNull.Value)
{
output.RenderBeginTag("a class=ms-navitem style=\"border-style:none;font-size:1em;\" href=http://" + strRootURL + System.Web.HttpUtility.UrlPathEncode(DataSet2.Tables[0].Rows[x][3].ToString()));
}
else
{
DataSet3 = new DataSet();
string strDocGUID = DataSet2.Tables[0].Rows[x][5].ToString();
SQLQuery = "select DirName, LeafName from AllDocs where id = '" + strDocGUID + "'";
DataAdapter = new SqlDataAdapter(SQLQuery, SQLConnection);
DataAdapter.Fill(DataSet3);
output.RenderBeginTag("a class=ms-navitem style=\"border-style:none;font-size:1em;\" href=http://" + strRootURL + "/" + System.Web.HttpUtility.UrlPathEncode(DataSet3.Tables[0].Rows[0][0].ToString()) + "/" + System.Web.HttpUtility.UrlPathEncode(DataSet3.Tables[0].Rows[0][1].ToString()));
}
output.Write(DataSet2.Tables[0].Rows[x][4]);
output.RenderEndTag();
output.RenderEndTag();
output.RenderEndTag();
output.RenderEndTag();
output.RenderEndTag();
output.RenderEndTag();
}
}
}
output.RenderEndTag();
output.RenderEndTag();
output.RenderEndTag();
}
DataSet1 = null;
SQLConnection.Close();
}
catch (Exception ex)
{
output.Write(ex.Message);
}
finally
{
}
}
}
}

Hi
I want to create a quick launch links based on user login.

By adding code in default.master, I can create links for a user A.

When User B logs in, it shows the links of user A. When i refresh the browser of B, it shows the links of User B.

When i refresh User B browser, it shows links of User B.

I want to retain the links of each user on their login, till they logout.

If this is possible what are the things, i need to keep in mind when i'm developing this.

Awaiting your reply.

Thanks
Prasad

Thanks hagrin. For us IT types who aren't as familiar with C#, would it be possible to post the code project for this? Not knowing much about making Custom Web Parts, I'm not exactly sure what to do with this cost specifically :)