Comments by hareshdgr8 (Top 148 by date)

Sir, you are great i installed x86 .. thank you for supporting...

ok sir ill try thanks for reply.

sir i cant find ARM64 in my application how can I do it can you please tell me thanks for instant reply

sir mysql i am using 5.6 Version and connector mysql-connector-java-8.0.19

No Sir I Can Pass Value
When I Use Your Method Error Remain Same Sir

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

sqlQuery does not exist getting this issue sir

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

Perf_Date
--------------------------------
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"

Sir If i want full month data then please help thats why its not working...

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

solution 3 is wrong sir that was my previous solution but not work properly no. of records not match with this .

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

okay sir can you please reply my query in Solution #5

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.

Otherwise sir please suggest me more solution

no sir from this got result properly..

please check my solution sir I found from google and i applied no issue got perfect result

i have sir only month and year how can i fix this

reject because as per google said that never convert date field
https://www.brentozar.com/blitzcache/non-sargable-predicates/

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

Getting Wrong Output .. with this sir...

sir i dont know about day date only i get month and year value from other source

sir how can i do if i want same code just need to change less then sign or other can you provide me

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..

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.

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..

no sir i am not shouting sir.. i am just telling you that i did this way sir...
please dont take me wrong sir...

SIR, I JUST SELECT PRINTER NAME FROM PRINTER DIALOGUE AND SELECT TRAY SELECT FROM PAPER SOURCE FROM SAME PRINTER DIALOGUE WHY IT IS NOT PRINTING AFTERWORDS THAT I DONT UNDERSTAND PLEASE HELP ME OUT ABOVE TWO LINK NOW WORK SAP SUPPORT WORK BUT IT won't HELP TO ME BECAUSE I AM DEVELOPER WHO IS USING FREE ONE.

Datasource is used to set data table value into crystal report rpt is object of crystalreport file "dim rpt as new cryName"

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.

it contains with Customer Name, Phone No., Email Id , Other Comments

sir try-catch is properly just here copy paste remaining

sir u are right that i want to use left outer join thank you for your hint sorry to late reply ....

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

ok sir

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.. :-)

sir did but same issue why its happen dont know help in anotherway if you found any other answer

sir is there any other way that you can help sir.. please

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

Thank You for your help ...
Sir... :-)

THis is work for me but not sure how much right but thank you for your help ...

no sir same error

Incorrect syntax near '='.

no sir same getting error over CalStatu1='Done' and CalDis='Pending'

Hide   Copy Code

Incorrect syntax near '='.

do you have some link please reply me with link

sir please visit that link ...

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

POSITION VALUE IS : 15
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

okey sir ill check and reply you.

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

thank you so much

but while I am running this api via script I got response then what is problem ...

Not Usefull sorry sir :-(

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

and
sir other link is not helpfull

Sir you already help me with previous question answer thank you so much


Mika Wendelius

sir my mistake thank you so much .......

sorry didn't work sir please check it.

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....

Can You instruct me is this query is okey

SELECT column from table where contains(column,'NEAR(SFH630),2,TRUE)');

Thank you sir for your help thank you so much...... :-)

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...

i need to do URL MAPPING...

I never understand how to use github code

i already had this... :-) thank you....

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...

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.

not understand can you please explain me in depth

thank you I will check it....

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.

sir where I write this code in javascript.

I tried AxSkype1.CreateGroup("GROUPNAMe") but didn't reflect

77500

i go throught from that but there is some problem

i tried but same problem exists anyways do have any idea of my question.

I need trigger in MySQL when I write in subject MySQL, code project give me error

sorry I didn't check this answer I was not in place.. thank you for every one help

sir I want the side by side. please help me..

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.

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)

sir give me error please update .

this code not working sorry..

actually I have value like Color [RED] and need to apply this color on Label1.BackCOlor

it give me error what is MAPtoCOLOR please Explain or show me example

Please help me.

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..

can you please tell me i am using vb.net 2005

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
tm_Email.Start()
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
sendMail()
else
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

Private Sub frmMail_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
tm_Email.Interval = 600000
tm_Email.Start()
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
sendMail()
else
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

Thank You Sir

i dint get request.getAttribute("txtValue") can't get value on other page so please help me for that........................

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
BGW.RunWorkerAsync()
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
getDatafromLoad()

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
Else
MsgBox("Done")

End If
End Sub

not proper

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.

Panel
in that panel one Flowlayout and flowlayout contain Buttons

how to set page orientation on PDF

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.

not usable that code.

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

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

Thank You sir for clear my concepts

Thank You very very much....... :-)

i want to merge my cells depend upon rows
like

in first rows
ABC in first cells other cells i have to merge
second rows i don't want to merge cells

how to add screenshot there is no option in codeproject

what is SautinSoft

i just use my variable like
String strValue="";
while reader.next()
{
strvalue=strvalue & reader(1) & ","
}
delete from Order_Table where OrderNo not in(strvalue)

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.......

because except this record all records are useless for me thats why i have to delete......

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)

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

my question is not solved please give me hint to what should i do.

yes you are right then what i have to do sir.

if i set datetime datatype in dateValue it also give me same problem in access database.

my first code is
Label.font=New Font(Segoe, 8, 0)

when i click on my click i give it msgbox like

msgbox(Label.font.size)
it show me 8.5
how its possible

i tried but when i click on that label it give me msg as font is 8.5 size

sir but i want to add label size as 8 then what

but there is only single columns where the value has been inserted

what about for access sir.... OriginalGriff

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....

sir their is no range of files..... :-)

sir actully file name is in database but without extension and i want to load a file with extension now what can i do ....

sir actually i have path with file name like this

D:\sam\DSC0001

and i want to file extension of DSC0001 file.

no sir not working

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

i m using .net 2005

wmf,png both are transperent

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

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"

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

no in visual studio 2005 sir

please send me code .... :-)

e chodu mal tera idea tere pass rakh

now is it fine for you or nor?

i have a 30 labels.... then this code is not perfect....

Not working for me sir.... i tried but i need this type in mail label report in crystal report

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

no i did my self actually this is last option in my mind ......

ok sir :-) Thank you

your link is meaningless i didn't understood. is it useful for me

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

nothing i have to do somthing but i am stuck about how to convert to vb editor mode please help me