boysilent
یک شنبه 09 مهر 1391, 20:52 عصر
سلام دوستان من میخوام چند تا فیلد اپدیت بشه دستورات رو نوشتم ویرایش که میزنی همهچی درسته بعدش اپدیت رو که میزنی مقدار رو تغییر نمیده ؟؟؟بنظرتون خطاش از چیه؟؟؟
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" Width="543px"
CellPadding="4" ForeColor="#333333" GridLines="None">
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
<Columns>
<asp:BoundField DataField="id" HeaderText="id" ReadOnly="True"
SortExpression="id" InsertVisible="False" />
<asp:BoundField DataField="fathername" HeaderText="fathername"
SortExpression="fathername" ReadOnly="True" />
<asp:BoundField DataField="kodemeli" HeaderText="kodemeli"
SortExpression="kodemeli" />
<asp:BoundField DataField="fathermeli" HeaderText="fathermeli"
SortExpression="fathermeli" />
<asp:CommandField ShowEditButton="True" />
</Columns>
<EditRowStyle BackColor="#999999" />
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
<SortedAscendingCellStyle BackColor="#E9E7E2" />
<SortedAscendingHeaderStyle BackColor="#506C8C" />
<SortedDescendingCellStyle BackColor="#FFFDF8" />
<SortedDescendingHeaderStyle BackColor="#6F8DAE" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:schoolConnectionString %>"
SelectCommand="SELECT [id], [fathername], [kodemeli], [fathermeli] FROM [newstudent]" UpdateCommand="UPDATE newstudent SET kodemeli = @kodemeli,fathermeli=@fathermeli WHERE id = @id">
<UpdateParameters>
<asp:Parameter Name="id" DbType="Int32" />
<asp:Parameter Name="fathername" DbType="String" />
<asp:Parameter Name="fathermeli" DbType="Int32" />
<asp:Parameter Name="Kodemeli" DbType="Int32" />
</UpdateParameters>
</asp:SqlDataSource>
<br />
</div>
</div>
</div>
</div>
<br />
</div>
</form>
<p>
<img alt="" src="../../../../Desktop/closeBtn.png" style="width: 27px; height: 28px" /></p>
</body>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" Width="543px"
CellPadding="4" ForeColor="#333333" GridLines="None">
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
<Columns>
<asp:BoundField DataField="id" HeaderText="id" ReadOnly="True"
SortExpression="id" InsertVisible="False" />
<asp:BoundField DataField="fathername" HeaderText="fathername"
SortExpression="fathername" ReadOnly="True" />
<asp:BoundField DataField="kodemeli" HeaderText="kodemeli"
SortExpression="kodemeli" />
<asp:BoundField DataField="fathermeli" HeaderText="fathermeli"
SortExpression="fathermeli" />
<asp:CommandField ShowEditButton="True" />
</Columns>
<EditRowStyle BackColor="#999999" />
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
<SortedAscendingCellStyle BackColor="#E9E7E2" />
<SortedAscendingHeaderStyle BackColor="#506C8C" />
<SortedDescendingCellStyle BackColor="#FFFDF8" />
<SortedDescendingHeaderStyle BackColor="#6F8DAE" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:schoolConnectionString %>"
SelectCommand="SELECT [id], [fathername], [kodemeli], [fathermeli] FROM [newstudent]" UpdateCommand="UPDATE newstudent SET kodemeli = @kodemeli,fathermeli=@fathermeli WHERE id = @id">
<UpdateParameters>
<asp:Parameter Name="id" DbType="Int32" />
<asp:Parameter Name="fathername" DbType="String" />
<asp:Parameter Name="fathermeli" DbType="Int32" />
<asp:Parameter Name="Kodemeli" DbType="Int32" />
</UpdateParameters>
</asp:SqlDataSource>
<br />
</div>
</div>
</div>
</div>
<br />
</div>
</form>
<p>
<img alt="" src="../../../../Desktop/closeBtn.png" style="width: 27px; height: 28px" /></p>
</body>