SQL Server security model

SQL Server security model In order to access data from a database, a user must pass through two stages of authentication. first one at the SQL Server level and the other at the database level. These two stages are implemented using Logins names and User accounts respectively. A valid login is required to connect to SQL Server and a valid user account is required to access a database. How to Login: A valid login name is required to connect to an SQL Server. A login could be: • A Windows NT/2000 login that has been granted access to SQL Server •...

Read More

Sql Server Hosting , web hosting

Key SQL Server Hosting Features (2008) SQL Server 2008 64-bit Language Integrated Query (LINQ) in sql server hosting Developers can use queries against data, with using a managed programming language, instead of SQL statements. Developers are enabled to use strongly typed, set-oriented queries to run against ADO.NET (LINQ to SQL), ADO.NET DataSets, the ADO.NET Entity Framework, and to the Entity Data Service Mapping provider. A new LINQ to SQL provider enables developers to use LINQ directly on SQL Server 2008 tables and columns. New Data...

Read More

Microsoft DreamSpark Offers Free Download Visual Studio 2008, Server 2003, SQL Server 2005

What is DreamSpark.Microsoft DreamSpark is a world wide program that provides no-cost access to Microsoft designer and development tools for students, In order to support and advance their learning and skills through technical design, technology, maths, science and engineering activities.Every free Microsoft developer tools download will be verified through an Online Student Status Verification process which linked to schools and organizations around...

Read More

Add a row / Multiple rows to the data table c#.net

I suppose to use a data table as data source in my grid View controller. Can you please explain how I need to do it? 1. The first step is to create an empty Data Table. DataTable dt = new DataTable(); 2. Second step is to create a new DataRow object. DataRow newRow = dt.NewRow(); 3. Now you have created and initialized a DataRow. So then it is needed to add values to rows. newRow["id"] = 1; // we have created column call “id” and add it to value 1 newRow["username"] = "adam" ; // we have created column call “username” and...

Read More

SQL Server 2005 — Enhancements

What are the enhancements for Data Base Administrators in SQL Server 2005 ? SQL Server 2005 has provide single management console that enables data base Administrators monitor, manage and tune all databases and services. SQL Management Object (SMO) is an efficient management infrastructure to easily program. SMO provides all the management functionalities of the SQL Server and is implemented as a Microsoft .NET Framework assembly. The primary purpose of the SMO is to automate administrative tasks such as retrieving configuration settings, creating...

Read More

How to use savefiledialog box in the c#.net ?

// Create a new SaveFileDialog object SaveFileDialog obDialogSave = new SaveFileDialog(); // Set Default file extension to dialog obDialogSave.DefaultExt = "txt"; // Other Available file extensions to dialog obDialogSave.Filter = "Text file (*.txt)|*.txt|XML file (*.xml)|*.xml|All files (*.*)|*.*"; // Adds a extension if the user does not select obDialogSave.AddExtension = true; // Restores the selected directory, next time obDialogSave.RestoreDirectory = true; // To display Dialog title obDialogSave.Title = "Where do you want to save the...

Read More

What is .Resx file in Dot Net?

What is .Resx file in Dot Net? How to access? Resource files are used in .NET to store culture-specific data all in one place, separate from the code. For example, suppose you are developing a multi-language Web site and you have a form on a page with a label beside a text field and the label in English says "First Name." Instead of having code like this: if (language == "English") { lblFirstName = "First Name"; } else if (language == "German") { lblFirstName = "Vorname"; } You can just do this: ResourceManager resourceManager = new ResourceManager("nameSpace.resourceFileBaseName", Assembly.GetExecutingAssembly()); lblFirstName...

Read More

C# reading data from Serial port

Question - I have a device (a GPS type of device) that constantly pushes communication through a standard serial connection (COM1).What I need to be able to do is:Programatically:1) Open the serial port2) Listen for a given period of time (say 2 seconds) to the data that is being received via the serial port.3) populate a multi-line text box with the data that was received from the serial port.4) close teh serial portThen I will build additional code surrounding handling the data in the textbox. Answer - I set up my serialport like thissp.BaudRate...

Read More

Connect to Microsoft SQL server 2008 (enterprise) database from Visual C# 2008 Express

Question - i've created a new database using SQL server managment studio with no problem. database via Management Studio there is no problem, the database appears in the Explorer. however, in Visual C# Express, when I try to 'Add Connection' as follows Data source - MS SQL Server Database File Database File Name - browse to appropriate folder and select Log in using WIndows Authentification And use the same database I receive the message (after a while): "A network-related or instance-specific error occurred while establishing a connection...

Read More

How to use GridView and DataSets in C#.NET 2.0?

Question - I need a example of how to create a gridview in .cs versus just dragging and dropping the gridview on the aspx page?I created a dataset and called a stored procedure using data adapter, but i do not know how to data bind the data set into the grid view I have.It seems everywhere I search the gridview examples they have is just dragging and dropping to the page and configuring a datasource. Answer - //connect to database via dataset & dataadapteSqlConnection con = new SqlConnection("server=localhost;Initial Catalog=databasename;uid=;pwd=;");DataSet...

Read More