البته یه کم طولانیه
یک جای کدتون اصافی هست. کدتون رو بزارید.
<asp:DataList ID="DataList1" runat="server" DataKeyField="sid"
DataSourceID="SqlDataSource1">
<ItemTemplate>
<table class="style1">
<tr>
<td>
نام</td>
<td>
فامیل</td>
<td>
کدملی</td>
<td>
کدپرسنلی</td>
<td>
نام پدر</td>
<td>
نام دوره</td>
<td>
نوع دوره</td>
<td>
موسسه</td>
<td>
ناریخ شروع</td>
<td>
تاریخ پایان</td>
<td>
شماره مجوز</td>
<td>
تاریخ مجوز</td>
</tr>
<tr>
<td>
<asp:Label ID="Label1" runat="server" Text='<%# Eval("nam") %>'></asp:Label>
</td>
<td>
<asp:Label ID="Label2" runat="server" Text='<%# Eval("famil") %>'></asp:Label>
</td>
<td>
<asp:Label ID="Label3" runat="server" Text='<%# Eval("codemeli") %>'></asp:Label>
</td>
<td>
<asp:Label ID="Label4" runat="server" Text='<%# Eval("codepersoneli") %>'></asp:Label>
</td>
<td>
<asp:Label ID="Label5" runat="server" Text='<%# Eval("fathernam") %>'></asp:Label>
</td>
<td>
<asp:Label ID="Label6" runat="server" Text='<%# Eval("onam") %>'></asp:Label>
</td>
<td>
<asp:Label ID="Label7" runat="server" Text='<%# Eval("nnam") %>'></asp:Label>
</td>
<td>
<asp:Label ID="Label8" runat="server" Text='<%# Eval("mnam") %>'></asp:Label>
</td>
<td>
<asp:Label ID="Label9" runat="server" Text='<%# Eval("datastart") %>'></asp:Label>
</td>
<td>
<asp:Label ID="Label10" runat="server" Text='<%# Eval("dataend") %>'></asp:Label>
</td>
<td>
<asp:Label ID="Label11" runat="server" Text='<%# Eval("shomaremojavez") %>'></asp:Label>
</td>
<td>
<asp:Label ID="Label12" runat="server" Text='<%# Eval("dtamojavez") %>'></asp:Label>
</td>
<td>
</td>
<td>
</td>
<td>
</td>
</tr>
</table>
<br />
</ItemTemplate>
</asp:DataList>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:DatabaseConnectionString %>"
DeleteCommand="DELETE FROM [tsabtedoreh] WHERE [sid] = @sid"
InsertCommand="INSERT INTO [tsabtedoreh] ([nam], [famil], [codemeli], [codepersoneli], [semat], [oid], [nid], [mid], [shomaremojavez], [dtamojavez], [moaseseh], [datastart], [dataend], [modat], [nomreh], [fathernam]) VALUES (@nam, @famil, @codemeli, @codepersoneli, @semat, @oid, @nid, @mid, @shomaremojavez, @dtamojavez, @moaseseh, @datastart, @dataend, @modat, @nomreh, @fathernam)"
ProviderName="<%$ ConnectionStrings:DatabaseConnectionString.Provide rName %>" SelectCommand="SELECT tsabtedoreh.nam, tsabtedoreh.famil, tsabtedoreh.codemeli, tsabtedoreh.dataend, tsabtedoreh.codepersoneli, tsabtedoreh.semat, tsabtedoreh.nid,
tsabtedoreh.mid, tsabtedoreh.shomaremojavez, tsabtedoreh.datastart, tsabtedoreh.modat, tsabtedoreh.nomreh, tsabtedoreh.sid,
tsabtedoreh.nomreh, tsabtedoreh.fathernam, tmoaseseh.mnam , tnoe.nnam, tsabtedoreh.dtamojavez, tsabtedoreh.oid, tonvan.onam
FROM tmoaseseh INNER JOIN
tsabtedoreh ON tmoaseseh.mid = tsabtedoreh.mid INNER JOIN
tnoe ON tsabtedoreh.nid = tnoe.nid INNER JOIN
tonvan ON tsabtedoreh.oid = tonvan.oid
where codepersoneli=@cp"
UpdateCommand="UPDATE [tsabtedoreh] SET [nam] = @nam, [famil] = @famil, [codemeli] = @codemeli, [codepersoneli] = @codepersoneli, [semat] = @semat, [oid] = @oid, [nid] = @nid, [mid] = @mid, [shomaremojavez] = @shomaremojavez, [dtamojavez] = @dtamojavez, [moaseseh] = @moaseseh, [datastart] = @datastart, [dataend] = @dataend, [modat] = @modat, [nomreh] = @nomreh, [fathernam] = @fathernam WHERE [sid] = @sid">
<DeleteParameters>
<asp:Parameter Name="sid" Type="Int32" />
</DeleteParameters>
<InsertParameters>
<asp:Parameter Name="nam" Type="String" />
<asp:Parameter Name="famil" Type="String" />
<asp:Parameter Name="codemeli" Type="String" />
<asp:Parameter Name="codepersoneli" Type="String" />
<asp:Parameter Name="semat" Type="String" />
<asp:Parameter Name="oid" Type="Int32" />
<asp:Parameter Name="nid" Type="Int32" />
<asp:Parameter Name="mid" Type="Int32" />
<asp:Parameter Name="shomaremojavez" Type="String" />
<asp:Parameter Name="dtamojavez" Type="String" />
<asp:Parameter Name="moaseseh" Type="String" />
<asp:Parameter Name="datastart" Type="String" />
<asp:Parameter Name="dataend" Type="String" />
<asp:Parameter Name="modat" Type="Int16" />
<asp:Parameter Name="nomreh" Type="Int16" />
<asp:Parameter Name="fathernam" Type="String" />
</InsertParameters>
<SelectParameters>
<asp:QueryStringParameter Name="cp" QueryStringField="cp" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="nam" Type="String" />
<asp:Parameter Name="famil" Type="String" />
<asp:Parameter Name="codemeli" Type="String" />
<asp:Parameter Name="codepersoneli" Type="String" />
<asp:Parameter Name="semat" Type="String" />
<asp:Parameter Name="oid" Type="Int32" />
<asp:Parameter Name="nid" Type="Int32" />
<asp:Parameter Name="mid" Type="Int32" />
<asp:Parameter Name="shomaremojavez" Type="String" />
<asp:Parameter Name="dtamojavez" Type="String" />
<asp:Parameter Name="moaseseh" Type="String" />
<asp:Parameter Name="datastart" Type="String" />
<asp:Parameter Name="dataend" Type="String" />
<asp:Parameter Name="modat" Type="Int16" />
<asp:Parameter Name="nomreh" Type="Int16" />
<asp:Parameter Name="fathernam" Type="String" />
<asp:Parameter Name="sid" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>
</div>
</asp:Content>