Dear all,
The below one is my gridview,
below are my requirements..
at the time of page load based on my columns i have to visible the columns, its working fine.
some times columns are 7 and some times columns are 8 and some times columns are 9.. etc..
so based on columns i want show autocomplete extender for specific column only,
means if i have 7 columns then i want to show autocomplete in 6 and 7 columns remain 1 to 5 columns are manual entry.
if i have 8 columns then i want to show autocomplete in 7 and 8 columns remain 1 to 6 columns are manual entry.
if i have 5 columns then i want to show autocomplete in 4 and 5 columns remain 1 to 3 columns are manual entry.
if i have 3 columns then i want to show autocomplete in 2 and 3 columns remain 1 column is manual entry.
if i have 12 columns then i want to show autocomplete in 11 and 12 columns remain 1 to 10 columns are manual entry.
so, how to i achieve this requirement or else any other solution there then tell me.
i have a gridview below like,
<asp:GridView ID="GvData1" runat="server" AutoGenerateColumns="false" ShowHeader="false" Width="1150px" GridLines="Vertical">
<Columns>
<asp:TemplateField HeaderText="Column1">
<ItemTemplate>
<asp:TextBox runat="server" ID="Section_Column1" Text='<%# Eval("Section_Column1") %>' CssClass="MultyLnTxtBox" TextMode="MultiLine" />
<asp:AutoCompleteExtender ID="ACE1" runat="server" ServiceMethod="DispUsrIds" MinimumPrefixLength="0" ServicePath="~/Autocomplete.asmx"
EnableCaching="false" TargetControlID="Section_Column1" CompletionListCssClass="autocomplete_completionListElement"
CompletionListItemCssClass="autocomplete_listItem" CompletionListHighlightedItemCssClass="autocomplete_highlightedListItem">
</asp:AutoCompleteExtender>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Column2">
<ItemTemplate>
<asp:TextBox runat="server" ID="Section_Column2" Text='<%# Eval("Section_Column2") %>' CssClass="MultyLnTxtBox" TextMode="MultiLine" />
<asp:AutoCompleteExtender ID="ACE2" runat="server" ServiceMethod="DispUsrIds" MinimumPrefixLength="0" ServicePath="~/Autocomplete.asmx"
EnableCaching="false" TargetControlID="Section_Column2" CompletionListCssClass="autocomplete_completionListElement"
CompletionListItemCssClass="autocomplete_listItem" CompletionListHighlightedItemCssClass="autocomplete_highlightedListItem">
</asp:AutoCompleteExtender>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Column3">
<ItemTemplate>
<asp:TextBox runat="server" ID="Section_Column3" Text='<%# Eval("Section_Column3") %>' CssClass="MultyLnTxtBox" TextMode="MultiLine" />
<asp:AutoCompleteExtender ID="ACE3" runat="server" ServiceMethod="DispUsrIds" MinimumPrefixLength="0" ServicePath="~/Autocomplete.asmx"
EnableCaching="false" TargetControlID="Section_Column3" CompletionListCssClass="autocomplete_completionListElement"
CompletionListItemCssClass="autocomplete_listItem" CompletionListHighlightedItemCssClass="autocomplete_highlightedListItem">
</asp:AutoCompleteExtender>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Column4">
<ItemTemplate>
<asp:TextBox runat="server" ID="Section_Column4" Text='<%# Eval("Section_Column4") %>' CssClass="MultyLnTxtBox" TextMode="MultiLine" />
<asp:AutoCompleteExtender ID="ACE4" runat="server" ServiceMethod="DispUsrIds" MinimumPrefixLength="0" ServicePath="~/Autocomplete.asmx"
EnableCaching="false" TargetControlID="Section_Column4" CompletionListCssClass="autocomplete_completionListElement"
CompletionListItemCssClass="autocomplete_listItem" CompletionListHighlightedItemCssClass="autocomplete_highlightedListItem">
</asp:AutoCompleteExtender>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Column5">
<ItemTemplate>
<asp:TextBox runat="server" ID="Section_Column5" Text='<%# Eval("Section_Column5") %>' CssClass="MultyLnTxtBox" TextMode="MultiLine" />
<asp:AutoCompleteExtender ID="ACE5" runat="server" ServiceMethod="DispUsrIds" MinimumPrefixLength="0" ServicePath="~/Autocomplete.asmx"
EnableCaching="false" TargetControlID="Section_Column5" CompletionListCssClass="autocomplete_completionListElement"
CompletionListItemCssClass="autocomplete_listItem" CompletionListHighlightedItemCssClass="autocomplete_highlightedListItem">
</asp:AutoCompleteExtender>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Column6">
<ItemTemplate>
<asp:TextBox runat="server" ID="Section_Column6" Text='<%# Eval("Section_Column6") %>' CssClass="MultyLnTxtBox" TextMode="MultiLine" />
<asp:AutoCompleteExtender ID="ACE14" runat="server" ServiceMethod="DispUsrIds" MinimumPrefixLength="0" ServicePath="~/Autocomplete.asmx"
EnableCaching="false" TargetControlID="Section_Column6" CompletionListCssClass="autocomplete_completionListElement"
CompletionListItemCssClass="autocomplete_listItem" CompletionListHighlightedItemCssClass="autocomplete_highlightedListItem">
</asp:AutoCompleteExtender>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Column7">
<ItemTemplate>
<asp:TextBox runat="server" ID="Section_Column7" Text='<%# Eval("Section_Column7") %>' CssClass="MultyLnTxtBox" TextMode="MultiLine" />
<asp:AutoCompleteExtender ID="ACE7" runat="server" ServiceMethod="DispUsrIds" MinimumPrefixLength="0" ServicePath="~/Autocomplete.asmx"
EnableCaching="false" TargetControlID="Section_Column7" CompletionListCssClass="autocomplete_completionListElement"
CompletionListItemCssClass="autocomplete_listItem" CompletionListHighlightedItemCssClass="autocomplete_highlightedListItem">
</asp:AutoCompleteExtender>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Column8">
<ItemTemplate>
<asp:TextBox runat="server" ID="Section_Column8" Text='<%# Eval("Section_Column8") %>' CssClass="MultyLnTxtBox" TextMode="MultiLine" />
<asp:AutoCompleteExtender ID="ACE8" runat="server" ServiceMethod="DispUsrIds" MinimumPrefixLength="0" ServicePath="~/Autocomplete.asmx"
EnableCaching="false" TargetControlID="Section_Column8" CompletionListCssClass="autocomplete_completionListElement"
CompletionListItemCssClass="autocomplete_listItem" CompletionListHighlightedItemCssClass="autocomplete_highlightedListItem">
</asp:AutoCompleteExtender>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Column9">
<ItemTemplate>
<asp:TextBox runat="server" ID="Section_Column9" Text='<%# Eval("Section_Column9") %>' CssClass="MultyLnTxtBox" TextMode="MultiLine" />
<asp:AutoCompleteExtender ID="ACE9" runat="server" ServiceMethod="DispUsrIds" MinimumPrefixLength="0" ServicePath="~/Autocomplete.asmx"
EnableCaching="false" TargetControlID="Section_Column9" CompletionListCssClass="autocomplete_completionListElement"
CompletionListItemCssClass="autocomplete_listItem" CompletionListHighlightedItemCssClass="autocomplete_highlightedListItem">
</asp:AutoCompleteExtender>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Column10">
<ItemTemplate>
<asp:TextBox runat="server" ID="Section_Column10" Text='<%# Eval("Section_Column10") %>' CssClass="MultyLnTxtBox" TextMode="MultiLine" />
<asp:AutoCompleteExtender ID="ACE10" runat="server" ServiceMethod="DispUsrIds" MinimumPrefixLength="0" ServicePath="~/Autocomplete.asmx"
EnableCaching="false" TargetControlID="Section_Column10" CompletionListCssClass="autocomplete_completionListElement"
CompletionListItemCssClass="autocomplete_listItem" CompletionListHighlightedItemCssClass="autocomplete_highlightedListItem">
</asp:AutoCompleteExtender>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Column11">
<ItemTemplate>
<asp:TextBox runat="server" ID="Section_Column11" Text='<%# Eval("Section_Column11") %>' CssClass="MultyLnTxtBox" TextMode="MultiLine" />
<asp:AutoCompleteExtender ID="ACE11" runat="server" ServiceMethod="DispUsrIds" MinimumPrefixLength="0" ServicePath="~/Autocomplete.asmx"
EnableCaching="false" TargetControlID="Section_Column11" CompletionListCssClass="autocomplete_completionListElement"
CompletionListItemCssClass="autocomplete_listItem" CompletionListHighlightedItemCssClass="autocomplete_highlightedListItem">
</asp:AutoCompleteExtender>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Column12">
<ItemTemplate>
<asp:TextBox runat="server" ID="Section_Column12" Text='<%# Eval("Section_Column12") %>' CssClass="MultyLnTxtBox" TextMode="MultiLine" />
<asp:AutoCompleteExtender ID="ACE12" runat="server" ServiceMethod="DispUsrIds" MinimumPrefixLength="0" ServicePath="~/Autocomplete.asmx"
EnableCaching="false" TargetControlID="Section_Column12" CompletionListCssClass="autocomplete_completionListElement"
CompletionListItemCssClass="autocomplete_listItem" CompletionListHighlightedItemCssClass="autocomplete_highlightedListItem">
</asp:AutoCompleteExtender>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Column13">
<ItemTemplate>
<asp:TextBox runat="server" ID="Section_Column13" Text='<%# Eval("Section_Column13") %>' CssClass="MultyLnTxtBox" TextMode="MultiLine" />
<asp:AutoCompleteExtender ID="ACE13" runat="server" ServiceMethod="DispUsrIds" MinimumPrefixLength="0" ServicePath="~/Autocomplete.asmx"
EnableCaching="false" TargetControlID="Section_Column13" CompletionListCssClass="autocomplete_completionListElement"
CompletionListItemCssClass="autocomplete_listItem" CompletionListHighlightedItemCssClass="autocomplete_highlightedListItem">
</asp:AutoCompleteExtender>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Column14">
<ItemTemplate>
<asp:TextBox runat="server" ID="Section_Column14" Text='<%# Eval("Section_Column14") %>' CssClass="MultyLnTxtBox" TextMode="MultiLine" />
<asp:AutoCompleteExtender ID="ACE14" runat="server" ServiceMethod="DispUsrIds" MinimumPrefixLength="0" ServicePath="~/Autocomplete.asmx"
EnableCaching="false" TargetControlID="Section_Column14" CompletionListCssClass="autocomplete_completionListElement"
CompletionListItemCssClass="autocomplete_listItem" CompletionListHighlightedItemCssClass="autocomplete_highlightedListItem">
</asp:AutoCompleteExtender>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="Data_Key" ItemStyle-HorizontalAlign="Left" HeaderStyle-HorizontalAlign="Left" ItemStyle-CssClass="hiddencol" HeaderStyle-CssClass="hiddencol" />
</Columns>
</asp:GridView>
protected void GvData1_DataBound(object sender, EventArgs e)
{
bool isColumn1Null = false, isColumn2Null = false, isColumn3Null = false, isColumn4Null = false, isColumn5Null = false;
bool isColumn6Null = false, isColumn7Null = false, isColumn8Null = false, isColumn9Null = false, isColumn10Null = false;
bool isColumn11Null = false, isColumn12Null = false, isColumn13Null = false, isColumn14Null = false;
for (int i = 0; i < GvData1.Rows.Count; i++)
{
if (!isColumn1Null) { isColumn1Null = (GvData1.Rows[i].FindControl("Section_Column1") as TextBox).Text == "NODATA" ? false : true; }
if (!isColumn2Null) { isColumn2Null = (GvData1.Rows[i].FindControl("Section_Column2") as TextBox).Text == "NODATA" ? false : true; }
if (!isColumn3Null) { isColumn3Null = (GvData1.Rows[i].FindControl("Section_Column3") as TextBox).Text == "NODATA" ? false : true; }
if (!isColumn4Null) { isColumn4Null = (GvData1.Rows[i].FindControl("Section_Column4") as TextBox).Text == "NODATA" ? false : true; }
if (!isColumn5Null) { isColumn5Null = (GvData1.Rows[i].FindControl("Section_Column5") as TextBox).Text == "NODATA" ? false : true; }
if (!isColumn6Null) { isColumn6Null = (GvData1.Rows[i].FindControl("Section_Column6") as TextBox).Text == "NODATA" ? false : true; }
if (!isColumn7Null) { isColumn7Null = (GvData1.Rows[i].FindControl("Section_Column7") as TextBox).Text == "NODATA" ? false : true; }
if (!isColumn8Null) { isColumn8Null = (GvData1.Rows[i].FindControl("Section_Column8") as TextBox).Text == "NODATA" ? false : true; }
if (!isColumn9Null) { isColumn9Null = (GvData1.Rows[i].FindControl("Section_Column9") as TextBox).Text == "NODATA" ? false : true; }
if (!isColumn10Null) { isColumn10Null = (GvData1.Rows[i].FindControl("Section_Column10") as TextBox).Text == "NODATA" ? false : true; }
if (!isColumn11Null) { isColumn11Null = (GvData1.Rows[i].FindControl("Section_Column11") as TextBox).Text == "NODATA" ? false : true; }
if (!isColumn12Null) { isColumn12Null = (GvData1.Rows[i].FindControl("Section_Column12") as TextBox).Text == "NODATA" ? false : true; }
if (!isColumn13Null) { isColumn13Null = (GvData1.Rows[i].FindControl("Section_Column13") as TextBox).Text == "NODATA" ? false : true; }
if (!isColumn14Null) { isColumn14Null = (GvData1.Rows[i].FindControl("Section_Column14") as TextBox).Text == "NODATA" ? false : true; }
}
if (!isColumn1Null) { GvData1.Columns[0].Visible = false; }
if (!isColumn2Null) { GvData1.Columns[1].Visible = false; }
if (!isColumn3Null) { GvData1.Columns[2].Visible = false; }
if (!isColumn4Null) { GvData1.Columns[3].Visible = false; }
if (!isColumn5Null) { GvData1.Columns[4].Visible = false; }
if (!isColumn6Null) { GvData1.Columns[5].Visible = false; }
if (!isColumn7Null) { GvData1.Columns[6].Visible = false; }
if (!isColumn8Null) { GvData1.Columns[7].Visible = false; }
if (!isColumn9Null) { GvData1.Columns[8].Visible = false; }
if (!isColumn10Null) { GvData1.Columns[9].Visible = false; }
if (!isColumn11Null) { GvData1.Columns[10].Visible = false; }
if (!isColumn12Null) { GvData1.Columns[11].Visible = false; }
if (!isColumn13Null) { GvData1.Columns[12].Visible = false; }
if (!isColumn14Null) { GvData1.Columns[13].Visible = false; }
}
please help me..
Thanks in advance
