Skip to main content

Posts

Showing posts from July, 2013

Login and Registration forms in C# windows application with Back end Microsoft SQL Server for data access

In this article, I'm gonna share about how to make login and register form with MS SQL database; 1. Flow Chart Logic 2. Normal Features 3. Form Designs Login Form Design Sign in Form Design Password Retrieve Form 4. Database Design and SQL queries and Stored Procedure Create new Database as "schooldata" create table registerdata (  ID int identity,  Username nvarchar(100),  Password nvarchar(100),  Fullname  nvarchar(100),  MobileNO nvarchar(100),  EmailID nvarchar(100)  ) select * from registerdata create procedure regis (  @Username as nvarchar(100),  @Password as nvarchar(100),  @Fullname as nvarchar(100),  @MobileNO as nvarchar(100),  @EmailID as nvarchar(100)  ) as begin insert into registerdata (Username, Password, Fullname, MobileNO,EmailID) values (@Username, @Password, @Fullname, @MobileNO, @EmailID) ...

Print and PrintPreview in C# Windows Application

In this article; we gonna see how to make print and preview options in C# windows application 1. Design View of the windows Form 2. Code using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; namespace PrintOptions { public partial class Form1 : Form { public Form1() { InitializeComponent(); } //printdocument associated with richTextbox value private void printDocument1_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e) { e.Graphics.DrawString(richTextBox1.Text, richTextBox1.Font, Brushes.Black, 100, 20); e.Graphics.PageUnit = GraphicsUnit.Inch; } // print button private void button1_Click(object sender, EventArgs e) { printDialog1.Document = printDocu...

Data Display Form Using DataGridview tool in C# Windows Application

1. Design Form  Steps: a. Choose Datagridview tool in tool kit b. Choose new datasource from datagridview c. After choosing particular database and data table the design of form will be look a like in this above acreenshot 2. Class view for data table  3. Code created automatically using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.SqlClient; using System.Data.Sql; namespace DataDisplayForm { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { // TODO: This line of code loads data into the 'nameDBDataSet.namedata' table. You can move, or remove it, as needed. this.namedataTableAdapter.Fill(this.nameDBDataSet.name...

C# Windows Application Data Form sample Module: Save and Retrieve Data using MS SQL database

Methods Used: 1. Created a database as NameDB and Database table as namedata as follows. --table for saving retrieving datas create table namedata (  ID int identity,  Firstname nvarchar(500),  Secondname nvarchar(500),  Fullname nvarchar(500) ) --get  query result select * from namedata 2. Create a  stored procedure for saving data -- creating stored procedure for saving data create proc nameprocedure  @Firstname as nvarchar(500), @Secondname as nvarchar(500), @Fullname as nvarchar(500) as begin   SET NOCOUNT ON; Insert into  namedata(Firstname,Secondname,Fullname) values(@Firstname,@Secondname,@Fullname) end -- execute strored procedure exec nameprocedure 3. Windows Application design for save and Retrieve data form set formborderstyle as none 4. App.config settings to Connect database <?xml version="1.0"?> <configura...

Java Swing Full Screen window Application without Maximize, Minimize, Exit Buttons

Code For FullScreen Java Swing Desktop Application package fullscreen; import java.awt.Toolkit; import javax.swing.JFrame; public class FullScreen extends JFrame { /** * full screen code using Java Swing component JFrame */ static JFrame f= new FullScreen(); public FullScreen() { setUndecorated(true); //removing Max, min, Exit buttons setSize(Toolkit.getDefaultToolkit().getScreenSize()); //set window size as full screen setVisible(true); } public static void main(String[] args) { // no code here } } Output Screen