Thursday, July 15, 2010

Stored Procedure using Dataset with where clause

<asp:TextBox ID="tbxAccountName" runat="server"></asp:TextBox>
<asp:Button ID="btnAccountName" runat="server" Text="Get Account Name" OnClick="btnAccountName_Click" />
<br />
<asp:Label ID="lblMessage" runat="server" Text=""></asp:Label>
<br />
<asp:GridView ID="gvProductDisplay" runat="server">
<Columns>
<asp:TemplateField HeaderText="AccountTypeID">
<ItemTemplate>
<asp:Label ID="lblAccountTypeID" runat="server" Text='<%# Bind("AccountTypeID") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="AccountTypeName">
<ItemTemplate>
<asp:Label ID="lblAccountTypeName" runat="server" Text='<%# Bind("AccountTypeName") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="AccountTypeCode">
<ItemTemplate>
<asp:Label ID="lblAccountTypeCode" runat="server" Text='<%# Bind("AccountTypeCode") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>


protected void btnAccountName_Click(object sender, EventArgs e)
{
try
{
DataSet ds = new DataSet();
SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["AccountingConnectionString"].ConnectionString);
SqlDataAdapter da = new SqlDataAdapter("sp_AccountType", conn);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.Add(new SqlParameter("@AccountTypeName", tbxAccountName.Text));
da.SelectCommand.Parameters["@AccountTypeName"].Value = tbxAccountName.Text;
da.Fill(ds, "AccountType");
gvProductDisplay.DataSource = ds;
gvProductDisplay.DataBind();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
}