Comments by Member 9762839 (Top 1 by date)

Member 9762839 2-May-13 7:58am View

yaaa i tried...

Source page
---------------

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:CheckBoxList ID="CheckBoxList1" runat="server" AutoPostBack="True"
DataSourceID="SqlDataSource1" DataTextField="NationalityID"
DataValueField="NationalityID"
onselectedindexchanged="CheckBoxList1_SelectedIndexChanged">

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:UllasConnectionString %>"
SelectCommand="SELECT [NationalityID] FROM [Nationality]">

<br />
<br />
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">
<columns>
<asp:BoundField DataField="NationalityID" HeaderText="NationalityID"
SortExpression="NationalityID" />
<asp:BoundField DataField="Nationality" HeaderText="Nationality"
SortExpression="Nationality" />

</div>
</form>
</body>
</html>

Code behind
--------------

using System;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

public partial class _Default : System.Web.UI.Page
{

protected void Page_Load(object sender, EventArgs e)
{

}
protected void CheckBoxList1_SelectedIndexChanged(object sender, EventArgs e)
{

SqlConnection cnn = new SqlConnection(
ConfigurationManager.ConnectionStrings["UllasConnectionString"].ConnectionString.Trim());

SqlCommand cmd = new SqlCommand();

String sqlText = "select * from Nationality ";
String sqlFilterText = "";
int index = 0;
foreach (ListItem item in CheckBoxList1.Items)
{
index += 1;
if (item.Selected)
{
String paramName = "@param" + index.ToString().Trim();
SqlParameter param = new SqlParameter(paramName, SqlDbType.UniqueIdentifier);

//param.Value = new Guid(item.Value.Trim());

param.Value =new Guid (item.Value.Trim());

cmd.Parameters.Add(param);

sqlFilterText += " NationalityID = " + paramName + " or ";
}
}

if (!String.IsNullOrEmpty(sqlFilterText))
{
sqlText += " Where " + sqlFilterText.Substring(0, sqlFilterText.Length - 3);
}
cmd.CommandText = sqlText;
cmd.Connection = cnn;

SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataTable tbl = new DataTable();
adapter.Fill(tbl);
GridView1.DataSource = tbl;
GridView1.DataBind();

}
}

But it showing the following error

Guid should contain 32 digits with 4 dashes (xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx).