Comments by Meysam Toluie (Top 101 by date)

I use no transaction. The algorithm I have wrote will executed in tSQLt test, and tSQLt will begin a transaction automatically and at the end it will be rollback.

Instead of Join, you can use Left Join; Then with the help of ISNULL function you can change null values to ZERO

But youngest child is 18 not 25!

I am changing a project which I didn't created myself. the developer had some terrible implementation on this project. specifically he put the contentplaceHolder of master page in an updatePanel so I can not use PostBackTrigger. Is there another solution?

How to change the line brush?

the ID columns is Identity and I am using disconnected architecture. did you see?

Are you looking for someone to write your homework? Here is the wrong place!

Do you need the whole row or an specific cell of it?

I thing dataGridView1.CurrentRow was enough. He asked for current Row null cell.

Does DataGridView Databinded?

Hi Sir.
I have added a solution but I can not see that myself. Can you see any solution here?
Its reputation also added to my reputation.

And What column should be update? And How?

Somehow you reply yourself in the question.

The solution Explorer of VS?

+5

If you have any question use 'Have a Question or Comment?' button!

+5!

sorry It was my mistake to post wrong question. See the updates.

So do it!
Best wishes for you.

+5

I executed this code:
DECLARE @cmd VARCHAR(255)
SET @cmd = 'bcp "Select Distinct Loan.ManagedFundAccNo1 From Account.Loan.Loan" queryout "D:\test.xls" -U sa -P 123 -c'
Exec xp_cmdshell @cmd

Then the following errors came as result.

output
SQLState = 08001, NativeError = 2
Error = [Microsoft][SQL Server Native Client 10.0]Named Pipes Provider: Could not open a connection to SQL Server [2].
SQLState = 08001, NativeError = 2
Error = [Microsoft][SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is config
ured to allow remote connections. For more information see SQL Server Books Online.
SQLState = S1T00, NativeError = 0
Error = [Microsoft][SQL Server Native Client 10.0]Login timeout expired
NULL

What's the use of
SqlDataAdapter adp = new SqlDataAdapter(command);

And where is the code you set updated row in dataGridView?

What is the platform? WinForm , Asp.Net, ... ?

See the update.
I hope you get what you want!

+5

See my solution.

I know the cause of the error is simple. What is not simple is the answer.

I had tried this one too; The same exception.

I am sure you mean V[1].Length for single string size; because string is not List it's an array.

Why do you want to show ComboBox?
Why don't you just change the value of the specified cell?

ProcessThread.Id and Thread.ManagedThreadId are different.
We can not match these two like that!

Before asking these basic question, please google it! you will be surprise of many answer more faster.

Can you put the codes of CitiesCountriesDAL class?

Solution 1 didn't solve your problem?

If specifying the line which cause the exception is hard to you I suggest to leave coding as soon as possible.
How can I fix the code when I do not know where exception occurs?!

Still you didn't specify where the exception occurs.
Anyway when I was reviewing your code, I see another mistake; And that is:
The final block will execute anyway. So you do not need to rewrite its code in try block!

You rewrite
citCountr.CloseConnnection();
several times.

It will be more efficient if you put the part of code which cause the error.

See the answer and tell me if it helped!

Have you checked that your table is not empty?

Maybe you are getting errors but you must change your code in a way that Abhinav has been mentioned.

What kind of errors occur?

So are you going to accept it formally or not?

See the answer update please.

Being long is less important than being messy.

I think LaTex will be good.

I am looking for some easiest way.
See: http://stackoverflow.com/questions/15042334/how-to-add-superscript-power-operators-in-c-sharp-winforms

I prefer to create my own control.
I will be thankful if you have any suggestion.

I prefer to create my own control.
I will be thankful if you have any suggestion.

Please read the question and the sample of result carefully.
Pay attention to Client_ID column and Sum Column.

Your first mistake is (A.PayDate < B.PayDate) And the second is you do not read the question caredully. Pay attention to the ClientID and sum column again.

Please tell me how to fix it. I can not use subquery, because the function is really complex and its not single select.
So what are the other way to solve it?
Thank you.

I am kind of beginner but I think starting lots of threads will not helping me even with BackgroundWorker. In Addition I had experience with BackgroundWorker.

The method SaveOutput is not a method which only saves the data; It also prepares data.
Meanwhile I am writing an text file.

The function is table-value.
I am using function because the function body is very long some other reasons.

The best way to understand is tracing the program and find out what is null in line which error occur.

In fact I used row_number to get the maximum of it for each message.

The below query gave me this:

Title Content RowNumber ID
----------------------------------------------------
first firstContent 1 1
first firstContent 2 4
first firstContent 3 5
second secondContent 1 9
second secondContent 2 2

But I need this:

Title Content Count
-------------------------------------------
first firstContent 3
second secondContent 2

With CTE As
( Select Row_Number() Over(Partition By [Log].Message_ID Order By [Log].ID) As RowNumber,
Message.Title,
Message.Content,
[Log].ID
From [Log]
Left Outer Join
Message
On Message.ID = [Log].Message_ID
) Select Title,
Content,
RowNumber,
ID
From CTE As A

Thank you for your time.
What if I want to get the message content from the table 'Message' using inner join and also other columns from the current table?

The error message:
Column 'column1' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

The English is not the first language of Many users and I. So take it easy.
Maybe I could use 'Get' or 'gain' or something else which I do not know!
Is there something else which is not clear?

Thank you for your answer. What if I want to remove only the alphabets?

You didn't get my question.
See the accepted answer.
Thank you anyway.

It is enough when you know what kind of error will occur; anyway thank you for your time.

Thank you for your time.
In your example you handle the error of multiple records; But what about the other errors.
There are many kind of queries that I can not think about all possible errors.
Did you get it?

This was the answer:
body
{
margin: 0;
}

Sorry but no problem solved!
Thank you However.

Nothing happened.

.title
{
color: White;
margin: 0px;
}

Thank you for your time.
What about the first div? There is still an space above that.

But never finding out?

I like the way you answer these type of question.
Thank you.

What kind of question is this?

You must explain more about your issue to gain the best solution.

I think you didn't read the question carefully. vijay79041384 didn't ask a solution for hiding a TabPage, but the TabPage's header. did S/He?

I have already found a class named "Win32_ScheduledJob" but I couldn't use it. can this class help me?
http://msdn.microsoft.com/en-us/library/windows/desktop/aa394399(v=vs.85).aspx

I have already found a class named "Win32_ScheduledJob" but I couldn't use it. can this class help me?
http://msdn.microsoft.com/en-us/library/windows/desktop/aa394399(v=vs.85).aspx

I do not want to use these typical ways that you named. As Windows can do this so I want to find a way to access the windows setting. I will find it some how. I just want help to do it as soon as possible! So what do you think now?

I forgot what?

My Problem is more complicated. The WebBrowser in my windows application doesn't fire any javascript even when I click on the link using webBrowser UI.

Thank you anyway!

I think you are miss understanding. The web site is not mine! and of course its my fault to not explaining well.
My Project is Windows Application.
I am trying to invoke a javascript in a website using WebBrowser.

Have you ever tried the above code yourself?

Yes, the solution accepted.

I handled the DocumentCompleted but i put NO CODE in the handler method and it just updates.

The above code is not the exact code. It is for explanation.
Yes, I did.

See my reply to Sergey.

I am creating many procedures in a Db one by one. For managing what procedure is being created or not I had made a DB with a single Table; Now I want to automatically update the progress table when creating the target Db procedures.
At first I thought the sys.etc kind of metadata are tables which can support triggers; Now I am looking for more sufficient ideas.

As you can see I commented that the statement continues.'.
The purpose is not important yet. For now my problem is to create the trigger.

First of all you could answer "Am I right?", didn't you?
After that you can see my problem, so if you can suggest something to solve it, please help me; otherwise do not look for a question.

Of course, Inner join slows down store procedures.
For suggesting you a solution I need to see your code.