Basic ASP C# – marifnst

I hope this first tutorial can help you to answer below question:

How to load AspxGridView
How to read Web.Config file
How to get ConnectionString of SQLDataSource from Web Config
How to set parameter of SQLDataSource

My Aspx:

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="WebApplication1._Default" %>
 
<%@ Register assembly="DevExpress.Web.ASPxGridView.v10.2, Version=10.2.11.0, Culture=neutral, PublicKeyToken=zzzzz" namespace="DevExpress.Web.ASPxGridView" tagprefix="dx" %>
<%@ Register assembly="DevExpress.Web.ASPxEditors.v10.2, Version=10.2.11.0, Culture=neutral, PublicKeyToken=zzzzz" namespace="DevExpress.Web.ASPxEditors" tagprefix="dx" %>
 
<!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>Untitled Page</title>
 
    <script language="javascript" type="text/javascript">
// <!CDATA[
 
// ]]>
    </script>
</head>
<body>
    <form id="form1" runat="server">
    <div>
 
        <dx:ASPxButton ID="ASPxButton1" runat="server" onclick="ASPxButton1_Click" 
            Text="Refresh">
        </dx:ASPxButton>
        <br />
        <dx:ASPxGridView ID="ASPxGridView1" runat="server" AutoGenerateColumns="True" 
            DataSourceID="SqlDataSource1" KeyFieldName="PKId">
            <Columns>           
            </Columns>
            <Settings ShowFilterRow="True" />
        </dx:ASPxGridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            SelectCommand="MY_SP" SelectCommandType="StoredProcedure">
            <SelectParameters>
                <asp:Parameter Name="PARAM_1" Type="DateTime" />
                <asp:Parameter Name="PARAM_2" Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>
 
    </div>
    </form>
</body>
</html>

My Aspx.cs

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
 
namespace WebApplication1
{
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            // how to get web config value & set to sql datasource
            SqlDataSource1.ConnectionString = ConfigurationManager.ConnectionStrings["LBUConnectionString"].ConnectionString;
            // load data from aspxgridview
            ASPxGridView1.DataBind();            
        }
 
        protected void ASPxButton1_Click(object sender, EventArgs e)
        {
            // inject variable or parameter to sqldatasource
            SqlDataSource1.SelectParameters["PARAM_1"].DefaultValue = DateTime.Now.ToString();
            SqlDataSource1.SelectParameters["PARAM_2"].DefaultValue = "20180101";
            ASPxGridView1.DataBind();
        }
    }
}

CMIIW .

Leave a Reply Cancel reply