我想用GridView加上一个button 按下button之後会抓该行资料以及一个DropDownList的值 存进另一个资料表 做是做出来了 按下新增都没进到资料库 但也没有错误讯息 请问一下哪里出了问题QQ DropDwonList的部份 <asp:DropDownList ID="Role" runat="server" DataSourceID="SqlDataSource1" DataTextField="Role_Title" DataValueField="Role_Title" OnSelectedIndexChanged="Role_SelectedIndexChanged"> </asp:DropDownList> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:workConnectionString %>" SelectCommand="SELECT [Role_Title] FROM [Role]"> </asp:SqlDataSource> GridView的部份 <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="3" DataKeyNames="num,id,name" DataSourceID="SqlDataSource2" OnSelectedIndexChanged="GridView1_SelectedIndexChanged" AllowPaging="True" BackColor="White" BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px"> <FooterStyle BackColor="White" ForeColor="#000066" /> <Columns> <asp:BoundField DataField="num" HeaderText="编号" InsertVisible="False" ReadOnly="True"SortExpression="num" /> <asp:BoundField DataField="id" HeaderText="帐号" SortExpression="id" /> <asp:BoundField DataField="name" HeaderText="姓名" SortExpression="name" /> <asp:ButtonField ButtonType="Button" Text="新增" /> </Columns> <RowStyle ForeColor="#000066" /> <SelectedRowStyle BackColor="#669999" Font-Bold="True" ForeColor="White" /> <PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" /> <HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" /> </asp:GridView> <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:workConnectionString %>" SelectCommand="SELECT [num], [id], [name], [project], [user_group] FROM [work_user]" OnSelecting="SqlDataSource2_Selecting" InsertCommand="INSERT INTO Assignment(Project_number, Account, Name, Role_Title) VALUES (@num, @id, @name, @Role_Title)"> <InsertParameters> <asp:ControlParameter ControlID="GridView1" Name="num" PropertyName="SelectedValue" /> <asp:ControlParameter ControlID="GridView1" Name="id" PropertyName="SelectedValue" /> <asp:ControlParameter ControlID="GridView1" Name="name" PropertyName="SelectedValue" /> <asp:ControlParameter ControlID="Role" Name="Role_Title" PropertyName="SelectedValue" /> </InsertParameters> </asp:SqlDataSource> 按下新增没有错误讯息 但是也没进资料库= = 另外有写一个删除的 但是就可以Work (但是不用抓DropDownList，直接删除) 恳请大大帮个忙QQ 这几天计画案赶进度啊QQ InsertCommand的Role_Title是要抓DropDownList的值 其他Account等等是要直接抓GridView1的值 -- ▏▎▍▌▋▊▉ 一个人或许会孤单...▉▊▋▌▍▎▏ ▏▎▍▌▋▊▉ 爱上一个人却让你更寂寞...▉▊▋▌▍▎▏ http://www.wretch.cc/album/Tony427 --

※ 发信站: 批踢踢实业坊(ptt.cc) ◆ From: 163.25.118.177 ※ 编辑: Tony427 来自: 163.25.118.177 (07/02 02:16)