Hi Friends, in this post I would like to explain Constraints in SQL Server. * Constraint is a mechanism which can be activated automatically when the specified event is occurred. * Constraint is a role it can be defined on the selected columns in order to prevent invalid data. * It is one of the data integrity concepts to enforce integrity explicitly. Different types of constraints: 1) Not Null: It does not allow null values in the specified column. 2) Check: It is used to validating user conditions. 3) Unique: It doesn’t allow duplicate...
Monday, 20 June 2011
Java Script function for Printing Div content.
Hi Friends, in this post I would like to explain Java Script function for Printing Div content. Here I took one Button control for printing the content. JavaScript Function: <script type ="text/javascript" language ="javascript"> function Print(elementId) { var printContent = document.getElementById(elementId); var windowUrl = 'about:blank'; var uniqueName = new Date(); var windowName = 'Print' + uniqueName.getTime(); var printWindow = window.open(windowUrl, windowName,...
Java Script function for entering only Integers values in Textbox.
Hi Friends, in this post I would like to explain Java Script function for entering only Integers values in Textbox. JavaScript Function: <script type="text/javascript" language="javascript"> function isNumberKey() { if(!(((event.keyCode>=48&&event.keyCode<=57) || (event.keyCode>=96&&event.keyCode<=105))||(event.keyCode==8) || (event.keyCode==9) || (event.keyCode==37) || (event.keyCode==39) || (event.keyCode==46) || (event.keyCode==190))) event.returnValue=false; } !--script> Calling...
Sunday, 12 June 2011
Windows application for converting Text into Speech.
Hi Friends, in this post I would like to explain how to convert Text into Speech.· Open windows application.· Place a TextBox & a Button control on to the form.· Goto ProjectMenu---> Add Reference---> COM---> MicrosoftSpeechObjectLibrary (Add this reference).· Add the following namespace: using SpeechLib;Please go through the code under button click event:using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Text;using System.Windows.Forms;using...
Deleting files from the system in ASP.Net.
Hi Friends, in this post I would like to explain how to delete the file existing on the system.For this I took 1 FileUpload, 1 Button & 1 label control on to the page.Please find the source code below:<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default"%><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN""http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"> <title>Untitled Page</title>...
Creating dynamic controls in asp.net web application.
Hi Friends,In this example i would like to explain how to create controls(Label,TextBox,DropDownList) dynamically.For this i took 1 button(Access) & place holder control on the form. Code under page load: protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { } else { createDynamicControls(); } } Code for method createDynamicControls(): protected void createDynamicControls() { Label lblCompanyName = new Label(); lblCompanyName.ID="lblCName1"; lblCompanyName.Style.Add("left", "15px"); lblCompanyName.Text = "Company Name:";...
Saturday, 11 June 2011
Sending email with attachments in ASP.Net.
Hi friends,in this post I would like to explain how to send email with attachments in Asp.Net.For this I am taking 3 TextBoxes(For ToAddress,Subject & Body),FileUpload control,label for displaying message and a Button control.For working with emails you need to add the following namespace: using System.Net.Mail; Then code under Send Button Click Event: protected void btnSendEmail_Click(object sender, EventArgs e){ MailMessage mssg = newMailMessage();mssg.From = new MailAddress("yourgmailid@gmail.com");mssg.To.Add(txtToAddtess.Text);mssg.Subject...
DDL Statements in SQL Server.
Hi friends,in this post i would like to explain DDL commands in SQL Server.There are 3 types of DDL commands exist:1)CREATE 2)ALTER 3)DROP1)CREATE : For creating databases & database objects.Syntax for creating database:CREATE DATABASE DataBaseNameFor Ex:Create DataBase CollegeSyntax for creating Table:CREATE TABLE TableName(Column1 datatype, Column2 datatype,..............)For Ex:Create Table Employee(EmpId int,EmpName varchar(50),Salary money)2)ALTER : For altering the exsisting tables.Syntax for adding columns:Alter Table TableName...
Wednesday, 8 June 2011
Sending email in ASP.Net.
Hi friends,in this post I would like to explain how to send email in Asp.Net.For this I am taking 3 TextBoxes(For ToAddress,Subject & Body) and a Button control.For working with emails you need to add the following namespace: using System.Net.Mail; Then code under Send Button Click Event: protected void btnSendEmail_Click(object sender, EventArgs e) {MailMessage mssg = newMailMessage(); mssg.From = new MailAddress("yourgmailid@gmail.com"); mssg.To.Add(txtToAddtess.Text); mssg.Subject = txtSubject.Text; mssg.IsBodyHtml = true; mssg.Body =...
Tuesday, 7 June 2011
Loading multiple tables in a DataSet ?
Hi friends,in this post i would like to explain Loading multiple tables in a DataSet ?
sqlCommand.CommandText = "Employee"sqlDataAdapter.Fill(sqlDataSet, " Employee ") sqlCommand.CommandText = "Colleges"sqlDataAdapter.Fill(sqlDataSet, " Colleges ")
In the above code,it will shows how to load multiple tables in single DataSet.
Firstdata.DataSource = sqlDataSet.Tables("Employee ").DefaultView
In order to get first table(Employee) data , use Tables collection of DataSet and the Defaultview object will give you the necessary output.
Thank You...
Difference between Dataset.Copy and Dataset.clone ?
Dataset .Copy: - It copies both structure and data.
Dataset .Clone: - It only copies structure, does not copy data.
Thank You...
Saturday, 4 June 2011
Types of Name Spaces.
Hi friends,in this post i would like to explain Types of Name Spaces.
* To work with ADO.Net Microsoft provided Name Spaces.
* Name Spaces are divided into 4 groups:
1)Common Name Spaces:
System.Data;
System.Data.Common;
System.Data.SQLTypes;
2)Unmanaged Name Spaces:
System.Data.OLEDB;
3)Managed Name Spaces:
System.Data.SQLClient;
System.Data.OracleClient;
4)ODBC Name Spaces:
System.Data.ODBC;
Thank You...
About Form in C#.Net.
Hi friends,in this post i would like to explain about Form in C#.Net.
* Form works like a container,in which we can place any number of controls.
* Form is a class,which must be inherited from Form class.
* Every form will be associated with 3 files:
1)form1.cs(contains design & logic)
2)form1.Designer.cs(contails only declarations)
3)form1.Resx(contains Globalization information)
Properties of Form:
1)Name
2)Back Color
3)Fore Color
4)Font
5)BackGroundImage
6)BackGroundImageLayout
7)FormBorderStyle
8)Opacity
.
.
.
.
Thank You...
StreamReader & StreamWriter classes in C#.Net.
Hi friends,in this post i would like to explain StreamReader & StreamWriter classes in C#.Net.
* StreamReader is used to read data from the file.
* StreamWriter is used to write data into the file.
* Directly we are not write data into the file.First we should write into RAM & then through flush() it will be written into the file.
StreamReader methods:
1)Read() : Reads single character.
2)ReadLine() : Reads single line.
3)ReadToEnd() : Reads full file.
For Example:
StreamReader str=new StreamReader(file1);
txtBox1.Text=str.ReadToEnd();
str.Close();
StreamWriter...
Example on Switch Condition.
Hi friends,in this post i would like to explain Example on Switch Condition in C#.Net.
* Open windows application.
* Place a TextBox & a Button on to the form.
* Code under button_Click event:
{
int j=int.Parse(textBox1.Text);
Switch(j)
{
Case 1 : this.BackColor=Color.Green;
break;
Case 2 : ColorDialog clrd=new ColorDialog();
clrd.ShowDialog();
this.BackColor=cd.Color;
...
About Converting in C#.Net.
Hi friends,in this post i would like to explain Converting.in C#.Net.
* Working with Convert class is called as Converting.
* Methods under Convert class:
Convert.ToChar(...)
Convert.ToByte(...)
Convert.ToString(...)
Convert.ToBoolean(...)
.
.
.
Convert.ToInt16(...)
Convert.ToInt32(...)
Convert.ToInt64(...)
Example on Converting:
Static void main(...)
{
int i= 50;
Char c=Convert.ToChar(i);
Console.WriteLine(c);
}
Thank You...
Type casting in c#.Net.
Hi friends,in this post i would like to explain type casting concept in C#.Net.
* Type casting is the concept of converting one datatype to another datatype.
* C#.Net supports 2 types of type casting:
1)Implicit type casting.
2)Explicit type casting.
* Implicit type casting is under control or CLR.
* Explicit type casting is under control of programmer.
* Converting from Lower data types into Higher data types is called as Implicit type casting.
For Example:
Byte---->Long(Implicit)
* Converting from Higher data types into Lower data types...
Subscribe to:
Posts (Atom)
Subscribe to email feed
