Query Your Database

Write log file while creating application

2010-12-15T09:26:00.000-08:00

Write log while creating ur application. use below two class for write a log for ur appliaciton

//**************************************************************************//

Create one Application Class for Address where to store log………….

/******************/

using System;
using System.Collections.Generic;
using System.Text;


        class AppClass
        {

// change folder name if require by default mylog in c drive
            //public static string AppPath = @"c:\myLog\";
           // public static string AppPath = System.IO.Path.GetDirectoryName(System.Reflection.Assembly.GetExecutingAssembly().Location);
            public static string AppPath = System.IO.Path.GetDirectoryName(AppDomain.CurrentDomain.BaseDirectory);

            public AppClass()
            {
                Log4NET.Write(this.ToString() + " AppPath " + AppPath);

            }
        }

//**************************************************************************/

// Create another Class for write log as per Datetime

using System;
using System.Collections.Generic;
using System.Text;

     public class Log4NET
        {
            public static string logfile = @"\logs\LogEntery.log";
            public static string errlogfile = @"\logs\LogError.err";

            public static void Write(string message)
            {
                string DateTimeFile = "";
                DateTime dt = DateTime.Now;
                try{
                        if (!System.IO.Directory.Exists(AppClass.AppPath + @"\logs"))
                        {
                            System.IO.Directory.CreateDirectory(AppClass.AppPath + @"\logs");
                        }
                        DateTimeFile = dt.Year + "" + (dt.Month <= 9 ? "0" + dt.Month + "" : dt.Month + "") + "" + dt.Day + "";
                        logfile = @"\logs\DBConfig_" + DateTimeFile + ".log";
                        System.IO.FileStream fs = System.IO.File.Open(AppClass.AppPath + logfile, System.IO.FileMode.Append);
                        byte[] info = new System.Text.UTF8Encoding(true).GetBytes(System.DateTime.Now.ToString() + ":" + message + "\n");
                        fs.Write(info, 0, info.Length);
                        fs.Close();
                    }catch(Exception se){
                        if (!System.IO.Directory.Exists(AppClass.AppPath + @"\logs"))
                        {
                        System.IO.Directory.CreateDirectory(AppClass.AppPath + @"\logs");
                        }
                    System.IO.FileStream fs = System.IO.File.Open(AppClass.AppPath + @"\logs\dbLogCon.err", System.IO.FileMode.Append);
                        byte[] info = new System.Text.UTF8Encoding(true).GetBytes(System.DateTime.Now.ToString() + ":" + message + "\n");
                        fs.Write(info, 0, info.Length);
                        fs.Close();
                    }

            }
            public static void Error(string message)
            {
                string DateTimeFile = "";
                DateTime dt = DateTime.Now;
                try{
                    if (!System.IO.Directory.Exists(AppClass.AppPath + @"\logs"))
                    {
                        System.IO.Directory.CreateDirectory(AppClass.AppPath + @"\logs");
                    }
                    DateTimeFile = dt.Year + "" + (dt.Month <= 9 ? "0" + dt.Month + "" : dt.Month + "") + "" + dt.Day + "";
                    errlogfile = @"\logs\DBConfig_" + DateTimeFile + ".err";
                    System.IO.FileStream fs = System.IO.File.Open(AppClass.AppPath + errlogfile, System.IO.FileMode.Append);
                    byte[] info = new System.Text.UTF8Encoding(true).GetBytes(System.DateTime.Now.ToString() + ":" + message + "\n");
                    fs.Write(info, 0, info.Length);
                    fs.Close();
                    }catch(Exception se){
                        if (!System.IO.Directory.Exists(AppClass.AppPath + @"\logs"))
                        {
                            System.IO.Directory.CreateDirectory(AppClass.AppPath + @"\logs");
                        }
                        System.IO.FileStream fs = System.IO.File.Open(AppClass.AppPath + @"\logs\dbLogCon.err", System.IO.FileMode.Append);
                        byte[] info = new System.Text.UTF8Encoding(true).GetBytes(System.DateTime.Now.ToString() + ":" + message + "\n");
                        fs.Write(info, 0, info.Length);
                        fs.Close();
                    }

            }

        }

//**********************************************************************//

//***********************how to use in ur application**************************//

protected void btnLogin_Click(object sender, EventArgs e)
{

Try

{

Log4NET.Write("Login Clicked:");
}

Catch(Exception er)

{

Log4NET.Error("Login Failed:" +er.ToString());

        }

    }

//*******************//

//File Created on above path and log is written.......

logfile

Thank you bhavesh

ads

We are updating our database daily keep watching.
ra one - mausam- Force - Rascals- Mere Brother Ki Dulhan -Aarakshan- Bodyguard

Learn Oledb connection

2010-12-03T01:50:00.000-08:00

Hello,
Here is a complete code detail of oledb connection.

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Drawing;
using System.Data.OleDb;

public class clsGeneral
{
DataTable dt = new DataTable();
public static string storeId = "";
public static string store = "";
#region :: Variable Declaration ::

public static string cnString;
#endregion

public clsGeneral()
{
try
{
//******* change connection path of window application***********/
string AppPath1 = System.IO.Directory.GetCurrentDirectory();
string AppPath = AppPath1.Substring(0,AppPath1.Length-10) + "\\RMC30.MDB";
cnString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + AppPath + "";
// cnString = ConfigurationSettings.AppSettings.Get("name");
}
catch (Exception)
{
}
}
/*********** Execute non qeury***** for insert delete, update*********/
public bool execute_NonQuery(string sql)
{
try
{
OleDbConnection con = new OleDbConnection();
con.ConnectionString = cnString;
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = sql;
con.Open();
cmd.ExecuteNonQuery();
cmd.Dispose();
con.Close();
con.Dispose();
cmd = null;
con = null;
sql = null;

}
catch (Exception er)
{
}
return true;
}
//******** select query*****************//
public object execute_Scalar(string sql)
{
string NewID = "";
try
{

OleDbConnection con = new OleDbConnection();
con.ConnectionString = cnString;
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = sql;
con.Open();
NewID = Convert.ToString(cmd.ExecuteScalar());

cmd.Dispose();
con.Close();
con.Dispose();
cmd = null;
con = null;
sql = null;

}
catch (Exception)
{

}
return NewID;
}
//********* get Record in Datatable*******/
public DataTable get_Records(string sql)
{
DataTable ds = new DataTable();
try
{
OleDbConnection con = new OleDbConnection();
con.ConnectionString = cnString;
con.Open();

OleDbDataAdapter adp = new OleDbDataAdapter(sql, con);
adp.Fill(ds);
adp.Dispose();
con.Close();
con.Dispose();
sql = "";

}
catch (Exception)
{

}
return ds;
}
//********* fill in Datagrid***********//
public bool fill_Grid(string sql, ref System.Windows.Forms.DataGrid dg)
{
try
{
OleDbConnection con = new OleDbConnection();
con.ConnectionString = cnString;
con.Open();
DataSet ds = new DataSet();
OleDbDataAdapter adp = new OleDbDataAdapter(sql, con);
adp.Fill(ds);
dg.DataSource = ds.Tables[0];

ds = null;
adp.Dispose();
con.Close();
con.Dispose();

}
catch (Exception)
{

}
return true;
}

public bool fill_Checkbox(string sql, ref System.Windows.Forms.CheckedListBox cb)
{
try
{
OleDbConnection con = new OleDbConnection();
con.ConnectionString = cnString;

con.Open();
DataSet ds = new DataSet();
OleDbDataAdapter adp = new OleDbDataAdapter(sql, con);
adp.Fill(ds);
cb.DataSource = ds.Tables[0];
ds = null;
adp.Dispose();
con.Close();
con.Dispose();

}
catch (Exception)
{

}
return true;
}

//************* fill datatable using dataAdapter********/
public bool DataAdapter(string sql, DataTable dt)
{
try
{
OleDbConnection con = new OleDbConnection();
con.ConnectionString = cnString;

con.Open();
OleDbDataAdapter adp = new OleDbDataAdapter(sql, con);
adp.Fill(dt);
adp.Dispose();
con.Close();
con.Dispose();

}
catch(Exception )
{

}
return true;
}

public bool fill_combo(string sql, ref System.Windows.Forms.ComboBox cmb, string cmbName, string cmbVal)
{
try
{
OleDbConnection con = new OleDbConnection();
con.ConnectionString = cnString;
OleDbCommand cmd = new OleDbCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.Text;
cmd.CommandText = sql;
con.Open();
System.Data.OleDb.OleDbDataReader dr;
// System.Data.SqlClient.SqlDataReader dr;
//dr = SqlHelper.ExecuteReader(cnString, CommandType.Text, sql);
dr = cmd.ExecuteReader();
cmb.DataSource = dr;
cmb.ValueMember = cmbVal;
cmb.DisplayMember = cmbName;
dr = null;
cmd.Dispose();
con.Close();
con.Dispose();
cmd = null;
con = null;
sql = null;

}
catch (Exception)
{

}
return true;
}
}

Thanks to Bhavesh for his editing.
Enjoy.
Submit your site
Submit your site to listtheweb.com
link

Learn to get full detail using ftp connection

2010-11-20T22:21:00.000-08:00

ftp connection

Developers are always thinking that how to download a file from the server. Here are the code to download and upload the file.

Before downloading the file we must have the name of that file for this we should have list of file. Here is the code to get the list of the file from the server.

public string[] GetFileList()

{

string[] downloadFiles;

StringBuilder result = new StringBuilder();

FtpWebRequest reqFTP;

try

{

reqFTP = (FtpWebRequest)FtpWebRequest.Create(new Uri("ftp://" + ftpServerIP + "/"));

reqFTP.UseBinary = true;

reqFTP.Credentials = new NetworkCredential(ftpUserID, ftpPassword);

reqFTP.Method = WebRequestMethods.Ftp.ListDirectory;

WebResponse response = reqFTP.GetResponse();

StreamReader reader = new StreamReader(response.GetResponseStream());

string line = reader.ReadLine();

while (line != null)

{

result.Append(line);

result.Append("\n");

line = reader.ReadLine();

}

// to remove the trailing '\n'

result.Remove(result.ToString().LastIndexOf('\n'), 1);

reader.Close();

response.Close();

return result.ToString().Split('\n');

}

catch (Exception ex)

{

System.Windows.Forms.MessageBox.Show(ex.Message);

downloadFiles = null;

return downloadFiles;

}

download code here

Resume

Need more visitors?
Add your website to our directory to get more visitors.

Creating simple Update stored procedure

2010-08-19T05:53:00.000-07:00

Here you can learn how to create a simple stored procedure..

You should follow the below step after login in sql server.
Be sure that you are logged in sql server.

SIMPLE UPDATE QUERY.

Select your database as shown here.

Click on new query as shown here.

Write below code in that file.

Create procedure updatelogin
@id varchar(50),
@name varchar(50),
@pass varchar(50)
as

Update logintable set name=@name,passsword=@pass where id=@id

Here name password and id are logintable field name.

Here updatelogin is a stored procedure name and logintable is table name.

After writing the code press F5. or select Execute query.

You will get a message as shown here.

Here is the way how to see stored procedure.

After refreshing you will get your stored procedure with prefix dbo.procedurename

Enjoy….

google

My Linked Profile
Submit your site
Submit your site to listtheweb.com

Creating simple delete stored procedure

2010-08-17T05:41:00.000-07:00

Here you can learn how to create a simple stored procedure..

You should follow the below step after login in sql server.
Be sure that you are logged in sql server.

SIMPLE DELETE QUERY

Select your database as shown here.

Click on new query as shown here.

Write below code in that file.

create procedure deletelogin
@id varchar(50)
as
Delete from logintable where id=@id

Here deletelogin is a stored procedure name and logintable is table name.

After writing the code press F5. or select Execute query.

You will get a message as shown here.

Here is the way how to see stored procedure.

After refreshing you will get your stored procedure with prefix dbo.procedurename

Enjoy….

google

Get higher pagerank
Get higher pagerank by submitting to our directory

Creating simple SELECT stored procedure

2010-08-16T03:22:00.000-07:00

Here you can learn how to create a simple stored procedure..

You should follow the below step after login in sql server.
Be sure that you are logged in sql server.

SIMPLE SELECT QUERY

Select your database as shown here.

Click on new query as shown here.

Write below code in that file.

Here selectlogin is a stored procedure name and logintable is table name.

create procedure selectlogin

@id varchar(50)

select * from logintable where id=@id

After writing the code press F5. or select Execute query.

You will get a message as shown here.

Here is the way how to see stored procedure.

After refreshing you will get your stored procedure with prefix dbo.procedurename

Enjoy….

google

@FaceBook

Creating simple stored procedure

2010-08-10T01:57:00.000-07:00

Here you can learn how to create a simple stored procedure..

You should follow the below step after login in sql server.
Be sure that you are logged in sql server.

SIMPLE INSERT QUERY

Select your database as shown here.

Click on new query as shown here.

Write below code in that file.

Here mylogin is a stored procedure name and logintable is table name.

Create procedure mylogin

@id varchar(50),

@name varchar(50),

@pass varchar(50)

insert into logintable values(@id,@name,@pass)

After writing the code press F5. or select Execute query.

You will get a message as shown here.

Here is the way how to see stored procedure.

After refreshing you will get your stored procedure with prefix dbo.procedurename

Enjoy….

google

Get higher pagerank
Get higher pagerank by submitting to our directory

Step by Step stored procedure

2010-06-08T21:52:00.000-07:00

A stored procedure is a subroutine available to applications accessing a relational database system. Stored procedures (sometimes called a proc, sproc, StoPro, or SP) are actually stored in the database data dictionary.

A stored procedure is a procedure (like a subprogram in a regular computing language) that is stored (in the database). Correctly speaking, MySQL supports "routines" and there are two kinds of routines: stored procedures which you call, or functions whose return values you use in other SQL statements the same way that you use pre-installed MySQL functions like pi(). I'll use the word "stored procedures" more frequently than "routines" because it's what we've used in the past, and what people expect us to use.

Step by step procedure to create a stored procedure
Step-1
Open Microsoft sqlserver
Login into that

Step-2

Select new query or any one below of that

Step-3

Write a procedure as shown here

&

Execute that query as shown here

Step-5
Hear you can see that stored procedure

See Status of the blog

Delete data using sqlcommand

2010-06-01T09:33:00.000-07:00

Delete data using sqlcommand,sql,command,

Delete Button code

protected void button_delete_Click(object sender, EventArgs e)

{

sqlgetdata getdata = new sqlgetdata ();

getdata.deletemain(Convert.ToInt32(TextBox_stuid.Text));

Label_reply.Text = "Record deleted";

TextBox_stuid.Text = "";

TextBox_name.Text = "";

TextBox_course.Text = "";

TextBox_fee.Text = "";

}

public void deletemain(Int32 ss)

{

Int32 sa = ss;

string querystring = "delete from student where stu_id=" + sa;

string sqlconstring = "Data Source= SHYAM\\SQLEXPRESS ;initial catalog=college; integrated security=True ";

SqlConnection sqlcn = new SqlConnection(sqlconstring);

Sqlcommand sqlcmd=new Sqlcommand(querystring,sqlcn);

sqlcn.Open();

sqlcmd.ExecuteNonQuery();

sqlcn.Close();

}

increase your webtraffic

Select data using SqlCommand

2010-04-30T10:24:00.001-07:00

Select data using sqlcommand

selectButton event

It is step3 procedure

protected void btn_select_Click(object sender, EventArgs e)

{

sqlgetdata getdata=new sqlgetdata();

classvar seletvar= getdata.searchmain(Convert.ToInt32(TextBox1.Text));

TextBox2.Text = Convert.ToString(seletvar.name);

TextBox3.Text = Convert.ToString(seletvar.course);

TextBox4.Text = Convert.ToString(seletvar.fee);

Label1.Text = "record fetched";

}

Variable class

It is step4 procedure

public class classvar

{

public int id{get;set;}

public string name { get; set; }

public string course { get; set; }

public int fee { get; set; }

}

It is step5 procedure

public classvar searchmain(Int32 ss)

{

Int32 sa = ss;

string sqlquerystring= "select * from student where stu_id="+ sa;

string sqlconstring= "Data Source= SHYAM-6E8C5C74B\\SQLEXPRESS ;initial catalog=college; integrated security=True ";

SqlConnection sqlcn= new SqlConnection(sqlconstring);

Sqlcommand sqlcmd=new Sqlcommand(sqlquerystring,sqlcn);
sqlcn.Open();

SqlDataReader sqlre= sqlcmd.ExecuteReader();

classvar seletvar = new classvar();

while (sqlre.Read())

{

seletvar.fee = re["fee"].ToString();

seletvar.name = re["name"].ToString();

seletvar.course = re["course"].ToString();

}

sqlre.Close();

sqlcn.Close();

return seletvar;

}

See Status of the blog

Insert data using sqlcommand

2010-04-26T09:57:00.000-07:00

Insert data using sqlcommand,usingsimple,datasqlclassusing,sqlcommand,simpledatausing,datasqlcommand,usingsqlcommand,sqlcommandsqlclass,simplesqlclasssimple,sqlcommandusing,datasqlcommandsimple,sqlclassdata,simplesqlclasssqlcommand,simplesqlcommand,datasimple,sqlcommanddatasimple,usingdatasqlcommand,simplesqlclassusing,sqlcommanddatausing,usingsqlcommandsqlclass,

It is step3 procedure

Insert data using sqlcommand

Save button event
protected void btninsert_Click(object sender, EventArgs e)
{
first f = new first();
f.id = Convert.ToInt32(TextBox1.Text);
f.name = TextBox2.Text;
f.course = TextBox3.Text;
f.fee = Convert.ToInt32(TextBox4.Text);

datac c=new datac();
c.insertmain(f);
Label1.Text = "record inserted";
}

It is step4 procedure

Variable class

public class first
{
public int id{get;set;}

public string name { get; set; }
public string course { get; set; }
public int fee { get; set; }
}

It is step5 procedure

Data class

Public void insertmain(first f)
{
string s= "insert into student values(" + f.id + ",'" + f.name + "','" + f.course + "'," + f.fee + ")";

string constring = "Data Source= SHYAM-6E8C5C74B\\SQLEXPRESS ;initial catalog=college; integrated security=True ";

SqlConnection cn = new SqlConnection(constring);
SqlCommand cmd = new SqlCommand(cmd, cn);
cn,Open();
cmd.ExecuteNonQuery();
cn.Close();
}

Happy to Help

2010-04-02T06:40:00.001-07:00

Here all procedure is done in 3 tier

Step by step guide

Step 1:

Open visual studio

Select new project or new website

Step 2:

Open “default.aspx” page and select design

Add text box and button as shown in figure

Step 3:

See the code written in BUTTON CODE

Write this code in button event

//see button code in simple delete post

Step 4:

Goto menu-->open PROJECT select ADD NEW ITEM

Add class file named as “first.cs”

See the code written in VARIABLE CLASS

Write this code in “first.cs” file

//see variable code in simple select post

Step 5:

Go to menu-->open PROJECT select ADD NEW ITEM

Add class file named as “datac.cs”

See the code written in DATA CLASS

Write this code in “datac.cs” file

//see data code in simple insert post

increase your webtraffic See Status of the blog

Delete data using (DATA SET)ds and dt

2010-03-21T02:46:00.000-07:00

It is step3 procedure

Delete Button code

protected void btn_delete_Click(object sender, EventArgs e)
{

datac b = new datac();
b.delete(Convert.ToInt32(TextBox1.Text));
//control of asp.net

Label1.Text = "record deleted";
TextBox1.Text = "";
TextBox2.Text = "";
TextBox3.Text = "";
TextBox4.Text = "";
}

It is step5 procedure.

This class actually work on data here it is work on deleting data

Delete Data class

public void deletemain(Int32 ss)
{
//simple delete query
//To insert data we just change the query.

string query = "delete from student where stu_id=" + ss;

// we can write query using logical operator also.
///////
//connection string

string constring = "Data Source= SHYAM-6E8C5C74B\\SQLEXPRESS ;initial catalog=college; integrated security=True ";

//Creating Connection

SqlConnection cn = new SqlConnection(constring);

SqlDataAdapter da = new SqlDataAdapter(query, cn);

DataSet ds = new DataSet();

da.Fill(ds);

}

Get 1 Million Hits, FREE!

Select data using (DATA SET)ds and dt

2010-03-20T23:25:00.000-07:00

Select data using (DATA SET)ds and dt,readerselectreader,datasetselectdataset,datasetreader,readerdataset,readerdatasetreader,selectreaderdataset,dsreader,dt,readerdtfillds,dtfilldtfill,dtreaderdtfill,readerdtreader,dsdtdtfill,dtds,dsdtfillds,dtfillreader,readerdsdt,dtfillreaderdt,

It is step3 procedure

protected void btn_select_Click(object sender, EventArgs e)

    {

        Datac c=new datac();
       first f= c.search(Convert.ToInt32(TextBox1.Text));
       TextBox2.Text = Convert.ToString(f.name);
       TextBox3.Text = Convert.ToString(f.course);
       TextBox4.Text = Convert.ToString(f.fee);

        Label1.Text = "record fetched";

    }

It is step4 procedure
Variable class

public class first
{
    public int id{get;set;}

    public string name { get; set; }
    public string course { get; set; }
    public int fee { get; set; }
}

It is step5 procedure

public first searchmain(Int32 ss)

{

Int32 sa = ss;

string querystring= "select * from student where stu_id="+ sa;

first f = new first();

string constring = "Data Source= SHYAM-6E8C5C74B\\SQLEXPRESS ;initial catalog=college; integrated security=True "

SqlConnection cn = new SqlConnection(constring);

SqlDataAdapter da = new SqlDataAdapter(querystring,cn);

DataSet ds = new DataSet();

da.Fill(ds);

f.name = Convert.ToString(ds.Tables[0].Rows[0][1]);

f.course = Convert.ToString(ds.Tables[0].Rows[0][2]);

f.fee = Convert.ToInt32(ds.Tables[0].Rows[0][3]);

return f;

}

Simple Insert data using (DATA SET)ds and dt

2010-03-20T13:14:00.000-07:00

Save button event

protected void btn_save_Click(object sender, EventArgs e)
    {

        first f = new first();
        f.id = Convert.ToInt32(TextBox1.Text);
        f.name = TextBox2.Text;
        f.course = TextBox3.Text;
        f.fee = Convert.ToInt32(TextBox4.Text);

      datac c=new datac();
            c.insertmain(f);
        Label1.Text = "record inserted";
    }

Variable class

public class first
{

    public int id{get;set;}

    public string name { get; set; }
    public string course { get; set; }
    public int fee { get; set; }
}

Data class

public void insertmain(first f)
{
string query = "Insert into student values(" + f.id + ",'" + f.name + "','" + f.course + "'," + f.fee + ")";

string constring = "Data Source= SHYAM-6E8C5C74B\\SQLEXPRESS ;initial catalog=college; integrated security=True "

SqlConnection cn = new SqlConnection(constring);

SqlDataAdapter da = new SqlDataAdapter(query,cn);

DataSet ds = new DataSet();

da.Fill(ds);

}

Need more visitors?

Add your website to our directory to get more visitors.

increase your webtraffic

Logical AND operator

2010-03-18T11:44:00.000-07:00

Logical And operator,operator,earn,learnlogical,learnoperator,logicalearn,learnlogicalearn,logicallearnlogical,earnoperatorlogical,learnearn,operatorearn,learnlogicaloperator,logicaloperatorearn,

The AND operator displays a record if both the first condition and the second condition is true.

It can be used in any valid SQL statement such as select,insert,update,or delete. the and operator requires that each condition must be met for the record to be included in the result set.

syntax

insert into table name where condition1 AND condition2

update tablename set columnname values value where condition1 AND condition2

delete from tabl name where condition1 AND condition2

select from tablname where condition1 AND condition2

EXAMPLE

insert into sqldemo1 (id) values (23) where firstname='sam' AND pass='sam';

Update sqldemo1 set id=34 where firstname='sam' AND pass='sam';

Delete * from sqldemo1 where firstname='sam' AND pass='sam';

select id from sqldemo1 where firstname='sam' AND pass='sam';

DISTINCT clause

2010-03-17T23:30:00.000-07:00

Use of DISTINCT clause

In table, some of the columns may contain duplicate values. Sometimes you will want to list only the different (distinct) values in a table.

The DISTINCT clause allows removing duplicates from the result set. and this clause can only be used with select statement.

Syntax

SELECT DISTINCT ColumnName1,ColumnName2 FROM TableName;

OR
SELECT DISTINCT * FROM TableName;
EXAMPLE

SELECT DISTINCT * FROM logintable;

See Status of the blog

Simple select query

2010-03-15T11:09:00.000-07:00

Learn how to select query ,sqlquerysql,class,select,simple,simpleclass,querysimplequery,classsimple,classselectsql,simpleselect,classsimplesql,selectquery,queryselect,querysqlquery,simpleselectclass,sqlselect,

SQL SELECT Statement

The SELECT statement is used to select data (THROUGH WHICH WE CAN GET DETAIL) from a database.

The result is stored in a result table, called the result-set.

SQL SELECT Syntax

SELECT column_name(s) FROM table_name

SELECT * FROM table_name

select * From table_name where condition

Example

SELECT id,password FROM logintable

SELECT id FROM logintable WHERE password="sam";

The DELETE Statement

2010-03-14T07:13:00.000-07:00

Learn simple delete statement,sqlclassstatement,delete,statementsqlclass,deletestatement,deletesqlclass,sqlclassdelete,statementsqlclassstatement,sqlclassstatementdelete,statementsqlclassdelete

The DELETE Statement

The DELETE statement is used to delete rows in a table.
==========================================================
SQL DELETE Syntax

DELETE FROM table_name
WHERE some_column=some_value

example

DELETE from logintable
where id="sam";
==============================================================

DELETE FROM table_name
WHERE some_column=some_value AND some_column=some_value

example

DELETE FROM Persons
WHERE LastName='sam' AND FirstName='231bk'

=====================================================

Delete All Rows

It is possible to delete all rows in a table without deleting the table.
This means that the table structure, attributes, and indexes will be intact:

DELETE FROM table_name;

Simple update query

2010-03-05T00:47:00.000-08:00

The UPDATE statement is used to update records in a table.

Syntax

UPDATE table_name
SET column1=value, column2=value2,...

UPDATE table_name
SET column1=value, column2=value2,...
WHERE some_column=some_value

something new::

The WHERE clause specifies which record or records that should be updated.
If you omit the WHERE clause, all records will be updated! so we can use where with update ........

Here

TABLE NAME=sqldemo
column name=id,pass,no,name

Example

UPDATE sqldemo
SET id='167', pass='1123';

Another example with where statement

UPDATE sqldemo
SET id='s167', pass='1s123'
WHERE no='23e';

UPDATE sqldemo
SET id='s167', pass='1s123'
WHERE no='23e'AND name='sam';

Check Backlinks

Simple insert Query

2010-02-23T12:07:00.000-08:00

Simple insert query

Here you can learn how to create simple insert query. Its all about how to create a simple insert query for sql server 2005.
Insert query is also help full when we are firing query to database from .net page.

Insert intoTable Name select column name1 column name N from Table name

Example

Insert into sqldemo (id,password,status) values('sds','sad','sdsa');

Insert into sqldemo select id,password,status from sqldemo1;

Here

- sqldemo is destination table

- sqldemo1 is source table

Another insert query with 'where' condition.
Insert into Table Name select column name1 column name-n from table name where condition

Example

Insert into sqldemo select id,password,status from sqldemo1 where id like 'a%';

see more on sql

This query is used in inserting data into table

See Status of the blog