با سلام و عرض خسته نباشید خدمت کلیه بزرگواران و عزیزان برنامه نویس
بنده قطعه کدی رو داشتم می نوشتم که به این ارور خوردم . ممنون میشم اگه کسی بتونه کمک کنه چون واقعا ارورشو متوجه نمیشم
کد sql
AS BEGIN SELECT ROW_NUMBER() OVER (ORDER BY F.RegDate DESC) AS RowIndex , CASE WHEN F.Id IS NULL THEN '' ELSE F.Id END AS FAQId , CASE WHEN F.Title IS NULL THEN '' ELSE F.Title END AS FAQTitle , CASE WHEN F.[Description] IS NULL THEN '' ELSE F.[Description] END AS FAQDescription , CASE WHEN F.ShortDescription IS NULL THEN '' ELSE F.ShortDescription END AS FAQShortDescription , CASE WHEN F.RegDate IS NULL THEN '' ELSE dbo.Christ2Shamsi(F.RegDate) END AS FAQRegPersianDate , CASE WHEN U.F_Name IS NULL AND U.L_Name IS NULL THEN '' ELSE CONCAT(U.F_Name , ' ' , U.L_Name ) END AS UserWirter FROM FAQ F JOIN Users U ON F.U_ID_Writer = U.U_Id END
کد html
<%@ Page Title="" Language="C#" MasterPageFile="~/Fa/SiteMasterPage.Master" AutoEventWireup="true" CodeBehind="FAQ.aspx.cs" Inherits="FaraSanaatProject.Fa.FAQ.FAQ" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
<form runat="server">
<div class="master-wrapper">
<!-- ========== -->
<!-- = Breadcrumbs = -->
<!-- ========== -->
<div class="darker-stripe">
<div class="container">
<div class="row">
<div class="span12">
<ul class="breadcrumb">
<li>
<a href="../../../../../../../../../../Fa/"> فراصنعت </a>
</li>
<li><span class="icon-chevron-left" style="font-size:10px;"> </span></li>
<li>
<a href="#"> سوالات متداول </a>
</li>
</ul>
</div>
</div>
</div>
</div>
<div class="container">
<div class="push-up top-equal blocks-spacer">
<div class="row">
<!-- ========== -->
<!-- = Main Title = -->
<!-- ========== -->
<div class="span12">
<div class="title-area">
<h1 class="inline"><span class="light">سخت افزار</span></h1>
<h2 class="inline tagline" style="font-style:normal;">- سوالات متداول در زمینه سخت افزار </h2>
</div>
</div>
<!-- ========== -->
<!-- = Main content = -->
<!-- ========== -->
<section class="span8 blog">
<!-- = Simple Post = -->
<!-- ========== -->
<asp:DataList ID="dListItems" runat="server" RepeatDirection="Vertical" RepeatColumns="2" DataKeyField="FAQCode" OnItemCommand="dListItems_ItemCommand" >
<ItemTemplate >
<article class="post format-standard">
<div class="post-inner">
<div class="post-title">
<h2><a href="#"><span class="light"> <%#Eval("FAQTitle") %> </span></a></h2>
<div class="metadata">
نوشته شده توسط : <%#Eval("UserWirter") %> /
<%#Eval("FAQRegPersianDate") %>
</div>
</div>
<p class="push-down-25"><%#Eval("FAQShortDescription") %></p>
<asp:LinkButton ID="LinkBtnDetails" runat="server" CssClass="btn btn-primary bold higher" CommandArgument='<%#Eval("RowIndex") %>' CommandName="btnDetails">ادامه مطلب</asp:LinkButton>
</div>
</article>
</ItemTemplate>
</asp:DataList>
<asp:PlaceHolder ID="PlaceHolder1" runat="server"></asp:PlaceHolder>
<hr />
<asp:Button ID="btnfirst" runat="server" Font-Bold="true" Text="<<" Height="31px"
Width="43px" onclick="btnfirst_Click" />
<asp:Button ID="btnprevious" runat="server" Font-Bold="true" Text="<" Height="31px"
Width="43px" onclick="btnprevious_Click" />
<asp:Button ID="btnnext" runat="server" Font-Bold="true" Text=">" Height="31px"
Width="43px" onclick="btnnext_Click" />
<asp:Button ID="btnlast" runat="server" Font-Bold="true" Text=">>" Height="31px"
Width="43px" onclick="btnlast_Click" />
<div class="pagination">
<ul>
<li><a href="#" class="btn btn-primary"><span class="icon-chevron-left"></span></a></li>
<li><a href="#">1</a></li>
<li class="active"><a href="#">2</a></li>
<li><a href="#">3</a></li>
<li><a href="#">4</a></li>
<li><a href="#">5</a></li>
<li><a href="#" class="btn btn-primary"><span class="icon-chevron-right"></span></a></li>
</ul>
</div> <!-- /pagination -->
</section> <!-- /main content -->
<!-- ========== -->
<!-- = Sidebar = -->
<!-- ========== -->
<aside class="span4 right-sidebar">
<!-- ========== -->
<!-- = Search Widget = -->
<!-- ========== -->
<div class="sidebar-item widget_search">
<!-- <div class="underlined">
<h3><span class="light">Search</span></h3>
</div> -->
<form class="form" action="#" id="searchform" method="get" role="search">
<input type="text" id="appendedInputButton" class="input-block-level" name="s" placeholder=" جستجو در سوالات .... " />
<button type="submit">
<i class="icon-search"></i>
</button>
</form>
</div>
</aside> <!-- /sidebar -->
</div>
</div>
</div> <!-- /container -->
</div> <!-- end of master-wrapper -->
</form>
</asp:Content>
کد C#
using System;
using System.Collections.Generic;
using System.Collections.Specialized;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace FaraSanaatProject.Fa.FAQ
{
public partial class FAQ : System.Web.UI.Page
{
DataSet Dset;
static PagedDataSource AdSource;
int Pos;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.ViewState["vs"] = 0;
}
Pos = (int)this.ViewState["vs"];
_dataBind();
}
public void _dataBind()
{
try
{
AdSource = new PagedDataSource();
AppCode.SQLConnection SQL_Read = new AppCode.SQLConnection();
NameValueCollection NVC_Read = new NameValueCollection();
DataSet ds = new DataSet();
AppCode.SQLConnection._DBReaderWithDataSetWithStoreProcedure("sp_DefaultPage_get8NewestProducts", NVC_Read, ref ds);
if (ds.Tables.Count == 0 || ds.Tables.Count < 0)
{
//DivMesseage.InnerHtml = AppCode.Functions._ShowMessage(" توجه ", " هیچ اطلاعاتی یافت نشد ");
//RunMesseageBox();
return;
}
else
{
if (ds.Tables[0].Rows.Count > 0)
{
AdSource.DataSource = ds.Tables[0].DefaultView;
AdSource.PageSize = 1;
AdSource.AllowPaging = true;
AdSource.CurrentPageIndex = Pos;
btnfirst.Enabled = !AdSource.IsFirstPage;
btnprevious.Enabled = !AdSource.IsFirstPage;
btnlast.Enabled = !AdSource.IsLastPage;
btnnext.Enabled = !AdSource.IsLastPage;
dListItems.DataSource = AdSource;
dListItems.DataBind();
//dListItems.DataSource = ds.Tables[0];
//dListItems.DataBind();
}
else
{
dListItems.DataSource = ds.Tables[""];
dListItems.DataBind();
// Divmsg.InnerHtml = AppCode.Function._ShowMessage("توجه", AppCode.Message._DivWarning("هیچ اطلاعاتی یافت نشد"));
return;
}
}
}
catch (Exception ex)
{
//AppCode.Function._RunJavaScript("alert('خطا 001 :" + ex.Message + "')");
//return;
}
}
protected void btnfirst_Click(object sender, EventArgs e)
{
Pos = 0;
_dataBind();
}
protected void btnprevious_Click(object sender, EventArgs e)
{
Pos = (int)this.ViewState["vs"];
Pos -= 1;
this.ViewState["vs"] = Pos;
_dataBind();
}
protected void btnnext_Click(object sender, EventArgs e)
{
Pos = (int)this.ViewState["vs"];
Pos += 1;
this.ViewState["vs"] = Pos;
_dataBind();
}
protected void btnlast_Click(object sender, EventArgs e)
{
Pos = AdSource.PageCount - 1;
_dataBind();
}
protected void dListItems_ItemCommand(object source, DataListCommandEventArgs e)
{
}
}
}
مبگه همچین فیلدی ندارم یا پیدا نمیکنن
FAQId
هیچ کاربری تا کنون از این پست تشکر نکرده است
با ما تماس بگیرید تا در این مسیر همراهتان باشیم :)
