How to start increment a column(Sl.No) value in grid by giving input from Textbox?

Question

0.00/5 (No votes)

See more:

How to start increment a column(Sl.No) value of gridview by giving user input from Textbox & auto Increment it based on no of Rows generated in gridview?

ex:
i have 10 rows in grid. i'm giving Textbox i/p of 100 means, the SlNo column should start from 100- 110.

I got answer for above Question.

Now My updated QA is

increment that count after checking from sql table if it is exists in table? if exists skip that no .

ex:
In table : 101,102,105,110
I/P is: 100 (from textbox)
No Of Row In DataGrid is :10
my Required O/P is 100,103,104,106,107,108,109,111,112,113

Posted 6-Oct-15 1:57am

Sathish km

Updated 6-Oct-15 4:08am

v2

Add a Solution

2 solutions

Solution 1

As i can tell the data you bind to the datagrid contain the column identifier you want and the collection you bind to grid is mycollection. Whenever user changes the text of the textbox or pushes search you must do this.

C#

string userInputtxt = txbUserInput.Text();
int userInputInt = 0;
var finalData = null;
if(int.TryParse(userInputtxt , out userInputInt ))
{
  finalData =  mycollection.Where(w => w.SINo >= userInputInt).Take(10).OrderBy(o => o.SINo);
}
else
{
   finalData = mycollection.OrderBy(o => o.SINo).Take(10);
}

  myDatagrind.DataSource = finalData;

Posted 6-Oct-15 2:14am

vagelis1

Updated 6-Oct-15 2:17am

v3

Comments

Sathish km 6-Oct-15 8:44am

thks I also Got my own.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Naveen.Sanagasetti · Accepted Answer · 2015-10-06T02:20:00

OnRowDataBound event of gridview you can add textbox value with gridview row count.

ASP.NET

<asp:TemplateField HeaderText="SNo">
    <ItemTemplate>
        <asp:Label ID="lblSNo" runat="server"></asp:Label>
    </ItemTemplate>
</asp:TemplateField>

C#

protected void gv_OnRowDataBound(object sender, GridViewRowEventArgs e)
{
    if(e.Row.RowType==DataControlRowType.DataRow)
    {
         ((Label)e.Row.FindControl("lblSNo")).Text=Convert.ToString(Convert.ToInt32(txtsno.Text)+Convert.ToInt32(e.Row.RowIndex+1));
    }
}