ASP.Net Script C# - Database: Parametric Queries - Morpheusweb.it - Webmaster resources: combobox, thread, threading, asp net, dotnet, webservice, c sharp, c# net, aspx, using c#, for c#, c# tutorial, windows forms, c# dataset, vb to c#, visual studio, c# web, c# string, function c#, xml c#, dropdownlist, c# datetime, csharp, c# arraylist, c# thread, c# combobox, c# excel, visual c# net, datagrid, c# listbox, array in c#, c# code, c# download, asp net c#, c# uml, hashtable, oledb, c# form, c# tooltip, c# components, c# file, c# datagrid, dotnet, script language c#

Parametric Queries - << VB.NET VERSION >>

Execute a parametric query

<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<html>
<script language="C#" runat="server">
public void btnFiltra_Click(Object sender, EventArgs E)
{
  String selectCmd = "select * from utenti where cognome = @cognome";
  OleDbConnection myConnection = new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0; Data Source=" +   Server.MapPath("database/utenti.mdb"));
  OleDbDataAdapter myCommand = new OleDbDataAdapter(selectCmd, myConnection);
  myCommand.SelectCommand.Parameters.Add(new OleDbParameter("@cognome", 2));
  myCommand.SelectCommand.Parameters["@cognome"].Value = tbFiltro.Text;
  DataSet ds = new DataSet();
  myCommand.Fill(ds, "utenti");
  MyDataGrid.DataSource= ds.Tables["utenti"].DefaultView;
  MyDataGrid.DataBind();
}
</script>
<body>
<form id="Form1" method="post" runat="server">
<asp:TextBox id="tbFiltro" runat="server">pippo</asp:TextBox>
<asp:Button id="btnFiltra" runat="server" Text="Filtra Cognome" OnClick="btnFiltra_Click"></asp:Button><BR>
<BR>
<ASP:DataGrid id="MyDataGrid" runat="server" Width="700px" CellPadding="4"
    BackColor="White" BorderColor="#CC9966" BorderStyle="None"
    BorderWidth="1px" Font-Names="Verdana" Font-Name="Verdana" Font-Size="8pt"
    HeaderStyle-BackColor="#aaaadd" EnableViewState="False">
<FooterStyle ForeColor="#330099" BackColor="#FFFFCC"></FooterStyle>
<SelectedItemStyle Font-Bold="True" ForeColor="#663399" BackColor="#FFCC66"></SelectedItemStyle>
<ItemStyle ForeColor="#330099" BackColor="White"></ItemStyle>
<HeaderStyle Font-Bold="True" ForeColor="#FFFFCC" BackColor="#990000"></HeaderStyle>
<PagerStyle HorizontalAlign="Center" ForeColor="#330099" BackColor="#FFFFCC"></PagerStyle>
</ASP:DataGrid></form>
</body>
</html>