please solve the following Issue

Question

0.00/5 (No votes)

See more:

Hi Everyone,
I have two grid views according to gate pass number. 1st grid view contains product name and status where status is warranty under repair and under repair and another grid view contains product Name and status where status repaired.. and a text box for gate pass status outside grid view. If all the status of a gate pass is repaired then the textbox should show open otherwise close. How will i do it .Kindly Help.

Posted 7-Apr-14 22:21pm

Member 10578683

Add a Solution

Comments

Er. Puneet Goel 8-Apr-14 4:34am

you mean in st Grid view or in both the grid view?

Member 10578683 8-Apr-14 4:40am

1st gridview

1 solution

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)

Er. Puneet Goel · Accepted Answer · 2014-04-07T22:38:00

Solution 1

Run this Query

SQL

select * from Product_Details where Status NOT IN ('repaired')

Now, if there is any product that is not repaired yet will be return. SO if this do not return any record (check row count) then the textbox should show open otherwise close

Posted 7-Apr-14 22:38pm

Er. Puneet Goel

Comments

Member 10578683 8-Apr-14 4:42am

I have to show two grid view. If any value is present in 1st gridview then it should show open otherwise close

Member 10578683 8-Apr-14 4:43am

if all are repaired then 1sr gridview will not appear only second gridview wil appear .
in this case the textbox will show close

Member 10578683 8-Apr-14 4:43am

otherwise open

Er. Puneet Goel 8-Apr-14 4:44am

YOu have mention in your Quest "If all the status of a gate pass is repaired then the textbox should show open otherwise close"
But here you saying if "if all are repaired then 1sr gridview will not appear only second gridview wil appear .
in this case the textbox will show close"

This is contradict to each other!!

Member 10578683 8-Apr-14 4:47am

using two queries

Er. Puneet Goel 8-Apr-14 4:50am

See, for 1st gridview, the data will come only if there are some record having status other than Repaired. So you can add a check on that.

Member 10578683 8-Apr-14 5:16am

but how will i check
if(gridview1.Visible== true)
{
TextBox.Text="open"
} like this or what

Er. Puneet Goel 8-Apr-14 5:54am

no no Like the data table you are using to bind gridview, add check on that like dt is datatable then

if(dt.Rows.count > 0){
TextBox.Text="open"}

Member 10578683 8-Apr-14 6:48am

int TotalRecord = gdvProducts.Rows.Count;
if (TotalRecord > 0)
{
TextBox1.Text = "Open";
}
else
{
TextBox1.Text = "closed";
}
I wrote like this but every time it is showing closed

Er. Puneet Goel 8-Apr-14 6:52am

i think you have return the opposite condition. You want to open when row count is > 0. is it?

Member 10578683 8-Apr-14 6:59am

Thanks. It is working now

Member 10578683 8-Apr-14 7:00am

When i directly take If(gdvProducts.Rows.Count>0) then it came. Thanks for the help

Er. Puneet Goel 8-Apr-14 7:03am

always welcome

Member 10578683 8-Apr-14 7:16am

Hi
Can you give me some good links for grid view events. So that i can understand everything about gridview.

Er. Puneet Goel 8-Apr-14 7:19am

yes:
http://www.csharptutorial.in/2014/01/AspNet-GridView-How-to-Update-Delete-Insert-in-GridView-in-csharpnet.html

http://www.dreamincode.net/forums/topic/184448-using-gridview-and-rowcommand-events/

Member 10578683 8-Apr-14 7:20am

Thank You Very Much

Er. Puneet Goel 8-Apr-14 7:22am

For more details on MVC and other you can visit these articles

http://www.codeproject.com/Articles/741632/Start-With-MVC-Push-Start-For-Beginners-Part
http://www.codeproject.com/Articles/741632/Start-With-MVC-Push-Start-For-Beginners-Part
http://www.codeproject.com/Articles/750747/MVC-With-Ajax-Push-Start-For-Beginners-Part
http://www.codeproject.com/Tips/755203/Export-HTML-table-to-Excel-With-CSS