控件SqlDataSource與FormViw應(yīng)用之在插入模板添加控件DropDwonList并保存記錄實例
SelectCommand="SELECT [CompanyID], [Company] FROM [tblCompany]">
DataKeyNames="CompanyID" DataSourceID="SqlDataSource1">
InsertVisible="False" ReadOnly="True" SortExpression="CompanyID" />
SortExpression="Company" />
ConnectionString="<%$ ConnectionStrings:HRM_DATAConnectionString %>"
InsertCommand="INSERT INTO tblDepart(Depart, CompanyID) VALUES (@Depart,@CompanyID)"
SelectCommand="SELECT tblDepart.DepartID, tblDepart.Depart, tblCompany.Company, tblDepart.CompanyID FROM tblDepart INNER JOIN tblCompany ON tblDepart.CompanyID = tblCompany.CompanyID WHERE (tblCompany.CompanyID = @Companyid)">
PropertyName="SelectedValue" />
BackColor="White" BorderColor="#CC9966" BorderStyle="None" BorderWidth="1px"
CellPadding="4" DataKeyNames="DepartID" DataSourceID="SqlDataSource2"
GridLines="Both" Height="125px" Width="566px">
DepartID:
Depart:
Company:
CommandName="Update" Text="更新" />
CausesValidation="False" CommandName="Cancel" Text="取消" />
Depart:
Company:
DataSourceID="SqlDataSource1" DataTextField="Company"
DataValueField="CompanyID" SelectedValue='<%# Bind("CompanyID") %>'>
CommandName="Insert" Text="插入" />
CausesValidation="False" CommandName="Cancel" Text="取消" />
DepartID:
Depart:
Company:
New
重慶分公司
重慶分公司
