Comments by Reza Alipour Fard (Top 74 by date)

I checked it, It didn't work correctly.

It doesn't work correctly. I have an error.
Please tell me full information about this problem.

OK, I will check it and tell you tomorrow.

public JsonResult Like(long id)
{
Entities entity = new Entities();
Note note = entity.Notes.SingleOrDefault(a => a.ID == id);
string user = Request.UserHostAddress;
bool exist = false;

foreach (NoteUserAddress item in entity.NoteUserAddresses.Where(a => a.NoteID == id))
if (item.UserAddress == user)
exist = true;

if (exist == false)
{
note.LikeCount++;
entity.SaveChanges();
}
return Json(new { LikeCount = note.LikeCount });
}

My html syntax:

<input type="button" class="Note-Like-Image" önclick="like(@item.ID)"/>

<script type="application/javascript">
function like(id) {
$.ajax({
url: "/Note/Like",
type: 'Get',
dataType: "json",
cache: false,
data: { commentId: id},
success: function (data) {

alert(data.LikeCount)

},
error: function () {
alert("error");
}
});

};
</script>

I get bellow error:
"3:92Uncaught TypeError: Cannot call method 'ajax' of undefined "

How are your Sampath. sorry first time I couldn't remember you.
You are one of my friends in Linked In.
I tried to use this format of ajax request many times today, but I get bellow error all the time:

"3:92Uncaught TypeError: Cannot call method 'ajax' of undefined ", pLEASE HELP ME.

Thank you for your attention.
Your java script has some syntax error.
Please check it.
Thanks a lot.

I want to only a number. I think using partial view for this problem isn't good solution.
I want send an ajax request to controller and get result and use that in view.

Please see my solution, I used from bellow query. for example:
DECLARE @cmd VARCHAR(255)
SET @cmd = 'bcp "Select * From TestTable" queryout "C:\TestFile.xlsx" -U sa -P 123 -c'
Exec xp_cmdshell @cmd

Thanks, I tried but it doesn't work correctly.
Can you give a sample of how you can use it?

Is your field in database null able?
What is your error or message or result?

good luck. I was surprised when I saw your comment.

I am sorry for you. Do you sure you are a developer? The first of all you should test my algorithms after than give a comment.
If you enter 1764 as input number result is 42.
If you enter 100 as input number result is 10.
If you enter 4900 as input number result is 70.
If you enter 2500 as input number result is 50.

Now, You say my algorithm return a prime number or number of square root???
I check a i is prime number because square root number is consist of a series of prime number.

MY ALGORITHMS IS FINE SQUARE ROOT NUMBER NO PRIME NUMBER.
Are you understood??

For solving this problem you should set AutoPostBack="true" in your checkbox.
But this is not related to Java Script!!!

If you want use from Javascript for this, your solution has not any improvement in loading your page. Because all of your data must be loaded after that your javascript can show your data by paging. Therefore I suggest to you if you want improve load page threfore don't use from JS.

Reason for my vote of 1 \n It's not article.

I can't understand your value in your table. I think it's better you show some row data as sample data.

I vote 5 out of 5. Your solution is very short and correct. Thanks

you data is in one column or two columns?
1900 t8 is a column or
1900 is a column and t8 is a column?

I update my answer. I add a best way for do this action. Please check my answer.

You must show your database structure for that 2 tables. I think you need only a group by and count vote. Please present your tables structure.

Welcome, I wish you will be success in your life.

Do you must save data in database as sorted data?
For Example if you have bellow records in DB
ID Name Date
-----------------------------
1 Test1 2012-01-01
2 Test2 2013-01-01
And now you want add a recod in 2012-06-30, you table value must be:

ID Name Date
-----------------------------
1 Test1 2012-01-01
2 NewTest 2012-06-30
3 Test2 2013-01-01

Your hint is it?

Please present you code for define ConnectionString.
You run this app on different computer from Visual Studio Computer?

Whats your problem?

Hi, I can help you but you must start to write this program and if you have any error you can tell me and I will help you.
If you want I write hole of your program, I tell you sorry.

Welcome, I hope you will be success in your life. Best Regards

You are right

Welcome, I hope you will be success in your life. Best Regrads

You must use '(' before select and ')' in enf of select.
Please attention bellow query:
UPDATE TempTable
WHERE ColumnID = (Select Top 1 ColumnID
From TempTable
Where Column1='1' AND Column2='2')
SET Column3 = '1'

Use Solution 1

See solution 2.

Please wait a minute....
What is your SQL server version??? tell me your version until I give solution compatible with your version.
DATEFROMPARTS is a function in SQL server 2012.
Rate 1 out of 5!!! :-(

I have a suggestion for you: Add unique identify column as ID to all tables. This help you to easily write query for your purpose. If my answer it's OK for you please give rate 5 (out of 5) to my answer. Best regards

I download and install 2007 Office System Driver: Data Connectivity Components and Microsoft Access Database Engine 2010 Redistributable (32Bit). But I have bellow Error:
Msg 7438, Level 16, State 1, Line 2
The 32-bit OLE DB provider "Microsoft.Jet.OLEDB.4.0" cannot be loaded in-process on a 64-bit SQL Server.
My Computer OS: 64 Bit
My SQL:64 Bit
My Office: 32 Bit

Last problem has been solved.
But I have a new error.
Msg 7438, Level 16, State 1, Line 1
The 32-bit OLE DB provider "Microsoft.ACE.OLEDB.12.0" cannot be loaded in-process on a 64-bit SQL Server.
My SQL Server is 64-bit.

I have erro:
Msg 7302, Level 16, State 1, Line 1
Cannot create an instance of OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)".

Please attend to my problem after that give me a clear sample.

I use from all of the introduced ways, but all of them is not work correctly.

I edit it. Thanks a lot.

Your code is OK, But have a little problem: In first load page will show all news and after 3 second your code will work correctly.

news was fetched from DB therefore I can fetched that in Java script. If you can do this please give me more information how I can use from a variable in java script that was fetched from data base?

I remove 2 news of 3 news therefore exist one news and page will be show that news.
I want change this news after some second without user action.

My complete question has in:
http://www.codeproject.com/Questions/586961/Showplusonlyplusoneplustext-news-plusatplussameplu

I have some text as news. I want show only one of them at the time.
Therefore I must show one of them to user and after some second without do any action by user My page must change that news by others.
Please help my for doing this action.

If your table name has in your DB, you must be create your script in your application and execute it.
for doing this action you must be replace your table name instead of YourTableName after that execute Try and Catch parts.

If you have code, please put it here. Your question is not complete, it has ambiguity.

I have a web service, that every one can call it and send data by this web service. I generate a username and password for some people that have permission to call this WS and send data to me.
Therefore I need get this user and pass when every one want request WS(Create session) I can detect it.

Thank you for your attention,
I read that link but it doesn't work correctly.
I don't know where I can use from your code!!!
Please present more information.

Welcome,

If my answer it's Ok for you please select my answer as "Accept Solution" and "Vote 5".
Best Regards

Hi, Your question has ambiguity. what mean of CDatabase, CString, ...
Please complete information of your question.

thank you

thank you for attention

I need to a method for getting data from specific web service. in some rows some columns may be null.

Please attention to question comments!!!
I know it, My problem is complex than your solution.

Thank your consideration,

I know my task when finished.
I call 3 methods in form constructor for do tasks, therefore i know when tasks was finished.
But i can't use Close in constructor because in this situation after finish task immediately form will be closed. and if i use from thread.sleep before close in constructor therefore form doesn't display while finished sleep time.
I want display form immediately after finished that form close after 10 second.

Thanks A lot, Where is I can call Close method?
I don't want to call this method in constructor of form.

Thank you for your attention, But my problem is:

<pre>
static class Program
{
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
MainForm mainForm = new MainForm();
Application.Run(mainForm);
mainForm.Close();
}
}
</pre>

I need exit from mainform after finish task.
this app execute every hours and system admin must see this result, But some times may be admin doesn't exist front of server. therefore i need close app automatically.

Do you need to check structure of entered text as e-mail address?
Or you need validate the entered text as e-mail address?
Please give more information.

your question has ambiguity.
you need update copies column? or delete some rows?
Do you need to group by table by MasterAccessionNo?
Please give more information.

Thank you for attention

I think you is popular. Therefore I present a class for management connecting to sql and get data.

You're welcome. It is my pleasure. Best Wish for you.

You must check text in your text box before convert it to int.
If structure of entering text is not valid for convert to int you can clear this text and focus on this before exit from this text box.
You have not any problem in this code, Your problem is related to text structure.

I test your code.
It's correct and perfect.

I present a solution and for more detail I said if need to more help clarification.
Why you get Down voted???
I think you have wrong in this action.
However, Thank you for your attention.

your opinion is correct, I know it.
But I think this question has ambiguity,
for example:
1- only one time setup by one user in one computer
2- only one time setup by every user in one computer
3- only one time setup by one user in every computer
4- only one time setup by every user in every computer

for each state I have best suggest but I don't know which state is goal of this question.