C# Dot Net Questions and Free Solutions

How to Convert Time in Different Time Zones C#

2012-02-14T07:35:00.000-08:00

Time Zone

In this article, we will discuss about how to convert time according to time zone. I am using TuneZoneInfo class to retrieve information about the current time zone and you can convert it to UTC (Coordinated Universal Time) or vice versa. And also you can use this class to retrieve information on any time zone defined on the local system.

#region TimeZoneConverter Source

private void frmTimeZoneConverter_Load(object sender, EventArgs e)

{

// get and set current date and time

lblLocalTimeIndicator.Text = DateTime.Now.ToString();

// Get system (local) time zone information in to readonlycollection list

ReadOnlyCollection<TimeZoneInfo> TimeZoneColl = TimeZoneInfo.GetSystemTimeZones();

cmbTimeZones.DataSource = TimeZoneColl;

cmbTimeZones.DisplayMember = "DisplayName";

cmbTimeZones.ValueMember = "Id";

}

private void cmdTimeConvert_Click(object sender, EventArgs e)

{

if (cmbTimeZones.SelectedIndex > 0)

{

DateTime dt = DateTime.Now;

// Convert current time in to selected time zone.

lblConvertedTime.Text = TimeZoneInfo.ConvertTimeBySystemTimeZoneId(dt, TimeZoneInfo.Local.Id, cmbTimeZones.SelectedValue.ToString()).ToString();

}

#endregion TimeZoneConverter

#region Information

private void GenaralInformation()

{

TimeZoneInfo tzi = TimeZoneInfo.Local;

// Gets and sets standared time zone name.

lblCurrentTimeZoneStd.Text = tzi.StandardName;

// Gets and sets the daylight saving time zone name.

lblCurrentTimeZoneDlt.Text = tzi.DaylightName;

//set current time and date

lblCurrTime.Text = DateTime.Now.ToString();

// check whether daylight serving is available

lblDaylightSavingYes.Text = tzi.IsDaylightSavingTime(DateTime.Now).ToString();

// set universal time

lblUniTime.Text = DateTime.Now.ToUniversalTime().ToString();

// get and set time different between local and universal time(UTC).

lblOffset.Text = tzi.BaseUtcOffset.ToString();

}

private void tabControl1_SelectedIndexChanged(object sender, EventArgs e)

{

GenaralInformation();

}

#endregion

This will Support this .Net frameworks
.net framework 4.0
.net framework 3.5
.net framework 3.0
.net framework 2.0

.NET Framework Client Profiles
Supported in: 4, 3.5 SP1

The entire source code of this article can be downloaded over here.

If you have any question regarding this article please be kind enough to mention it on comment area.
Thank you for viewing this article.
Give me a +1 if you think it was a good article

Windows 8 NEW FEATURES APP Development

2012-02-10T08:24:00.001-08:00

Windows 8

Windows 8 has a new developer platform according to Microsoft Vice President Julie Larson-Green. The primary purpose of this article is to discuss the new features coming up in Windows 8. Especially I ll consider from the development side.

Here is the list of new features coming up in Windows 8 which I found based on various sources in internet.

Windows 8 Application Development features

A New developing environment for software developers
Windows Runtime (WinRT) and app model
Adding Metro style to apps
It provides broad range of app programming languages
Compatibility with existing frameworks
Able to build component libraries with extensible frameworks
Able to create immersive user interfaces with adaptive layout
Massive media support for apps
Developing support for Internet Explorer 10
Support for frameworks
Maximize your earnings through Windows apps Store

Developing for Windows 8

In windows 8, Microsoft has provided number of excellent new feathers to the developers. It gives platform and tools to create rich app experiences where customers focus on tasks that are important.

With this new environment

Web developers can use their HTML5, CSS3, and JavaScript skills to build native applications for Windows.
.NET Developers can use XAML, C#, and Visual Basic to build beautiful Metro style apps.
Game developers can use the power of DirectX 11.1 to build amazing, immersive gaming experiences.
Driver developers can use the new, integrated Microsoft Visual Studio development environment to increase productivity.

Windows Runtime and app model

The Windows Runtime (WinRT) is providing set of APIs used to build Metro style apps for the developers. You can use WinRT API to in multiple languages such as JavaScript, C++, C#, and Visual Basic. As well as HTML5 and CSS3 APIs that are accessible to Metro style app developers.

Adding Metro style to apps

Metro style UI controls are designed for both touch devices and for mouse and keyboard. There are the three kinds of controls that you can use.

Standard controls – these controls includes tools to display, enter, and manipulate data and content. Such as view, text, pattern, overlay, media (audio and video), content, collection, and basic.

Collection controls – these controls give developers to create rich content experiences in consistent, touch-friendly ways. Such as simple list, grid view, grouped grid view, flip view, and semantic zoom.

Intrinsic controls

It provides broad range of app programming languages

If you develop windows Metro style apps using JavaScript leverage, then you can use combination of HTML5 and CSS3 to build the user interface and JavaScript for app logic. If you use C++, C#, or Visual Basic to build apps, you have to use XAML markup for the user interface, with C++, C#, or Visual Basic for app logic. Game developers are able to build Metro style type games using C++ and DirectX 11.

Compatibility with existing frameworks

WinRT APIs are able to access other Microsoft programming frameworks, like the .NET Framework or Windows C Runtime Library.

Able to build component libraries with extensible frameworks

By using windows 8 app models feature, you can build reusable component libraries. You can build your own custom components with C++, C#, or Visual Basic and then, you can use JavaScript or any other supported language to call these components from your apps.

Able to create immersive user interfaces with adaptive layout

By using Metro style apps, you can build attractive user interfaces using css3. It provides to your customers a fluid, natural-feeling experience. Smooth Animations, 3-D transformations, Flexible box layouts, Grid layouts, Multi-column layout are available.

Massive media support for apps

You can integrate audio and video content with your application using declarative APIs with support for many popular codecs.

Metro style apps also have access to the Windows.Media namespaces. By using this you can enable capturing, transcoding media, Play stream audio, video, or images to networked devices. With camera capture support, you can create capture controls, use a preview window, and specify resolution and codecs for media capture.

Developing for Internet Explorer 10

Internet Explorer 10 support for modern standards like HTML5, CSS3, and SVG, as well as hardware-accelerated graphics and compiled JavaScript. This type of technology provides you to build the next generation of web experiences.

Support for frameworks

The Windows 8 SDK includes free versions of Microsoft Visual Studio 2011 Express and Microsoft Expression Blend, as well as the latest tools, APIs, compilers, debuggers, sample apps, documentation, templates, tutorials, and guidance from the experts. Visual Studio 2011, Express, and Expression Blend work perfectly with Windows 8

Windows Dev Center provides developers to a dashboard which includes many ways to improve developing apps by monitoring their success. Such as View reports on downloads, revenue, usage, in-app transactions, customer ratings, market trends, and crash and hang data.

Maximize your earnings through Windows Store

Windows Store will meet your application with millions of customers to anywhere in the world. This environment will provide you to distribute, update, and get paid for the apps that you develop. Windows store has an ability to revenue-sharing approach so you can earn more. When you submit an app to Windows Store, you can specify whether the app is free, a trial version or full. With in-app purchases, you can set up your app to let a customer ot buy content or new functionality, such as unlocking the next level of a game etc... and also you can select countries or regions to sell your app.

Windows 8 NEW General FEATURES

2012-02-10T08:24:00.000-08:00

Here is the list of new features coming up in Windows 8 which I found based on various sources in internet.

General Features

New Tile based start screen
Touch keyboard
Windows 8 App Store feature
Apps can work together
Metro style
Picture password
New Task Manager
New easy restore
USB 3.0
Support for fewer Restarts

New Tile based start screen

A Tile is a program shortcut which displayed in home screen of Windows 8. And it is a small, rectangular program interface similar to the Icons. Tile is "Live" and "Interactive". Especially programs are able to display information on the Tile like notifications; current status etc. by using this you can get details and notifications from a program even when it is closed (not running). Users can click on the tile and perform some operations without opening the application.

As an example Tile for your mail account can show the number of new emails. A stock ticker Tile can display the current trading value of few stocks.

Microsoft is bringing significant changes to icon concept with tile. The classic start menu is being replaced with a Tile based start screen.

Have used Windows Phone 7 will be familiar with the Tiles. Windows 8 borrows tile from the Windows 7 Phone UI. And Tile is touching friendly.

Touch keyboard

Windows 8 provides two touch keyboards for users for mobility and flexibility which is full size touch, Because of this it easy to use your computer on the go. It’s more comfortable and natural to type using your thumbs when the keyboard is split Whether you’re walking around or sitting down.

Windows 8 App Store feature

Microsoft introduction a Windows Store on Windows 8, like Ubuntu Software Center, and Mac App Store, that allows developers to publish their Metro-style applications on Windows 8 devices.

If you signing up with windows Store, which means you can sell your app through Windows Store and you can tap into the broad customer reach of Windows around the world.

Apps can work together

If you want to send some pictures in email, in different places like facebook, flicker you can easily pick and send the ones you want. Likewise apps can communicate with each other in windows 8.

Metro style

Microsoft has extensively redesigned "Metro-style" user interface, optimized for touchscreens as well as mice and keyboards for Windows 8.

Picture password

Instead of typing a password in login for the screen, a new authentication method allows users to use a set of gestures in the selected picture to login.

New Task Manager

A new Task Manager replaces with new Windows Task Manager (though the old version is also included).

New easy restore

Windows 8 comes with two new recovery functions. Which are named as Refresh and Reset, and both make a complete restore easier than a re-installation.

USB 3.0

New USB 3.0 ports operate at speeds up to ten times faster than USB 2.0. To better support these speeds and longer battery life. Microsoft is outfitting Windows 8 with native USB 3.0 drivers.( windows 8 will have built-in support)

Support for Multiple Monitors

Windows 8 will include support for multiple monitors; The Developers Preview of the new OS includes first-time capabilities for extending the taskbar across two PCs, without any need for third-party apps. And it is easy to switch between multiple monitors.

Support for fewer Restarts

In Windows 7 it gave users for number of options to update notifications and installation. Users could elect to have updates installed automatically or option for notification when an update was available and users have to choose to be notified only before the installation.

But in Windows 8, Most of those options will remain. Users will only be asked to restart their PCs so that an update can take effect once per month-on patch Tuesday. That's usually the second Tuesday of each month. There's one exception--critical security patches will trigger an update request immediately.

What is c# / What is C sharp

2012-02-10T02:26:00.000-08:00

C sharp

C# is a software design and programming language which enables object oriented concepts. It is invented around 1999 or 2000 by Anders Hejlsberg at Microsoft.

C# is designed to work with Microsoft's .Net platform.

It is very similar to java. But C# does not support multiple inheritance. It provides interfaces. Interfaces implemented by a class specify certain functions that the class is guaranteed to implement.

Interfaces avoid the multiple inheritance while maintaining the ability to let several classes implement the same set of methods.

Microsoft .NET Framework 4

Another useful feature of C# is garbage collection. Therefore, it is unnecessary to add a destructor for each class unless a class handles unmanaged resources. If so, it's necessary to release control those resources from within the class.

C# also provides direct access to memory through C++ style pointers, but these pointers are not garbage collected until specifically released by the programmer.

In C#, .NET framework, programmer’s code is compiled in to MSIL (Microsoft Intermediate Language) which is similar to the java bitecode.

MSIL allows C# to be platform independent and runs using just in time compiling.

The MSIL is what allows C# to be platform independent like bytecode.

What are the Variables and Variable Types in C sharp

2012-02-10T02:11:00.000-08:00

"Variables" are simply storage locations for data in program. Programmer is able to place data into variable and retrieve their contents. The interpretation of the data in a variable is controlled through "Types".

The C# simple types consist of the Boolean, Integrals, Floating Point, Decimal and String. In integrals types includes sbyte, byte, short, int, uint, long, and char.

In “Floating Point" refers to the float and double types

The Boolean Type
Boolean types are declared using the keyword, bool. They have two values: true or false.
bool state = true;
bool noState = false;

Integral Types
They are whole numbers, either signed or unsigned. Integral types are well suited for those operations involving whole number calculations.

The Size and Range of C# Integral Types

Type	Size (in bits)	Range
sbyte	8	-128 to 127
byte	8	0 to 255
short	16	-32768 to 32767
ushort	16	0 to 65535
int	32	-2147483648 to 2147483647
uint	32	0 to 4294967295
long	64	-9223372036854775808 to 9223372036854775807
ulong	64	0 to 18446744073709551615

Floating Point and Decimal Types

In C# floating point type is either a float or double. Floating point types are used when you need to perform operations requiring fractional representations.

The Floating Point and Decimal Types with Size, precision, and Range

Type	Size (in bits)	precision	Range
float	32	7 digits	1.5 x 10^-45 to 3.4 x 10³⁸
double	64	15-16 digits	5.0 x 10^-324 to 1.7 x 10³⁰⁸
decimal	128	28-29 decimal places	1.0 x 10^-28 to 7.9 x 10²⁸

The string Type
A string is a collection of characters. This type allows us to manipulate character data through methods and properties. It provides methods to concatenate, append, replace, search and split.

String has the following characteristics

It is a reference type – string is not a value type. It is a reference type.
It's immutable - You can never change the contents of a string. If you try to do, it just sets the value of string to a new string, which is a copy of the old string.
It can contain nulls - In .NET, strings can contain null characters with no problems at all as far as the string methods themselves are concerned
It overloads by the == operator - When the == operator is used to compare two strings, the Equals method is called

What is Enumeration or Enums

2012-02-08T09:10:00.000-08:00

In this c sharp question, we will discuss about Enumerations.

Enumeration or Enums store special values. They make programs simpler by providing an efficient way to define a set of constants which they may be assigned to a variable. If you use constants directly to do this, your C# program rapidly becomes complex and hard to change. Enumeration will provide you to keep these magic constants in a distinct type. This improves code clarity and alleviates maintenance issues.

As an example if you define a variable which will represent a day of week then there are only seven meaningful values. To define those values, you can use an enumeration type, which is declared by using the enum keyword.

enum Days { Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday };

By default type of each element in the enum is int. if you need to specify another type then you need to implement it by using a colon, as shown in the bellow example

enum Days : byte { Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday };

If you do not specify values for the each element in the list the values are automatically incremented by one. Like

Days.Sunday has a value of 0

Days.Monday has a value of 1

And so on.

class Program

{

enum Days { Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday };

static void Main(string[] args)

{

// These values are enum Days types.

Days weekend_ = Days.Saturday;

if (weekend_ == Days.Saturday)

{

// Will be printed.

Console.WriteLine("Today is Weekend");

}

if (weekend_ == Days.Sunday)

{

// Will not be printed.

Console.WriteLine("Today is Weekend");

}

And also you can assign any values to the elements in the enumerator list of an enumeration type, and you can also use computed values at the program.

enum MyDayPlan

{

Getup = 5,

Schooling = 8,

Swimming = 5,

Eating = Swimming + 2

}

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

2012-02-08T09:05:00.001-08:00

Microsoft DreamSpark Offers Free Download Visual Studio 2008, Server 2003, SQL Server 2005 and more to student

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 the world that can confirm student status.

Free Offers,

.NET Mobile

2012-02-08T09:05:00.000-08:00

.NET Mobile

Mobile technology
1. Today, Cell phones(mobile phones) have becoming part of our life style.

2. Now Mobile devices can connect to the Internet, and execute web applications contents.

3. Different mobile devices support different programming languages. Some support WAP and WML, some support HTML or a limited version of HTML, and some support both or a different language.

To support all types of mobile devices, developers must create one different application for each language.

NET Mobile, Microsoft has introduced a new platform for developing mobile applications.

Introduction
Before moving further, I want to give you a brief introduction.
.NET is a developmental platform introduced by Microsoft at their 2000 Professional Developers Conference (PDC). The following figure shows a simple architecture of the .NET framework application development.

Requirements for development

To develop mobile applications with .NET, you must download and install the following components. IE and the .NET SDK can be downloaded from the Microsoft MSDN site for free.

Windows 2000 Professional/Server/Advanced Server OS
Internet Explorer 5.5
.NET framework Beta 1
.NET Mobile Web SDK Beta 1
Your favorite WAP simulator.

The mobile controls provided by ASP .NET target, as the name suggests, mobile devices (cell phones, Palms, etc.). This article will give you an idea of how to develop mobile web applications using ASP .NET and the Microsoft Visual Studio .NET environment. It will describe some of the most important mobile specific controls but won't go deep into the subject. At the end we'll also take a look at the Pocket PC Emulator 2002 which is included in Visual Studio .NET.

The ways mobile pages are organized differ from the classic web pages that you see on your computer. One mobile page is represented by a Form and a typical file ( MobileWebForm1.aspx ) can contain multiple forms, therefore multiple pages. This way when you open a page with the WAP browser actually multiple pages will be loaded (represented by forms) and when you click a link to one of the other forms there will be no loading time because they are in the same page. There is a good reason for this. Some WAP browsers disconnect after they retrieve the webpage to save the battery of the mobile phone and the money if the connection is charged per minute. This way they won't have to reconnect every time a new form is loaded, if it is located in the same file.

More Information

SQL Server security model

2009-06-30T02:45:00.000-07:00

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
• An SQL Server login, that is maintained within SQL Server
These login names are maintained within the master database. So, it is needed to backup the master database after adding new logins to SQL Server to the machine.

User: A valid user account within a database is required to access that database. User accounts are specific to a database. All permissions and ownership of objects in the database are controlled by the user account. SQL Server logins are associated with these user accounts. A login can have associated users in different databases, but only one user per database.
During a new connection request, SQL Server verifies the login name supplied, to make sure, that login is authorized to access SQL Server. This verification is called Authentication. SQL Server supports two authentication modes:

• Windows authentication mode: With Windows authentication, you do not have to specify a login name and password, to connect to SQL Server. Instead, your access to SQL Server is controlled by your Windows NT/2000 account (or the group to which your account belongs to), that you used to login to the Windows operating system on the client computer/workstation. A DBA must first specify to SQL Server, all the Microsoft Windows NT/2000 accounts or groups that can connect to SQL Server

• Mixed mode: Mixed mode allows users to connect using Windows authentication or SQL Server authentication. Your DBA must first create valid SQL Server login accounts and passwords. These are not related to your Microsoft Windows NT/2000 accounts. With this authentication mode, you must supply the SQL Server login and password when you connect to SQL Server. If you do not specify SQL Server login name and password, or request Windows Authentication, you will be authenticated using Windows Authentication.
Point to note is that, whatever mode you configure your SQL Server to use, you can always login using Windows authentication.

Windows authentication is the recommended security mode, as it is more secure and you don't have to send login names and passwords over the network. You should avoid mixed mode, unless you have a non-Windows NT/2000 environment or when your SQL Server is installed on Windows 95/98 or for backward compatibility with your existing applications.

Sql Server Hosting , web hosting

2009-04-01T23:58:00.000-07:00

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 Types in sql server hosting
SQL Server 2008 introduces new date and time data types: DATE, TIME, DATETIMEOFFSET, DATETIME2. The new data types enable applications to have separate data and time types.

Spatial Data Types help build spatial capabilities into applications by using the support for spatial data. Customers can implement Round Earth solutions with the geography data type, using latitude and longitude coordinates to define areas on the Earth's surface. Customers can also implement Flat Earth solutions with the geometry data type, storing polygons, points, and lines that are associated with projected planar surfaces and naturally planar data, such as interior spaces.

Integrated Full Text Search in sql server hosting
Integrated Full Text Search makes the transition between Text Search and relational data seamless.

Sparse Columns in sql server hosting
NULL data consumes no physical space, providing an efficient way of managing empty data without experiencing large space costs.

Large User-Defined Types in sql server hosting
SQL Server 2008 eliminates the 8-KB limit for User-Defined Types (UDTs), allowing users to expand heir UDT size.

Remote SQL 2008 Management in sql server hosting
Customers can manage their SQL 2008 databases remotely with any sql client like SQL Management Studio or SQL Management Studio Express.

Web-based SQL Manager in sql server hosting
Customers can manage their SQL 2008 databases with a web-based SQL manager powered by myLittleAdmin.

Other SQL server Hosting 2008 & Control Panel Features

1. DBO Rights in the SQL Server Hosting
2. Stored procedure support for sql serce in the SQL Server Hosting
3. Full text search in the SQL Server Hosting
4. ASP.NET SQL Session in the SQL Server Hosting
5. Order Multiple SQL 2008 Database Addons in the SQL Server Hosting
6. SQL Disk Space Meter in the SQL Server Hosting
7. SQL Login Password Reset Tool in the SQL Server Hosting
8. Additional SQL 2008 Login Manager in the SQL Server Hosting

The goal of the SQL Server Hosting Toolkit is to enable a great experience around SQL Server in shared hosting environments.

The toolkit will eventually consist of a suite of tools and services that holsters can deploy for use by their customers. It will also serve as an incubation vehicle for tools that hosting customers can download and use directly, regardless of whether their holster has deployed the toolkit. See the Project Roadmap for details on where we're going.

How to Order a SQL Server Database Hosting Plan

If you wish to add a SQL Server database option to your hosting account, simply add the option when you order your hosting account. If you need a SQL Server database without a website, you can do it easily.

SQL Backup Service
SQL Backup Service is optional additional backup service that lets you determine how often you want accessible backup files created of your valuable information. See how you can go beyond emergency backups and be in control of your data protection.

SQL Server Hosting Technical Information
For information on using SQL Server Enterprise Manager, SQL Server Query Analyzer, DTS, ODBC/OLEDB database connections, SQL Server Management Studio and more,

SQL Server 2005 Information and Resources
SQL Server 2005 drives better decision-making with enterprise-grade reporting and data analysis. A highly reliable database platform for critical applications, SQL Server 2005 delivers high levels of availability, performance, and security. For more information and links to SQL Server 2005 resources.

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

2009-03-25T21:43:00.001-07:00

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 the world that can confirm student status.

What are the Free Offers,

Microsoft developer tools:
o Visual Studio 2005 Professional Edition
o Visual Studio 2008 Professional Edition
o XNA Game Studio 2.0
o 12-month free membership in the XNA Creators Club

Microsoft designer tools:
o Expression Web
o Expression Blend
o Expression Design
o Expression Media

Microsoft platform resources:
o SQL Server 2005 Developer Edition
o Windows Server, Standard Edition

How do I get it?

1. Go to www.dreamspark.com

2. Log in with your Windows Live ID (e.g. your Hotmail or Messenger email address)

3. Select the software you wish to download or get the license key

4. Down the bottom of the page, select the “Verify” button, to verify that you are a student. You will only have to do this once.

5. After you have selected “Verify”, select your country and university, and then select the “Select and Continue” button

6. The you will be showed you for a username and password. Enter the same details that you would use for your UTS webmail, ( i.e. your UTS student number and your UTS webmail password. www.dreamspark.com will connect to UTS (auth-idp.uts.edu.au), UTS will verify your username/password, and send back to www.dreamspark.com whether you are a student or not)

7. Once your student status has been confirmed, go back to the software page, and the download button will now be activated. Also, a section will have appeared at the bottom of the page allowing you to get your license key for the software.

If you have any question Please comment here !

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

2009-03-24T01:34:00.000-07:00

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 add it to value “adam”.

4. Next, we want to add this newly created row (with two columns) to the blank Datatable we created in the first step.

dt.Rows.Add(newRow);

5. You can now set this created Datatable as a DataSource and then DataBind to the GridView or any other similar C# control.

gridView1.Datasource = dt;
gridView1.Databind();

All the steps from above are put together in the below:

DataTable dt = new DataTable();
DataRow newRow = dt.NewRow();
newRow["id"] = 1;
newRow["username"] = "adam" ;
dt.Rows.Add(newRow);
gridView1.Datasource = dt;
gridView1.Databind();

Let see how to add multiple records in datatable without write multiple time code

DataTable dt = new DataTable();
dt.Columns.Add("Min", System.Type.GetType("System.Int32"));
dt.Columns.Add("Max", System.Type.GetType("System.Int32"));
dt.Columns.Add("Avg", System.Type.GetType("System.Int32"));

for (int i = 0; i < i =" i">
{
DataRow dr = dt.NewRow();
row["Min"] = i;
row["Max"] = i + 9;
row["Avg"] = (i + 9) / 2;
dt.Rows.Add(dr);
}

You can add values to row using for loop.

SQL Server 2005 — Enhancements

2009-03-17T02:57:00.000-07:00

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 new databases, applying T-SQL scripts, Creating SQL Server Agent jobs and so on

1. SQL Server Management Studio :
It is a one point access to a number of services – the relational database, the Integration services, Analysis services, Reporting services, Notification Services and SQL Mobile.
Indexing capabilities
The SQL Server 2005 has been greatly enhanced. Indexes can be created, rebuilt or dropped online without disturbing existing indexes. This online indexing capability allows parallel processing, concurrent modifications to the table in the database or clustered index data or any other associated indexes.

2. Peer to peer model of replication
It is enables synchronization of transactions with an identical peer database. This further improves availability of data.

3. Table and index partitioning
It is concept of large databases by dividing the whole into manageable chunks. The concept is not new to the SQL Server, but the partitioning of tables horizontally across file groups in the database is new.

4. Snapshot isolation
This feature allows users access the last row that was committed by providing a transactional and consistent view of the database.

5. Replication monitor tool
It defines a new standard for managing complex data replication operations. Its interface is intuitive and has a number of data metrics that are useful.

6. New security model
Security model of the database platform now provides more precise and flexible control for ensuring security of store data.

7. Encryption capabilities
Data encryption of the database has been integrated with the management infrastructure for centralization of security assurance and server policy.

8. Secure computing measures
Those things have been put in place to enable deployment of a secure environment.
SQL Server Express Manager (XM)
This is a free Query Editor tool that is available for download.

9. Improved Business Intelligence

10. Improved Analysis Services

11. Improved Reporting services

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

2009-03-12T01:01:00.000-07:00

// 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 file?";

// Start directory
obDialogSave.InitialDirectory = @"C:/";

// Show the dialog and process the result
if (obDialogSave.ShowDialog() == DialogResult.OK)
{
// your code go here if user click on “OK” button.
MessageBox.Show("You selected the file: " + DialogSave.FileName);
}
else {
// your code go here if user click on “Cancel” button.
MessageBox.Show("You click cancel.");
}

obDialogSave.Dispose();

// Set object to null.
obDialogSave = null;

What is .Resx file in Dot Net?

2009-03-12T00:58:00.000-07:00

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 = resourceManager.GetString("lblFirstName");
And that's it—just two lines. There's no need to change a million sections of code each time you add or take away a language.

Reading from .Resx File:

You can access the .Resx file using this code:

ResXResourceReader reader = new ResXResourceReader(Server.MapPath("fileName.resx"));
IDictionaryEnumerator rsxr = reader.GetEnumerator();
foreach (DictionaryEntry d in reader)
{
Console.WriteLine(d.Key.ToString() + ":\t" + d.Value.ToString());
}
//Close the reader.
reader.Close();

Writing to .Resx File:

We can write the binary data of an image to the .Resx file using the following code

Image img = Image.FromFile("abc.jpg");
ResXResourceWriter rsxw = new ResXResourceWriter("abc.resx");
rsxw.AddResource("urdu.jpg",img);
rsxw.Close();

Use of .Resx File:

It is very useful while working on Localized project [Multiple Languages], You can make different resource files for different languages and depending upon the user choice you can change the Language of the application.

C# reading data from Serial port

2009-02-03T12:53:00.001-08:00

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 port
2) 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 port

Then I will build additional code surrounding handling the data in the textbox.

Answer -

I set up my serialport like this

sp.BaudRate = 115200;
sp.PortName = "COM53";
sp.DataBits = 8;
sp.StopBits = System.IO.Ports.StopBits.One;
sp.Parity = System.IO.Ports.Parity.None;
sp.ReadTimeout = 0;
sp.Open();
sp.DataReceived += new
System.IO.Ports.SerialDataReceivedEventHandler(sp_ DataReceived);

and then I have this

void sp_DataReceived(object sender,
System.IO.Ports.SerialDataReceivedEventArgs e)
{

string Mystring = sp.ReadExisting();
byte testbyte = 254;
// Gather all the bytes until 102 is reached
foreach (byte c in Mystring)
{
if(pixelcount<102) pixelcount ="="" testbyte =" {0}" oldx =" 0;" pixelcount =" 0;">

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

2009-02-03T12:20:00.000-08:00

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 to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"

and yes i did detach the database / disable windows firewall / shutdown anti-virus sw before i try to connect.

* also, let me say i manage to connect for OLE DB (Access 2007) with no problems

does visual c# express edtion got to do with this problem, i mean if full version of visual studio can solve the problem ?

Looking for a solution if possible for the SQL server 2008.

Answer -

Upgrade will definitely solve the problem. The full version of Visual Studio provides support to SQL Server.
The comment about "Real" SQL Server, means that you can connect to the server itself (rather than just the SQL Server files)
I have heard of folks who just bypass the connection wizard and code the connection to the SQL Server "by hand". Using this technique, you *can* use C# Express to connect to a SQL Server... but you've got to do all the work.

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

2009-02-03T12:10:00.000-08:00

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 & dataadapte
SqlConnection con = new SqlConnection("server=localhost;Initial Catalog=databasename;uid=;pwd=;");
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter("stored proc name", con);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.Fill(ds);

//create gridview by code & bind dataset to it
GridView g = new GridView();
Page.Controls.Add(g);
g.DataSource = ds;
Page.DataBind();