Comments by Black_Rose (Top 124 by date)

Thanks. :)

I got this below sample. but here they are not using the sp_who2 command

https://gallery.technet.microsoft.com/scriptcenter/How-to-kill-SQL-Server-a33476b7
Can you please suggest me on this.

i got the point of spid > 50. didn't got the earlier one. can you please give me a small example.

1st one i identified. i need help in the 2nd one.

I did ErrorAction as SilentlyContinue but still it is prompting for that Yes/No option like how it ask when we run something as admin.

It's working but the problem is it is prompting for the Yes/No option dialog. how to disable that.

The 2nd one is not working. executing fine but no result. and i can't opt for the first one bcoz i have a single file in which i have different function all which doesn't need admin credentials.

i am not getting. i am using PSVersion 4.0. Verb option is not coming.

I Checked this. this is opening a powershell command prompt as admin. but here i am trying to in a script and only for a single command.

See u gave that already i did. what i wanted you havn't got and which your provided support dosn't cover. i want to copy the cell's between two text. now the rows in between them can be added/removed later. In the sample it's mentioned 4 rows,but it can be 3 or 10 later
I asked how to do this.

i use to come to CP only after search in google. if u don't want to help that's fine.

Code is big. i can't post that. but only thing i need the idea how can i do this in powershell foreach loop

Code is big. i can't post that. but only thing i need the idea how can i do this in powershell foreach loop

Thanks

Private Declare Function Shell_NotifyIcon Lib "shell32.dll" Alias "Shell_NotifyIconA" (ByVal dwMessage As Long, lpData As NOTIFYICONDATA) As Long

I did that. now i am getting expected '(' at line 1 char 27

Phil i am splitting it in next step. but how to remove the duplicate one's

Didn't got...

Oracle servers

Yes. a component through which may be i can update the existing browser version to the latest in Windows System.

No. using code i want to check and update browser version.

I need some idea how to start the code.

In case of office laptop..?? is there any possibility..??

Is there any location/logs where the details use to get saved..??

Yes..That's why i accepted the answer

Thanks sisir...

Ok.Thanks for ur help

Ok.
but can't change the job without solving this.

Can you please post the sample code.

This is a text output. not any JSON or XML code

Not getting. i tried what you mentioned. but it is still printing the other parts apart from name.

This is what i am already using

if (str_Current_Line.ToString().Contains("name") && str_Current_Line.ToString().Contains("root") || str_Current_Line.ToString().Contains("name") && str_Current_Line.ToString().Contains("ckpt"))
{
str_Current_Line.Replace(str_Current_Line, "");
}
else
{

Obj_DT_FileTage.Rows.Add("", str_Current_Line.Trim().ToString());
}

Yes. but not getting how to do that. because i am getting each line at a time.like "name = root_fs_d5" iteration , volume = md5 in next iteration.
and for some "name" comes after 2 lines for some after 3 lines.

That is like line starts with "name" upto occurrence of the next "name"

dashed one i gave for identification of each set here. the actual output comes without that.

CP, as you told, can you tell me how to do that part using code. any sample. then instead of dashed one occurance i can look for "name" occurance

Done that.

Thanks CP

Hi CP.
Thanks for the reply.
This is working as expected.

One thing, can you tell me how to use the sb in dt.rows.add(). below is the code

mytrim(str_Final_Output); //calling your function
Obj_DT_FileHealthCheck.Rows.Add(ls_IP.ToString(), sb.ToString());

i just want to dump both the data table data into a single. that's all. as i mentioned 10 columns instead of 7+3

dt and dt1 are the datatables.

Yes. i tried like dt.merge(dt1) but not happening.
There is no condition.

Any solution for this..??

Thanks...

See i am looking for help here..i need idea not the solution. want to help please help. please let other do. u people have the privilege so u will close the question that's all..

Without sorting.

Actually i don't have idea so that's why if u can share some sample reference so it will be easy for me to start.

Hi Richard

Thanks for your reply. But what i am looking for is installing/upgrading the VM tools using any scripts.

If you have any info related to the post please share.

I was not knowing that..there is no intension of being rude, unthinking, and careless.

Sorry for that..but i am not getting what u r telling..

Yes. i did.

It is ok..but when this .vbs will run it will generate a HTML file. how to open that and refresh every time

I need to.

editor..?? i m in VS2012

What i have to do then..??

Try to put them inside a HTML table and check.

Not enough.
share how, when, where u r getting the error...

Describe your problems peoperly to get a proper response.

Not clear..
why you want a console at all?
Does this need a user interface at all?
If not, just make it a windows forms app, and remove the form. Open the "program.cs" file, and replace the code in the Main method

"how can i search that value in gridview without loop???"
and why u don't want to use loop..??

What you are looking for..??any application or paid software ..?? or anything else..

I think you didn't went through the links posted by Abhinav S.
Go through once you will get the answer.

+5..

Without seeing code it's not possible to help you..

Not enough to start.
share more information.

Check the updated asnwer..

:) welcome...

Nice..please accept the answer.

But if it is blank then what to do..

But if it is blank then what to do..

Yes.it worked.
i changed like below.

update tbl_transaction_master set parcel=0 where COALESCE(parcel,'0') = '0'

Got the below error

ERROR: invalid input syntax for type numeric: ""
LINE 1: ...ction_master set parcel=0.00 where COALESCE(parcel, '') = ''
^


********** Error **********

ERROR: invalid input syntax for type numeric: ""
SQL state: 22P02
Character: 70

Ur first query giving below error

Msg 1033, Level 15, State 1, Line 8
The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified.

I want the first one..

This is a query i wrote to get the records repeated more then 2 time.
i want to keep this records and delete other records which repeated <=2 times

instance methods.

Ok.may be this will help. please tell me
i have 2 classes in my project, which contains one method each.
how to call both of the methods in a single event.

Ok.may be this will help. please tell me
i have 2 classes in my project, which contains one method each.
how to call both of the methods in a single event.

Then is there any other way to relate this question.

No actually this was asked in one interview i faced.

No actually this was asked in one interview i faced.

This is not what i m looking...

Yes.Exactly.
actually i am having weighing scale.

The thing is i want the data of the scale to my IP.
when i am sending ctrl+e command in hyperterminal in windows, it's giving me the data.so that data i want to display in an asp.net page.

Please tell me what i am missing here..??
means any piece of code has to be added..??

Hi

I mentioned the line where i am getting error.
it's at the first part
Decrypt(xmlDoc, tDESkey, hashPwd) //Getting Error Here
Then when it is coming to Decrypt function it's giving here
exml.DecryptDocument()

I don't have idea how to do this from ubuntu to windows.
please provide some code snippet or reference links.
else at least tell me how to copy file from ubuntu to windows.

Not working..

I want to copy one table data..not all..

select 'ASales Amt' as tran_type, sum(amount) as net_total from tbl_transaction_master Where to_char(bill_date,'yyyy-MM-dd')>='2014-12-23' and to_char(bill_date,'yyyy-MM-dd')<='2014-12-23'

This was asked to me in one interview.i updated with the entire question.

sorry.idle means suppose a user left the application at middle at some form and left, then after 5-10 sec it should redirect to the main form.

I want to save and then print the same.

Yes.But u mentioned textbox and all which i am not using..

i am using streamreader to put data in a .txt file.

Thanks for your reply griff..

Just want to is there any process we can specify specific line space value.
e.g. 0.75 or 1.5 etc

ya i know that..but i need specific point of spacing line ms-word.

"my javascript code is not working" is not enough to go.Please tell what is the script is about..what u r trying to do..what kind of output u r expecting..

I have updated my question with my printing function.please tell me where to use this.

Agree griff..i need some idea..means what points i can cover..

Griff it's working fine as required.but getting the below error after scanning

Cross-thread operation not valid: Control 'Passbook Insert' accessed from a thread other than the thread it was created on.

can you give me some example for this.

Thanks for your reply griff..
I tried the shown event
private void PassbookInsert_Shown(object sender, EventArgs e)
{
scan();
}
But it is at the same time like load.
means, it's not showing the form but the function is getting executed.

Sorry for that.it's a windows application.
and i tried to put one timer.i gave my scan() in timer_tick event but problem is after scanning also it is going back to the scan() again and again.so it's throwing error.

Thanks..:)

Thanks for your reply.
i did this below code

using (StreamReader srr = new StreamReader("C:\\Display.txt"))
{
line = srr.ReadToEnd();

line is a string variable which contains this when i see in HTML visualization

Date Particulars ChequeNo Withdrawals Deposits Balance -------------- -------------------------- --------- ----------- -------- -------- 1 07 Oct 2011 By INITIAL DEPOSIT 0 0.00 100.00 100.00 2 31 Mar 2012 By Half Yearly Interest 0.00 2.00 102.00 3 30 Sep 2012 By Half Yearly Interest 0.00 2.00 104.00 4 31 Mar 2013 By Half Yearly Interest 0.00 2.00 106.00 5 14 Jun 2013 By Cash 0 0.00 12170.00 12276.00 6 14 Jun 2013 To SCHOOL FEES FR SES JUN 0 11545.00 0.00 731.00 7 14 Jun 2013 To SCHOOL FEES FR AVG JUN 0 625.00 0.00 106.00
when i am printing it is printing like this only.
Please tell me how to format this.

This is what i faced problem in c#

http://www.codeproject.com/Questions/820271/Need-help-in-formatting-the-data?arn=0

I tried using c# but i was facing some alignment issues.that's why i did using this approach.
please tell me how to convert it to COM or dll..??

ya..i am sry for that..i totally forgot..

It's giving below error

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM car_uploads GROUP BY item,total) X' at line 6: Select sum(Quantity) from(SELECT item, SUM(CASE WHEN location = 1 THEN quantity ELSE 0 END) location_001, SUM(CASE WHEN location = 2 THEN quantity ELSE 0 END) location_002, SUM(CASE WHEN location = 3 THEN quantity ELSE 0 END) location_003, SUM(quantity) total, FROM car_uploads GROUP BY item,total) X

Thanks...:)

Yes i changed depending on that..3,9,10,20,30,40
But still no change..

Is there any other way to format.

Please check..i updated my question with the image link..

I checked with this..it's coming in the same way..

I am trying that..actually the data is coming in a dataset.
when i am trying to format one column, it is disturbing other columns..

I am trying to print using EPSON printer driver.

I updated with my sample data

Thanks for your reply Griff..

Can u please show me one small example for below lines

Date Particulars ChequeNo Withdrawals Deposits Balance
-------------------- ----------------------------------- -------- ----------------- -------------------- ---------------
1 07 Aug 2012 By IB-2012220152498-cash 0 0.00 10938.00 44929.00
2 07 Aug 2012 To Cash 0 20000.00 0.00 24929.00

Here first is serial no. of length max 3 i.e. 999
date is 9
next particulars 25
cheque 8
withdrawals 10
deposits 10
balance 10

Can u give some implementation example..

That's funny..
i know that i have to start in vs.

I asked how to start the application..what is the approach should i take..

I want to convert that data to a image file.

ya but this is for text.
i have a notepad with formatted data.
how to convert that.
it is for passbook printing..so i can't mismatch the format.

Please read the question..i asked for dataset not datatable.

Please read the question..i asked for dataset not datatable.