Welcome to C# Resources! Deals and savings on C# and C# products for sale!

Creating Sql Database Connection in Asp.net Web Application Through C#

1: Open visual studio 2005 and from FILE select NEW-> WebSite, then from pop-menu select asp.net website (Note: Language must be C#) , then press OK.

2: Now create three textboxes from the toolbox , to remove ambiguity I am using default name for that textboxes and that should be textbox1,textbox2 & textbox3. And also drag & drop the button to the asp.net application.

3: Meanwhile, Open SQL SERVER Management studio 2005 and open adventureworks(or you can create your own database by the Sql command CREATE DATABASE database_name), but here I am using AdventureWorks database.

4: Then create table by clicking right mouse button and form three column, Name them according to your requirement , for your information only I used EID,name,Address. And click save button, then you’ll get a pop up menu where you have to enter the Table Name, for this example I used  students.

5: Now Come Back to Visual studio Application and write the following code in the button_click event

protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection myConn = new SqlConnection();
myConn.ConnectionString = “Connection string(See Below for this — )COPY PASTE  HERE“;

myConn.Open();
string strqry = “Insert into students values (” + TextBox1.Text +
“,’” + TextBox2.Text + “‘,’” + TextBox3.Text + “‘)”;

SqlCommand myCom = new SqlCommand(strqry, myConn);
int numrow = myCom.ExecuteNonQuery();
myConn.Close();

}

Kindly note down the connectionString Syntax, to obtain this string do the following steps:

Step 1 : Go to toolbox and from data section drag & drop SqlDataSource.

Step 2: Then on left clicking the mouse on SqlDataSource , you will get configureDataSource link, Slect this.

Step 3: NewConnection String -> Provide Server Name then select or write database name , i.e. AdventureWorks.

Step 4: TestConnection and then Press OK.

Step 5 : Now you will again redirect to the page that you actually see in the step 2, but this time click + sign before the connection string and from the drop drown hierarchy you will receive the connection string.

Step 6: Just copy and paste this string to the place of connectionstring.

Now debug & run Your application and check it’s effect on the table.

Hope this explanation helps you to understand the basics of database connectivity.

(ArticlesBase SC #692926)

.NET Programming Languages - C# and Visual Basic

When we use ASP.NET we have different language options available - these options include VB.NET and C#. So its depend upon the programmer which language they are using all of the language have there different syntax and language have there own charaterstics. In this article I will talk about Visual Basic and C#. Some people like VB.NET with its simple style and some people like the C# syntaxes. But the similar thing is that both of them using same plateform which is the .NET framerwork. However, there are some important differences between C# and VB.NET.

In VB.NET we have optional parameters which help in development of COM interoperability. In VB.NET we can use construct which is not in available in C#. Another feature of VB.NET is late binding with Option Strict off .We can also use Visual Basic functionalities by using Microsoft.VisualBasic namespace. Another beautiful feature of VB.NET is that it compiles code in the background so this is considered an advantage for small projects, people creating very large projects have found that the IDE slows down considerably as the project gets larger.

Now we come to C#. We can genernate XML documentation from source code but this is now being incorporated in Whidbey. Another good feature that is included in C# is operator overloading which is not available in VB.NET. In C# we have access to Unsafe code which allows pointer arithmetic and we can also improve performance in some situations. 

So these are the some of most elegant differences between VB.NET and C#.

(ArticlesBase SC #804105)

C# Web Multi-view Control

Introduction

At some point in developing web sites or web applications, there will come a time when a requirement of having tab functionality like there is for a Windows application. Before ASP.NET, JavaScript had to be used to achieve this. But when ASP.NET 2.0 came out, a new set of controls were introduced to give the ability of having tab functionality for the web. With the new controls of a multi-view and view when combined with a few basic buttons, the tab can be created.

Scenario

There is a need for an employee to have easy access to their general information and their paycheck information. Instead of creating two separate pages to show this information, a tab will be needed to flip back and forth from one set of information (General) to the other (Paycheck).

Implementation

On a new aspx page, a DIV section needs to be created to hold the button controls that will be acting as tabs. Inside the DIV, add to buttons. To make sure that the buttons look like tabs and not buttons, set the border style to no border and the border width to 0px. Now to let the user know which tab that is currently being view, there needs to be two different background colors for the buttons. Pick contrasting colors so it’s fairly easy to tell the difference. In the article, Gainesboro will be the active tab and Silver will be the inactive tab.

Please Visit Programminghelp.com For the full article and Pictorial tutorial.

http://www.programminghelp.com/web-development/asp-net/c-web-multi-view-control/

(ArticlesBase SC #514624)

ASP.NET - Developers Choice for Web Development

Web development is the beautiful, technical and ingenious work for the online presentation of the different kind of information. This information may show a discrepancy such as business related as well social & cultural. For the creation of attractive, effective websites web developers use a variety of programming languages and ASP.NET website development is popular for easy creation and great features. Plus being a product of world famous Microsoft, it is admired by large web development community at global level.

Like other programming languages it is a full featured programming language for the development of dynamic websites for the online presentation business and its products globally. Under ASP.NET web development work, developers are enabled to perform a variety of web development jobs such as custom software applications, mobile games, web applications, product development, ecommerce shopping cart and database management. According to the ASP.NET experts it is popularized as latest version of Microsoft's Active Server Pages technology (ASP) and widely developers are using this technology for the development of dynamic websites, XML web services and web applications. Technology is having power for the development of large sized enterprise applications for the big companies.

From the technical point of view of the developers why they prefer ASP.NET for the web development?

They enjoy writing very less code for the development of large applications, it offers server-side programming model to make the development work simpler, writing pages in ASP.NET are easier as it provides source code and HTML together, execution of source code on server provides power & flexibility, fast compilation of source code in first request of page because server saves the compiled version for the next time, more security of application source code as it do not sent back to browser, due to inbuilt configuration developer needs not to register components, security through continue monitoring of (pages, components and applications running on it) by web server which automatically kills the (illegal software, memory leaks, infinite loops, etc) and restarts itself and without writing code it provides validation controls.

ASP.NET is server-side technology, as it is most advantageous part in addition to long list of features. Before sending to browser, code use to execute on server and code which is sent back to browser is HTML instead of ASP.NET code which ultimately provides the more security to code from unwanted stealing.

ASP.NET is serving the web development world from year 2002 and introduced five upgraded versions with advanced features. It’s latest in 2008 version 3.5 service pack released with Visual Studio 2008 Service Pack 1.

(ArticlesBase SC #713700)

Generate PDF from HTML with C# in ASP.NET

PDF Duo .Net is a converting component for use in ASP.NET (VB, C# etc.) and enables to convert HTML to PDF. The main class HtmlToPdf provides several methods and properties to enable multi-purpose customization of the resulting PDF. Main functions allow to convert HTML represented as a File, Page from Url address, Stream or as a String.

Developers can easily invoke the converting component in their own application or website projects on base of ASP.NET. To deploy the PDF Duo .Net component you will need only three lines of code. Installing package is provided with fully featured demos written in both C# and Visual Basic. Simple examples with source code help you using the PDF Duo .Net component to successfully convert HTML to PDF.

I have used PDFDuo-NET.dll (version 2.3) in my project which is very useful. First, you need to convert content of your ASPX to HTML and then converted that HTML content into a PDF file or another way which I use is to create a simple HTML string and then convert it.

See below C# code:
using System;
using System.Web;
using System.Web.UI;
using System.IO;
using DuoDimension;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string html = "<table width='240'>" +
"<tr style='background-color:#00AAFF'><td width='50%'>Product</td><td width='25%'>Quantity</td><td>Cost</td></tr>" +
"<tr><td>Product Name 1</td><td>5</td><td>$100</td></tr>" +
"<tr><td>Product Name 2</td><td>15</td><td>$300</td></tr>" +
"<tr><td>Product Name 3</td><td>55</td><td>$500</td></tr>" +
"</table>";
string pdf = "pdf_file.pdf";
DuoDimension.HtmlToPdf conv = new DuoDimension.HtmlToPdf();
conv.PageInfo.PageFormat = ePageFormat.A4;
conv.PdfDocumentInfo.Title = "Generate PDF from HTML source";
conv.Header = "<br><i>HTML table Example</i>";
try
{
conv.OpenHTML(html);
conv.SavePDF(MapPath("~/Reports/") + pdf);
}
catch (Exception ex)
{
throw ex;
}
}
}

Adobe's PDF format is one of the most widely accepted document formats in use today. Most users and clients expect that the software you write will be able to generate and work with PDFs. Unfortunately, however, Adobe does not offer a free SDK that you can download and use; you have to pay to license the API.

Statically creating PDF files is quite simple. Applications, such as OpenOffice.org Writer, give the user options to export a word processor document as a PDF file. Users can even find utilities that allow them to "print" directly to a PDF file. Features like these are well-known to end users and are useful for creating a PDF based off a document originally created in another format.

But what about dynamic PDF generation? Some programs need to be able to write out PDF files. PDF Duo .NET alleviates this problem. It will give you the ability to add PDF functionality to your applications. Using PDF Duo .NET, you can create PDF by converting HTML string or file, so you can deliver the functionality your users expect.

It is up to you how you generate your HTML from your data source and then convert it to PDF or another option is to convert your ASPX to HTML first and then to PDF. This need to be done because PDF Duo .NET component can only works with clear html format. It did not support for asp:control and runat=server tag for now. You can apply styleshhet to tables, h1, h2, paragraph, and all others necessary stylesheet tag to complete your PDF.

PDF Duo .NET is absolutely independent, doesn't require any additional components and really appropriate for ASP.NET websites. The component is written entirely in C# for the .NET platform. PDF Duo .NET is a library that allows you to generate (convert) PDF documents from HTML web page.

(ArticlesBase SC #1232722)