Відео

have a look at this one ua-cam.com/video/CGvy8f6WSG0/v-deo.html

@@rajeevsingh-fg6in thank you

@@brilliantMotjiang please check if you have added the required libraries in visual studio

Install-Package System.Data.SqlClient Run the above command in Nuget Package Manager Console

Not yet but I will come to it

ajax k through dynamic data laaa kr

Ajax se data toh AA jayega lekin usse data tables ke kuch features kaam nahi karenge, jese pdf xl export, pagination, search etc

Isiliye ek aur coding hoti hai server side coding for data tables, woh chalta hai Ajax k get post k saath

Welcome sir ☺️

Template builder means?

@@fired_developer do u have fb

let connect ill tell

You might have missed out initialising an object before using it in the script section,

@@fired_developer great, i have fixed it, i inspected the page, in my array it's using camel case, which was not in my javascript. but I am having another issue, it's not showing the changes if i insert using a query in my server, , i tried this, , ALTER DATABASE HelpIsOnItsWay SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE SELECT is_broker_enabled FROM sys.databases WHERE NAME='HelpIsOnItsWay' but still not working

@@fired_developer i fixed it by using camel case, but now its not showing the changes in the browser when i make changes in the database, what could be the reason

@@chomuekez check if you have granted permission from SQL

@@fired_developer i did thi "alter database productsDB set enable_broker with rollback immediate", but still not,, it used to show changes but when i altered my table to add a new column thats when it started not showing changes

Thank you 😊

Sir waiting for your reply

What is your email

@@fired_developer For some reason i cant post it here. The comment doesnt send

@@Vaclav-w9l send me on triple.r.pp at gmail

My pleasure

Please run this command in SQL before performing these operations SELECT is_broker_enabled FROM sys.databases WHERE NAME='your_database_name' ALTER DATABASE your_database_name SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE

In SQL run this command

Are you using dotnet identity in your application

@@fired_developer no, how to setting in sql server??is this about have to create a user?? i login sql server 2017 use windows authentication

@@XELTRA1 Please run this command in SQL before performing these operations SELECT is_broker_enabled FROM sys.databases WHERE NAME='your_database_name' ALTER DATABASE your_database_name SET ENABLE_BROKER WITH ROLLBACK IMMEDIATE

@@fired_developer select is broker =1,my connectrion string var conn = "Server=.\\SQL2K17;Database=RealTime;Trusted_Connection=true;MultipleActiveResultSets=true"; no problem using add-migration,update-database , but the problem use var tbDepency = new SqlTableDependency<Person>(conn), the error is TableDependency.SqlClient.Exceptions.UserWithNoPermissionException: 'User without permissions.', hoe to fix that?

@@fired_developer is_broker = 1, conn = "Server=.\\SQL2K17;Database=RealTime;Trusted_Connection=true;MultipleActiveResultSets=true"; using EF for add-migrations,updatedatabase is fine, but the error on using (var tbDepency = new SqlTableDependency<Person>(conn)) is usernotpermission, i dont know how to fix that

My pleasure!

As of now I have only tested it with single table, you probably can use a generic class to accept dynamic table names

@@fired_developer But if i just do the same for another table it should work too no? working with on the same hub or should i try to add another one

@@Vaclav-w9l yes it will

@@fired_developer and should i add other hubs or use just one DashboardHub that is already used.

@@fired_developer And how would i do that? And one more question do i need to do another database migration for another database table or not?

Sorry about that, I actually record at a higher speed than my normal voice

Sorry about that, I have not tested that, but I hope it should

Exactly 💯

Ok I can , in the evening, at work now

This is a part of an actual live project so, I can send the code in email instead of github, please send me your email id

Learned

Rename your model class to match the DB table name. It will be good

Check the GitHub link I provided in the description

Yes it's working coz SQL table dependency connects with your database

Super nice to hear that 🙂

Could you please check that you have installed the signal r client side dlls

If you want i can take a Remote access and help you

Thanks for Reply.👏 It seems there may be an accessibility issue in SQL on my system; it works fine on other systems.

@@MithunKiet if it's accessible issue then look at my video description. I have posted an SQL command to run, in order to grant access to SQL dependency to your tables. Please run it before running your program

@@fired_developer seems this issue is not from sql software i tried installing all the dll still facing same can we connect?

For that you have to select id on click over the table row. Then get the corresponding data from database and bind it to the textbox. Another way is to use jQuery or javascript to get the value of the respective element and assign it to the textbox value

@@fired_developer OdbcDataAdapter da = new OdbcDataAdapter(cmd); DataSet ds = new DataSet(); da.Fill(ds); if (ds.Tables[0].Rows.Count > 0) {TextBox1.Text = ds.Tables[0].Rows[0]["DAN_DATE"].ToString();} This is not working for type=date , where as this working for normal textbox.

Yes, it will work also, because that ultimately connects with the database, and SQL dependency is connected with your database

Thank you sir! :)

Did you check SignalR is installed from the Nuget package manager.

check this file : github.com/triple93r/SignalR_RealTimeTableData/blob/main/SignalRDemo3ytEFC/Views/Dashboard/Index.cshtml

here there is a reference to @section Scripts{ <script src="~/lib/microsoft/signalr/dist/browser/signalr.js"></script> <script src="~/js/dashboard.js"></script> }

so you have to add signalr.js from .net core libraries as in the video to your project 8:22 and then the reference script tags

​@@fired_developer Thanks I now connect to the Hub and display the data but i still have one problem. The data i display shows undefined everywhere not firstname, lastname and department that i have in my database but it shows undefined everywhere.

Lol

Sure I will come up with an API project for this

My pleasure ☺️

My pleasure :)

please put your sample code in github and share me the repository link on triple.r.pp@gmail.com

When you get an undefined error means you have either a variable used that is never initialized or have used the variable before initialization,

My mistake is when make json controller. I don't know hot to get Id from first and second table

@@jawir226 @ 7:46 you will see how the table row id is bonded with the dropdown list using ajax. and at 9:56 you will see my json controller actions passing the values called by ajax