Working with Microsoft Report Viewer Control in asp.net web application

If you would like to display data in matrix form then Microsoft report viewer control is perfect one for you.
I just show below how you use this control in your application

Create new project – name it as ReportViewer
Add new dataset to your application
Solution-> add new item - > data- Dataset
Go to toolbox as shown below

Drag Table Adapter on Dataset designer

Configure the Data source as shown below. Specify your database

Click next –> then specify your connection string

Click next -> if you have database query specify SQL statements or stored procedure as per your requirements

Click next-> next -> click finish

Now Dataset is configured with data source. Your dataset is ready

Now add rdlc file as shown below to your application.

Solution- Add new Item-> Reporting->Report

Now drag matrix from toolbox on rdlc designer

Now open website data sources (from menu – Data-Show data sources)

Drag fields on matrix as you require displaying data in the matrix

And now save the changes

Now add new web page to your application

Add Microsoft report viewer control on this page

(Drag from Toolbox -> Reporting -> Microsoft Report Viewer)
Select the created rdlc file as your report  as shown below

And save your application and run application

Now your data is displaying in matrix format!!!. Change font, background color as you require.  enjoy the  beauty of this control :) It saves lots of your time for sure....

If you find any issues please write me comment.
Happy coding….

Uploading files to sql server database in asp.net

Guys if u requires storing files in sql server database, then here is the code.
create a datatable as shown in fig.

Drag a FileUpload control and Button control on Aspx markup .

And on button click event write the following code.

protected void Button2_Click(object sender, EventArgs e)
{
string cnstng = "Data Source=test;Initial Catalog=testdb;Integrated Security=True";
SqlConnection con = new SqlConnection(cnstng);
string sqlText = "insert into dbo.Attachments (FileName, FileContent,FileSizeInMB,ContentType) values(@FileName ,@FileContent,,FileSizeInMB,ContentType)";
if (FileUpload1.HasFile)
{
HttpPostedFile p_filePosted = FileUpload1.PostedFile;
int length = p_filePosted.ContentLength;
string filePath = p_filePosted.FileName;
string fileName = Path.GetFileName(filePath);
string contentType = p_filePosted.ContentType;
string sizeMB = (length / 1048576).ToString();
int sizeMBIndex = sizeMB.IndexOf(".");
if (sizeMBIndex > 0)
{
sizeMBIndex = sizeMBIndex + 4;
sizeMB = sizeMB.Substring(0, sizeMBIndex);
}

byte[] bytes = new byte[length];
p_filePosted.InputStream.Read(bytes, 0, length);
try
{
con.Open();
SqlCommand cmd = new SqlCommand(sqlText, con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@FileName", fileName);
cmd.Parameters.AddWithValue("@FileContent", bytes);
cmd.Parameters.AddWithValue("@FileSizeInMB", sizeMB);
cmd.Parameters.AddWithValue("@ContentType", contentType);
cmd.ExecuteNonQuery();
}
Catch
{
}
}
}

Double click event for asp.net List Box control

If your requirement is to redirect or other functionalities to be done on double clicking of list box control then here is the solution.
Write following JavaScript method.
function m_lbFallowUp_DoubleClick() {
/* we will change value of this hidden field so that in
page load event we can identify event.
*/
var list = document.getElementById('ctl00_ctl00_ContentPlaceHolder2_m_tpFallowUp_m_lbFallowUp');
for (var i = 0; i < list.options.length; i++) {
if (list.options[i].selected == true) {
document.forms[0].ListBox1Hidden.value = "doubleclicked";
document.forms[0].submit();
}
}
}
place this code in aspx markup
asp:ListBox ID="m_lbFallowUp" Width="400px" Height ="100px" runat="server" ondblclick="m_lbFallowUp_DoubleClick()" asp:ListBox
input type="hidden" name="ListBox1Hidden"
Inside code behind place this code
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Params["ListBox1Hidden"] != null && (string)Request.Params["ListBox1Hidden"] == "doubleclicked")
{
if (m_lbFallowUp.SelectedItem != null)
{
int fallowUpId = Convert.ToInt32(m_lbFallowUp.SelectedItem.Value);
Response.Redirect("~\\Forms\\CreateFallowUp.aspx?SuggestionId=" + suggestionId + "&FallowUpId=" + fallowUpId );
}
}
}

Creating asp.net treeview dynamicaly with sql database for discussion thread.

If you require to display discussion thread where each main topic commented by someone and each comment again reponded by someone and this cycels goes on. Then here is the solution where I have developed same fuctionality using recursive technique. I have used asp.net treeview control where each node is binded with database.

private void CreateParentNode(TreeView p_treeview)
{
try
{
CommentDetails cdetails = new CommentDetails();
DataTable dtComments = cdetails.GetCommentWithoutResponse(suggestionId);//retriving parent node data from database
for (int i = 0; i < dtComments.Rows.Count; i++)
{
DataRow drComments = dtComments.Rows[i];
int commentId = Convert.ToInt32(drComments["commentId"].ToString());
TreeNode root = new TreeNode();
string text = drComments["PostedOn"].ToString() + " " + drComments["StaffName"].ToString();
root.Text = text;
// root.Target = "_blank";
root.NavigateUrl = "~\\Forms\\ViewComment.aspx?SuggestionId=" + suggestionId + "&CommentId=" + commentId ;
p_treeview.Nodes.Add(root);
CreateChildNode(root, commentId); //calling method for creating child node
// p_treeview.CollapseAll();
}
}
catch
{}
}

private void CreateChildNode(TreeNode p_tnode, int p_commentId, int p_discussionType)
{
try
{
CommentDetails cdetails = new CommentDetails();
DataTable dtComments = cdetails.GetResponseByCommentId(suggestionId,p_commentId); //retrieving child nodes data from database
for (int i = 0; i < dtComments.Rows.Count; i++)
{
DataRow drComments = dtComments.Rows[i];
int commentId = Convert.ToInt32(drComments["commentId"].ToString());
TreeNode child = new TreeNode();
string text = drComments["PostedOn"].ToString() + " " + drComments["StaffName"].ToString();
child.Text = text;
//child.Target = "_blank";
child.NavigateUrl = "~\\Forms\\ViewComment.aspx?SuggestionId=" + suggestionId + "&CommentId=" + commentId ;
p_tnode.ChildNodes.Add(child);
// TreeView1.Nodes.Add(p_tnode);
CreateChildNode(child, commentId); //calling this method recursively
}
}
catch
{
}
}

protected void Page_Load(object sender, EventArgs e)
{
if(!IspostBack)
CreateParentNode(TreeView1);
//call this method from page load event // Treeview1 is name of cotrol placed on aspx markup
}



Happy coding…