Real Tech: Complete List View:

Create two tables:

-- Create Login Page

Create Table Login

(

StudentId bigint identity(1,1),

StudentName varchar(50),

StudentPassword varchar(50)

)

STUDENT ID	STUDENT NAME	STUDENT PASSWORD
1	Srinivas	Srinivas
2	Krishna	Krishna
3	Ramu	Ramu
4	Rakesh	Rakesh

-- Create Marks table

Create table marks

(

StudentId bigint,

Telugu int,

Hindi int,

English int,

Maths int,

Science int,

Scoial int

)

-- Insert values to Marks table

-- Create stored procedure

CREATE PROCEDURE dbo.GetStudentMarks
 (
 @USERNAME VARCHAR(50),
 @PASSWORD VARCHAR(50)
 )
     
 AS
 BEGIN
     --DECLARING TEMP @STUDENTID
     DECLARE @STUDENTID BIGINT
     SET @STUDENTID = (SELECT TOP 1 STUDENTID 
                         FROM    Login
                         WHERE    StudentName = @USERNAME
                         AND        STUDENTPASSWORD = @PASSWORD)
 
     --RETRIVING STUDENT MARKS 
     SELECT * 
     FROM    MARKSTABLE
     WHERE    STUDENTID = @STUDENTID
 END
     /* SET NOCOUNT ON */

-- List View Page

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ListView.aspx.cs"
  Inherits="ListView" %>
 
 <!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>ListView</title>
 </head>
 <body>
     <form id="form1" runat="server">
     <div>
     <table align="center">
            <tr>
                 <td>
                     UserName:
                 </td>
                 <td>
                     <asp:TextBox runat="server" ID="txtUsername" >
     
                     </asp:TextBox>
                 </td>
 
            </tr>
             <tr>
                 <td>
                       Password:
                  </td>
                  <td>
                     <asp:TextBox runat="server" ID="txtpassword" >
                     
                     </asp:TextBox>
                     </td>
             </tr>
             <tr>
             <td colspan="2" align="center">
                <%-- <input type="button" id="btnAdminLogin" value="Submit" />
 --%>
 
 <asp:Button runat="server" ID="btnSubmit" OnClick="GetMarks_Submit" Text="Submit" />
 </td>
 </tr>    
     </table>
     <table align="center">
     <tr>
     <td>
     <asp:ListView runat="server" ID="ltvData" >
     <LayoutTemplate>
     
     
     
     <table align="center">  
     <tr>
   <td>
    <asp:Label runat="server" ID="Label11" Text="StudentID" ></asp:Label>
  </td>
                                                         <td>
  <asp:Label runat="server" ID="lblTelgu1" Text="Telugu" ></asp:Label>
   </td>
   <td>
   <asp:Label runat="server" ID="lblHindi1" Text="Hindi" ></asp:Label>
     </td>
   <td>
   <asp:Label runat="server" ID="lblEnglish1" Text="English" ></asp:Label>
   </td>
    <td>
 <asp:Label runat="server" ID="lblMaths1" Text="Maths" ></asp:Label>
    </td>
    <td>
    <asp:Label runat="server" ID="lblScience1" Text="Science" ></asp:Label>
    </td>
    <td>
     <asp:Label runat="server" ID="lblsocial1" Text="Social" ></asp:Label>
      </td>
                             
   <td>
  </tr>
   <tr>
   <td>
   <tbody>
  <asp:PlaceHolder ID="itemPlaceholder" runat="server"></asp:PlaceHolder>
  </tbody>
   </td>
     </tr>
                              
             </td>
             </tr>
     </table>
     
     
     </LayoutTemplate>
     <ItemTemplate>
    
     
     <table align="center">  
     <tr>
               <td>
     <asp:Label runat="server" ID="Label1" Text='<%#Eval("StudentID") %>' ></asp:Label>
 <asp:LinkButton ID="btnupdate" runat="server" Text="Edit" 
 PostBackUrl='<%#"MarksEdit.aspx?id=" + Eval("StudentID") %>'>
     </asp:LinkButton></td>
     <td>
      <asp:Label runat="server" ID="lblTelgu" Text='<%#Eval("Telugu") %>' ></asp:Label>
      </td>
     <td>
      <asp:Label runat="server" ID="lblHindi" Text='<%#Eval("Hindi") %>' ></asp:Label>
       </td>
         <td>
      <asp:Label runat="server" ID="lblEnglish" Text='<%#Eval("English") %>' ></asp:Label>
      </td>
      <td>
    <asp:Label runat="server" ID="lblMaths" Text='<%#Eval("Maths") %>' ></asp:Label>
      </td>
      <td>
        <asp:Label runat="server" ID="lblScience" Text='<%#Eval("Science") %>' ></asp:Label>
      </td>
        <td>
         <asp:Label runat="server" ID="lblsocial" Text='<%#Eval("Social") %>' ></asp:Label>
            </td>
                             </tr>
     </table>
     
     </ItemTemplate>
 
     </asp:ListView>
     </td>
     </tr>
     
     </table>
     </div>
     </form>
 </body>
 </html>

.Cs code

using System;
 using System.Collections.Generic;
 using System.Linq;
 using System.Web;
 using System.Web.UI;
 using System.Web.UI.WebControls;
 using System.Data;
 using System.Data.SqlClient;
 
 public partial class ListView : System.Web.UI.Page
 {
     BL objBL = new BL();
     DataSet dt;
          
     protected void Page_Load(object sender, EventArgs e)
     {
         if (!IsPostBack)
         {
            // FillDataList();
         }
 
     }
     protected void GetMarks_Submit(object sender, EventArgs e)
     {
         FillDataList();
     }
     #region FillDatalist
     /// <summary>
     /// FillDatalist 
     /// </summary>
     public void FillDataList()
     {
         try
         {
             string StudentName = txtUsername.Text.ToString();
             string StudentPassword = txtpassword.Text.ToString();
             dt = objBL.GetStudentMarks(StudentName, StudentPassword);
             ltvData.DataSource = dt;
             ltvData.DataBind();
         }
         catch (Exception Ex)
         {
             Response.Write("<script>alert('Error')</script>");
         }
 
     }
 
     #endregion
 }

-- Take 3 classes.

That is

1. BL.

2. DL.

3. Sqlcommon.

BL:

using System;
 using System.Collections.Generic;
 using System.Linq;
 using System.Web;
 using System.Data;
 using System.Data.SqlClient;
 
 /// <summary>
 /// Summary description for BL
 /// </summary>
 public class BL
 {
     DL objDL = new DL();
     DataSet dt;
     public BL()
     {
         //
         // TODO: Add constructor logic here
         //
     }
     #region GetStudentMarks
 
     /// <summary>
     /// GetStudentMarks
     /// </summary>
     /// <param name="StudentName"></param>
     /// <param name="StudentPassword"></param>
     /// <returns></returns>
     public DataSet GetStudentMarks(string StudentName, string StudentPassword)
     {
         try
         {
             return dt = objDL.GetStudentMarks(StudentName, StudentPassword);
         }
         catch (Exception Ex)
         {
             throw Ex;
         }
     }
     #endregion
 }

DL:

using System;
 using System.Collections.Generic;
 using System.Linq;
 using System.Web;
 using System.Data;
 using System.Data.SqlClient;
 using Microsoft.ApplicationBlocks.Data;
 
 /// <summary>
 /// Summary description for DL
 /// </summary>
 public class DL
 {
     SqlCommon objSqlcommom = new SqlCommon();
     DataSet dt;
    
     public DL()
     {
         //
         // TODO: Add constructor logic here
         //
     }
     #region SetProperties
     string StudentName;
     string StudentPassword;
 
     public string StudentPassword1
     {
         get { return StudentPassword; }
         set { StudentPassword = value; }
     }
 
     public string StudentName1
     {
         get { return StudentName; }
         set { StudentName = value; }
     }
    
     #endregion
     #region GetStudentMarks
     public DataSet GetStudentMarks(string StudentName, string StudentPassword)
     {
         string ProcedureName = "GetStudentMarks";
         try
         {
             SqlParameter parStudentName = objSqlcommom.CreateParameter("@USERNAME", DbType.String, StudentName);
             SqlParameter parStudentPassword = objSqlcommom.CreateParameter("@PASSWORD", DbType.String, StudentPassword);
             SqlParameter[] par = { parStudentName, parStudentPassword };
             dt = SqlHelper.ExecuteDataset(SqlCommon.connectionString, ProcedureName, par);
             return dt;
             
         }
         catch (Exception Ex)
         {
             throw Ex;
         }
     }
     #endregion
 }

SQLCOMMON CLASS:

using System;
 using System.Collections.Generic;
 using System.Linq;
 using System.Web;
 using System.Data;
 using System.Data.SqlClient;
 using System.Configuration;
 
 /// <summary>
 /// Summary description for SqlCommon
 /// </summary>
 public class SqlCommon
 {
     public SqlCommon()
     {
         //
         // TODO: Add constructor logic here
         //
     }
     #region connectionString
     /// <summary>
     /// GetConnecction String
     /// </summary>
     public static string connectionString {
         get { return ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; }
 
     }
     #endregion
     #region CreateSqlParameter
 
     /// <summary>
     /// Createparameter
     /// </summary>
     /// <param name="Paramenter"></param>
     /// <param name="type"></param>
     /// <param name="value"></param>
     /// <returns></returns>
     public SqlParameter CreateParameter(string Paramenter, DbType type, object value)
     {
         SqlParameter par = new SqlParameter();
         par.ParameterName = Paramenter;
         par.DbType = type;
         par.Value = value;
         return par;
     }
     #endregion
 }

Create a connection in web config:

<connectionStrings>
         <add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\ListView.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>
     </connectionStrings>

Real Tech

Thursday, 20 June 2013

Complete List View:

Create two tables:

SQLCOMMON CLASS:

Create a connection in web config:

No comments:

Post a Comment