<asp:ObjectDataSource ID="ObjectDataSource1" runat="server" OldValuesParameterFormatString="original_{0}" SelectMethod="getrateGridInfo_TEST" UpdateMethod="getrateGridInfo_TESTEDIT" TypeName="BAL.rate_Viever" > <SelectParameters> <asp:ControlParameter ControlID="DropDownLis_rateCode" Name="rateCode" PropertyName="SelectedValue" Type="String" /> </SelectParameters> <UpdateParameters> <asp:ControlParameter ControlID="Lbl_sq" Name="sq" PropertyName="Text" Type="String" /> <asp:ControlParameter ControlID="txtRate" Name="rate" PropertyName="Text" Type="String" /> </UpdateParameters> </asp:ObjectDataSource>
public DataTable getrateGridInfo_TEST(String rateCode) { string sql = "SELECT [minWeight],[maxWeight],[rate],[sq] FROM tblRateDetails WHERE rateCode='" + rateCode + "' order by minWeight"; DataTable dt = SQLTrans.executeQuery(sql, "tbl"); return dt; } public Void getrateGridInfo_TESTEDIT(String sq,String rate) { string sql = "UPDATE tblRateDetails SET rate = '" + rate + "' WHERE sq = '"+sq+"' "; DataTable dt = SQLTrans.executeQuery(sql, "tbl"); //return dt; }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)