我想在下拉列表中选定索引更改的下拉列表中选择的项目中，在gridview中显示该项目

问题描述

在第两个或更多列中放置了hv drpdwnlst...当我选择任何列名时，相关数据将显示在网格视图中.t .......... thanxxx advance

i hv drpdwnlst.in lst two or more colum is placed..when i select any column name then the related data is shown in grid view..
t..........thanxxx an advance

推荐答案

CREATE PROCEDURE selectDataByDDLValue(@ddlValue INTEGER)
AS
IF @ddlValue == 1
BEGIN
-- Query3 to execute
END
ELSE
BEGIN
  IF @ddlValue == 2
  BEGIN
  -- Query2 to execute
  END
  ELSE
  BEGIN
  -- Query3 to execute
  END
END
GO

希望您能想到.

Hope you got the idea.

CREATE PROCEDURE selectDataByDDLValue(@ddlValue INTEGER)
AS
IF @ddlValue == 1
BEGIN
-- Query3 to execute
END
ELSE
BEGIN
  IF @ddlValue == 2
  BEGIN
  -- Query2 to execute
  END
  ELSE
  BEGIN
  -- Query3 to execute
  END
END
GO

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
  {
// get selected value of dropdown.
      int intValue= int.Parse(ddlCompany.SelectedValue.ToString());
// call function for displaying records in grid according to dropdown value 
      fnShowDetails(intValue);
  }

protected void fnShowDetails(int intReference)
  {
       // here u should send value(intReference) to database for getting record and bind the grid with returning  datatable or dataset .
  }

希望这对你有帮助.
谢谢

Hope this will help u.
Thanks

这篇关于我想在下拉列表中选定索引更改的下拉列表中选择的项目中，在gridview中显示该项目的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！