IIS 7 มีปัญหาใครก็ได้ช่วยดูด้วยค๊าบ HTTP Error 500.23 - Internal Server Error. An ASP.NET setting has been detected that does not apply in Integrated managed pipe
Code (Web.Config)
<system.webServer>
<validation validateIntegratedModeConfiguration="false" />
</system.webServer>
Date :
2012-03-20 08:41:07
By :
webmaster
แก้ที่ Web.Config แร้ว...มันก็เป็นแบบนี้อ่ะ ครับ
Date :
2012-03-20 09:11:59
By :
mewinsiam
เอา Code ตรง Connect มาดูครับ
Date :
2012-03-20 10:09:36
By :
webmaster
แบบไหนครับ..ผมไม่รุ้จักก
Date :
2012-03-20 13:32:23
By :
mewinsiam
เอา Code หน่้านั้นมาทั้งหมดก็ได้ครับ
Date :
2012-03-20 14:21:57
By :
webmaster
Code (VB.NET)
<%@ Page Title="" Language="C#" MasterPageFile="~/Site.Master" AutoEventWireup="true" CodeBehind="Competition.aspx.cs" Inherits="GolfScore.Competition" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
<style type="text/css">
.style1
{
width: 100%;
height: 224px;
}
.style2
{
width: 100%;
}
</style>
</asp:Content>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="SELECT * FROM [Competition]"
DeleteCommand="DELETE FROM [Competition] WHERE [ID] = @ID"
InsertCommand="INSERT INTO [Competition] ([ListName], [Ground], [District], [Province], [Tel], [Date], [P1], [P2], [P3], [P4], [P5], [P6], [P7], [P8], [P9], [P10], [P11], [P12], [P13], [P14], [P15], [P16], [P17], [P18], [Com]) VALUES (@ListName, @Ground, @District, @Province, @Tel, @Date, @P1, @P2, @P3, @P4, @P5, @P6, @P7, @P8, @P9, @P10, @P11, @P12, @P13, @P14, @P15, @P16, @P17, @P18, @Com)"
UpdateCommand="UPDATE [Competition] SET [ListName] = @ListName, [Ground] = @Ground, [District] = @District, [Province] = @Province, [Tel] = @Tel, [Date] = @Date, [P1] = @P1, [P2] = @P2, [P3] = @P3, [P4] = @P4, [P5] = @P5, [P6] = @P6, [P7] = @P7, [P8] = @P8, [P9] = @P9, [P10] = @P10, [P11] = @P11, [P12] = @P12, [P13] = @P13, [P14] = @P14, [P15] = @P15, [P16] = @P16, [P17] = @P17, [P18] = @P18, [Com] = @Com WHERE [ID] = @ID">
<DeleteParameters>
<asp:Parameter Name="ID" Type="Decimal" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="ListName" Type="String" />
<asp:Parameter Name="Ground" Type="String" />
<asp:Parameter Name="District" Type="String" />
<asp:Parameter Name="Province" Type="String" />
<asp:Parameter Name="Tel" Type="String" />
<asp:Parameter DbType="Date" Name="Date" />
<asp:Parameter Name="P1" Type="Decimal" />
<asp:Parameter Name="P2" Type="Decimal" />
<asp:Parameter Name="P3" Type="Decimal" />
<asp:Parameter Name="P4" Type="Decimal" />
<asp:Parameter Name="P5" Type="Decimal" />
<asp:Parameter Name="P6" Type="Decimal" />
<asp:Parameter Name="P7" Type="Decimal" />
<asp:Parameter Name="P8" Type="Decimal" />
<asp:Parameter Name="P9" Type="Decimal" />
<asp:Parameter Name="P10" Type="Decimal" />
<asp:Parameter Name="P11" Type="Decimal" />
<asp:Parameter Name="P12" Type="Decimal" />
<asp:Parameter Name="P13" Type="Decimal" />
<asp:Parameter Name="P14" Type="Decimal" />
<asp:Parameter Name="P15" Type="Decimal" />
<asp:Parameter Name="P16" Type="Decimal" />
<asp:Parameter Name="P17" Type="Decimal" />
<asp:Parameter Name="P18" Type="Decimal" />
<asp:Parameter Name="Com" Type="String" />
</InsertParameters>
<UpdateParameters>
<asp:Parameter Name="ListName" Type="String" />
<asp:Parameter Name="Ground" Type="String" />
<asp:Parameter Name="District" Type="String" />
<asp:Parameter Name="Province" Type="String" />
<asp:Parameter Name="Tel" Type="String" />
<asp:Parameter DbType="Date" Name="Date" />
<asp:Parameter Name="P1" Type="Decimal" />
<asp:Parameter Name="P2" Type="Decimal" />
<asp:Parameter Name="P3" Type="Decimal" />
<asp:Parameter Name="P4" Type="Decimal" />
<asp:Parameter Name="P5" Type="Decimal" />
<asp:Parameter Name="P6" Type="Decimal" />
<asp:Parameter Name="P7" Type="Decimal" />
<asp:Parameter Name="P8" Type="Decimal" />
<asp:Parameter Name="P9" Type="Decimal" />
<asp:Parameter Name="P10" Type="Decimal" />
<asp:Parameter Name="P11" Type="Decimal" />
<asp:Parameter Name="P12" Type="Decimal" />
<asp:Parameter Name="P13" Type="Decimal" />
<asp:Parameter Name="P14" Type="Decimal" />
<asp:Parameter Name="P15" Type="Decimal" />
<asp:Parameter Name="P16" Type="Decimal" />
<asp:Parameter Name="P17" Type="Decimal" />
<asp:Parameter Name="P18" Type="Decimal" />
<asp:Parameter Name="Com" Type="String" />
<asp:Parameter Name="ID" Type="Decimal" />
</UpdateParameters>
</asp:SqlDataSource>
</p>
</asp:Content>
Date :
2012-03-20 14:26:02
By :
mewinsiam
ดูตรง Web config. ว่า connectionstring มีค่าเท่าไร ตรงกับ sql ที่เราต้องการคุยหรือไม่
Date :
2012-08-28 13:25:16
By :
pom
เอา ConnectionStrings:ConnectionString มาดูครับ
Date :
2012-08-28 21:29:17
By :
mr.win
Load balance : Server 00