Click here to Skip to main content
14,492,599 members

Comments by Naveen.Sanagasetti (Top 197 by date)

Naveen.Sanagasetti 28-Sep-16 7:08am View
   
I just visited the below link for connecting with webservices and getting library files with metada, request you to kindly confirm me whether this could be help us to resolve this issue.

https://blogs.msdn.microsoft.com/sowmyancs/2007/09/14/how-to-download-files-from-a-sharepoint-document-library-remotely-via-lists-asmx-webservice-sps-2003-moss-2007/
Naveen.Sanagasetti 23-Dec-15 3:59am View
   
In that case better to go with webapplication, no problem the main difference between MVC and WebApplication is performance, since this is like school project it won't give that much performance issue. Go with WebApplication with 3-Tier architecture.
Naveen.Sanagasetti 23-Dec-15 3:27am View
   
agree with you..
Naveen.Sanagasetti 22-Dec-15 4:22am View
   
Question not clear, need more details...
Naveen.Sanagasetti 22-Dec-15 4:19am View
   
I totally agree with you Mehdi, without where conditions that's not possible to give consistent output in all cases.
Naveen.Sanagasetti 22-Dec-15 4:19am View
   
Hi Chill, I won't agree with your answer if he needs kumar age then you made one more query for kumar?
Naveen.Sanagasetti 25-Nov-15 5:41am View
   
What you have tried so far?
Naveen.Sanagasetti 19-Nov-15 7:42am View
   
please elaborate your question, and don't post your total html, post necessary information and elaborate your requirement clearly so that we can help you better
Naveen.Sanagasetti 19-Nov-15 7:37am View
   
As per error, you are trying to access null value, so that only you are getting this error. My suggestion is debug the code and check in which line you got this error and check whether it contains value or not?
Naveen.Sanagasetti 19-Nov-15 7:35am View
   
check the dll location by pressing F4 to check the properties there you can find the dll path and remove it and add the reference again.
Naveen.Sanagasetti 19-Nov-15 7:23am View
   
not clear
Naveen.Sanagasetti 17-Nov-15 2:25am View
   
could you please elaborate your requirement, so that we can help you better
Naveen.Sanagasetti 12-Nov-15 2:52am View
   
Check the logs with that Correlation ID and there it showing the exact error, provide to us that error details, so that we can help you.
Naveen.Sanagasetti 12-Nov-15 2:42am View
   
Refer below link this might be helpful to you, http://www.codeproject.com/Articles/1397/Selection-Highlighting-of-an-Entire-Row
Naveen.Sanagasetti 12-Nov-15 2:31am View
   
Refer below link this might be helpful to you "https://msdn.microsoft.com/en-us/library/5hs4b7a6.aspx"
Naveen.Sanagasetti 2-Nov-15 8:57am View
   
As suggested BillWoodruff, first off all you need to understand the principles then read question and answers.
Naveen.Sanagasetti 2-Nov-15 2:20am View
   
Hi Andy,

Thanks for correcting me. Yes, you are right instead of table variable CTE is the best option.
Naveen.Sanagasetti 29-Oct-15 2:58am View
   
request you to debug the code to fix this type of issues..
Naveen.Sanagasetti 28-Oct-15 6:58am View
   
sry for delay, refer below link http://www.aspsnippets.com/Articles/Multiple-Select-MultiSelect-DropDownList-with-CheckBoxes-in-ASPNet-using-jQuery.aspx
Naveen.Sanagasetti 28-Oct-15 6:04am View
   
Could you please elaborate your problem
Naveen.Sanagasetti 28-Oct-15 5:50am View
   
debug and check the exact issue, this is not the full error details. Please post your error clearly.
Naveen.Sanagasetti 28-Oct-15 5:40am View
   
What's the issue are you facing now?
Naveen.Sanagasetti 27-Oct-15 3:58am View
   
You know the problem right? because of looping iterations you are getting delay of execution then check whether there is a chance to skip that iteration. If there is a chance then do that, how do you expect help from our end regarding this. We are helpless in this situation this is totally your project setup, you need to discuss with your lead and come to know one solution for the same.
Naveen.Sanagasetti 27-Oct-15 3:44am View
   
Please check the datatypes.
Naveen.Sanagasetti 26-Oct-15 10:46am View
   
Your question is not clear, please elaborate little bit.
Naveen.Sanagasetti 15-Oct-15 9:59am View
   
The best way to resolve this is debug the code and find out by your own, since we don't know about your code logic we can't guide you in this. Usually when you perform button click event postback is happening. So, obviously gridview also rebinded automatically controls should be clear but in your case it won't happen means you need to analyse it by your own.
Naveen.Sanagasetti 15-Oct-15 2:15am View
   
CSS Style improvement that's totally depend up on your taste. We can't say this is the best one, you need to decide that. So, Please work around it.
Naveen.Sanagasetti 14-Oct-15 10:49am View
   
Debug the code and then check where it's giving this error.
Naveen.Sanagasetti 14-Oct-15 10:40am View
   
didn't get your point, could you please share some sample data and expected result.
Naveen.Sanagasetti 13-Oct-15 7:25am View
   
Please provide the error details, which you have faced while using this code blocks.
Naveen.Sanagasetti 13-Oct-15 7:24am View
   
What about your gridview columns.?

Whether it is BoundField or TemplateField.?
Naveen.Sanagasetti 9-Oct-15 5:32am View
   
could you pl elaborate your requirement..
Naveen.Sanagasetti 9-Oct-15 5:30am View
   
put a breakpoint in onselectedindexchanged event of dropdown and then check whether event is triggered or not while first click time..
Naveen.Sanagasetti 8-Oct-15 3:22am View
   
Could you please provide more details.
Naveen.Sanagasetti 8-Oct-15 2:40am View
   
This is very hard to give solution if you provide the query like this, because we don't know about your table structure and data. I request you to please provide some sample data and table design then provide the details of your requirement. So, that we will help you better.
Naveen.Sanagasetti 8-Oct-15 2:30am View
   
I have a doubt, if the student is already belongs to one group then why you are allowing him to select(checkbox), my suggestion is if the member is already available in group then disable the checkbox.
Naveen.Sanagasetti 7-Oct-15 9:28am View
   
Could you please try like below.
Use Proper Id tag

txt.ID = "txtVal"+ i.ToString();

And find that control like below
TextBox txtname = ((TextBox)gvEmployee.FindControl("txtVal1"));
Naveen.Sanagasetti 7-Oct-15 7:54am View
   
Have you debug the code what dataset returns.? Please check that first...
Naveen.Sanagasetti 7-Oct-15 7:49am View
   
Please provide error details
Naveen.Sanagasetti 7-Oct-15 6:57am View
   
Everything is Ok.

Have you check all conditions.?

Keep in mind while join the tables first you need to call master then child, because master contains few records but child contains lakh of records.
Naveen.Sanagasetti 7-Oct-15 6:36am View
   
Make sure while posting a question please follow the rules and regulations.
Naveen.Sanagasetti 7-Oct-15 5:24am View
   
If you want styles on your button controls then apply CSS styles over there, you need to prepare those by applying styles as you want.
Naveen.Sanagasetti 7-Oct-15 4:07am View
   
Your Car giving trouble, first you need to start push it then only few of them are also start push it. If you simply Go and sit and ask others to push the car, that is not a request manner, that is demanding/ commanding we are not working for you. We will push you that's it.
Naveen.Sanagasetti 7-Oct-15 1:54am View
   
May I know who give downvote for this, on what basis.? Please provide your comment for downvote so that I try to avoid those mistakes don't downvote unnecessarily.
Naveen.Sanagasetti 6-Oct-15 9:17am View
   
Refer below sample

declare @tab table
(
Id int,
ParentId int,
IsFavorite bit
)

insert into @tab
values (1,null,1),(2,1,1),(3,1,1),(4,2,1),(5,1,1),(6,2,0)

select a.id as Parent, b.id as child
from @tab a,
@tab b
where a.Id=b.ParentId
and a.IsFavorite=1
Naveen.Sanagasetti 6-Oct-15 9:17am View
   
Deleted
Refer below sample

declare @tab table
(
Id int,
ParentId int,
IsFavorite bit
)

insert into @tab
values (1,null,1),(2,1,1),(3,1,1),(4,2,1),(5,1,1),(6,2,0)

select a.id as Parent, b.id as child
from @tab a,
@tab b
where a.Id=b.ParentId
and a.IsFavorite=1
Naveen.Sanagasetti 6-Oct-15 8:51am View
   
Good to hear ;)
Naveen.Sanagasetti 6-Oct-15 8:25am View
   
Can you pl elaborate it more..
Naveen.Sanagasetti 6-Oct-15 3:02am View
   
don't post duplicate posts, if any one having idea about your requirement they will respond immediately, you need to wait until some body respond to your thread.
Naveen.Sanagasetti 6-Oct-15 3:01am View
   
Improve your question
Naveen.Sanagasetti 6-Oct-15 2:09am View
   
Is gridview is AutoGenerate Columns or not.? check this once and debug the code and while binding grid check the datasource and see the list of columns over their.
Naveen.Sanagasetti 6-Oct-15 2:01am View
   
duplicate post remove one of your post.
Naveen.Sanagasetti 6-Oct-15 2:01am View
   
duplicate post remove your one of the post
Naveen.Sanagasetti 6-Oct-15 2:00am View
   
duplicate post remove your one of the post.
Naveen.Sanagasetti 6-Oct-15 2:00am View
   
Please use Proper Title while posting a question in forum
Naveen.Sanagasetti 6-Oct-15 1:59am View
   
Have you debug the code.? Please debug the code and check the values carefully to resolve the issue.
Naveen.Sanagasetti 5-Oct-15 10:45am View
   
This is not a good way to ask question.? Please read terms & conditions before asking a question in any forum.
Naveen.Sanagasetti 5-Oct-15 10:44am View
   
Use proper Title while asking question
Naveen.Sanagasetti 5-Oct-15 10:05am View
   
Improve your question then only people will review and share their thoughts
Naveen.Sanagasetti 5-Oct-15 8:59am View
   
Could you please share your error details.
Naveen.Sanagasetti 5-Oct-15 7:31am View
   
If you want to compare list of values then iterate it through out all the values and then compare.
Naveen.Sanagasetti 5-Oct-15 6:53am View
   
This is not a good way to ask question, You should provide the details of your query, I don't know Why you are post your total design. Please Use "Improve Question" tag for edit the question and provide details.
Naveen.Sanagasetti 5-Oct-15 6:49am View
   
Please improve your question to get more +ve responses.
Naveen.Sanagasetti 5-Oct-15 2:38am View
   
In your designer, if the OnClick property and the event name both are same then it should be trigger; In any cases both are same then also it is not trigger, I request you to recreate the button and events.
Naveen.Sanagasetti 1-Oct-15 6:25am View
   
Now, What is your need..?
Naveen.Sanagasetti 1-Oct-15 6:23am View
   
Is this question.?
Naveen.Sanagasetti 1-Oct-15 5:04am View
   
Enjoy :)
Naveen.Sanagasetti 1-Oct-15 5:03am View
   
Deleted
;)
Naveen.Sanagasetti 1-Oct-15 4:47am View
   
First you should try by your own; if you have any issues we will help you.
Naveen.Sanagasetti 1-Oct-15 4:45am View
   
Already you are enabling textbox based on radio button selection; then what's the issue on that. Are you getting any error.
Naveen.Sanagasetti 1-Oct-15 2:22am View
   
Please check the rows in datatable, If there is no rows obviously foreach terminated. Please check and let us know
Naveen.Sanagasetti 1-Oct-15 2:19am View
   
SELECT Rate FROM rateList WHERE rateList.MakeModel=AllocateAsset.ItemModel

Please check the result set of this...
Naveen.Sanagasetti 1-Oct-15 2:04am View
   
I guess, if you include "~" symbol your problem solved.

Response.Redirect("~/SelectApp.aspx");
Naveen.Sanagasetti 29-Sep-15 10:48am View
   
1) What is not working.?

2) Where it is not working.?

Then only we can come to know,

3) why it is not working.?

Without knowing first 2 points we can't say 3rd answer
Naveen.Sanagasetti 29-Sep-15 10:06am View
   
Why you want existing excel is there any reason, what's the wrong if you export in new excel sheet.? What you have tried so far..?
Naveen.Sanagasetti 29-Sep-15 10:02am View
   
Have you tried to keep the popup in outside the div.?

As of my knowledge there is no relation using div and button click event.

May be because of some other issue, it might be fail..
Naveen.Sanagasetti 29-Sep-15 6:22am View
   
First off all you can split up the requirement into small modules and then start working from module 1 to achieve your goal, if you struck in any place then we will help you.
Naveen.Sanagasetti 29-Sep-15 2:21am View
   
Hi,

Whatever you post in design, there are 2 tables in one table you declare id but you didn't set the runat server property, but in 2nd table you set the runat server property without declaring id. follow whatever I said in my answer.
Naveen.Sanagasetti 28-Sep-15 9:31am View
   
Could you please confirm to me, as per your thread header you are asking to get the result. Where you want to show the same.? Is it in gridview or any other datasource controls.?
Naveen.Sanagasetti 28-Sep-15 9:29am View
   
Hi, this is answering section don't post your queries on here, use Have a Question or Comment? or Reply for reply to the current comment. Please delete the answer
Naveen.Sanagasetti 28-Sep-15 7:12am View
   
What's the issue..
Naveen.Sanagasetti 28-Sep-15 7:11am View
   
What type of issue are you facing.?
Naveen.Sanagasetti 25-Sep-15 7:40am View
   
Can you please share the plugin details, so that I can use that to accomplish my task.
Naveen.Sanagasetti 24-Sep-15 10:40am View
   
Sry, don't mine what I'm expecting is different, and your solution is different.
Naveen.Sanagasetti 22-Sep-15 4:53am View
   
There is an option to Integrating service using sitecore, but the problem is it's sending information in XML format, but we required in JSON format. Is their any third party integration for the same, that is what I'm expecting.
Naveen.Sanagasetti 22-Sep-15 3:42am View
   
Welcome
Naveen.Sanagasetti 21-Sep-15 10:58am View
   
Hi RasiKazi,

I already go through those all links, but all are using Web API only, we require without using API, and without wrote any code we need to configure it using sitecore content, that is what I'm expecting.
Naveen.Sanagasetti 21-Sep-15 10:32am View
   
Hi RasiKazi,

I want to implement the service using sitecore.
Naveen.Sanagasetti 21-Sep-15 10:23am View
   
In SSRS, which database are you using. If that is SQL then it should work in SSRS too. If it is not working means, please check the query which you have passed.
Naveen.Sanagasetti 21-Sep-15 10:05am View
   
My suggestion is keep backup before integrate it..
Naveen.Sanagasetti 21-Sep-15 6:10am View
   
Could you please confirm, whether image gets saved in your database or not.?
If Yes, then please post your getting data method.
Naveen.Sanagasetti 21-Sep-15 5:24am View
   
Is this question.?
Naveen.Sanagasetti 21-Sep-15 5:23am View
   
That is the reason it is throwing that error, As per Solution 1 if you remove static it will show that method in service call, obviously it should work as you expected.
Naveen.Sanagasetti 21-Sep-15 4:07am View
   
Call the Service URL and open the method which you try to call using JSON.
Naveen.Sanagasetti 21-Sep-15 3:49am View
   
your question is not clear, can you please elaborate it little bit.
Naveen.Sanagasetti 21-Sep-15 3:44am View
   
I request you to please search the URL in browser, if it is working fine, then please check the parameters which you passed through Json call, I guess this is case sensitive, as Point out by Rohan Leuva, in method declaration you are using the parameter "BasketInfo" and in JSON call you call like below "basketInfo", I guess this might be problem, Please check this once.
Naveen.Sanagasetti 21-Sep-15 2:22am View
   
What about datatype of dtProducts.Rows[0]["ProductImage"], I guess the problem is conversion. Please check the left & right hand side datatypes both should be same then only it should work perfect.
Naveen.Sanagasetti 18-Sep-15 8:15am View
   
Where is the error log, please share those details instead of share your full content.
Naveen.Sanagasetti 18-Sep-15 4:10am View
   
Cell[2], which row..? Is this static or there is any condition you required.?

Please provide few more details.
Naveen.Sanagasetti 18-Sep-15 4:01am View
   
do you have static data.? please give more details.
Naveen.Sanagasetti 18-Sep-15 3:40am View
   
What information Are you expecting from our end.?
Naveen.Sanagasetti 18-Sep-15 2:51am View
   
What do you mean by Insert textbox into usercontrol.?
Please elaborate your requirement, so that we can help you in better way.
Naveen.Sanagasetti 18-Sep-15 2:50am View
   
Hi Rohit,

Can you please debug and see the CommandArgument, what it's return and check whether that is your desired RowIndex or not.?

I guess the problem is RowIndex, if RowIndex also correct then check your column type whether that is BoundField or TemplateField.

Please check and revert back to me.
Naveen.Sanagasetti 15-Sep-15 8:53am View
   
The Answer is simple previously you done with static data, now you need to implement the same with dynamic data.

First note down the plan in one paper and proceed..

Step 1 : Whether DataBase is static one or dynamic one
Step 2 : prepare SP for getting all the tables against Database
Step 3 : Prepare select queries against each table
Step 4 : once you made query then get the result into DataSet.
Step 5 : using DataSet, you can read the data into Excel sheet.

Achieve the requirement by splitting into small small modules like above and achieve your goal.
Naveen.Sanagasetti 15-Sep-15 8:47am View
   
What you tried so far..?

Naveen.Sanagasetti 15-Sep-15 6:19am View
   
Hi, if something is working fine in one environment and it is not working in other environment there might be problem in Configuration level or DB level please compare these 2 in both the environments and let us know.
Naveen.Sanagasetti 15-Sep-15 5:34am View
   
Could you please elaborate your requirement.
Naveen.Sanagasetti 15-Sep-15 5:33am View
   
Share your exception details instead of post your full code; that will help you to get more responses from our end.
Naveen.Sanagasetti 15-Sep-15 5:26am View
   
Hi Hari prakash, only for this two objects intelligence is not working or through out all the objects..? If this is happen for all I request you to please reinstall your Visual studio, if this is happen only for those 2 then lets wait for one of our experts responses.
Naveen.Sanagasetti 15-Sep-15 5:23am View
   
Have you debug the code and check the same.?
What's the CommandText, and execute that commandtext in SQL Management studio and see the result set.
Naveen.Sanagasetti 15-Sep-15 3:59am View
   
Are you getting any error.? Please share your error details to us, so that we will help you as our best.
Naveen.Sanagasetti 30-Aug-13 6:39am View
   
Deleted
Few people are working for just find the faults in others. I don't consider those people responses.
Naveen.Sanagasetti 27-Aug-13 0:03am View
   
Deleted
Thanks for your suggestion i know that is not correct wy to ask code. But for this i tried from 2 days onwords that's the reason i'm asking. Or else please give idea to do this, i have ajaxtabcontainer in that i have multiple tables now when i click on print button i need to print particular table information only how to do any idea out of this...?
Naveen.Sanagasetti 19-Aug-13 9:50am View
   
Ok i try to remove that CSSClass then also it's not working. Css class is used for Styling purpose only nooo. I don't want style that's the reason i remove that CssClass and try again but no result.
Naveen.Sanagasetti 19-Aug-13 9:43am View
   
Here, im using OnActiveTabChanged event only so that is available in my code behind. And if Cssclass is available or not there is no impact due to CSS class right..?
I tried to delete that CssClass also .But no use...
Naveen.Sanagasetti 26-Jul-13 6:24am View
   
hi, here material_id is repeated more than once then i want to show the 1.a , 1.b ... based on repetation. How to do...
Naveen.Sanagasetti 19-Jul-13 6:34am View
   
Hai,
My self tried all those links but while export the data becomes like this .
<meta http-equiv=Content-Type content=text/html;charset=UTF-8><div>

</div>
Naveen.Sanagasetti 6-Jul-13 2:09am View
   
no, in that link they are hide grid header and statically they pass grid columns using table. But i don't want to pass static columns i want to pass dynamic columns.
If i use this link i do some operations in my grid header that features also i missedout. That's the reason i'm asking..
Naveen.Sanagasetti 6-Jul-13 1:51am View
   
Hi nirav,

good link but in that link they pass static columns. But i don't want to pass static columns i want to fetch columns from DataBase. Based on database values i want to display columns. But using that link how its possible..
Naveen.Sanagasetti 8-May-13 8:15am View
   
no here what i'm trying to do is when i click a button in my first page it's redirect to another page ( popup window ) and i fill total all details and click on submit button then my popup window is closed and it's open my first page itself but it's not redirect to my first page ....
Without redirect to my first page how to check the querystring value....
If its loaded in page load then only that value is read other wise it's not possible to read that querystring value naaa...?
Naveen.Sanagasetti 16-Apr-13 1:16am View
   
Your correct Prashant but the column name your mentioned is not correct, the column name is "BudgetFYDef". Any way good Answer...
Naveen.Sanagasetti 12-Apr-13 8:14am View
   
Hi,

On top of right corner your name is there with DropDown , just move a cursor to that DropDown and click on "MySettings" option and then you edit what ever you want and click on save changes. That's it..
Naveen.Sanagasetti 12-Apr-13 5:00am View
   
I think the problem is related to connection problem , please send your connection string..
Naveen.Sanagasetti 11-Apr-13 5:24am View
   
check this line ORDER BY rnd (INT(NOW*ImageID)-NOW*ImageID)
is it correct , first of all you can execute this query in your SQL side in sql wise its working fine then you can use that in your code
Naveen.Sanagasetti 11-Apr-13 5:09am View
   
check your parameteres are refer in proper name or not.
Naveen.Sanagasetti 3-Apr-13 6:15am View
   
send me your code, you bind data to which control...?
Naveen.Sanagasetti 3-Apr-13 5:56am View
   
send me sample data
Naveen.Sanagasetti 3-Apr-13 5:15am View
   
That is not a table , in my SP one of the column and that SP i'm using to Generate the Report purpose..

i already given the details in my question itself
ex: jan-2013, feb-2013....

month ----jan-1, year---2013 .


Once pl study my question again
Naveen.Sanagasetti 2-Apr-13 5:30am View
   
hi i tried like this this works fine for me

select month(cast('01-'+'feb-2012' as datetime)),year(cast('01-'+'feb-2012' as datetime))
Naveen.Sanagasetti 2-Apr-13 5:28am View
   
thank you this works fine for me,
but here month means it's showing monthname but i want month number without using case is it possible to display month number
Naveen.Sanagasetti 2-Apr-13 5:14am View
   
Ok fine but my query is look like this
SELECT DATEPART(MONTH, 'jan-2013') 'Month', DATEPART(YEAR, 'jan-2013') 'Year'

how to fetch month && year details
Naveen.Sanagasetti 2-Apr-13 5:06am View
   
SELECT DATEPART(MONTH, 'jan-2013') 'Month', DATEPART(YEAR, 'jan-2013') 'Year'

i'm getting this error message "The conversion of a varchar data type to a datetime data type resulted in an out-of-range value."
Naveen.Sanagasetti 2-Apr-13 5:03am View
   
If my date is '2013-04-02 14:36:10.300' this format then i know how to fetch that month && year details month(date),year(date).

But my date is varchar type and my date is look like this 'jan-2013'....
Naveen.Sanagasetti 13-Mar-13 6:23am View
   
you are finding the control "dlQuantities", does that controls exists ?, if that controls not exists, that object becomes null and if you are trying to access null object, then this error will occur. just put the break point at that line, and place mouse pointer over the object, you can see whether it is null or not.


This is very help full to me thanks alot...
Naveen.Sanagasetti 13-Mar-13 6:18am View
   
Can you plz explain the reason of this error, what are the cases we see this type of error
like Binded data is empty....
Naveen.Sanagasetti 13-Mar-13 6:15am View
   
dlQuantities control is exist, then also i'm facing the object value is null....
How to overcome this issue now...
Naveen.Sanagasetti 13-Mar-13 6:13am View
   
dlQuantities is not a DDL , it is DataList already i assigned that object
Naveen.Sanagasetti 13-Mar-13 6:12am View
   
dlQuantities is NULL
Naveen.Sanagasetti 13-Mar-13 6:10am View
   
Can u plz explain eloborate about "dlQuantities" is an invalid reference....
Naveen.Sanagasetti 13-Mar-13 6:08am View
   
Can u plz explain eloborate about "dlQuantities" is null or not....
Naveen.Sanagasetti 27-Feb-13 22:54pm View
   
Your Question is not clear
Naveen.Sanagasetti 26-Feb-13 23:45pm View
   
K fine i checked that query it's working fine but here it's displaying yyyy-mm-dd also , but i want to display quantity based on prev month only , in this case no need to consider date
Naveen.Sanagasetti 26-Feb-13 23:26pm View
   
FOR ex this is the month of jan 13, previous month means dec 12. using that dateadd function whatever you given using that it's satisfied the date condition , here my doubt is year also changed na..? that's the confusion now
for this i tried like this DATEPART(M,a.Planned_Date)=DATEPART(M,DATEADD(M,-1,GETDATE())) AND DATEPART(yy, a.Planned_Date) = DATEPART(yy, DATEADD(m, -1, getdate())) , this is ok or any issues
Naveen.Sanagasetti 26-Feb-13 0:47am View
   
I tried like this but my output is mismatch to my requirement

select a.Proj_code,a.Material_Id,a.DED_Description,a.DED_Short_Desc,a.Planned_date,

a.Planned_Material_qty, sum(b.Planned_Material_qty) As Total

from #TempTable a cross join #TempTable b where (b.Material_Id=a.Material_Id)

group by a.Proj_code,a.Material_Id,a.DED_Description,a.DED_Short_Desc,a.Planned_date,

a.Planned_Material_qty order by Material_Id
Naveen.Sanagasetti 25-Feb-13 2:15am View
   
Dear Sir ,
Here my doubt is related to SQL query.. But you given link in that they explain something about Commands,Parameters...
But i'm struking in my query ...
Naveen.Sanagasetti 25-Feb-13 2:12am View
   
Ok but my requirement wise no need to pass the parameters..
Naveen.Sanagasetti 25-Feb-13 2:04am View
   
Yes, But i don't want to Pass any parameter on here iwant to fetch total all information from project satrting date to till date
Naveen.Sanagasetti 21-Feb-13 8:02am View
   
All d best but previous comment written by Ed Nutting
Naveen.Sanagasetti 21-Feb-13 7:55am View
   
Sorry yar i'm try to resolve this issue , but still now i'm confusing about your requirement.
Your DataTable returns empty records means that's the problem of your Select Query only.
I understand the scenario 1, but i can't understand scenario 2..
Naveen.Sanagasetti 21-Feb-13 7:43am View
   
your searching based on driver name , in this case your query returns any value
Naveen.Sanagasetti 21-Feb-13 7:41am View
   
Without enter text value you got the result...
But when you try to search some text in TextBox and then click on button at that time your searching result is blank...right...?
Naveen.Sanagasetti 21-Feb-13 7:30am View
   
your select query returns any value...?

upto now your not given exact information , what's the problem you facing please mentioned that...
Naveen.Sanagasetti 21-Feb-13 7:28am View
   
you face the problem in select query right..?
Naveen.Sanagasetti 21-Feb-13 7:26am View
   
I think your requirement is based upon search value you want to display the information in DDL...?


righ...?
Naveen.Sanagasetti 21-Feb-13 7:24am View
   
you try to display the information ... right...?
your using select query , where to display that information...
I can't understand your exact requirement...
Naveen.Sanagasetti 21-Feb-13 7:12am View
   
can you provide your source code....
Naveen.Sanagasetti 21-Feb-13 7:11am View
   
After insert data you want to clear your textbox values.... right....?

use like this txtname.clear();
Naveen.Sanagasetti 21-Feb-13 7:04am View
   
What's the problem now ...?
Any error you got...?
your given some improper information...
How to workout using this information...?
please provide your source code also..
And where your facing problem , that's also you should mentioned..

what's the meaning of this
but the debugger doesnot enter the bt1_Click() ...?
Naveen.Sanagasetti 19-Feb-13 4:22am View
   
Thank's alot...
Naveen.Sanagasetti 19-Feb-13 4:14am View
   
Oh k k thank you , after that which option i selected for editing
Naveen.Sanagasetti 19-Feb-13 4:02am View
   
But now you can do that na..
To edit the tusharkaushik question na...
Naveen.Sanagasetti 19-Feb-13 3:57am View
   
this question is published by tusharkaushik , but in my screen it's not showing improve question option.
Naveen.Sanagasetti 19-Feb-13 3:49am View
   
Hi Karthik Harve , How to edit the question can you please tell me the steps..
Naveen.Sanagasetti 19-Feb-13 3:39am View
   
your question is not clear... can you please elaborate your question
Naveen.Sanagasetti 19-Feb-13 1:38am View
   
page is moving up and down...?
means
Naveen.Sanagasetti 18-Feb-13 22:49pm View
   
Select col1,col2,col3
into #TEMPTable
from table1

this is the sample syntax only ..
Naveen.Sanagasetti 18-Feb-13 6:18am View
   
If they want to update more than one row how to achieve using this query..?
Naveen.Sanagasetti 16-Feb-13 3:20am View
   
Once please execute the SQL table in sQL server side how much time it's taking for execution please checkout this...
If the table execution takes more time then you contact to your DB team to resolve this issue
Naveen.Sanagasetti 15-Feb-13 8:21am View
   
but i'm not using LINQ
Naveen.Sanagasetti 14-Feb-13 7:03am View
   
I already mentioned in my question i know how to do using for loop but i'm asking using foreach loop
Naveen.Sanagasetti 14-Feb-13 4:56am View
   
Any doubt's use "Have a Question or comment" button.
Naveen.Sanagasetti 14-Feb-13 3:40am View
   
Put a break point in your code and check the "ds" having Table "0" or not.
Naveen.Sanagasetti 14-Feb-13 1:53am View
   
'ING' means your assembly name...?
I think your refering the assembly is not loaded properly. please checkout this...
Naveen.Sanagasetti 12-Feb-13 6:21am View
   
I'm also tried using Response.Redirect & server.Transfer but my boss is not accepted to use those , he ask me using only hypelinks
Naveen.Sanagasetti 12-Feb-13 6:12am View
   
<asp:HyperLink ID="link" runat="server" Text="EXCEL MANUAL" OnClick="btnManual_Click" >

protected void btnManual_Click(object sender, EventArgs e)
{

if (COM_Code == 5)
{
link.NavigateUrl = "http://eipvidhyadev/edrc/elect/O11153/Documents/EMS_PTD.xls";
}
else if (COM_Code == 1)
{
link.NavigateUrl = "http://eipvidhyadev/edrc/ems/O10070/Documents/EMS_BnF.xls";
}
}
Naveen.Sanagasetti 12-Feb-13 6:05am View
   
for based up on parent project code
Naveen.Sanagasetti 12-Feb-13 4:40am View
   
k thank you
Naveen.Sanagasetti 12-Feb-13 4:30am View
   
yes
Naveen.Sanagasetti 12-Feb-13 4:14am View
   
yes, inside of linkbutton_click event
Naveen.Sanagasetti 12-Feb-13 1:13am View
   
i'm not asking about exporting option. i'm asking to display manual what are the columns we provide while inserting excel data into SQL DB, i want to display the details .... any way thanks for your help....
Naveen.Sanagasetti 12-Feb-13 0:53am View
   
yes, already i have an Excel file .
Naveen.Sanagasetti 11-Feb-13 4:48am View
   
sorry i'm not checking the previous solution.
Naveen.Sanagasetti 8-Feb-13 4:06am View
   
that's not a textbox i fetch the information from Excel sheet that data i want to be to store it on SQL database before that i want to check the date has to be correct format or not
Naveen.Sanagasetti 6-Feb-13 6:09am View
   
Sorry Abhinav i'm asking i upload any type of file name but i want to save the file name as xxx.xls. But one thing after save the file i displayed the sheet names available in that excel . If we change some thing in file name it wont effect on existing.
Naveen.Sanagasetti 5-Feb-13 23:50pm View
   
Are You passing the values via page wise only....?
If you pass the values in page wise then check the condition using "if".
Naveen.Sanagasetti 5-Feb-13 4:31am View
   
for error explanation , they post some information that's enough...
But user asking in his question "Please help me in this... I'm Stuck for a long time... No luck in googling.", that's way i'm asking code, try to resolve where he facing the issue. that's want i'm asking yar...
Naveen.Sanagasetti 5-Feb-13 4:16am View
   
Deleted
error findout means whatever you post that enough. But i'm asking try to resolve that.
Naveen.Sanagasetti 5-Feb-13 4:07am View
   
post your code.. please
Naveen.Sanagasetti 4-Feb-13 23:22pm View
   
please elaborate your question..
Naveen.Sanagasetti 4-Feb-13 6:49am View
   
in your source code itself you follow this code..
<asp:Label ID="lblMSCE_SE_Code" runat="server" Visible="false" Text='<%# DataBinder.Eval("your object") %>' />
Naveen.Sanagasetti 4-Feb-13 6:26am View
   
How many times you post the same query...?
If you want to modify the question use Improve Question tag, then modify whatever you want..
Naveen.Sanagasetti 3-Feb-13 23:06pm View
   
I think here the problem is saving location. CheckOut your saving location , you saved the application in exact location or not check out that.
Naveen.Sanagasetti 2-Feb-13 6:21am View
   
once post your code
Naveen.Sanagasetti 2-Feb-13 5:52am View
   
You can achieve this by using QueryStrings & Sessions also . Checkout the Syntax for that...
Naveen.Sanagasetti 31-Jan-13 1:49am View
   
In question it self they mentioned that, PK col is "numb".
Naveen.Sanagasetti 31-Jan-13 1:45am View
   
I told you in coding wise you do that stuff, your not an end user ... right..?, you know that logic , what are the PK column etc.. so, you do that stuff in your coding wise i'm also do the excel uploading concept, my table PK col is auto increment column . So, i never face this type of issue. But in some other page i'm facing this issue at that time i'm checking whatever i mentioned in my solution
Naveen.Sanagasetti 31-Jan-13 0:19am View
   
hmmmmm, Could you please elaborate your question...