ASP.NET

<br />
protected void Page_Load(object sender, EventArgs e)<br />
<br />
{<br />
<br />
if (!IsPostBack)<br />
<br />
{<br />
<br />
SqlConnection conn = new SqlConnection((ConfigurationManager.ConnectionStrings["ASPNETDBConnectionString1"]).ToString());<br />
<br />
SqlCommand cmd = new SqlCommand("SELECT DISTINCT Type FROM Product", conn);<br />
<br />
try<br />
<br />
{<br />
<br />
conn.Open();<br />
<br />
SqlDataReader dr = cmd.ExecuteReader();<br />
<br />
ddltype.Items.Add("All");<br />
<br />
<br />
while (dr.Read())<br />
<br />
{<br />
<br />
ddltype.Items.Add(dr.GetValue(0).ToString());<br />
<br />
}<br />
<br />
<br />
}<br />
<br />
catch<br />
<br />
{<br />
<br />
}<br />
<br />
conn.Close();<br />
<br />
}<br />
<br />
else<br />
<br />
{<br />
<br />
 <br />
<br />
protected void ddltype_SelectedIndexChanged(object sender, EventArgs e)<br />
<br />
{<br />
<br />
<br />
string pType = ddltype.SelectedItem.Text.ToString();<br />
<br />
//Label1.Text = Type.ToString().Trim();<br />
<br />
<br />
<br />
Response.Redirect("Product.aspx?Type=" + pType);<br />
<br />
<br />
}<br />
<br />
///////////////////////////////<br />
<br />
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:ASPNETDBConnectionString1 %>"<br />
<br />
SelectCommand="SELECT [ID], [Name], [quantity], [Pic], [Type], [comment], [desc] FROM [Product]"><br />
<br />
</asp:SqlDataSource>

ISession session = NHibernateHelper.GetCurrentSession();<br />
string connection = session.Connection.ConnectionString;

<property name="connection.connection_string"><br />
   Server=localhost; Initial Catalog=Database; Uid=sa; Pwd=password;<br />
</property>