16,018,518 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Visual Basic questions
View Javascript questions
View .NET questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by planetz (Top 127 by date)
planetz
31-May-18 0:56am
View
I have moved the data up. But as you can see from code, I deleted only the range and not the entire row. Are you saying that is the reason that the count does not change?
planetz
29-Mar-18 2:28am
View
Hi, I took your advice to shift the data to database. Now it is much more easy and fast. Thank you..!!
planetz
27-Nov-17 9:15am
View
sum is for numbers...that's why I was looking for aggregate function for string...max() worked...
planetz
21-Nov-17 21:04pm
View
I have updated the query with present table.
planetz
20-Nov-17 11:30am
View
the sum function will not work on status which is string, so I am not able to find a way to group the columns name and sub.
planetz
20-Nov-17 11:03am
View
yes. This query is the old one with old table. Old table is same as table1. But instead of column 'status'(varchar2) it was column 'score'(number).
planetz
7-Nov-17 23:14pm
View
Hi GobblesGobbles, this is the recording of the manual procedure. I need to get distinct count of data for a particular item. My mistake, I will add an example of my requirement.
planetz
3-Nov-17 5:42am
View
this query has to be in a procedure. right? else where can I declare 'a_defined_variable'?
planetz
2-Nov-17 3:04am
View
Yes GKP1992, that is correct. I am using oracle 10g.
planetz
31-Oct-17 6:58am
View
the output can be achieved by query...but it will be writing same selected lines from 4 different queries. But if thie procedure I asked is even more complicated and time taking, then may be query is a better option.
planetz
31-Oct-17 6:55am
View
yes, there is a column that is same for all datasets, but that is not something like a primary key. Just like a student list say, where student name is the common field, and their individual subject marks are 4 datasets and then there is a summary that contains individual subject marks and also total marks.
planetz
23-Oct-17 2:09am
View
Great!! List worked!! Thank you!!
planetz
13-Oct-17 6:27am
View
'having' clause surely is a condition but it wont check for everyday when they are placed one beside other. For example, if for each day count >1 then output should only have
ename | 01-10-17 | 02-10-17
emp3 | 2 | 2
But with your query it comes as:
ename | 01-10-17 | 02-10-17
emp3 | 2 | 2
emp1 | 3 | null
planetz
13-Oct-17 1:10am
View
I have to show individual dates as individual column names and their respective count under them.
planetz
10-Oct-17 23:44pm
View
This is exactly what I want. It worked and query is understandable. Thank you..!!
planetz
10-Oct-17 5:47am
View
But date is an important filter. I can't leave it out. User will select date and output will be according to that.
planetz
10-Oct-17 0:43am
View
Well I found out that I have typed the formula wrong which gave the error. My mistake!!
Thank you though..!!
planetz
27-Sep-17 2:06am
View
I have recreated the table and uploaded the data into 10g tables.
planetz
17-Aug-17 11:30am
View
Thank you so much Maciej....your point no two was a good hint....helped....
planetz
13-Aug-17 8:52am
View
that closes all other excel files.
planetz
3-Jul-17 1:20am
View
dim fcount as integer
public sub browseFiles()
'browse files and count no of files
fcount=fcount+1
end sub
public sub runMacro()
if fcount >0 then
'do something
end if
end sub
**the two subs run on two different button clicks
planetz
30-Jun-17 6:48am
View
Thanks for your support..!! But the requirement is not to call another sub from a sub. They should run on button click by user.
planetz
26-Jun-17 11:23am
View
no, i was looking for some simpler solution!
planetz
26-Jun-17 10:24am
View
Can not it be done without cookies?
planetz
23-Jun-17 3:34am
View
Yes, of course.
inputs:
date1=20-06-2017 01:02:30 am
date2=21-06-2017 01:04:30 am
after subtracting date2-date1, output
00:02:00
It is only calculating the minutes and seconds and not the hours.
My code:
Dim startDateTime, endDateTime As Date
startDateTime = CDate(Form.txtStartTime.Text)
endDateTime = CDate(Form.txtEndTime.Text)
Form.txtDuration.Text = Format((endDateTime - startDateTime), "hh:mm:ss")
planetz
22-Jun-17 12:05pm
View
I have converted strings into date using CDate(). Could that be a problem?
planetz
12-Jun-17 6:21am
View
I see. In all, access is not a good choice for multi user. Thank you for the information..!!
planetz
25-Apr-17 2:02am
View
Will you help me understand how can I define the array so that the output is not a string?
planetz
25-Apr-17 1:42am
View
I have changed my code as per your code. Still it generates the same value!
planetz
25-Apr-17 1:12am
View
The variables are defined at the start and in course of program values are assigned to them through calculation. In the end I am trying to get those values back from them and paste them in cells.
planetz
24-Apr-17 7:38am
View
But how to convert it to variable name?
planetz
7-Apr-17 4:55am
View
The unhide worked as wonderfully as the hide. Thank you so much..!! First time a problem made me laugh too.
planetz
1-Mar-17 6:31am
View
Thank you for your response. Yes, I meant single file. :-)
planetz
1-Mar-17 6:30am
View
Thank you for helping with ideas. I will try and get back.
planetz
2-Feb-17 2:14am
View
Pardon...it is how to save the text file? I'l edit the question
planetz
5-Oct-16 1:56am
View
I have found a work around. To execute the logic separately and then redirecting separately. Since it is part of the answer, I am not marking your answer as solution.
planetz
5-Oct-16 1:42am
View
There is logic in emp.logout().
planetz
5-Oct-16 1:29am
View
I am not redirecting to aspx directly. The logout method contains some updates and then redirection. So I need to display alert and then move on to the method which includes the redirection.
planetz
5-Oct-16 1:19am
View
have tried that also..but as F-ES Sitecore explained, since the html version will be prepared at the end and before that there is redirection, so pop up part will be discarded.
planetz
5-Oct-16 1:01am
View
emp.logout redirects to another page. I have to show pop up before calling the method.
planetz
5-Oct-16 0:55am
View
Ok...now I got it..!!
planetz
5-Oct-16 0:45am
View
Yes, the logout method redirects to another page. I understand..!! Thank you so much!!
What if I display alert before logout method? It is not showing then also.
planetz
5-Oct-16 0:39am
View
Deleted
Yes, the logout method redirects to another page. I understand..!! Thank you so much!!
planetz
19-Sep-16 2:36am
View
hey..thanks for your hint....!!
planetz
19-Sep-16 2:36am
View
i was seeking help regarding logic...the problem is solved..i will update my proper running code...
planetz
15-Sep-16 8:45am
View
Will you please explain with a sample code. My code here goes for first student. But how can I move on to next one?
planetz
3-Aug-16 2:54am
View
A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond 74.125.136.109:587
This is the error coming now.
planetz
3-Aug-16 1:07am
View
I have tried various examples as per your suggestion with gmail. Every time it says "the remote name could not be resolved". When I try pinging gmail.com it says request timed out. Server is in intranet. Could that be a problem?
planetz
2-Aug-16 6:47am
View
Also I would like to inform that the server is in intranet network.
planetz
2-Aug-16 6:33am
View
Is there any other option?? I will try if there is. I am now trying to send mail using gmail. But it is giving time out error.
planetz
2-Aug-16 5:46am
View
After giving permissions, the old error is gone. Now this error is coming:
Retrieving the COM class factory for component with CLSID {0006F03A-0000-0000-C000-000000000046} failed due to the following error: 80010001 Call was rejected by callee. (Exception from HRESULT: 0x80010001 (RPC_E_CALL_REJECTED)).
planetz
2-Aug-16 5:25am
View
I want to send a mail to user when user clicks a button. That's all. If there is any other way apart from outlook, I'll be glad to try it.
planetz
2-Aug-16 5:05am
View
I have given full permission to iis users from outlook command button control properties in DCOM config, as I saw in another solution. But still it is not working. I am not aware of restrictions of sending mail over web. It is working fine in debugging mode.
planetz
28-Jul-16 4:59am
View
wow!!it is working now...!!
planetz
28-Jul-16 2:35am
View
hey...i tried the code again.
it is giving two errors:
1. Uncaught ReferenceError: $ is not defined on " $(function () {" line.
2. GET http://localhost:12345/jquery.js on "<script src="jquery.js"></script>"
planetz
27-Jul-16 1:38am
View
I have thought of this process and it worked. A little lengthy though..It would have to be from code behind since placeholders have variable values.
planetz
26-Jul-16 7:51am
View
checked the demo....this is exactly what i wanted... i will go through your demo again and check my own code and revert....
planetz
26-Jul-16 7:21am
View
it is not working..!
planetz
26-Jul-16 7:04am
View
Let me explain. Suppose on gridview databind there are 3 textboxes in three rows. One has value 3 and other two NA. These values are put while rowdatabound event. Now if a user clicks on textbox containing 3 then 3 will disappear and textbox will be clear to enter new value. If user clicks out of textbox then old value i.e 3 will appear again. So if the user is not interested in changing value, old value will be submitted. In short, user can submit either NA or any number.
planetz
26-Jul-16 6:49am
View
actually the user needs to enter value. But default value is NA or values they have entered previously. Now if a user clicks a textbox then it should get clear for him to enter data. Else the old value will be back.
planetz
22-Jul-16 2:22am
View
Deleted
Can you help me with the query in getting the opposite of this??
Where output will be employees and score where mn1 is not their manager??
I have managed to get the output but only for emps who has score.
SELECT UD.EMPNAME, US.SCORE
FROM TABLE1 UD LEFT JOIN TABLE2 US
ON UD.EMP=US.EMP
WHERE US.MNGRID = 'mn1' AND NOT UD.MNGRID ='mn1'
planetz
22-Jul-16 1:33am
View
Thank you so much...!!
planetz
21-Jul-16 7:45am
View
It worked now!!! Thank you...!! Don't know why there was error before. Must be something I missed..!!
planetz
21-Jul-16 7:37am
View
There are multiple conditions. I want the data where manager is mn1 also.
planetz
21-Jul-16 1:02am
View
The live demo link that you shared is exactly what I want. Need help with the .css files and in this line:
<input class="easyui-combotree" data-options="url:'tree_data1.json',method:'get'" style="width:100%">
planetz
1-Jul-16 0:45am
View
I changed default settings of project to 32 bit in IIS. Now it is working. It is a 'bit' issue.
planetz
30-Jun-16 5:55am
View
will it work for 2013?? I installed this only. Still not working.
planetz
30-Jun-16 4:23am
View
still it is not working..!! I installed Microsoft Access Database Engine 2010 Redistributable also.....
planetz
23-May-16 1:46am
View
I removed cache and passed the values to jquery function that calls the service. Now it works..!
planetz
23-May-16 0:29am
View
I am sorry! I am not aware of such thing for cache. Thank you for the information..!! Actually I have never used service before and what I was basically trying to do was to apply excel autofilter in gridview. The example I followed used service. If there is any other solution to implement the same without service, I will be very happy to accept it.
This is the site I referred:
http://www.dotnettwitter.com/2012/08/filtering-on-each-column-in-gridview-as.html
planetz
23-May-16 0:24am
View
Hi, I'm afraid this is not what I asked. The data needs to be transferred to a service file (.svc).
planetz
19-May-16 7:37am
View
thanks...!!
planetz
19-May-16 7:20am
View
I have posted the solution code in previous reply.
planetz
19-May-16 7:20am
View
I use the following way: initially visibility of all columns is true.
gv.DataSource = ds.Tables[0];
gv.DataBind();
gv.Columns[7].Visible=false;
Now its working...
planetz
19-May-16 7:09am
View
still only the header is visible!!
planetz
19-May-16 6:34am
View
this is rendering an empty column in the middle since there are columns after that column also. Actually, the header is appearing, but the rows are rendering properly
planetz
6-May-16 2:57am
View
Thanks..!! You made me check web.config once again..!! :-)
planetz
6-May-16 0:52am
View
the one which is running http://localhost:1609/Service1.svc/data?ColumnName=FNAME gives some id and value pairs on the web page.
the one which is not running http://localhost:61832/Service1.svc/data?ColumnName=FNAME is not giving that output...
Also on running the service page directly for the 'good' project redirects automatically to the .aspx page that uses it. While running .svc file from 'bad' project says "You have created a service. To test this service, you will need to create a client and use it to call the service. You can do this using the svcutil.exe tool from the command line with the following syntax:
svcutil.exe http://localhost:61832/Service1.svc?wsdl
This will generate a configuration file and a code file that contains the client class. Add the two files to your client application and use the generated client class to call the Service."
planetz
4-May-16 7:56am
View
yes...the one which is giving error...
planetz
6-Apr-16 7:35am
View
My mistake..!! I didn't unlock all the cells first..now it works..!!
planetz
4-Apr-16 5:44am
View
got it..!!
planetz
4-Apr-16 5:32am
View
Yes, it does... :-)
planetz
4-Apr-16 5:24am
View
For now, I have thought of and implemented a second way and it is working fine. I just looped through the excel rows and created html table rows accordingly on the fly. I will post the code, if it helps someone. And I will surely go through your hint. Thanks once again.
planetz
4-Apr-16 0:03am
View
Thank you Farono....!! It was an error I should have understood..!! Now it's gone but anyway the excel range is not getting pasted yet. So I am not marking your solution as answer because it may mislead users, since question was to paste excel range in outlook mail body.
planetz
31-Mar-16 6:45am
View
Thank you Karthik...!!
planetz
31-Mar-16 6:25am
View
nope...they are demo data and I typed them in manually....
planetz
31-Mar-16 5:55am
View
i modified the query like this:
SELECT [NAMES] FROM CRC WHERE [STATUS]='<div>to</div>'
now, data is getting retrieved but wrapped in <div> tag..!!
Now I am replacing the tags with replace method. Though it is working, it is a very poor way to do so. Help needed.
planetz
31-Mar-16 5:51am
View
all the rows and all the columns
planetz
31-Mar-16 5:50am
View
I tried selecting * from table and found that whatever data it is retrieving is wrapped in <div> tag..is there anything different in access with C#.net?
planetz
31-Mar-16 5:48am
View
hi Karthik...I took up your suggestion of running query removing filter... surprisingly the data is wrapped in <div> tags..!! Like this
<div>abc@xyz.com</div>
planetz
31-Mar-16 5:44am
View
thank you Sitecore for answering..yes, I tried running the query in query design in pass through. While running it asks for DNS connection and after creating and trying to use same gives this error - "you cannot use odbc to import from export to or link an external microsoft access or isam database table to your database"..got another problem there..i chose MS Access driver for DNS setup....
planetz
19-Oct-15 2:03am
View
well...its not working...!!
planetz
19-Oct-15 1:53am
View
ok..i got it...
planetz
19-Oct-15 1:50am
View
what is meant by point no 5 & 6??
5. Run the devenv /InstallVSTemplates switch;
6. Run the devenv /Setup switch
planetz
16-Sep-15 6:34am
View
Well it says object expected...any idea what object can be missing??
planetz
16-Sep-15 5:43am
View
I'll follow your suggestion Andy...
planetz
3-Sep-15 2:49am
View
Yes RyanDev...I am expecting September 2...
planetz
26-Aug-15 0:58am
View
i am using System.Data.OracleClient. Problem is now solved.
planetz
16-Aug-15 14:21pm
View
Hello Mika,
What I wanted to do is connect this procedure to dropdownlist at design time through sqlDataSource to show the dept name in the drop down. Just for practice. But there is no option to include function. Is there any way to create procedure for same?
planetz
26-Mar-15 8:31am
View
Hi Richard,
Thanks for your reply. But I am using oracle client 9.2.0 which is greater than 8.1.7. Still it is saying to use something else. And debugging is fine.
planetz
23-Jul-14 6:19am
View
it was a great help indeed...thank you so much!!
planetz
23-Jul-14 6:18am
View
thank u for explaining what it meant.....:-)
planetz
3-Jun-14 3:41am
View
Thank you so much!!! It worked...
planetz
24-Apr-14 14:12pm
View
I tried everything..nothing works...!!
planetz
24-Apr-14 12:19pm
View
i started the project from file--> new website...can that be a problem?
because when i made a console application from file---> new project, i can change the platform there and it runs fine...but for website only CPU is there and no new platform can be created!!
planetz
24-Apr-14 12:16pm
View
turning enable 32 bit application true or false in application pool is not helping....
planetz
19-Apr-14 10:26am
View
there is a big list in application pool...how to know which is for my project??
planetz
31-Mar-14 3:04am
View
Hi...I would like you to know that when I am creating project, I can create new platform in config manager and can add x64 in dropdown and the code runs fine...but when creating website create new platform checkbox is disabled and so solution can't be run....any suggestion/idea why is this happening?
planetz
30-Mar-14 0:48am
View
http://i61.tinypic.com/2b5dzs.png
Here is the link of screenshot...
And when I am trying to create new platform, the create new solution platform checkbox is not getting enabled....
http://tinypic.com/view.php?pic=2v3kl84&s=8#.UzehrfmSzBB
Was there something to be done during the installation process??
planetz
29-Mar-14 9:20am
View
How can I add a screenshot here?? Then I can show you the dropdown list....
planetz
29-Mar-14 0:11am
View
I am using professional edition....the drop down only has Any CPU option..nothing else...how can I select anything else then?
planetz
28-Mar-14 13:18pm
View
http://msdn.microsoft.com/en-us/library/ms228844(v=vs.90).aspx
this link here says in point 5: "Make sure the Create new project platforms check box is selected. If not, you will have to manage and add the configuration files, any platform dependent code that the wizard can generate for you, and other project files such as resources."
Now in my case the Create new project platforms check box is disabled...also from where can I get the resources??
planetz
28-Mar-14 12:47pm
View
I have checked it...it is running on 'Any CPU'.....but I do not have any option to change it to x64 or x86...that is my problem....and I cannot add them also....
planetz
27-Mar-14 10:32am
View
hi...I could not find any other way so I went with the replace procedure..now insertion can be done without error...but updating a field takes double value..like...if a text box has dog and it has to be updated to cat then updated value is taking 'dog,cat'.....any suggestion for that?
planetz
25-Mar-14 7:20am
View
yes..that is the insertion query....no problem in that...
yes I can replace comma with blank space but when there many text boxes, there will be many replacements...I want to avoid that....
planetz
24-Mar-14 9:32am
View
thank u.....
planetz
19-Mar-14 0:28am
View
Okk...it means I have client installed...now how can I connect oracle 12c to excel 2013?
planetz
18-Mar-14 7:23am
View
no I didn't...I have the database in my machine only...so...I used oracle 10g in office 2010...but then I didn't need to install any client..it worked fine with the above code...can you please tell me why will I need it and how to get the software? thank you...
planetz
17-Mar-14 8:49am
View
This is my code...
<pre lang="vb">
Dim conn As New ADODB.Connection
conn.Open "DRIVER={MICROSOFT ODBC FOR ORACLE};uid=xyz;pwd=x123".</pre>
And these are references used:
Visual Basic for Applications
MS Excel 15.0 Objct Lib
MS Office 15.0 Objct Lib
Ole Automation
MS Active Data Objects 2.0 Lib
planetz
25-Jan-14 3:08am
View
yes it is redirecting....changed only in master page....thank you
planetz
25-Jan-14 1:00am
View
yes template is designed using html and css....so links are also html....i want to replace links with aspx links
planetz
25-Jan-14 0:53am
View
should i change it in index.html as well?
planetz
25-Jan-14 0:01am
View
you added mode="hold" in div....what does that mean?
planetz
24-Jan-14 23:57pm
View
can you just explain 'mode'?
planetz
12-Dec-13 6:01am
View
yes i have used them already...but they are for editing operations....am talking about displaying gridview in editable mode on clicking button....
planetz
12-Dec-13 6:00am
View
i didnt bind it twice...they are two different cases...one works...one doesnt...
planetz
30-Jul-13 9:24am
View
i hav a question.....
is it necessary to add all columns from the source sheet?? or can selected columns be used??
Show More