Friday, May 16, 2008

NEW FORM IN VISUAL STUDIO

I am now going talk about a nice feature in VISUAL STUDIO
All you need to just see my code..
Its builts customized forms in VISUAL STUDIO.
Its works ,with the help of Windows Forms Generating System.
The code follows.......


using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;

namespace dataform
{

/// Summary description for Form1.

public class Form1 : System.Windows.Forms.Form
{
/// Required designer variable.

private System.ComponentModel.Container components = null;

public Form1()
{
//
// Required for Windows Form Designer support
//
InitializeComponent();

//
// TODO: Add any constructor code after InitializeComponent call
//
}



protected override void Dispose( bool disposing )
{
if( disposing )
{
if (components != null)
{
components.Dispose();
}
}
base.Dispose( disposing );
}

#region Windows Form Designer generated code

/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.

private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
this.Size = new System.Drawing.Size(300,300);
this.Text = "Form1";
}
#endregion


/// The main entry point for the application.

[STAThread]
static void Main()
{
Application.Run(new Form1());
}
}
}

Saturday, May 3, 2008

TO MAKE A DATABASE (C#.NET)

One of my readers mailed me to solve his problem
Actually he is working for a software firm in Chennai,India.
There in their project,there was a module to create a database connection,
create a database,and create a table....These are much complicated in a sense.
Tell you..the actual value of each database should not be static.
Done ..he send me a mail to solve this.
Ok where ever you are please check my blog Mr.Anand kumar
It will help you i am sure....


------------------------------------------------------------------------------------

First of all we must add namespaces on our program
A complete general notes on basics of .net will present you later ok?


using system.data.sqlclient;

Then

add this

string source = (@"Data Source=.;Initial Catalog=*yourdatabasename*;Integrated Security=True");
string insert = ("insert into tbl_soft values('" + textBox1.Text + "','" + textBox2.Text + "')");
SqlConnection cnn = new SqlConnection(source);
cnn.Open();
SqlCommand cmd = new SqlCommand(insert,cnn);
cmd.ExecuteNonQuery();
MessageBox.Show("files added successfully");

here i've used certain controls to give the values in database rather sql server.
Those are textboxes.Once it generates the values ,it will add itself as Main and Sub Tables.