Comments by Dnyaneshwar Kondbale (Top 38 by date)

Please provide Sample data and more information.

Can you please provide the sample data and structure of the table.

Try this .. I thing its help you..

from STUDENT_CRpt s,STUDENT_DTL_Crpt d where s.Stu_ID=d.Stu_ID and s.Class=d.Class
group by s.Stu_Name,s.Class,d.Address,d.Gender,s.Subject,s.Marks order by Class
select s.Stu_Name,s.Class,s.Marks,s.Subject ,d.Gender,d.Address, M.Marks as 'Highest Marks'
from STUDENT_CRpt s,STUDENT_DTL_Crpt d,(select MAX(Marks) as Marks,Subject,Class,Sty_Name from STUDENT_CRpt group by Subject,Class,Sty_Name)
M where s.Stu_ID=d.Stu_ID and s.Class=d.Class and m.Subject=s.Subject and s.Class=m.Class and s.Sty_Name=m.Sty_Name

K Means you want to change the caption of button at run time,
Then if you click on Edit button Set button text property to Update and in page load you can set it Edit.
try smiler ways.

If you retrieving the data from SQL server 2008 ,
Then try below.

select * from TableName where datename(dw,DateColumn)='Friday'

Hey you want list all students marks with their class ,subject and adress,gender.
Or you want Highest mark of student.
Or You want Class,subject,Highest Mark,and Student name and address whose get highest mark
Please clear If I am wrong.

Instead of writing com.ExecuteNonQuery() use data reader or data set.for fetching the record

As per above comment add one dummy button with ID=btnDummy
set this button as Target contrl id for animation extender then
write code line

btnDummy.click();

after the line

this.ModalPopupExtender1.Show();

Try to check email ID is present in table or not, before inserting it into data base.
using select query if record is found then restrict to the user by showing the message.

Show_button_click is it method??

I am sorry if I doing any mistake, Is this comment for me @OriginalGriff .

Add one dummy button which is Link as Target control ID for animation extender ..

In "Show_Button_click" method call for dummy button click .

If you have save Booking entry in data base then check count of transaction in date range
before inserting the record in database.

Hope its Help You :)

srry its dnyaneshwar17@gmail.com
dnyanesh.k@hotmail.com

Yup like

<asp:AsyncPostBackTrigger ControlID="btnUpload" EventName="Click" />

and its work for you..

are You adding tigers for update panel.???

In BindEmployeeDetails1() function you write a query

OleDbCommand cmd = new OleDbCommand("Select u.U_id ,u.U_name, u.U_Email,s.ImageName ,s.Description,s.CategoryName,s.ADshop_name,s.ADShop_Address,s.ADshop_city,s.ADshop_mob,s.ADshop_Email,s.AreaName,s.startdate,s.enddate,s.ImagePath,s.diffrence from LOGIN u ,SlideShowTable1 s where u.U_id=s.U_id", con);

In above select Query you checked u.U_id=s.U_id, I thing its causes problem.

instead of cross join try left outer join

You try to check
where u.U_id=s.U_id
Here S.U_Id is in SlideShowTable1 table.Try to debug the code you get a solution.
Please correct me if I am wrong.

You Can try to Save data first and after the completing of this cycle in same function you can write code for printing the ticket.

Use Update panel for the same. put grid view in update panel and update mode is conditional.

are you trying to do something?
are you write code for printing ?

I checked the code Please debug and check at the time of inserting value in SlideShowTable1 what is U_ID.???

Can you explain in detail..
What problem you facing ..

Try the Following line of code insted of your code m just changing where condition.

SqlCommand cmd = new SqlCommand("Select distinct Branch from Userinfo where User_name ='"+ Session["userName"].ToString()+"'",con);

Hope you can Get IT .. :)

After the checked your code I found the below things..

In your SlideShowTable1 table U_id is Identity or What?

If its Identity then How can you join on table LOGIN u and SlideShowTable1 s where u.U_id=s.U_id.

can you show me the Database structure.

Correct me if I am wrong , :)

Yes Why not....

Please share your code in Google docs My email Id is dnyanehswar17@gmail.com

Dnyaneshwar

First Thing check the
int result = cmd.ExecuteNonQuery(); in rotected void Activate_Click(object sender, EventArgs e) is working fine
after that check da.Fill(ds); return what in protected void BindEmployeeDetails1() methode.

Can u explain in Brief...
:)

select DATEADD(dd, 0, DATEDIFF(dd, 0,SubmittedOn)) as WorkingDate,DATENAME(dw, SubmittedOn) as DaName,
ClientID,EmployeeID
from dbo.tblEmployeeTimeCards where


and convert(Datetime,convert(char(10),SubmittedOn,103),103) between convert(Datetime,convert(char(10),@From,103),103) AND convert(Datetime,convert(char(10),@To,103),103)

Hii Satya,
Here In dataset there is only one table as you say.
Then Ds.Table.count must return table count i.e. 1 the Count property return the count of table i.e. 1 and its not return the index of table i.e. 0.

There is diff between Index and count.
0 is index and 1 is count in above condition.

:)

I think you try to give full access to the directory "D:/Share/photo1"

Reffer the below link you get the details of report wizard,
http://www.c-sharpcorner.com/uploadfile/john_charles/report-wizard-in-visual-studio-2008/

Actully ds.Tables.count is check the no of table present in DataSet, If In my DataSet there is 0 table present(means DataSet is null) then How can we perform the operation like Rows.count on Table which is at 0 position,
In ds.Tables.count > 0 line we check how many tables if it is greater than zero does not mean We need to check Ds.Tables[1] its always start from Ds.Tables[0].
:)