15,904,156 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 Javascript questions
View Visual Basic questions
View Python 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 TAUSEEF KALDANE (Top 41 by date)
TAUSEEF KALDANE
19-Jul-18 22:46pm
View
Hi Friend, Thanks for the explanation. Do we need to change the connection code as we start working on openvpn or the existing code will work fine? For desktop application
TAUSEEF KALDANE
18-Jul-18 23:24pm
View
Friend, I don't have idea about openvpn?? What are pros and cos?? And how do we use that??
TAUSEEF KALDANE
18-Jul-18 23:22pm
View
But web service should be hosted publicly to access the same.
TAUSEEF KALDANE
28-Sep-15 5:42am
View
yes, but it didn't display images
TAUSEEF KALDANE
26-Aug-15 7:37am
View
Sir, it works. Thank you sir
TAUSEEF KALDANE
26-Aug-15 7:05am
View
No Sir, i tried ur query and it is also throwing errors as follows
1. Msg 8155, Level 16, State 2, Line 5
No column name was specified for column 1 of 'a'.
2. Msg 1038, Level 15, State 5, Line 1
An object or column name is missing or empty. For SELECT INTO statements, verify each column has a name. For other statements, look for empty alias names. Aliases defined as "" or [] are not allowed. Change the alias to a valid name.
TAUSEEF KALDANE
25-Jun-15 8:03am
View
No, i have visited on this site for opc technology.
http://www.codeproject.com/Articles/12441/OPC-Technology
http://www.codeproject.com/Articles/1135/OPC-and-NET-with-COM-Interoperability
etc
TAUSEEF KALDANE
1-Jun-15 7:32am
View
Sir, I don't want any permission from u. I have decided to go for java for my career but I want to some comparisons between java and .net for compatibilty
TAUSEEF KALDANE
18-Feb-15 4:45am
View
Sir, i tried it but didn't work
TAUSEEF KALDANE
12-Dec-14 2:48am
View
thank you sir, your solution has worked properly.
TAUSEEF KALDANE
12-Dec-14 2:16am
View
Sir, Please tell me how to convert excel file to byte array?
TAUSEEF KALDANE
12-Dec-14 1:31am
View
there are multiple datasets writing in excel file... nd then 4 datasets for graph.... file is saving at particular location on server using worksheet.SaveAs(FilePath). We want to make it downloadable to any machine.
TAUSEEF KALDANE
9-Dec-14 5:00am
View
i wanted to get data in graph from SQL Database directly. i don't want to display source table values into excel. is it possible?
TAUSEEF KALDANE
27-Oct-14 6:24am
View
i got following error
Msg 8164, Level 16, State 1, Procedure SP_Firstdistil, Line 174 An INSERT EXEC statement cannot be nested
TAUSEEF KALDANE
13-Oct-14 4:21am
View
i need to transfer data between two servers through sql query and it has to update automatically after every 1 hour
TAUSEEF KALDANE
3-Sep-14 6:44am
View
sir,
i can't use sp_executesql due to open query. it started throwing errors
TAUSEEF KALDANE
3-Sep-14 6:38am
View
i want the value for further calculations.
TAUSEEF KALDANE
3-Sep-14 6:29am
View
i had used sp_executesql but it didn't work.
TAUSEEF KALDANE
28-Aug-14 6:16am
View
or sir you can provide me some good links that i can get idea about embedded and robotics
TAUSEEF KALDANE
28-Aug-14 6:12am
View
i had googled but i want some basic knowledge of embedded and robotics
TAUSEEF KALDANE
28-Aug-14 2:46am
View
thank you sir
TAUSEEF KALDANE
19-Aug-14 6:04am
View
thank you vinay sir
TAUSEEF KALDANE
19-Aug-14 6:04am
View
thank you sir
TAUSEEF KALDANE
19-Aug-14 5:13am
View
how to use query analyzer ?
TAUSEEF KALDANE
19-Aug-14 5:12am
View
sir i have also tried it without group by clause as follows.
declare @month int
declare @year int
set @month=8
set @year =2014
declare @startdate datetime
declare @enddate datetime
set @startdate=CONVERT(datetime,convert(varchar,@year)+'-'+convert(varchar,@month)+'-'+'01')
if (@month>= MONTH(GETDATE()) and @year>=YEAR(GETDATE()))
begin
set @enddate=(select GETDATE())
end
else
begin
set @enddate=DATEADD(day,-1,DATEADD(month,1,@startdate))
end
create table #thick
(
[date] datetime,
alumina decimal(18,5),
caustic decimal(18,5),
ratio decimal(18,5),
fsfalumina decimal(18,5),
fsfcaustic decimal(18,5),
fsfratio decimal(18,5),
nt_6o decimal(18,5),
nt_6u decimal(18,5),
nt_6_density decimal(18,5),
nt_6_solid decimal(18,5),
sodagpldms1 decimal(18,5),
soliddms1 decimal(18,5),
mudmgpldms2 decimal(18,5),
sodagplpfdms2 decimal(18,5),
solidpfdms2 decimal(18,5),
gplsodae1 decimal(18,5),
phe1 decimal(18,5),
nt_2s3 decimal(18,5),
pglmudp1 decimal(18,5),
ofmgplp2 decimal(18,5),
densityp3 decimal(18,5),
solidp3 decimal(18,5),
hrddensityh1 decimal(18,5),
hrdsolidh1 decimal(18,5),
ufdensityh1 decimal(18,5),
ufsolidh1 decimal(18,5),
mudp4 decimal(18,5),
ntu1density decimal(18,5),
ntu1soda decimal(18,5),
ntu1solid decimal(18,5),
ntu2density decimal(18,5),
ntu2soda decimal(18,5),
ntu2solid decimal(18,5),
ntu3density decimal(18,5),
ntu3soda decimal(18,5),
ntu3solid decimal(18,5),
ntu4density decimal(18,5),
ntu4soda decimal(18,5),
ntu4solid decimal(18,5),
ntu5density decimal(18,5),
ntu5soda decimal(18,5),
ntu5solid decimal(18,5),
ntu6density decimal(18,5),
ntu6soda decimal(18,5),
ntu6solid decimal(18,5),
nto1soda decimal(18,5),
nto2soda decimal(18,5),
nto3soda decimal(18,5),
nto4soda decimal(18,5),
nto5soda decimal(18,5),
nto6soda decimal(18,5)
)
while (@startdate<=@enddate)
begin
insert into #thick
select * from (
select
@startdate as [date],
isnull(AVG(s1.alumina),'') as alumina,
isnull(AVG(s1.caustic),'') as caustic,
isnull(AVG(s1.ratio),'') as ratio,
isnull(AVG(s2.alumina),'') as fsfalumina,
isnull(AVG(s2.caustic),'') as fsfcaustic,
isnull(AVG(s2.ratio),'') as fsfratio,
isnull(AVG(l1.nt_6o),'') as nt_6o,
isnull(AVG(l1.nt_6u),'') as nt_6u,
isnull(AVG(l2.density),'') as nt_6_density,
isnull(AVG(l2.solid),'') as nt_6_solid,
isnull(AVG(d1.sodagpldms),'') as sodagpldms1,
isnull(AVG(d1.soliddms),'') as soliddms1,
isnull(AVG(d2.mudmgpl),'') as mudmgpldms2,
isnull(AVG(d2.sodagplpf),'') as sodagplpfdms2,
isnull(AVG(d2.solidpf),'') as solidpfdms2,
isnull(AVG(e1.gpl_soda),'') as gplsodae1,
isnull(avg(e1.ph),'') as phe1,
isnull(AVG(s3.nt_2),'') as nt_2s3,
isnull(AVG(p1.pglmud),'') as pglmudp1,
isnull(AVG(p2.ofmgpl),'') as ofmgplp2,
isnull(AVG(p3.density),'') as densityp3,
isnull(AVG(p3.solid),'') as solidp3,
isnull(AVG(h1.hrddensity),'') as hrddensityh1,
isnull(AVG(h1.hrdsolid),'') as hrdsolidh1,
isnull(AVG(h1.ufdensity),'') as ufdensityh1,
isnull(AVG(h1.ufsolid),'') as ufsolidh1,
isnull(AVG(p4.mud),'') as mudp4,
isnull(AVG(tu1.density),'') as ntu1density,
isnull(AVG(tu1.soda),'') as ntu1soda,
isnull(AVG(tu1.solid),'') as ntu1solid,
isnull(AVG(tu2.density),'') as ntu2density,
isnull(AVG(tu2.soda),'') as ntu2soda,
isnull(AVG(tu2.solid),'') as ntu2solid,
isnull(AVG(tu3.density),'') as ntu3density,
isnull(AVG(tu3.soda),'') as ntu3soda,
isnull(AVG(tu3.solid),'') as ntu3solid,
isnull(AVG(tu4.density),'') as ntu4density,
isnull(AVG(tu4.soda),'') as ntu4soda,
isnull(AVG(tu4.solid),'') as ntu4solid,
isnull(AVG(tu5.density),'') as ntu5density,
isnull(AVG(tu5.soda),'') as ntu5soda,
isnull(AVG(tu5.solid),'') as ntu5solid,
isnull(AVG(tu6.den
TAUSEEF KALDANE
18-Aug-14 2:39am
View
i have already tried it but i want to pass month and year to query
TAUSEEF KALDANE
3-Jul-14 1:39am
View
yes sir i checked and it is correct. but i want application to be hosted on dynamic ip provided by router to server machine. plz help
TAUSEEF KALDANE
2-Jul-14 2:27am
View
i used machine name but it thows me an error as follows
HTTP Error 500.0 - Internal Server Error
Calling LoadLibraryEx on ISAPI filter "C:\Windows\Microsoft.NET\Framework\v4.0.30319\aspnet_filter.dll" failed
TAUSEEF KALDANE
27-Jun-14 2:28am
View
sir i got the solution,
i deleted old web.config file and then add new config file and now it is working properly.
TAUSEEF KALDANE
27-Jun-14 1:03am
View
i tried this but getting same error plz help me
TAUSEEF KALDANE
26-Jun-14 8:34am
View
how would i know about whether i m running application in cluster/Webform or not.
TAUSEEF KALDANE
2-Jun-14 8:04am
View
actually i already added runat= "server" but it doesn't work
TAUSEEF KALDANE
22-May-14 7:13am
View
yes rohan u r right
TAUSEEF KALDANE
11-Apr-14 4:37am
View
but how do i use that control in wpf?
TAUSEEF KALDANE
29-Mar-14 3:25am
View
i means that a code-behind file(.aspx.cs) is used to process page and http handler is used to process page? then can we say that a code-behind file is httphandler?
TAUSEEF KALDANE
11-Mar-14 5:52am
View
it gives only minute wise data. It should give data occurred whithin 10 minutes of interval
TAUSEEF KALDANE
1-Mar-14 0:00am
View
thank u very much...................
TAUSEEF KALDANE
24-Feb-14 23:19pm
View
thank u.........................
TAUSEEF KALDANE
24-Feb-14 23:18pm
View
Thank u...................
TAUSEEF KALDANE
17-Feb-14 4:01am
View
and how do i refer this key in another table?
how do i create foreign key by referring this primary key?
TAUSEEF KALDANE
15-Feb-14 5:16am
View
is webmail-lite used to create app?
Show More