Click here to Skip to main content
15,068,168 members

Comments by hareshdgr8 (Top 147 by date)

hareshdgr8 20-Jul-20 1:18am View
sir i want all combination and want one code ORG62 that's why using AND not using OR in query

I have combination value

(SubCate_Id='2' and SubCate_Value='HNBR') and (SubCate_Id='1' and SubCate_Value='10') and (SubCate_Id='4' and SubCate_Value='1.74') and (SubCate_Id='3' and SubCate_Value='10.10') and (SubCate_Id='5' and SubCate_Value='Black') with this combination all have one Item Code i.e. ORG62
hareshdgr8 18-Jul-20 9:11am View
sir i have one table that contains one itemcode and that item code have different parameter I want to fetch item code using multiple parameter like as below

Code Cate_Id SubCate_Id SubCate_Value
ORG62 2 2 HNBR
ORG62 2 1 10
ORG62 2 4 1.74
ORG62 2 3 10.1
ORG62 2 5 Black

ORG63 1 2 HNBR
ORG63 1 1 10
ORG63 1 4 1.74
ORG63 1 3 10.1
ORG63 1 5 Black

sir, I want ORG62 code using the above query what I can do sir...

sir MY CATE 2 and 1 but can upload as per database design
hareshdgr8 18-Jul-20 2:10am View
sir in external software i just pass data like
insert into Invoice_Details(Inv_date,Customer_Name) values('2020-07-17','HARESH');

What is wrong sir...

Please tell me if any idea.

Thank you for your reply.
hareshdgr8 12-Jul-20 7:28am View
but every time you always help me sir thank you so so much for your instant help...
hareshdgr8 12-Jul-20 7:22am View
Sir, you are great i installed x86 .. thank you for supporting...
hareshdgr8 12-Jul-20 6:48am View
ok sir ill try thanks for reply.
hareshdgr8 12-Jul-20 6:39am View
sir i cant find ARM64 in my application how can I do it can you please tell me thanks for instant reply
hareshdgr8 27-Apr-20 10:16am View
sir mysql i am using 5.6 Version and connector mysql-connector-java-8.0.19
hareshdgr8 27-Apr-20 7:48am View
No Sir I Can Pass Value
When I Use Your Method Error Remain Same Sir
hareshdgr8 6-Apr-20 8:08am View
Exec is in SQL not in MYSQL sir
I read sir about SQL Injection
If I need to pass two Parameter but if i dont want to use first parameter then how i can do it like

Country_No int,Country_Name some time i dont want to use Country_No then how should i write mysql store Procedure
hareshdgr8 6-Apr-20 7:48am View
sqlQuery does not exist getting this issue sir
hareshdgr8 5-Mar-20 4:10am View
no sir while using declare @castparm date = CAST(@parm + '-01' as DATE) -- results in 2020-01-01 it give me only 1 date of data not whole month data like month of jan data
hareshdgr8 4-Mar-20 22:38pm View
2019-09-11 00:00:00.000
2019-09-12 00:00:00.000
2019-09-14 00:00:00.000
2019-09-15 00:00:00.000
2019-09-16 00:00:00.000
2019-09-17 00:00:00.000
2019-09-18 00:00:00.000
2019-09-19 00:00:00.000
2019-09-20 00:00:00.000
2019-09-21 00:00:00.000
2019-09-22 00:00:00.000
2019-09-23 00:00:00.000
2019-09-24 00:00:00.000
2019-09-25 00:00:00.000
2019-09-26 00:00:00.000
2019-09-27 00:00:00.000
2019-12-19 00:00:00.000
2019-12-20 00:00:00.000
2019-12-22 00:00:00.000
2019-12-23 00:00:00.000
2020-01-03 00:00:00.000
2020-01-04 00:00:00.000
2020-01-06 00:00:00.000
2020-01-07 00:00:00.000
2020-01-08 00:00:00.000
2020-01-09 00:00:00.000
2020-01-31 00:00:00.000
2020-02-01 00:00:00.000
2020-02-06 00:00:00.000
2020-02-07 00:00:00.000
2020-02-08 00:00:00.000
2020-02-17 00:00:00.000
2020-02-25 00:00:00.000
2020-03-01 00:00:00.000
2020-03-02 00:00:00.000

This is my data i want jan month data as well as i want before jan month data both case need to fire same query what can i do sir
my parameter is Month/Year i.e. 01/2020 so i want "=01/2020" or "<01/2020"
hareshdgr8 4-Mar-20 8:54am View
Sir If i want full month data then please help thats why its not working...
hareshdgr8 4-Mar-20 8:07am View
sir if i want full month data then this will not work at any more thats why i am just passing month and year only and my Field Perf_Date is datetime datatype
hareshdgr8 4-Mar-20 7:13am View
solution 3 is wrong sir that was my previous solution but not work properly no. of records not match with this .
hareshdgr8 4-Mar-20 7:11am View
sir still you not understand where i can pass this value CAST('2020-01-01' AS DATE)
i have only Year and Month like 2020-01
hareshdgr8 4-Mar-20 7:08am View
okay sir can you please reply my query in Solution #5
hareshdgr8 4-Mar-20 7:06am View
here if i want before 2020-01 data i dont have date sir where should i transfer because i want same month data as well as before month data also using single query that i want to use.
hareshdgr8 4-Mar-20 6:57am View
Otherwise sir please suggest me more solution
hareshdgr8 4-Mar-20 6:53am View
no sir from this got result properly..
hareshdgr8 4-Mar-20 6:49am View
please check my solution sir I found from google and i applied no issue got perfect result
hareshdgr8 4-Mar-20 1:01am View
i have sir only month and year how can i fix this
hareshdgr8 4-Mar-20 0:54am View
reject because as per google said that never convert date field
hareshdgr8 4-Mar-20 0:32am View
sir not getting proper data as per mine it should give me 49 records and for this query giving me 20 records only because the format will convert date into a string
hareshdgr8 3-Mar-20 9:43am View
no sir getting wrong output still this
hareshdgr8 3-Mar-20 9:39am View
Getting Wrong Output .. with this sir...
hareshdgr8 3-Mar-20 9:22am View
sir i dont know about day date only i get month and year value from other source
hareshdgr8 3-Mar-20 9:12am View
sir how can i do if i want same code just need to change less then sign or other can you provide me
hareshdgr8 20-Feb-20 2:31am View
sir for your above query i am using like this SELECT * FROM MyTable WHERE StreetAddress = 'Baker''s Wood'. I m using double single quote insted of single it will auto replace my application so wont get any issue if some one pass this type of issue sir any other hint or help can you please provide me its greate help to me ...

Whenever you help me every time it works sir ... please help me more about this issue.

Waiting sir..
hareshdgr8 10-Feb-20 5:25am View
yes sir actually as per them and my query both are diff. in stage because i just want to sent tray name with printing crystal report as per client selection.
hareshdgr8 10-Feb-20 5:09am View
ohh that i dont know actually while typing my caps lock is on sir thats why i dont know about this thing sorry if you feel i am shouting...
sir could you please reply me about my query if you know answer ...

please help me out sir..
hareshdgr8 10-Feb-20 4:58am View
no sir i am not shouting sir.. i am just telling you that i did this way sir...
please dont take me wrong sir...
hareshdgr8 10-Feb-20 2:50am View
hareshdgr8 7-Feb-20 22:48pm View
Datasource is used to set data table value into crystal report rpt is object of crystalreport file "dim rpt as new cryName"
hareshdgr8 7-Feb-20 4:37am View
sir it only giving me an error like "Load Report Failed" but after some time i run it work perfectly dont know what is the issue.
hareshdgr8 7-Feb-20 4:35am View
it contains with Customer Name, Phone No., Email Id , Other Comments
hareshdgr8 7-Feb-20 4:35am View
sir try-catch is properly just here copy paste remaining
hareshdgr8 3-Feb-20 5:47am View
sir u are right that i want to use left outer join thank you for your hint sorry to late reply ....
hareshdgr8 1-Feb-20 7:08am View
sir can't use join because some time other table dont have product details in it we have to fetch one by one only there is only the way...
example Some product not in GRN and in Credit note there is same product thats why using too much select ... JOIN is FAIL in my scenario ....

help me more if you got my point sir
hareshdgr8 1-Feb-20 5:14am View
ok sir
hareshdgr8 15-Jan-20 9:37am View
sir i checked but my regional setting is perfect sir if its is not perfect then my othere why my othere date not changed i cant understand help me where i am wrong ... if i enter same with sapec and after that i enter value it take perfect like ExcelApp.Cells(j, k + 1) = " " & Format(Date.Parse(frmReportWizard.dgvData.Item(l, i).Value.ToString), "dd/MM/yyyy hh:mm:ss")
after this excel not change my format why sir i dont know but i found this answer by my own way.. :-)
hareshdgr8 15-Jan-20 9:28am View
sir did but same issue why its happen dont know help in anotherway if you found any other answer
hareshdgr8 14-Jan-20 8:05am View
sir is there any other way that you can help sir.. please
hareshdgr8 14-Jan-20 7:59am View
ExcelApp.Cells(j, k + 1) = Format(Date.Parse(frmReportWizard.dgvData.Item(l, i).Value), "dd/MM/yyyy hh:mm:ss")
sir i changed this but no effect
hareshdgr8 25-Apr-19 4:41am View
Thank You for your help ...
Sir... :-)
hareshdgr8 25-Apr-19 4:40am View
THis is work for me but not sure how much right but thank you for your help ...
hareshdgr8 25-Apr-19 2:58am View
no sir same error

Incorrect syntax near '='.
hareshdgr8 25-Apr-19 1:49am View
no sir same getting error over CalStatu1='Done' and CalDis='Pending'

Hide   Copy Code
Incorrect syntax near '='.
hareshdgr8 12-Dec-17 8:09am View
do you have some link please reply me with link
hareshdgr8 12-Dec-17 7:30am View
sir please visit that link ...
hareshdgr8 23-Jan-17 7:39am View
how can i use 20B9 acutally i am sending printer to byte code so how can i do it please help me i am new in this area

please help me
hareshdgr8 26-Aug-16 5:31am View
sir i am getttin gerror on line

TextView tId = (TextView) l.getChildAt(0);

when i read count of lv.getChildCount() it returns 14 but I have total 16 Rows in Listview what is problem didn't get it .... please help me
hareshdgr8 16-Feb-16 8:04am View
okey sir ill check and reply you.
hareshdgr8 16-Feb-16 8:01am View
sir I don't want drag and drop I want if I click on button then 2nd column apper 1 and 1st column apper on 2nd side.

Thank you for trying to resolve my problem
hareshdgr8 9-Dec-15 8:28am View
thank you so much
hareshdgr8 8-Dec-15 0:58am View
but while I am running this api via script I got response then what is problem ...
hareshdgr8 7-Dec-15 8:00am View
Not Usefull sorry sir :-(
hareshdgr8 7-Dec-15 4:54am View
sir I refer that link but didn't work for me and first link is in php not in java I need in java please help me

sir other link is not helpfull
hareshdgr8 5-Sep-15 4:41am View
Sir you already help me with previous question answer thank you so much

Mika Wendelius
hareshdgr8 5-Sep-15 4:09am View
sir my mistake thank you so much .......
hareshdgr8 5-Sep-15 4:07am View
sorry didn't work sir please check it.
hareshdgr8 5-Sep-15 3:42am View
Sir cannot use this type because User Enter SFH6 this is not fixed word that we can split with SFH and Number 6 is different, User will enter SFH6 please Update me and Please help me I am stuck over here....
hareshdgr8 2-Sep-15 9:22am View
Can You instruct me is this query is okey

SELECT column from table where contains(column,'NEAR(SFH630),2,TRUE)');
hareshdgr8 30-Jul-15 4:28am View
Thank you sir for your help thank you so much...... :-)
hareshdgr8 30-Jul-15 4:17am View
sir this is not usefull because i have only time

StartTime = 11:10:25;
EndTIme = 11:20:45;

just get to know i do i get Time Difference

Please Help me i stuck over here...
hareshdgr8 9-Jul-15 0:45am View
i need to do URL MAPPING...
hareshdgr8 16-May-15 1:52am View
I never understand how to use github code
hareshdgr8 2-May-15 4:38am View
i already had this... :-) thank you....
hareshdgr8 3-Apr-15 4:42am View
sir i have link that contain webservices and i have to use that web services and get xml file so how can i use it...
hareshdgr8 3-Feb-15 5:26am View
sir, I restart java application same error occurred every time I have to restart MySQL Service and upto 5-10 min it work perfectly, after 5-10 min same problem exists.
hareshdgr8 3-Feb-15 4:38am View
not understand can you please explain me in depth
hareshdgr8 29-Jan-15 6:08am View
thank you I will check it....
hareshdgr8 29-Jan-15 5:28am View
sir can you tell me can I update cookies value by javascript and how can I create cookies and use in another page please help me I stuck.
hareshdgr8 29-Jan-15 5:25am View
sir where I write this code in javascript.
hareshdgr8 19-Jan-15 6:55am View
I tried AxSkype1.CreateGroup("GROUPNAMe") but didn't reflect
hareshdgr8 26-Dec-14 10:04am View
hareshdgr8 24-Dec-14 2:24am View
i go throught from that but there is some problem
hareshdgr8 24-Dec-14 2:13am View
i tried but same problem exists anyways do have any idea of my question.
hareshdgr8 24-Dec-14 1:16am View
I need trigger in MySQL when I write in subject MySQL, code project give me error
hareshdgr8 24-Dec-14 0:50am View
sorry I didn't check this answer I was not in place.. thank you for every one help
hareshdgr8 5-Nov-14 1:15am View
sir I want the side by side. please help me..
hareshdgr8 10-May-14 2:56am View
but sir when I open sql server management studio I logged in with windows authentication mode that's why I not included userid and password in connectionstring

Please sir Help me,
Hope for answer ASAP.
hareshdgr8 16-Apr-14 2:37am View
error is type is expected

Dim fromDB As String = "COLOR[RED]"
Dim color As String = fromDB.Split(New () {"["C, "]"C})(1)
Label1.Backcolor = System.Drawing.Color.FromName(color)
hareshdgr8 16-Apr-14 2:36am View
sir give me error please update .
hareshdgr8 16-Apr-14 2:23am View
this code not working sorry..
hareshdgr8 16-Apr-14 2:23am View
actually I have value like Color [RED] and need to apply this color on Label1.BackCOlor
hareshdgr8 16-Apr-14 1:58am View
it give me error what is MAPtoCOLOR please Explain or show me example

Please help me.
hareshdgr8 5-Apr-14 8:12am View
just converting value to string if its not there is no problem but it give me like starting index cannot be more than end index something like this..
hareshdgr8 1-Apr-14 7:24am View
can you please tell me i am using 2005
hareshdgr8 24-Mar-14 4:43am View
how can i use please give me correct example if my code is as follows...

Private Sub frmMail_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
tm_Email.Interval = 600000
End Sub
Private Sub tm_Email_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles tm_Email.Tick
If IsConnectionAvailable() = True Then
tm_Email.Interval = 600000
End if

End Sub
private sub sendMail()
' Mail Code by CLient wise
End sub

Here is my Code please help me
hareshdgr8 24-Mar-14 2:36am View
Private Sub frmMail_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
tm_Email.Interval = 600000
End Sub
Private Sub tm_Email_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles tm_Email.Tick
If IsConnectionAvailable() = True Then
tm_Email.Interval = 600000
End if

End Sub
private sub sendMail()
' Mail Code by CLient wise
End sub

Here is my Code please help me
hareshdgr8 19-Mar-14 8:22am View
Thank You Sir
hareshdgr8 17-Jan-14 1:24am View
i dint get request.getAttribute("txtValue") can't get value on other page so please help me for that........................
hareshdgr8 28-Nov-13 2:36am View
i will sent you code please check it

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
BGW.WorkerReportsProgress = True
BGW.WorkerSupportsCancellation = True
End Sub

Private Sub BGW_DoWork(ByVal sender As System.Object, ByVal e As System.ComponentModel.DoWorkEventArgs) Handles BGW.DoWork
System.Windows.Forms.Control.CheckForIllegalCrossThreadCalls = False

System.Windows.Forms.Control.CheckForIllegalCrossThreadCalls = True

End Sub

Private Sub BGW_RunWorkerCompleted(ByVal sender As System.Object, ByVal e As System.ComponentModel.RunWorkerCompletedEventArgs) Handles BGW.RunWorkerCompleted
If e.Cancelled = True Then
'lblPercent.Text = "Operation Cancelled"
MsgBox("Operation Canceled")
'WorkEventRunning = False
ElseIf e.Error IsNot Nothing Then
'lblPercent.Text = "Failed" 'e.Error.Message.ToString

End If
End Sub
hareshdgr8 13-Nov-13 4:38am View
not proper
hareshdgr8 16-Oct-13 10:12am View
actuall i have controls in flowlayout some controls visible false at run time so i have to auto height my flowlayout and outer panel same as flowlayout height. i dont need scroll bar in flowlayout and panel.

in that panel one Flowlayout and flowlayout contain Buttons
hareshdgr8 30-Sep-13 2:19am View
how to set page orientation on PDF
hareshdgr8 30-Sep-13 2:18am View
how to set page orientation on PDF
hareshdgr8 27-Aug-13 7:04am View
i tried select rate from tablename where qty1>=1 and qty2<=1 but it is wrong i know that . what can i do for this type of query.
hareshdgr8 7-Aug-13 6:06am View
not usable that code.
hareshdgr8 7-Aug-13 5:44am View
sorry. i can't change that value i need to compare 1 row value with another rows and so on and finally get max value of rows no with bgcolor red
hareshdgr8 7-Aug-13 5:39am View
No i have static value whenever i increase that row with values it will check and give me max value of rows with bgcolor red.
please help me i need in using javascript
hareshdgr8 7-Jun-13 3:13am View
Thank You sir for clear my concepts

Thank You very very much....... :-)
hareshdgr8 25-May-13 3:28am View
i want to merge my cells depend upon rows

in first rows
ABC in first cells other cells i have to merge
second rows i don't want to merge cells
hareshdgr8 25-May-13 3:27am View
i want to merge my cells depend upon rows

in first rows
ABC in first cells other cells i have to merge
second rows i don't want to merge cells
hareshdgr8 17-May-13 6:01am View
how to add screenshot there is no option in codeproject
hareshdgr8 23-Apr-13 7:28am View
what is SautinSoft
hareshdgr8 16-Apr-13 9:00am View
i just use my variable like
String strValue="";
strvalue=strvalue & reader(1) & ","
delete from Order_Table where OrderNo not in(strvalue)
hareshdgr8 16-Apr-13 8:54am View
this is not a good idea because if one of the record are not in this than it would be deleted so not a good idea.......
hareshdgr8 16-Apr-13 5:27am View
because except this record all records are useless for me thats why i have to delete......
hareshdgr8 16-Apr-13 4:57am View
sir specially i have to say thank you for every time you help me and out me by problem.
sir actually i have to fire delete query included not in syntax i.e.

delete from Order_Table where OrderNo not in (Above Order No)
hareshdgr8 4-Apr-13 5:11am View
i did it but not solved what i did i am writing code for that whenever my application starts it change data format at dd/MM/yyyy after that same problem occur please tell me what should i do now
hareshdgr8 4-Apr-13 4:57am View
my question is not solved please give me hint to what should i do.
hareshdgr8 4-Apr-13 4:40am View
yes you are right then what i have to do sir.
hareshdgr8 4-Apr-13 4:33am View
if i set datetime datatype in dateValue it also give me same problem in access database.
hareshdgr8 12-Mar-13 1:55am View
my first code is
Label.font=New Font(Segoe, 8, 0)

when i click on my click i give it msgbox like

it show me 8.5
how its possible
hareshdgr8 11-Mar-13 8:44am View
i tried but when i click on that label it give me msg as font is 8.5 size
hareshdgr8 11-Mar-13 6:43am View
sir but i want to add label size as 8 then what
hareshdgr8 13-Feb-13 4:27am View
but there is only single columns where the value has been inserted
hareshdgr8 13-Feb-13 4:25am View
what about for access sir.... OriginalGriff
hareshdgr8 13-Feb-13 4:09am View
but i have only 1500 data and i have to read data from database to crystal report with dynamic image like member photo and company photo in every detail section....
hareshdgr8 24-Dec-12 4:07am View
sir their is no range of files..... :-)
hareshdgr8 24-Dec-12 3:37am View
sir actully file name is in database but without extension and i want to load a file with extension now what can i do ....
hareshdgr8 24-Dec-12 3:09am View
sir actually i have path with file name like this


and i want to file extension of DSC0001 file.
hareshdgr8 24-Dec-12 2:57am View
no sir not working
hareshdgr8 24-Dec-12 2:47am View
yes sir i tried but it can't work it give me blank extension because i have file name only like DSC0001 not a DSC001.txt
hareshdgr8 19-Dec-12 23:59pm View
i m using .net 2005
hareshdgr8 17-Dec-12 0:30am View
wmf,png both are transperent
hareshdgr8 14-Dec-12 2:05am View
sir actually i m using transperent image into my crystal report but whenever i run image isn't transperent. i need to transperent my image dynamically at time of crystal report run my image field is BLOB OBJECT
hareshdgr8 12-Dec-12 0:47am View
sorry sir i didn't have any solution actually some member's are not serious to answer my question if you have time that see that comment of member "ryanb31" and i requested to codeproject please remove the member or deactive that member name as "ryanb31"
hareshdgr8 12-Dec-12 0:40am View
yes sir i am using same computer where i design my crystal report and my font is segeo UI but i m sending font as dynamically to my report what is the problem i didn't get that and my report generate successfully whenever i export crystal to pdf at that time font size will be changed if my font size is 10 then pdf show as like 8
Please Help me

Thank you
hareshdgr8 11-Dec-12 2:36am View
no in visual studio 2005 sir
hareshdgr8 6-Dec-12 4:27am View
please send me code .... :-)
hareshdgr8 6-Dec-12 4:26am View
please send me code .... :-)
hareshdgr8 6-Dec-12 4:26am View
e chodu mal tera idea tere pass rakh
hareshdgr8 1-Dec-12 3:46am View
now is it fine for you or nor?
hareshdgr8 2-Nov-12 1:13am View
i have a 30 labels.... then this code is not perfect....
hareshdgr8 4-Oct-12 6:35am View
Not working for me sir.... i tried but i need this type in mail label report in crystal report
hareshdgr8 4-Oct-12 6:03am View
hey you just looping your single content like use for loop or while loop and match with main string i.e. 1-300,1-300,1-300,1-200,1-200

hareshdgr8 4-Oct-12 5:45am View
no i did my self actually this is last option in my mind ......
hareshdgr8 4-Oct-12 5:45am View
no i do my self actually this is last option i get from my self...
hareshdgr8 26-Jul-12 8:13am View
ok sir :-) Thank you
hareshdgr8 26-Jul-12 4:18am View
your link is meaningless i didn't understood. is it useful for me
hareshdgr8 26-Jul-12 3:41am View
Yes actually client will enter if else condition like in excel we can enter if else statement i have to achieve like that excel things please help me
hareshdgr8 26-Jul-12 3:34am View
nothing i have to do somthing but i am stuck about how to convert to vb editor mode please help me
hareshdgr8 26-Jul-12 3:29am View
nothing i have to do somthing but i am stuck about how to convert to vb edition mode please help me