Comman object declaration: SqlCommand sqlcmd = new SqlCommand ( "slelect * from BooKs", sqlconn); or SqlCommand sqlcmd = sqlconn.CreateCommand (); sqlcmd.CommandText = "select * from Books"; performed SqlDataReader dr = sqlcmd.ExecuteReader () ; sqlcmd.CommandText = "select * from Books for xml auto, xmldata"; xmlreader xr = sqlcmd.executexmlreader (); sqlcmd.CommandText = "delete * from bools where price = 10"; sqlcmd.executeNonQuery (); call a stored procedure SqlCommand sqlQueryAuthor = sqlconn.Create Command (); sqlQueryAuthor.CommandText = "QueryAuthor"; sqlQueryAuthor.CommandType = CommandType.StoredProcedure; sqlQueryAuthor.Parameters.Add ( "@ Author", SqlDbType.NVarChar) .Value = "Mi-chael";
