Codeanswer

SqlDataReader to Retrieve Multiple Rows

2011-12-15T15:37:00.000-08:00

SqlDataReader to Retrieve Multiple Rows

The SqlDataReader approach to retrieve multiple rows is illustrated in the following code fragment.

using System.IO;

using System.Data;

using System.Data.SqlClient;

public SqlDataReader RetrieveRowsWithDataReader()

{

SqlConnection conn = new SqlConnection(

"server=(local);Integrated Security=SSPI;database=northwind");

SqlCommand cmd = new SqlCommand("DATRetrieveProducts", conn );

cmd.CommandType = CommandType.StoredProcedure;

try

{

Contextual Links

XmlReader to Retrieve Multiple Rows

2011-12-15T02:11:00.000-08:00

XmlReader to Retrieve Multiple Rows

You can use the SqlCommand object to generate an XmlReader object, which provides forward-only, stream-based access to XML data. The command (usually a stored procedure) must generate an XML-based result set, which for SQL Server 2000 usually consists of a SELECT statement with a valid FOR XML clause. The following code fragment illustrates this approach:

public void RetrieveAndDisplayRowsWithXmlReader()

{

using( SqlConnection conn = new SqlConnection(connectionString) )

{;

SqlCommand cmd = new SqlCommand("DATRetrieveProductsXML", conn );

cmd.CommandType = CommandType.StoredProcedure;

try

{

conn.Open();

XmlTextReader xreader = (XmlTextReader)cmd.ExecuteXmlReader();

while ( xreader.Read() )

{

if ( xreader.Name == "PRODUCTS" )

{

string strOutput = xreader.GetAttribute("ProductID");

strOutput += " ";

strOutput += xreader.GetAttribute("ProductName");

Console.WriteLine( strOutput );

}

xreader.Close(); // XmlTextReader does not support IDisposable so it can't be

// used within a using keyword

}

The preceding code uses the following stored procedure:

CREATE PROCEDURE DATRetrieveProductsXML

SELECT * FROM PRODUCTS

FOR XML AUTO

XmlReader to Retrieve Multiple Rows

2011-12-13T05:17:00.000-08:00

public void RetrieveAndDisplayRowsWithXmlReader()

{

using( SqlConnection conn = new SqlConnection(connectionString) )

{;

SqlCommand cmd = new SqlCommand("DATRetrieveProductsXML", conn );

cmd.CommandType = CommandType.StoredProcedure;

try

{

conn.Open();

XmlTextReader xreader = (XmlTextReader)cmd.ExecuteXmlReader();

while ( xreader.Read() )

{

if ( xreader.Name == "PRODUCTS" )

{

string strOutput = xreader.GetAttribute("ProductID");

strOutput += " ";

strOutput += xreader.GetAttribute("ProductName");

Console.WriteLine( strOutput );

}

xreader.Close(); // XmlTextReader does not support IDisposable so it can't be

// used within a using keyword

}

The preceding code uses the following stored procedure:

CREATE PROCEDURE DATRetrieveProductsXML

SELECT * FROM PRODUCTS

FOR XML AUTO

SqlDataReader to Retrieve Multiple Rows

2011-12-13T05:16:00.000-08:00

SqlDataReader to Retrieve Multiple Rows

The SqlDataReader approach to retrieve multiple rows is illustrated in the following code fragment.

using System.IO;

using System.Data;

using System.Data.SqlClient;

public SqlDataReader RetrieveRowsWithDataReader()

{

SqlConnection conn = new SqlConnection(

"server=(local);Integrated Security=SSPI;database=northwind");

SqlCommand cmd = new SqlCommand("DATRetrieveProducts", conn );

cmd.CommandType = CommandType.StoredProcedure;

try

Stored Procedure Output Parameters to Retrieve a Single Row

2011-12-11T22:12:00.000-08:00

Stored Procedure Output Parameters to Retrieve a Single Row
You can call a stored procedure that returns the retrieved data items within a single row by means of named output parameters. The following code fragment uses a stored procedure to retrieve the product name and unit price for a specific product contained in the Products table in the Northwind database.

void GetProductDetails( int ProductID,

out string ProductName, out decimal UnitPrice )

{

using( SqlConnection conn = new SqlConnection(

"server=(local);Integrated Security=SSPI;database=Northwind") )

{

// Set up the command object used to execute the stored proc

SqlCommand cmd = new SqlCommand( "DATGetProductDetailsSPOutput", conn )

cmd.CommandType = CommandType.StoredProcedure;

// Establish stored proc parameters.

// @ProductID int INPUT

// @ProductName nvarchar(40) OUTPUT

// @UnitPrice money OUTPUT

// Must explicitly set the direction of output parameters

SqlParameter paramProdID =

cmd.Parameters.Add( "@ProductID", ProductID );

paramProdID.Direction = ParameterDirection.Input;

SqlParameter paramProdName =

cmd.Parameters.Add( "@ProductName", SqlDbType.VarChar, 40 );

paramProdName.Direction = ParameterDirection.Output;

SqlParameter paramUnitPrice =

cmd.Parameters.Add( "@UnitPrice", SqlDbType.money );

paramUnitPrice.Direction = ParameterDirection.Output;

conn.Open();

// Use ExecuteNonQuery to run the command.

// Although no rows are returned any mapped output parameters

// (and potentially return values) are populated

cmd.ExecuteNonQuery( );

// Return output parameters from stored proc

ProductName = paramProdName.Value.ToString();

UnitPrice = (decimal)paramUnitPrice.Value;

}

radiobutton inside datalist itemTemplate

2011-12-11T22:04:00.000-08:00

aspx:

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="radioButtonInListView.aspx.cs" Inherits="WebApplication1.radioButtonInListView" %><!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>
    <script type="text/javascript">
        function resetname(senderid) {
            var radio = document.getElementById(senderid);
            radio.name = 'myoption';
         }
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:DataList ID="DataList1" runat="server" DataKeyField="NationalityID" 
            DataSourceID="SqlDataSource1" onitemdatabound="DataList1_ItemDataBound">
            <ItemTemplate>
                Nationality:
                <asp:Label ID="NationalityLabel" runat="server" 
                    Text='<%# Eval("Nationality") %>' />
                <br />
                <br />
                <asp:RadioButton ID="RadioButton1" runat="server"/>
            </ItemTemplate>
        </asp:DataList>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:TrustDBDevConnectionString %>" 
            SelectCommand="SELECT * FROM [Nationality]"></asp:SqlDataSource>
    </div>
    </form>
</body>
</html>

C# :
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace WebApplication1
{
public partial class radioButtonInListView : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}

protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
{
RadioButton r = (RadioButton)e.Item.FindControl("RadioButton1");
r.Attributes.Add("onclick", "resetname('" + r.ClientID + "')");
}
}
}

SqlDataReader to Retrieve Multiple Rows

2011-12-11T22:03:00.001-08:00

SqlDataReader to Retrieve Multiple Rows

The SqlDataReader approach to retrieve multiple rows is illustrated in the following code fragment.

using System.IO;

using System.Data;

using System.Data.SqlClient;

public SqlDataReader RetrieveRowsWithDataReader()

{

SqlConnection conn = new SqlConnection(

"server=(local);Integrated Security=SSPI;database=northwind");

SqlCommand cmd = new SqlCommand("DATRetrieveProducts", conn );

cmd.CommandType = CommandType.StoredProcedure;

try

{

repeater control using multiple Array List

2011-12-10T05:09:00.001-08:00

ASPX CODE:

<asp:Repeater ID="categoryRepeater" runat="server">
    <HeaderTemplate><dl></HeaderTemplate>
    <ItemTemplate>
    <dt><em><%# Eval("Key") %></em></dt>
    <dd>
        <asp:Repeater ID="nestedRepeater" runat="server"

DataSource='<%# Eval("Value") %>' >
            <HeaderTemplate><ol></HeaderTemplate>
            <ItemTemplate>
                <li>
                    <asp:Label ID="lblSubCategory" 
                        runat="server" 
                        Text='<%# Eval("Key") %>' />
                    <asp:TextBox ID="txtInformation"
                        runat="server"
                        Text='<%# Eval("Value") %>' />
                </li>
            </ItemTemplate>
            <FooterTemplate></ol></FooterTemplate>
        </asp:Repeater>
    </dd>
    </ItemTemplate>
    <FooterTemplate></dl></FooterTemplate>
    </asp:Repeater>

Codebehind (Init Arrays and DataBind) :

        ArrayList categories = new ArrayList 
            { "Category", "Category 2", 
                "Category 3", "Category 4" };
        ArrayList subCategories = new ArrayList 
            { "SubCategory 1", "SubCategory 2", 
                "SubCategory 3", "SubCategory 4" };
        ArrayList textControlNames = new ArrayList 
            { "Enter 1", "Enter 2", "Enter 3", "Enter 4" };

        Dictionary<string, Dictionary<string, string>> combined =
                new Dictionary<string, Dictionary<string, string>>();
        for (int i = 0; i < categories.Count; i++)
        {
            Dictionary<string, string> inner = new Dictionary<string, string>();
            for (int j = 0; j < subCategories.Count;j++)
            {
                inner.Add(subCategories[j].ToString(),
                    textControlNames[j].ToString());
            }
            combined.Add(categories[i].ToString(), inner);
        }

        categoryRepeater.DataSource = combined;
        categoryRepeater.DataBind();

What's the best way to show multiple checkboxes for multiple records in ASP.NET

2011-12-10T05:01:00.001-08:00

ASPX:

<asp:Repeater ID="rptOuter" runat="server" OnItemDataBound="rptOuter_ItemDataBound">
        <HeaderTemplate>
                <ul style="list-style-type: none">
        </HeaderTemplate>
        <ItemTemplate>
                <li id='<%# Eval("Id") %>'>
                <%# Eval("Category") %>
                <asp:Repeater ID="rptInner" runat="server">
                        <HeaderTemplate>
                                <ul style="list-style-type: none">
                        </HeaderTemplate>
                        <ItemTemplate>
                                <li>
                                        <asp:CheckBox ID="chkFeed" runat="server" Text='<%# Eval("Feed") %>' />
                                </li>
                        </ItemTemplate>
                        <FooterTemplate>
                                </ul>
                        </FooterTemplate>
                </asp:Repeater>
                </li>
        </ItemTemplate>
        <FooterTemplate>
                </ul>
        </FooterTemplate>
</asp:Repeater>

Code Behind:

protected void Page_Load(object sender, EventArgs e)
{
    using (SqlConnection conn = new SqlConnection(connString))
    {
        conn.Open();
        SqlCommand cmd = new SqlCommand("SELECT id, category FROM rsscategory_tbl", conn);
        SqlDataReader rdr = cmd.ExecuteReader();
        this.rptOuter.DataSource = rdr;
        this.rptOuter.DataBind();
        rdr.Close();
    }
}
protected void rptOuter_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
    if (e.Item.ItemType == ListItemType.Item ||
        e.Item.ItemType == ListItemType.AlternatingItem)
    {            
        using (SqlConnection conn = new SqlConnection(connString))
        {
            conn.Open();
            System.Data.Common.DbDataRecord rd = (System.Data.Common.DbDataRecord)e.Item.DataItem;
            SqlCommand cmd = new SqlCommand("SELECT feed FROM rssfeed_tbl WHERE categoryid = " + rd.GetInt32(rd.GetOrdinal("id")), conn);
            Repeater rptInner = (Repeater)e.Item.FindControl("rptInner");
            SqlDataReader rdr = cmd.ExecuteReader();
            rptInner.DataSource = rdr;
            rptInner.DataBind();
            rdr.Close();
        }
     }
}

ASP.net - LinkButtons in a Repeater within an UpdatePanel are not triggering a postback of any kind

2011-12-09T00:48:00.000-08:00

<asp:UpdatePanel ID="DataUpdatePanel" runat="server">
<ContentTemplate>
<table>
    <asp:Repeater ID="RepeaterBlock" runat="server">
    <HeaderTemplate><thead><tr><th>Name</th><th>Status</th><th class="empty"></th></tr></thead></HeaderTemplate>
    <ItemTemplate><tr>
        <td><a class="link" href="Detail.aspx?item=<%# DataBinder.Eval( Container.DataItem, "Name") %>"><%# DataBinder.Eval( Container.DataItem, "Name") %></a>
        </td>
        <td><%# DataBinder.Eval( Container.DataItem, "Status") %></td>
        <td class="no-border">
            [<asp:LinkButton CommandName='Schedule' CommandArgument='<%# DataBinder.Eval(Container.DataItem, "Name") %>' ID="ScheduleButton" runat="server" CausesValidation="false" >Schedule</asp:LinkButton>]
        </td>
     </tr></ItemTemplate>
    </asp:Repeater>
</table>
</ContentTemplate>
</asp:UpdatePanel>

<Triggers>
   <asp:AsyncPostBackTrigger ControlID="ScheduleButton" />
</Triggers>

use in Code Behind

RepeatData.DataBind();
RepeatData.ItemCommand += new RepeaterCommandEventHandler(RepeatData_ItemCommand);

UpdateScripts.RegisterAsyncPostBackControl(FindControlRecursive( RepeatData, "SchedulButton"));

Repeater, Link Button, onItemCommand

2011-12-08T23:53:00.001-08:00

asp:Repeater ID="myRepeater" OnItemCommand="MyCommand" runat="server">
    <ItemTemplate>
        <asp:LinkButton ID="myLinkButton" CommandName="MyCommand" CommandArgument='<%#Eval("uid")%>' runat="server" Text='<%#Eval("Forename")%>' />    <ItemTemplate>
</asp:Repeater>

In my page load I did the following

if Page.Request.Params.Get("__EVENTTARGET").ToString.Substring(Page.Request.Params.Get("__EVENTTARGET").ToString.LastIndexOf("$") + 1) = "myLinkButton" then
    rebind_repeater_hereend if

Repeater and Submit button problem

2011-12-08T23:52:00.001-08:00

Private void Page_Load(object sender, System.EventArgs e)
                {
                        // Put user code to initialize the page here
                        if(IsPostBack)
                        {
                        }

                        else
                        {
                                MyHashTable=new Hashtable(2);

                                MyHashTable.Add("Hello",1);
                                MyHashTable.Add("Bye",2);

                                this.Repeater1.DataSource=MyHashTable;
                                this.Repeater1.DataBind();
                        }
                }
private void Button1_Click(object sender, System.EventArgs e)
                {
                        System.Web.UI.WebControls.Label MyLabel=new Label();
                        MyLabel=(System.Web.UI.WebControls.Label)this.Repeater1.Items[0].FindControl("Label1");
                        string mmmm=MyLabel.Text.ToString().TrimEnd();
                        int x=0;
                
                }

To read entire contents of uploaded file

2011-12-08T21:45:00.002-08:00

We can Use only one line For that
Here EntireContent is a variable.

fileupload1.PostedFile.InputStream.Read

(EntireContent, 0, fileupload1.PostedFile.ContentLength);

PDF Compression by iTextsharp

2011-12-08T21:45:00.000-08:00

string pdfFile = @"D:\google.pdf";

PdfReader reader = new PdfReader(pdfFile);

PdfStamper stamper = new PdfStamper(reader, new FileStream(@"D:\google.pdf", FileMode.Create), PdfWriter.VERSION_1_5);

stamper.FormFlattening = true;

stamper.SetFullCompression();

stamper.Close();

GridView with CheckBox for Deleteing the checked Items..

2011-12-08T21:44:00.000-08:00

Take This Items In webForms

- One gridView

- One button checkAll/UncheckAll

- One Button for Delete all the Checked CheckBox..

Lets see one by one how can we put checkbox inside GridView

Use This Source File In Html

[asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"]

[Columns]

   [asp:BoundField DataField="roll_no" HeaderText="Roll No" /]

   [asp:BoundField DataField="s_name" HeaderText="Student Name" /]

   [asp:BoundField DataField="class" HeaderText="Class" /]

     [asp:TemplateField]

   [ItemTemplate]

       [asp:CheckBox ID="ch1" Text='<%# Eval("roll_no") %>' runat="server" /]

     [/ItemTemplate]

      [/asp:TemplateField]

[/Columns]

  [/asp:GridView]

In your .cs file in the class level write this line of code

First Use This Code in Page load

ArrayList alist = new  ArrayList();

protected void Page_Load(object sender, EventArgs e)

 if (!Page.IsPostBack)

      //Populate data and Bind in Gridview

Use This Code In Check All Button Click Event

SqlDataAdapter To Retrieve Multiple Rows

2011-12-07T21:44:00.000-08:00

SqlDataAdapter To Retrieve Multiple Rows

The following code illustrates how to use a SqlDataAdapter object to issue a command that generates a DataSet or DataTable. It retrieves a set of product categories from the SQL Server Northwind database.

using System.Data;

using System.Data.SqlClient;

public DataTable RetrieveRowsWithDataTable()

{

using ( SqlConnection conn = new SqlConnection(connectionString) )

{

conn.Open();

SqlCommand cmd = new SqlCommand("DATRetrieveProducts", conn);

cmd.CommandType = CommandType.StoredProcedure;

SqlDataAdapter adapter = new SqlDataAdapter( cmd );

DataTable dataTable = new DataTable("Products");

adapter .Fill(dataTable);

return dataTable;

}

To use a SqlAdapter to generate a DataSet or DataTable

1. Create a SqlCommand object to invoke the stored procedure and associate this with a SqlConnection object (shown) or connection string (not shown).
2. Create a new SqlDataAdapter object and associate it with the SqlCommand object.
3. Create a DataTable (or optionally, a DataSet) object. Use a constructor argument to name the DataTable.
4. Call the Fill method of the SqlDataAdapter object to populate either the DataSet or DataTable with the retrieved rows.

Reading BLOG Data from the Database

2011-12-07T21:42:00.000-08:00

Reading BLOB Data from the Database

When creating a SqlDataReader object through the ExecuteReader method to read rows that contain BLOB data, use the CommandBehavior.SequentialAccess enumerated value. Without this enumerated value, the reader pulls data from the server to the client one row at a time. If the row contains a BLOB column, this might represent a large amount of memory. By using the enumerated value, you have a finer degree of control because the BLOB data will be pulled only when referenced (for example, by means of the GetBytes method, which you can use to control the number of bytes read). This is illustrated in the following code fragment.

Writing BLOG Data to the Database

2011-12-07T21:41:00.000-08:00

Writing BLOG Data to the Database

public void StorePicture( string filename )

{

// Read the file into a byte array

using(FileStream fs = new FileStream(filename, FileMode.Open, FileAccess.Read))

{

byte[] imageData = new Byte[fs.Length];

fs.Read( imageData, 0, (int)fs.Length );

}

using( SqlConnection conn = new SqlConnection(connectionString) )

{

SqlCommand cmd = new SqlCommand("StorePicture", conn);

cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.Add("@filename", filename );

cmd.Parameters["@filename"].Direction = ParameterDirection.Input;

cmd.Parameters.Add("@blobdata", SqlDbType.Image);

cmd.Parameters["@blobdata"].Direction = ParameterDirection.Input;

// Store the byte array within the image field

cmd.Parameters["@blobdata"].Value = imageData;

conn.Open();

cmd.ExecuteNonQuery();

conn.Close();

}

Bringing SelectedItem Into Focus Using DataGrid Control

2011-12-07T00:41:00.000-08:00

Problem :

When using datagrid control of the silverlight control there is situation when datagrid control has lots of records and vertical scrolling of the datagrid control is visible and the selected item of the datagrid control is not in the view as the scrolling (vertical scrolling of the datagrid is visible due to large record). So it is important to give focus to the selected item of the datagrid control.In this post I will give you solution of this problem which many of you may have face.

Solution :

To start with how to solve above problem I have one button control with is used to bring the selected item of the datagrid control in the focus and one datagrid control which is used to show the records. The main form of the test application is shown in the Image 1 here you can see that datagrid display all the records which are assign to it ( as I have small number of records in my grid so i have reduce the height of the datagrid control so that it has vertical scrolling and the selected item is not seen when datagrid control first display). In the Image 1 you can see that selected item is not displayed which I have mention in my problem.

Image 1

The solution to above problem is quite simple but it take time when I first come across this problem. You can see the code used to bring the selected item of the datagrid control in the focus just one line of code which is used. Here I have used ScrollIntoView function of the datagrid control which take The data item (row) to scroll to as its first parameter ( here you can see that I have passed the selected item of the datagrid control) and the second parameter of the ScrollIntoView is the column of the datagrid control(the column to scroll to here I have passed the first column of the datagrid control).

private void Button_Click(object sender, RoutedEventArgs e)

{

    dgrdCustomer.ScrollIntoView(dgrdCustomer.SelectedItem, dgrdCustomer.Columns[0]);

}

List 1

The output can be seen in the Image 2, when you client the "Selected Item" button then it will focus the selected item of the datagrid control.

Image 2

Note: In the HomeViewModel which is the viewModel for the home page. I have assigned value to the Selectedcustomer before sorting the PagedCollectionView(CustomerList property) so that after sorting the selected item will disappear from the view and it should.If I assigned the first element of the PagedCollectionView (CustomerList) after sorting then first element will be selected..

If you have similar situation then you solved it by using above technique as I have done when I got similar situation.You can download the source code from here.

original Source : http://asimsajjad.blogspot.com/2011/12/bringing-selecteditem-into-focus-using.html

How to Display Dynamic Images in Crystal Report

2011-12-07T00:38:00.000-08:00

How to use Dynamic images in Crystal Report with out Using Database

Step 1: Add Pictures in Crystal report and Suppress all the pictures

For example:
let us Consider 5 pictures A,B,C,D,E. Add those Pictures using Insert Picture Proberty After Adding just supress the all 5 Pictures.

Step 2:
In Your Asp.net Page Just check the the condition according to that remove Suppress option

Code:

using crystalDecisions.Shared;
using crystalDecisions.crystalReports.Engine;

ReportDocument crDoc=new ReportDocument();
crDoc.load(crystalreportpath,OpenReportMethod.OpenReportByTempCopy);
if(id=="A")
{
 crDoc.ReportDefinition.Sections("SectionNameinCrystalReport")

.ReportOject("PicturelabelName").ObjectFormat.EnableSuppress=False
}
else if(id=="B")
{
 crDoc.ReportDefinition.Sections("SectionNameinCrystalReport")

.ReportOject("PicturelabelName").ObjectFormat.EnableSuppress=False
}
else if(id=="C")
{
 crDoc.ReportDefinition.Sections("SectionNameinCrystalReport")

.ReportOject("PicturelabelName").ObjectFormat.EnableSuppress=False
}
else if(id=="D")
{
 crDoc.ReportDefinition.Sections("SectionNameinCrystalReport")

.ReportOject("PicturelabelName").ObjectFormat.EnableSuppress=False
}
else if(id=="E")
{
 crDoc.ReportDefinition.Sections("SectionNameinCrystalReport")

.ReportOject("PicturelabelName").ObjectFormat.EnableSuppress=False
}