|
Hi this is my query:
SELECT EM.empId, TC.carddate,SD.Whrs,
MHD.Appwhours as AppHours,MHD.AppOtHours as AppOtHours
FROM dbo.tblEmployeeMaster EM INNER JOIN dbo.tblTimeCardmain TC
ON EM.empId = TC.empid INNER JOIN dbo.tblSalaryDetails SD
ON EM.empId = SD.EmpID left outer join dbo.tblMonthHourdetails MHD
ON TC.empid=MHD.empid and TC.Carddate=MHD.Sdate
WHERE TC.carddate = '8/1/2007' AND TC.app1 = 1 AND TC.projectid = 100
order by EM.Empid
For this i am getting o/p like:
Empid carddate whrs AppHours AppOtHours
100 8/1/2007 11 11 3
101 8/1/2007 8 8 6
102 8/1/2007 11 11 3
103 8/1/2007 11 11 3
103 8/1/2007 11 11 3
See that empid=103 have 2 entries in tblsalarydetails...,
So its givng in o/p 2 values...,
But there i need one o/p that want to be based on the date...,
In my tblsalarydetails i have date column...,
So How to display the whrs based on the date for that employee?,
Plz hlp me...,
Tblsalarydetails table design:
empid whrs edate
100 11 8/1/2007
101 8 7/1/2007
102 11 8/1/2007
103 11 8/1/2007
103 10 2/21/2007
Regards,
Magi
|
|
|
|
|
Magh_M wrote: See that empid=103 have 2 entries in tblsalarydetails...,
So its givng in o/p 2 values...,
But there i need one o/p that want to be based on the date...,
if u want only one output each empid..why dont u use Select Distinct query
Regards,
Tomi
|
|
|
|
|
<code>
SELECT DISTINCT your_column FROM bla... bla... bla...
</code>
I hope this will help U
Regard,
Edwin
|
|
|
|
|
Hello,
I have a gridview and I have an 'RowDataBound' event on it. To perform some operations on each row of the grid view i have to check below condition:
if e.Row.RowType == DataControlRowType.DataRow
But the first row and the last row are treated as 'DataControlRowType.Header' and 'DataControlRowType.Footer', Instead the first and last row are also DataRow. Please suggest how can I solve this.
I tried using below condition
if (e.Row.RowType == DataControlRowType.DataRow) || (e.Row.RowType ==
DataControlRowType.Header)
but in the above case, the below statement throws error
DataRowView rowView = (DataRowView)e.Row.DataItem
rowview will be NULL and I will get an error 'Object not set'
Pavas
|
|
|
|
|
hi,
I am not sure you can cast e.Row.DataItem into a DataRowView because e.Row is a GridViewRow and not a DataRow, which is not exactly the same.
To access individual columns of a gridview row, I use the following (in RowDataBound event method):
GridViewRow row = e.Row;
TableCell tcell = row.Cells[0];
string temp = tcell.Text;
Hope this helps.
Talal
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning."
--Rich Cook
|
|
|
|
|
My problem is I want to access fist row and but first row is treated as header and last row is treated as footer.
Hence when I check below condition, It thows error.
if (e.Row.RowType == DataControlRowType.DataRow )
Pavas
|
|
|
|
|
Ok, if you're using the statement you wrote in the post, I believe it is normal that you get an "object not set" error.
You said that you use the following expression:
if (e.Row.RowType == DataControlRowType.DataRow) || (e.Row.RowType == DataControlRowType.Header)
This indicates that if the row is either a data row or a header do something. In case it is a header, there is no data in it and it might throw an error if you attempt to access something that is not there.
I have never used DataItem so I cannot tell you for sure but what I'm sure of is that I use the following and it works very well:
GridViewRow row = e.Row;
if (row.RowType == DataControlRowType.Header)
{
}
if (row.RowType == DataControlRowType.DataRow)
{
}
It could help if you post more code to see exactly what is written.
Talal
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning."
--Rich Cook
|
|
|
|
|
Yup I agree with you.
The code is as below:
if (e.Row.RowType == DataControlRowType.DataRow )
{
DataRowView rowView = (DataRowView)e.Row.DataItem;
string Code = rowView["CODE"].ToString();
}
Thie fist row doesn't match the condition as row type is DataControlRowType.Header.
But the first row has some data and i want the fist row shouldnt be a DataControlRowType.Header.
Does this helps you to solve the problem
Pavas
|
|
|
|
|
You can choose to remove the header from the GridView if you don't want it at all.
I have tried writing similar lines in my code. I didn't get any error with DataRowView rowView = (DataRowView)e.Row.DataItem. Now I'm thinking that maybe the data binding was not done properly for the GridView? If the data binding was not done, DataItem would be empty and the cast (DataRowView)e.Row.DataItem could thrown an error. I don't see what else could be wrong. Maybe someone can provide a fresh perspective.
Talal
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning."
--Rich Cook
|
|
|
|
|
I am not sure why this is happening...? Could some one help on this
Pavas
|
|
|
|
|
Hi guys how to creat note pad in runtime in asp.net plz give some sample code
Praveen Kumar.R
|
|
|
|
|
Your question is illogical. You can't create a notepad in ASP.NET, because you can't save files locally. You can trivially add a text control, and save the contents to the server, however. What do you mean by 'in runtime'. What is it you want to do ?
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Did U mean text editor ?
U should use javascript to ceate that.
www.fckeditor.net
Hope this will help U
Regard,
Edwin
|
|
|
|
|
hi,
below this is the code written in C#.net .i want the correspond vb.net code. thanks in advance...
" string distict = ((DropDownList)MyGridView.FooterRow.FindControl("ddlDistrict")).SelectedValue.ToString().Trim();"
where MyGrid=id of the gridview
ddlDistrict=id of the ddl which is taken in side the footer template of gridview
|
|
|
|
|
Please don't cross post.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
dim distict as string=ctype(MyGridView.FooterRow.FindControl("ddlDistrict"),DropDownList).SelectedValue.ToString().Trim()
Best regard
Pathan
---------------------------------------------------
|
|
|
|
|
Hi friends
I need validation expression string for 'XXX XXX' format
Thanks In advance
pathan
---------------------------------------------------
|
|
|
|
|
What do the X's mean ? you probably mean you need to build a regex ? Expresso is a great tool for that.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Use Regular Expression Validator.
\s{3} \s{4}
|
|
|
|
|
Thanks
Pathan
---------------------------------------------------
|
|
|
|
|
hi,
This is the regular expression for U.S Phone number(XXX-XXX-XXXX)
((\(\d{3}\) ?)|(\d{3}-))?\d{3}-\d{4}
You can edit it and use it for your work accordingly..
SHWETA!!
|
|
|
|
|
Thanks
Pathan
---------------------------------------------------
|
|
|
|
|
Hi guys, iam using session in my project some session variables are interger some other string. when session expired i click next button they show error, so i want to validate when session is expired. so please give some ideas how to validate
Praveen Kumar.R
|
|
|
|
|
The best you can do is work out in your pages that it has timed out, and redirect to the login page.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Before getting the data from the Session first check is not null.
Parwej Ahamad
g.parwez@gmail.com
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
