|
I can't run your code. You have to. Debug the code and see what is happening.
|
|
|
|
|
Quote: First for companies like Facebook, YouTube, Instagram and
other companies' database processing to report SQL Server
The communication line is given to our web server
User information is available on this server by
user information to access database data or fetch user-related files.
We get to the point where the user posts the files every day
we store On the database of a computer in the internal network
that has a hard drive with a raid strip.
There is a Windows service on this computer whose job is to
distribute the database table data on computers within the network
up to 100 computers for storage and the computer ip stores the
storage in the table of a computer that is to be extracted.
To identify a suitable computer for distributing the file on it,
it looks at the active IP table and, for example,
if there are 10 active computers,
stores it on one of the ten to be taken And returns the IP
to store the record with the ID on the database of that particular computer.
Now you can use the server link to report or obtain files
The id of the file is stored on a table with ip of computer that stored on back to the server and store
on the on table that inner join with table of users
Now, when the user logs in, his data will be accessible.
Having the IP address of the link server and the ID of
the file storage location, the report can be get with dynamic queries
Microsoft sql server and the speed of getting files depends
on how many of network computers
Windows service must clear the data from its table after saving the data on
the SQL Server database to always serve the file senders with
|
|
|
|
|
You seem to have forgotten to ask a question.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Quote: First for companies like Facebook, YouTube, Instagram and
other companies' database processing to report SQL Server
The communication line is given to our web server
User information is available on this server by
user information to access database data or fetch user-related files.
We get to the point where the user posts the files every day
we store On the database of a computer in the internal network
that has a hard drive with a raid strip.
There is a Windows service on this computer whose job is to
distribute the database table data on computers within the network
up to 100 computers for storage and the computer ip stores the
storage in the table of a computer that is to be extracted.
To identify a suitable computer for distributing the file on it,
it looks at the active IP table and, for example,
if there are 10 active computers,
stores it on one of the ten to be taken And returns the IP
to store the record with the ID on the database of that particular computer.
Now you can use the server link to report or obtain files
The id of the file is stored on a table with ip of computer that stored on back to the server and store
on the on table that inner join with table of users
Now, when the user logs in, his data will be accessible.
Having the IP address of the link server and the ID of
the file storage location, the report can be get with dynamic queries
Microsoft sql server and the speed of getting files depends
on how many of network computers
Windows service must clear the data from its table after saving the data on
the SQL Server database to always serve the file senders with
How to distribute the processing load of one system on several systems؟
modified 25-Jan-21 12:12pm.
|
|
|
|
|
This is not the right place to post answers to questions that haven't been asked.
Try fleshing out the description and posting a tip instead:
Code Project Article FAQ[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I post in stack overflow befor post in your site why down my article 3account in stack overflow down my question
|
|
|
|
|
Because you're posting in a forum which is designed for answering other people's questions. But instead of answering someone else's question, you've made up your own question and posted an answer to that.
It's similar to a salesman who knocks on your door to try to sell you a set of encyclopaedias - he obviously won't receive the same welcome as the plumber you called to come and fix your broken toilet.
As I said, if you want to publish this information here, then you need to post it as a tip. There is no equivalent section on StackOverflow, so you can't publish it there.
The other alternative would be to set up your own blog.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Additionally, the downvotes might be related to bad spelling, bad formatting, wrong grammatic and specially with the impression you give, that you don't give a crap about the quality and correctness of your posts.
An don't get me wrong, I can understand if you are not a native english speaker, because neither I am native speaker. But only because you can't speak well a language, it doesn't mean that you can't try to speak that language properly.
M.D.V. 
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
I am trying to work on autocomplete using jQuery (using a tutorial from here - link,
The problem is that it works fine when I add the following line:
@{
Layout = null;
}
but when I remove it, I have the error about autocomplete function not being found.Is there way around this? I know that it is related to the scripts conflinct in _layout page, but I don't know how to resolve it and I'd like to have my menu layout.
|
|
|
|
|
You haven't included the required script references properly, or you've included them in the wrong order.
Since we can't see what you've done, we can't tell you how to fix it.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I load the script from external file and the order is:
<script src="https://ajax.aspnetcdn.com/ajax/jQuery/jquery-1.10.0.min.js" type="text/javascript"></script>
<script src="https://ajax.aspnetcdn.com/ajax/jquery.ui/1.9.2/jquery-ui.min.js" type="text/javascript"></script>
<link href="https://ajax.aspnetcdn.com/ajax/jquery.ui/1.9.2/themes/blitzer/jquery-ui.css"rel="Stylesheet" type="text/css" />
<script src="~/Scripts/selectAuthor.js"></script>
and the script order in _layout:
in the head section:
<script src="~/Scripts/jquery-3.3.1.min.js"></script>
<script src="~/Scripts/bootstrap.min.js"></script>
<link rel="stylesheet" href="~/Scripts/bootstrap.min.css">
and at the end of section:
@Scripts.Render("~/bundles/jquery")
@Scripts.Render("~/bundles/bootstrap")
<script src="https://ajax.aspnetcdn.com/ajax/jquery/jquery-3.3.1.min.js"
asp-fallback-src="~/lib/jquery/dist/jquery.min.js"
asp-fallback-test="window.jQuery"
crossorigin="anonymous"
integrity="sha384-K+ctZQ+LL8q6tP7I94W+qzQsfRV2a+AfHIi9k8z8l9ggpc8X+Ytst4yBo/hH+8Fk">
</script>
<script src="https://ajax.aspnetcdn.com/ajax/bootstrap/3.3.7/bootstrap.min.js"
asp-fallback-src="~/lib/bootstrap/dist/js/bootstrap.min.js"
asp-fallback-test="window.jQuery && window.jQuery.fn && window.jQuery.fn.modal"
crossorigin="anonymous"
integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa">
</script>
<script src="~/js/site.min.js" asp-append-version="true"></script>
@RenderSection("scripts", required: false)
|
|
|
|
|
You're loading multiple copies of jQuery, which will never work:
<script src="https://ajax.aspnetcdn.com/ajax/jQuery/jquery-1.10.0.min.js" type="text/javascript"></script>
...
<script src="~/Scripts/jquery-3.3.1.min.js"></script>
...
@Scripts.Render("~/bundles/jquery")
...
<script src="https://ajax.aspnetcdn.com/ajax/jquery/jquery-3.3.1.min.js"
asp-fallback-src="~/lib/jquery/dist/jquery.min.js"
asp-fallback-test="window.jQuery"
crossorigin="anonymous"
integrity="sha384-K+ctZQ+LL8q6tP7I94W+qzQsfRV2a+AfHIi9k8z8l9ggpc8X+Ytst4yBo/hH+8Fk">
</script> You're also loading Bootstrap multiple times.
And you're mixing up the MVC5 approach (@Scripts.Render) with the ASP.NET Core / .NET 5 tag helper approach (asp-append-version, asp-fallback-src).
Simplify your scripts so that you only load each library once. And pick the correct approach for the framework you're using.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
I left layout scripts as they are and didn't touch them. For the script part I took one from tutorials. What would you suggest in the terms of making both work fine? For me it doesn't matter much if it is MVC5 approach or ASP.NET core as long as it works.
|
|
|
|
|
Well, it does matter which approach you use - the @Scripts.Render approach won't work in ASP.NET Core / .NET 5, and the asp-append-version approach won't work properly in MVC5. 
(To be precise, the asp-* attributes will be sent as-is in the rendered HTML, and won't have the expected effect in MVC5.)
If you're using MVC5, stick to the @Scripts.Render approach for your bundles, and remove the asp-* attributes from your <script> tags:
Layout:
@Scripts.Render("~/bundles/jquery")
@Scripts.Render("~/bundles/bootstrap")
<script src="~/js/site.min.js"></script>
@RenderSection("scripts", required: false) View:
@section scripts {
<script src="https://ajax.aspnetcdn.com/ajax/jquery.ui/1.9.2/jquery-ui.min.js"></script>
<link href="https://ajax.aspnetcdn.com/ajax/jquery.ui/1.9.2/themes/blitzer/jquery-ui.css" rel="stylesheet" />
<script src="~/Scripts/selectAuthor.js"></script>
}
If you're using ASP.NET Core or .NET 5, use the asp-* attributes instead:
Layout:
<script src="https://ajax.aspnetcdn.com/ajax/jquery/jquery-3.3.1.min.js"
asp-fallback-src="~/lib/jquery/dist/jquery.min.js"
asp-fallback-test="window.jQuery"
crossorigin="anonymous"
integrity="sha384-K+ctZQ+LL8q6tP7I94W+qzQsfRV2a+AfHIi9k8z8l9ggpc8X+Ytst4yBo/hH+8Fk">
</script>
<script src="https://ajax.aspnetcdn.com/ajax/bootstrap/3.3.7/bootstrap.min.js"
asp-fallback-src="~/lib/bootstrap/dist/js/bootstrap.min.js"
asp-fallback-test="window.jQuery && window.jQuery.fn && window.jQuery.fn.modal"
crossorigin="anonymous"
integrity="sha384-Tc5IQib027qvyjSMfHjOMaLkfuWVxZxUPnCJA7l2mCWNIpG9mGCD8wGNIcPD7Txa">
</script>
<script src="~/js/site.min.js" asp-append-version="true"></script>
@RenderSection("scripts", required: false) View:
@section scripts {
<script src="https://ajax.aspnetcdn.com/ajax/jquery.ui/1.9.2/jquery-ui.min.js"></script>
<link href="https://ajax.aspnetcdn.com/ajax/jquery.ui/1.9.2/themes/blitzer/jquery-ui.css" rel="stylesheet" />
<script src="~/Scripts/selectAuthor.js" asp-append-version="true"></script>
}
Either way, make sure you only include each library once in the page, and that you include them in the correct order. Check the "view source" option in your browser to view the rendered output to make sure it's doing what you expect.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
|
It works with the first approach. The only problem is that the dropdown autocomplete menu is not shown directly under the textbox, but rather in the top-left corner.
|
|
|
|
|
|
I have created housie game page, but it is loading slow. Can some one suggest is it coding issue or network issue.
If i run code locally on my pc, it runs fast, but once uploaded on site winmilestone com, it becomes slow.
page winmilestone com / housie
Host server is in usa location, does the site becomes slow if accessed from different countries.
for example, if I click/mark number in housie game, it takes time to refresh but when i test it in my local server, housie game is fast.
how can i test my website speed access across different countries, to check if site is fast in usa and slow in other countries.
|
|
|
|
|
|
Sub Salesorder()
Dim found As Boolean = False
cn.Open()
cm = New SqlCommand("select * from tblbill where SalesOrderNo like '" & txtInvoiceFor.Text & "'", cn)
dr = cm.ExecuteReader
dr.Read()
If dr.HasRows Then found = True Else found = False
dr.Close()
cn.Close()
If found = True Then
cn.Open()
cm = New SqlCommand("update tblbill set INno = @INno where SalesOrderNo=@SalesOrderNo", cn)
With cm.Parameters
.AddWithValue("@INno", txtInvoiceNo.Text)
.AddWithValue("@SalesOrderNo", txtInvoiceFor.Text)
End With
cm.ExecuteNonQuery()
cn.Close()
End If
End Sub
|
|
|
|
|
asp.net is presentation layer this is database layer.
Never underestimate the power of human stupidity -
RAH
I'm old. I know stuff - JSOP
|
|
|
|
|
|
Sorry for another thread.
I have the following that is supposed to read from web.config file.
public string ReadConfig(string ValueToGet)
{
System.Configuration.AppSettingsSection section = (System.Configuration.AppSettingsSection)config.GetSection("appSettings");
return section.Settings[ValueToGet].Value;
}
string URL = Master.ReadConfig("DailyReport");
The application runs perfectly on my local machine but again when run from the server, it gives the following error:
Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
Any idea how to fix this?
Thanks again in advance
|
|
|
|
|
Which line of code raised the error? The actual problem is usually not to difficult to resolve once you know which reference is the problem. You may wish to edit your question and show the actual contents of the config file. Are you sure all refernces are correctlym spelled?
|
|
|
|
|
Richard, thanks for your response.
This is the ReadConfig () method:
public string ReadConfig(string ValueToGet)
{
System.Configuration.AppSettingsSection section = (System.Configuration.AppSettingsSection)config.GetSection("appSettings");
return section.Settings[ValueToGet].Value;
}
The first error is on this line:
return section.Settings[ValueToGet].Value;
Then ReadConfig tries to call the report with this:
string URL = Master.ReadConfig("DailyReport");
This is the line that generated the second error.
Then this is the web.config content that Master.ReadConfig("DailyReport"); is trying to call:
<add key="DailyReport" value="http://servername/ReportServer?/Reports/DailyReport"/>
I have had similar issues with ReadConfig() function which I was able to resolve.
For instance, This line was generating exact same error:
appVersion.Text = ReadConfig("AppVersion");
and I was able to resolve it with this:
WebConfigurationManager.AppSettings["AppVersion"]
But the Master.ReadConfig(...) line is a bit too challenging.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
