Hello fellas, If you've faced a situation like where you have data in different databases located in different servers then in case of SQL server there's a solution to that problem- linked server. Linked server can be set up through SQL server to SQL server or other servers as well.
This piece of code is to retrieve data from database. Integrated security set to false for sql server authentication. After passing the dataset to view and display as table I wrote my view like this.
To import excel to sql server database I did as following: 1. Add Reference Add Microsoft Excel 15.0 Object Library to the reference. Too refer it in controller I added it as following: 2. Create model I have created a student model. Highlighted part is to auto generate id. 3. Upload
Create a stored procedure in database After expanding the database follow this: Programmability>Stored Procedures>Right click on it and select New Stored Procedure Here write codes to create a procedure. I created a simple procedure like following: My procedure's name is GetProducts which will take a parameter named pricerange of