Software Applications Programming Errors and solutions.

If you have lot of databases in sql and want to add any user to all database then you do not need to add user in each database. You can add user directly from security menu in sql which is located outside of databases. security menu exists in all individual database and outside of database so if you add user from outside then that user get automatically added to all database. You can assign right using server mapping properties.

If you want to delete any user from database security but you are not able to delete that user due to schema then you can change schema authorization to dbo. To do that you can try following command in sql query analyzer. use databasename ALTER AUTHORIZATION ON SCHEMA::YourSchemaName TO dbo; I hope this post will help you.

MS BI is a platform on which an organization can build out their analysis capabilities and enhance their presentation of decision critical data through dimensional modeling and data mining algorithms to identify opportunities for improving the effectiveness of marketing, operational efficiencies and identifying areas that would yield the best return on investment as well as many other applications.

To Import Excel data in to SQL Server Database table You can visit link below to download code and details. This code is based on ADO.net. Import Excel data in to SQL Server Database table Same way you can Read Excel rows into Gridview using asp.net. Read Excel rows into Gridview using asp.net

How to connect MS access database with your C# windows application. This link can explain you details with code sample which can help you to design your application. Connecting MS Access Database in C#

If you want to clear or expire session in Asp.net page than you can try following code hints. Seesion.Abandon(); Response.Cookies.Clear(); To make session expire HttpCookie YourCookie; YourCookie.Expires = DateTime.Now.AddDays(-1);

Check this link Streamline Your Database Setup Process with a Custom Installer. http://msdn.microsoft.com/en-us/magazine/cc163919.aspx Keep in mind it is just an example but you should be able to see the idea and create your own installer. Depending on how you are creating your setup project, you will have to follow that technology's guidelines. Check out this site.  http://wixtoolset.org/