How to accept only 10 records in Gird view after 11 record is not accept in grid view?

Question

0.00/5 (No votes)

See more:

I want insert only 10 records in my table. And I want to display those records in my gridview and when I suppose to insert 11 th record in gridview .Thern it has to Give error like Only 10 records is allowed.

Posted 16-Mar-14 18:41pm

Sai Prasad anumolu

Add a Solution

Comments

syed shanu 17-Mar-14 0:47am

You question is not clear.If you want to display only 10 recoudes from DB then you can query to select top 10 record from your db and dind to grid.If you want to insert means if you want to add 10 row in button click each time in button click check for the grid row count if its less then 10 then add row else show message.What is your question clear it

Sai Prasad anumolu 17-Mar-14 1:01am

i need to display only records .After 11 th record is not display in gird view or any other database condition

Peter Leow 17-Mar-14 1:11am

Do you mean : User can add new rows in the gridview programmatically but not more that 10 rows?

Sai Prasad anumolu 17-Mar-14 1:13am

yes sir ,

VICK 17-Mar-14 2:19am

How the data is binding to gridview?? from Database or from a form, from where you are inserting records one by one??

Sai Prasad anumolu 17-Mar-14 2:27am

From Database , Sir and inserting in webpage

VICK 17-Mar-14 2:28am

Well! can you share your code where you are binding the Gridview?

Sai Prasad anumolu 17-Mar-14 2:32am

private void BindGirdTextAdd()
{
con.Open();
SqlCommand cmd = new SqlCommand("Select *from Tbl_TextAdds", con);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
GridTextAdds.DataSource = ds;
GridTextAdds.DataBind();
con.Close();

}

VICK 17-Mar-14 2:36am

SqlCommand cmd = new SqlCommand("Select top 10 *from Tbl_TextAdds", con);

try this to get only 10 records from the database and bind it to gridview.

Check and share your findings.

Sai Prasad anumolu 17-Mar-14 2:43am

Yes ..Its working, Exacting you answer is write but also need in database also only 10 records accepting ..tell me any suggestion

VICK 17-Mar-14 2:45am

Good to hear that. You mean to restrict the insertion in Database to max 10 rows as well?

Sai Prasad anumolu 17-Mar-14 2:46am

Yes i want in database also restict the 10 rows only,

VICK 17-Mar-14 2:52am

See the link in My Updated answer. and if it solves your problem, dont forget to Upvote and accept it as a Solution. :)

Sai Prasad anumolu 17-Mar-14 2:59am

kk I accepted sir , Please give me any suggestions restricted values in database. In database also only 10 records acepting after 11th record is not accepted

VICK 17-Mar-14 3:03am

Have not you seen my solutions EDIT part? I have answered for database rows limit in that Sai.

Sai Prasad anumolu 17-Mar-14 3:12am

Rows limit is 10 in database ...

VICK 17-Mar-14 3:26am

simply change the following line in the given link to

if @tableCount > 50.

Change it to if @tableCount > 10

and than check.. further incase of any issue, do post your trigger syntax.

Sai Prasad anumolu 17-Mar-14 3:36am

Create table Tbl_TextAdds(AddId int Identity(1,1),TextAddImagePath varBinary(max),MaxCharLength varchar(200),Price Money default 0)

select * from Tbl_TextAdds

VICK 17-Mar-14 3:39am

After you have created your table, than afterwards use the trigger.

create trigger LimitTable
on Tbl_TextAdds
after insert
as
declare @tableCount int
select @tableCount = Count(*)
from Tbl_TextAdds

if @tableCount > 10
begin
rollback
end
go

VICK 17-Mar-14 3:40am

and Kindly when ever a link is provided to you by anyone. Do read it carefully and try to implement it after understanding. We all are here to help you on the point where you are stuck and expect you to have a bit understanding of what you are doing and what you want.

2 solutions

Solution 1

While inserting the records, check the count using the SQL COUNT()[^].

If that is 10, then show error message.

Posted 16-Mar-14 18:58pm

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

Comments

Sai Prasad anumolu 17-Mar-14 1:01am

i need to display only records .After 11 th record is not display in gird view or any other database condition ...

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 17-Mar-14 1:02am

I don't get you. Can you explain again?

Sai Prasad anumolu 17-Mar-14 1:05am

First Of all , I will display in gridview only 10 records after 11th record is not accepted in grid view. Okey .
Any Code ..I will be use gridview condition or any database logic also

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 17-Mar-14 1:07am

If you are showing 10 records in GridView, then you already know the count, right?
While inserting just check the GridView Rows Count. If it is 10, then show error message. That's it.

Sai Prasad anumolu 17-Mar-14 1:10am

Yes exactly , After 11 th record in not Accepted in gridview

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 17-Mar-14 1:17am

So, did you try to check the count while inserting?

Sai Prasad anumolu 17-Mar-14 1:22am

trying U r suggestion sir

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 17-Mar-14 1:24am

Good. Let me know your findings. :)

Sai Prasad anumolu 17-Mar-14 1:25am

I am try sir .. I have any dout i will send doubt

Sai Prasad anumolu 17-Mar-14 2:26am

It is not working solution sir

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 17-Mar-14 3:20am

I don't know what you have tried. Butt it's fine. You have solved it. Glad to hear that. :)

Sai Prasad anumolu 17-Mar-14 3:38am

i tried Row limit in Datatable ....

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ) 17-Mar-14 4:02am

Ok. Good. :)

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)

**VICK** · Accepted Answer · 2014-03-16T20:47:00

Based on OP's Comment,

Quote:
Yes ..Its working, Exacting you answer is write but also need in database also only 10 records accepting ..tell me any suggestion
Sai Prasad anumolu

C#

SqlCommand cmd = new SqlCommand("Select top 10 *from Tbl_TextAdds", con);

try this to get only 10 records from the database and bind it to gridview.

Check and share your findings.

:)

EDIT: For OP's another requirement i.e Limit table rows.
You have to trigger the table using the link below.

Possible solution can be found HERE.